Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating the payment for a loan
PMT calculates the payment for a loan but assumes a constant number of
payment for the loan (constant installments). My requirement is as follows: a. Interest varies between months (could be the same for a long time and change again) b. The monthly installment is the same irrespective of the interest change. c. The loan tenure changes because of increase/decrease in the interest rate. I have the same issue with IPMT and PPMT as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loan payment program | Excel Worksheet Functions | |||
Car loan payment calculations | Excel Discussion (Misc queries) | |||
loan payment | Excel Worksheet Functions | |||
loan amortization template with loan start date AND first payment | Excel Discussion (Misc queries) | |||
how do you calcualte a payment for a loan. | Excel Worksheet Functions |