welltemperedspreadsheet.wordpress.com
Fast Formulas #2: Average Life of Mortgage (Amortizing with Balloon)
Fast Formulas #1: Average Life of Mortgage (as Scheduled) showed a quick way to calculate the weighted average life (“WAL”) of a fixed-rate mortgage that pays as originally scheduled. …