Returns the payment amount for an annuity based on periodic, fixed payments and a fixed interest rate.
double Pmt(double Rate; double NPer; double PV; [double FV]; [bool DueBegOfPeriod])
Rate |
The interest rate per period. |
NPer |
The total number of payment periods in the annuity. |
PV |
The present value that a series of payments to be paid in the future is worth now. |
FV |
Optional future value or cash balance you want after you have made the final payment. Default zero. |
DueBegOfPeriod |
Optional setting if the payments are due at the beginning of the period (true) or at the end of the period (false). Default false. |
Example
Pmt(0.06/12; 36; -400000; 100000)
Returns 9,626.58 EUR as the monthly amount to pay for a 36-month lease with 6% annual interest, starting value 400,000 EUR, and ending value 100,000 EUR.
