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.

Download “MacaulyDuration_with_Balloon” from:

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

Downloads Written in Excel 2013