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
what is the average life (years and average Life (months) for on an amortization schedule?
Hi Suzanne
The average life is the number of years the unpaid principal will remain outstanding.
Don
Hi Don, thank you so much for your work on this blog and spreadsheets! Do you have a loan amortization that has Credit Life/Disability or Debt Protection included? I’m stuck on how to include those in an amortization. Any assistance would be greatly appreciated.
Thank you!
Kolin,
It seems that Credit Life is just an insurance policy on a loan. I’m not sure how to apply the policy to an amortization schedule. I will send an email to you and maybe you can explain how it might apply.
Don
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
Hi Don,
I, too, am in search of a specialty amortization schedule. I am trying to produce an ongoing schedule for a note where principal and interest are both on demand, with fairly random payments. I started with your variable rate model, but am having trouble with the periodic payments. Any help you could provide would be very much appreciated! Thank you.
Megan,
I have some questions. I will email you.
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