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 function | Short description of function |
MnFinanceDDB | Returns the depreciation of an asset for a specific time period using a specified depreciation methodology |
MnFinanceFV | Returns the future value of an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate |
MnFinanceIPmt | Returns the interest payment for a given period for an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate |
MnFinanceIRR | Returns the internal rate of return for a series of periodic payments and receipts |
MnFinanceMIRR | Returns a modified internal rate of return for a series of periodic payments and receipts taking into account financing and reinvestment rates |
MnFinanceNPer | Returns the number of periods over which a set of annuity-style cash flows will last |
MnFinanceNPV | Returns the net present value of a series of periodic payments and receipts |
MnFinancePmt | Returns the overall fixed payment (interest and principal) for an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate |
MnFinancePPmt | Returns the principal payment for a given period for an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate |
MnFinancePV | Returns the present value of an annuity-style cash flow involving periodic fixed payments and a term-independent interest rate |
MnFinanceRate | Returns the interest rate (per period) for a annuity cash flow |
MnFinanceSLN | Returns the straight line depreciation of an asset for a single period (is same for each period) |
MnFinanceSYD | Returns the sum of digits depreciation of an asset for a given period |