PMT (loan stuff)

PMT (loan stuff)

The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this function to work. To calculate the loan we must know a combination of the following

(rate) interest rate per period
(nper) number of payments until repaid
(pv) present value of the loan (amount we are borrowing)
(fv) future value of the money (for saving or investing)
(type) enter 0 or 1 to indicate when payments are due.

=PMT(rate, nper, pv, fv, type)

Note that the rate is per period. If we have an annual interest rate of 9% and we are calculating monthly payments, we must divide the annual interest rate by 12 to calculate the monthly interest rate.

PMT (loan stuff)

16179

Choose: TRIO home I tutorials I by Brad James I [email protected]