cumipmt(rate, periods, value, start, end, type)
finance.AM(principal, rate, period, yearOrMonth, payAtBeginning)
Compound Annual Growth Rate
finance.CAGR(beginning value, ending value, number of periods)
finance.CI(rate, compoundings per period, principal, number of periods)
Discount Factor (returns an array; must index array to obtain values -- to see all values of array, see working example above)
finance.DF(rate, number of periods)[index]
finance.FV(rate, nper, pmt, pv, type)
finance.IAR(investment return, inflation rate)
finance.LR(total liabilities, total debts, total income)
finance.NPV(rate, initial investment, cash flows[all])
finance.PI(rate, initial investment, cash flows[all])
Payment for a loan based on constant payments and a constant interest rate
finance.PMT(fractional interest rate, number of payments, principal)
finance.PP(number of periods, cash flows[all])
finance.PV(rate, nper, pmt, [fv], [type])
Weighted Average Cost of Capital
finance.WACC(market value of equity, market value of debt, cost of equity, cost of debt, tax rate)
Internal rate of return for a schedule of cash flows.
finance.xirr([-10,11], [0,12], 12) = 10%
fv(rate, nper, pmt, pv, [type])
Future Value Interest Factor of an Annuity.
Interest portion of a given loan payment.
ipmt(rate, per, nper, pv, [fv], [type])
Periodic payment for a loan.
pmt(rate, nper, pv, [fv], [type])
Principal portion of a given loan payment.
ppmt(rate, per, nper, pv, [fv], [type])
pv(rate, nper, pmt, fv, [type])
Present Value Interest Factor
Interest rate per period of an annuity.
rate(nper, pmt, pv, [fv], [type], [guess])