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.
No comments:
Post a Comment