Financial Function Arguments
Excel’s financial functions enable you to use complex financial formulas in your worksheets:
- Rate – the interest rate per period. If expressed as an annual interest rate, you must divide it by the number of periods.
- Nper – the total number of payment periods.
- Pmt – the payment made each period; constant value that doesn’t change.
- Pv - the present value of the loan
- Fv – the future value after the last payment is made.
- Type – indicates when payments are due; if omitted, 0 is assumed.
1 (due at the beginning of the period)
Click here to open and print out the instruction.