I am looking for help to design a spreadsheet for a payment stream where interest-only payments are made for three months and Principal & Interest payments are made for nine months. The original amortization is 240 months and when the P &I payments are calculated they are based on the number of payments remaining. After Payment 1 is made there are 239 left, etc so the first P&I payment will be based on 237 payments remaining, etc.
Thanks in advance for your help.
What are you having trouble with exactly?
What would you like help with specifically?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Try this....
Payment Schedule 3 months interest only.xls
Bernie Deitrick
Excel MVP 2000-2010
This posting came in handy for me as I wanted to check my new car loan. Thanks for the posting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks