PV = Present Value (pv#) FV = Future Value (fv#) i = Interest Rate (rate#) n = Number of periods (nper#) CF = Variable Cash Flow m = Compounding Period (freq#) n = Period of interest (per#)

Calculate the number of periods n a PV takes to achieve a FV at a fixed i

Calculate the i for a PV to achieve a FV over a period n

Calculate the payment to amortize a loan PV over a period of n at i

Calculate FV for PV over a period n at i

Calculate FV for PV over a period n at i where compounding is more frequent

Calculate the FV of a variable CF over a period n at i

Cash flow

Calculate the FV of an annuity with PMT over a period n at i Note this is similar to cash flow but for constant PMT

Calculate PV of FV over a period n at i

Calculate PV for FV over a period n at i where compounding is more frequent

Calculate the remaining balance on a loan

Calculate cummulative interest paid on a loan up to period n

Calculate the principle paid on a load at period n

Amount of principle paid on payment n

Amount of interest paid on payment n