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.

Leave a Reply

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