Finance Functions
IRR (Values, Guess?) - > number
Returns the internal rate of return for a series of cash flows. Node references are also accepted as arguments
NPV (Rate, value1, valueN?) - > number
Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values)
PMT(Rate, Nper, PV, FV?, Type?) - > number
Calculates the payment for a loan based on constant payments and a constant interest rate
IPMT (Rate, Per, Nper, PV, FV?,Type?) - > number
Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate
FV(Rate, Nper,Pmt?, PV,Type?) - > number
Returns the future value of an investment based on periodic, constant payments and a constant interest rate
CUMIPMT (Rate, Nper, PV, start_period, end_period, Type) - > number
Returns the cumulative interest paid between two periods
CUMPRINC (Rate, Nper, PV, start_period, end_period, Type) - > number
Returns the cumulative principal paid on a loan between two periods
RATE(Nper, PMT, PV?,FV?,Type?,Guess?) - > number
Returns the interest rate per period of a loan or an investment.
Last updated