Sample Amortizations

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



Don Pistulka

Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.


  1. what is the average life (years and average Life (months) for on an amortization schedule?

  2. 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!

    1. 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.


  3. 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.

      1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *