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

Download:

http://pistulka.com/Excel_Shared/Sample_Amortizations.xlsx

 

Don Pistulka
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.

6 Comments

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

Leave a Reply

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