Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
loan payment program HeyJay Excel Worksheet Functions 1 June 21st 06 09:20 PM
Car loan payment calculations saziz Excel Discussion (Misc queries) 2 May 2nd 06 11:01 PM
loan payment vieira Excel Worksheet Functions 2 April 16th 06 08:31 PM
loan amortization template with loan start date AND first payment Lisa W Excel Discussion (Misc queries) 0 January 30th 06 10:27 PM
how do you calcualte a payment for a loan. rfhorn Excel Worksheet Functions 3 April 5th 05 07:15 PM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"