Home / calculate balloon payment in excel / A brief introduction of PMT, IPMT and PPMT Excel …
A brief introduction
of PMT, IPMT and
MS Excel - PMT Function(WS,
? In Excel, the PMT function returns the payment amount for a
loan based on an interest rate and a constant payment
? The syntax for the PMT function is:
? PMT( interest_rate, number_payments, PV, [FV], [Type] )
? interest_rate is the interest rate for the loan.
? number_payments is the number of payments for the loan.
? PV is the present value or principal of the loan.
? FV is optional. It is the future value or the loan amount
outstanding after all payments have been made. If this
parameter is omitted, the PMT function assumes a FV value of
Title: A brief introduction of PMT, IPMT and PPMT Excel functions
Creator: Microsoft® PowerPoint® 2010
Producer: Microsoft® PowerPoint® 2010
CreationDate: Fri Oct 5 15:02:51 2012
ModDate: Fri Oct 5 15:02:51 2012
Page size: 720 x 540 pts (rotated 0 degrees)
File size: 562532 bytes
PDF version: 1.5