Macaulay Duration Plus Balloon Payment

By Don Pistulka
Excel Spreadsheet, UncategorizedLeave a Comment on Macaulay Duration Plus Balloon Payment

I was asked by a reader to add an option to the workbook “MacaulayDuration”. The option is to include a balloon payment. I added the option in a separate workbook called “MacaulayDuration_with_Balloon”. Read my post on “Macaulay Duration of an Amortizing Loan” for further information.

Duration_Balloon

Download “MacaulyDuration_with_Balloon” from:

http://www.pistulka.com/Excel_Shared/

Downloads Written in Excel 2013

Post Views: 83
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 *