A brief introduction of PMT, IPMT and PPMT Excel functions
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.
? Type is optional. It indicates when the payments are due. Type can be one of the following values:
? If the Type parameter is omitted, the PMT function assumes a Type value of 0.
Value 0
1
Explanation Payments are due at the end of the period. (default)
Payments are due at the beginning of the period.
? Applies To: Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 ? Type of Function: Worksheet function (WS) VBA function (VBA)
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- how to calculate monthly payments in excel
- how daily simple interest works onemain financial
- interest rate formulas new mexico state university
- a brief introduction of pmt ipmt and ppmt excel functions
- excel exercise 3 mortgage worksheet mortgage
- 360 day interest calculation
- formula sheet for financial mathematics
- global cashflow worksheet lender s online training
- chapter 17 lecture mit opencourseware
- mortgage repayment formula derivation mathshelper
Related searches
- a brief history of surgery
- a brief history of philosophy
- a brief history of education
- a brief history of computer
- a brief history of china
- a brief history of time review
- a brief history of india
- a brief history of english
- a brief history of time quotes
- brief introduction of yourself sample
- a brief history of time film
- a brief history of time summary