
Copyright 20112019. All Rights Reserved.
Twitter Updates
 We’re so proud of her! Years ago she had deep ideas relating the Harry Potter story to trauma recovery. Now she h… twitter.com/i/web/status/1… 1 month ago
 Please join us at QWAFAFEW Denver on September 12 as George Bonne of @MSCI_Inc discusses how investors are using a… twitter.com/i/web/status/1… 3 months ago
 RT @tedgioia: Little known jazz fact: A scientific term called a "tatum" (in honor of jazz pianist Art Tatum) has been defined at MIT as "… 7 months ago

Recent Posts
 September in Paris
 Talk on Alternative Factor Investing
 Bond Talk on May 23
 New Paper on Bond Portfolio Dynamics
 Spam Followers
 The Invisible RunOff
 My Letter to the Wall Street Journal
 Quarter the Cross: An Elegant Construction
 Quarter the Cross
 My FT Alphaville Commentary on Managing U.S. Treasury Debt
Top Posts & Pages
 Generating Sitemap Links with Excel
 Puzzle #2: Weighted Average LTV
 Fast Formulas #1: Average Life of Mortgage (as Scheduled)
 Good Fences Make Good Spreadsheets, Part 1
 Fast Formulas #2: Average Life of Mortgage (Amortizing with Balloon)
 Fast Formulas #3: Pool Average Life with CPR Prepayments
 Fast Formulas #4: Geometric Series (One of the Tricks)
 Spaghetti Puzzle #1
 Fast Formulas #5: QuasiGeometric Series (The Other Trick)
 Puzzle #9 (Followup): Binary Sudoku and the Limits of Visualization
Recent Comments
Categories
Archives
Tag Cloud
 Average Life Formula
 Benjamin T. Solomon
 Big Data
 Bond Math
 Bond Math Puzzle
 Bond Puzzle
 Brandeis University
 Brookings Institution
 Calculus
 Calendar Puzzle
 Callable Premium Bonds
 Carmen Reinhart
 Christmas Trees
 Closed Formula
 Conferences
 Cool Graphs
 Derivative
 Economics
 Excel Tables
 Fast Formulas
 Federal Reserve
 Finance Math Puzzle
 Financial Math
 Floating Rate Debt
 FRNs
 GARP
 Geometric Series
 Gravitation
 Halton Sequence
 Humor
 Innovations
 Interest Rate Risk
 Japan
 Johann Sebastian Bach
 Ken Rogoff
 Loan Average Life
 Marc Faber
 Math
 MATLAB
 Matt Henderson
 MortgageBacked Securities
 Municipal Bonds
 Municipal Finance Conference
 National Debt
 Optimization
 Physics
 Precious Metals
 Public Debt
 Pure Math
 Puzzle
 Puzzle #1
 Puzzle #2
 Puzzle #3
 QuasiGeometric Series
 Quasirandom
 Quotes
 QWAFAFEW
 Representing Numbers
 Seeking Alpha
 Space Travel
 Spreadsheet Tips
 Talks
 TED Talks
 The Bond Buyer
 Thomas Herndon
 Treasury Debt
 Treasury Floaters
 Tsunami
 U.S. Treasury
 U.S. Treasury Debt
 UC Denver
 volunteerAKITA
 Weighted Average Life
 Weighted Average LTV
 Weighted Average Maturity
Blogroll
Consultants
Father/Daughter Math Adventures
LinkedIn
Recommended Music
Tumblr
Meta
Tag Archives: Weighted Average Life
Fast Formulas #3 (Followup): The Derivation
Fast Formulas #3: Pool Average Life with CPR Prepayments presented Formula 3.1., a compact formula for the weighted average life of a homogeneous loan pool assuming a constant prepayment rate. I wrote that the formula took a few pages and “a couple … Continue reading
Puzzle #7 (Followup): Treasury Island, Part 1
In Puzzle #7: The Mysterious Islands, I told the story of two islands where each individual’s remaining lifespan can be perfectly predicted. The lifespans on Uniformia are evenly distributed, and their average remaining life expectancy will gradually decline over time. … Continue reading
Posted in Bonds, Fun, Math, Puzzles
Tagged Life Expectancy, Puzzle, Weighted Average Life
Leave a comment
Fast Formulas #5: QuasiGeometric Series (The Other Trick)
In Fast Formulas #3: Pool Average Life with CPR Prepayments, I described Formula 3.1., a compact formula for the average life of a prepaying loan pool, and I wrote that the formula had been found by using “a couple of … Continue reading
Posted in Fast Formulas, Math, Uncategorized
Tagged Duration, Fast Formulas, Geometric Series, QuasiGeometric Series, Weighted Average Life
2 Comments
Fast Formulas #3: The Spreadsheet
Fast Formulas #3: Pool Average Life with CPR Prepayments showed a shortcut for finding the weighted average life (“WAL”) of a homogenous pool of loans assuming a constant prepayment rate. The shortcut, Formula 3.1, takes just a few steps to calculate … Continue reading
Posted in Fast Formulas, Math, Spreadsheet Tips
Tagged Average Life Formula, Excel Tables, Fast Formulas, Weighted Average Life
2 Comments
Fast Formulas #3: Pool Average Life with CPR Prepayments
Fast Formulas #2: Average Life of Mortgage (Amortizing with Balloon) presented a compact formula for calculating the average life of a mortgage that pays as scheduled until it is paid off with a “balloon” payment before the scheduled end of its term. It occurred to … Continue reading
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 fixedrate mortgage that pays as originally scheduled. I found this formula (which is probably not original) by substituting the standard level … Continue reading
Posted in Fast Formulas, Math
Tagged Average Life Formula, Closed Formula, Fast Formulas, Financial Math, Loan Average Life, Math, Weighted Average Life
12 Comments
Fast Formulas #1: Average Life of Mortgage (as Scheduled)
The weighted average life (“WAL”) of a mortgage is the average time until principal is repaid. It is also the average amount of time that the principal is outstanding. Recall that for a standard fixedrate mortgage with level payments, the principal … Continue reading
Posted in Fast Formulas, Math
Tagged Average Life Formula, Closed Formula, Fast Formulas, Financial Math, Loan Average Life, Math, Weighted Average Life
9 Comments