Recently, I have had more requests for specialty amortizations. This workbook is intended to give readers a list of example amortizations that can be used as starting points to produce amortization schedules that fit their needs. The examples have not been used in real world situations, so if you find bugs, let me know. Here is a list of amortizations in the workbook:
Standard Amortizations
• Simple
• Balloon
• Interest Only #1
• Interest Only #2
• Interest Only #3
• Balloon and IO
• Skip Payments
• Extra Payments
• Variable Rates
• Using Dates
• Amortization Math
• Consolidate Amortization
Pooled Loan Amortizations
• PV of Cash Flows with CPR
• PV of Cash Flows with PSA
• MBS MEGA Formula
Download:
http://pistulka.com/Excel_Shared/Sample_Amortizations.xlsx
Hi Don, can you help with a sheet where I can calculate amortization with variable rate AND additional payments? Where the focus will be on reducing the total tenure. This might be tricky, which is why I haven’t found a calculator for it yet.
For example, I want to calculate how soon I can pay off my mortgage if the interest rate has changed multiple times and I occasionally make some additional payments.
I will send you something. Let me know if it works for you.
Don
Another gem! Thanks so much for sharing your time and talent.
Thank you, Jim
I have a need for updating a current financial spreadsheet. How can I visit with you?
Chuck,
Send me a copy of the excel workbook, along with an explanation of what you are working on.
blog@pistulka.com
Don