A reader asked for a simple amortization schedule that could handle both interest only and a balloon payment. You can find it here:
“SimpleA“.
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.
[…] Simple Amortization Schedule – Excel@CFO – Pistulka.com – A reader asked for a simple amortization schedule that could handle both interest only and a balloon payment. You can find it here: “SimpleA”. […]
Have you ever created a simple interest spreadsheet with multiple interest rates, multiple draw downs & multiple repayment amounts (uneven) using an annual interest function? If not, do you know anyone who has a template like this?
Steve,
Take a look at these posts. All have spreadsheets attached. You might be able to use one. If not, sketch out an example of what you are looking for and send it to me.
Amortization – Variable Terms, Rates, & Payments
Amortization Model – All Variable
Variable Rate Amortization – Day/Year Count & Last Payment Options
Amortization – Variable Terms, Rates, & Payments
Don