/

The Nematrian Function Library

Finance Functions

[this page | pdf | back links]

The Nematrian function library includes a range of tools that mimic finance orientated functions available in typical spreadsheet systems, e.g. DDB(), FV(), IPmt(), IRR(), MIRR(), NPer(), NPV(), Pmt(), PPmt(), PV(), Rate(), SLN() and SYD().

 

The web functions available include ones set out in the table below. To see a complete list of functions currently available in the Nematrian online toolkit please go to list of types of available functions or complete list of individual functions.

 


NAVIGATION LINKS
Contents | Prev | Next


Web functionShort description of function
MnFinanceDDBReturns the depreciation of an asset for a specific time period using a specified depreciation methodology
MnFinanceFVReturns the future value of an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate
MnFinanceIPmtReturns the interest payment for a given period for an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate
MnFinanceIRRReturns the internal rate of return for a series of periodic payments and receipts
MnFinanceMIRRReturns a modified internal rate of return for a series of periodic payments and receipts taking into account financing and reinvestment rates
MnFinanceNPerReturns the number of periods over which a set of annuity-style cash flows will last
MnFinanceNPVReturns the net present value of a series of periodic payments and receipts
MnFinancePmtReturns the overall fixed payment (interest and principal) for an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate
MnFinancePPmtReturns the principal payment for a given period for an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate
MnFinancePVReturns the present value of an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate
MnFinanceRateReturns the interest rate (per period) for a annuity cash flow
MnFinanceSLNReturns the straight line depreciation of an asset for a single period (is same for each period)
MnFinanceSYDReturns the sum of digits depreciation of an asset for a given period

Desktop view | Switch to Mobile