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
- a brief introduction of pmt ipmt and ppmt excel functions
- for paying off your mortgage faster and reducing your
- hp 12c loan amortizations amortization the hp12c
- early repayment residential investment fixed rate interest
- present value and interest rates
- why does the interest charged increase or decrease some
- chapter 4 managing your money lecture notes math 1030
- the graduated payment mortgage solving the initial
- understanding how a precomputed loan works
- bond prices and interest rates university of michigan
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