Home / calculate balloon payment in excel / A brief introduction of PMT, IPMT and PPMT Excel …
A brief introduction of PMT, IPMT and PPMT Excel … - calculate balloon payment in excel
A brief introduction
of PMT, IPMT and
PPMT Excel
functions
MS Excel - PMT Function(WS,
VBA)
? In Excel, the PMT function returns the payment amount for a
loan based on an interest rate and a constant payment
schedule.
? 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
0.
Pdf INFO
Title: A brief introduction of PMT, IPMT and PPMT Excel functions
Author: Admin
Creator: Microsoft® PowerPoint® 2010
Producer: Microsoft® PowerPoint® 2010
CreationDate: Fri Oct 5 15:02:51 2012
ModDate: Fri Oct 5 15:02:51 2012
Tagged: yes
Form: none
Pages: 25
Encrypted: no
Page size: 720 x 540 pts (rotated 0 degrees)
File size: 562532 bytes
Optimized: no
PDF version: 1.5
