 Copyright 20112017. All Rights Reserved.
Twitter Updates
 RT @benorlin: https://t.co/KG9YfM6vFk 1 month ago
 RT @panlepan: Last one for tonight! đźšŁâ€Ťâ™€ď¸Ź https://t.co/UWiAyvcxD8 2 months ago
 ICYMI, my take on ultralong bonds and managing UST debt, in @FTAlphaville twitter.com/SmithWinthrop/â€¦ 2 months ago
 RT @scienmag: John V. Muntean has a Ph.D. in Chemistry and works as a spectroscopist in a laboratory but still finds time to play with LEGOâ€¦ 2 months ago

Recent Posts
 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
 NAMA in NOLA
 Taming Premium Bonds
 Fifth Annual Municipal Finance Conference
 Generating Sitemap Links with Excel
 Spaghetti Puzzle #1
 A Mathematician’s New Year’s Resolutions
Top Posts & Pages
 Fast Formulas #1: Average Life of Mortgage (as Scheduled)
 Fast Formulas #3: The Spreadsheet
 Puzzle #2: Weighted Average LTV
 Fast Formulas #3: Pool Average Life with CPR Prepayments
 Good Fences Make Good Spreadsheets, Part 1
 Fast Formulas #2: Average Life of Mortgage (Amortizing with Balloon)
 Tables vs. Fences
 Puzzle #3: A Better Answer
 Fast Formulas #5: QuasiGeometric Series (The Other Trick)
 Puzzle #9 (Followup): Binary Sudoku and the Limits of Visualization
Recent Comments
My Letter to the Wal… on The National Debt is Closer th… Bob Rosinsky on Quarter the Cross Win Smith on Fast Formulas #1: Average Life… Win Smith on Quarter the Cross Bob Rosinsky on Quarter the Cross Mohammed Mustafa on Fast Formulas #1: Average Life… Win Smith on Fast Formulas #2: Average Life… Tianhang on Fast Formulas #2: Average Life… Win Smith on NAMA in NOLA Win Smith on NAMA in NOLA 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 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 Optimization Physics Pi Day Precious Metals Prime Numbers 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 MaturityBlogroll
Consultants
Father/Daughter Math Adventures
LinkedIn
My Company
Recommended Music
Tumblr
Meta
Tag Archives: Puzzle #1
Puzzle #1: Epilogue
Puzzle #1 posed the question: given a $100,000 mortgage at 5% with monthly payments of $536.82 for 30 years, what is the average life of the principal payments? The puzzle was to be solved with just a few simple calculations. … Continue reading
Posted in Bonds, Fun, Math, Puzzles
Tagged Bond Math Puzzle, Finance Math Puzzle, Financial Math, Puzzle, Puzzle #1, Weighted Average Life
7 Comments
Answer to Puzzle #1
The answer to Puzzle #1 is now visible as a comment from Ron Page under the original post. Ron has provided the only correct answer so far (he’s missing a pair of parentheses, but it’s clear what he means). His … Continue reading
Posted in Fun, Math, Puzzles
Tagged Bond Math Puzzle, Finance Math Puzzle, Financial Math, Puzzle, Puzzle #1, Weighted Average Life
4 Comments
Clue for Puzzle #1
For anyone who needs a little help with Puzzle #1, I placed a clue in a comment to this post. Other Posts on Puzzle #1: Puzzle #1, Answer to Puzzle #1, Puzzle #1: Epilogue Other Puzzles: Puzzle #2, Puzzle #3, … Continue reading
Posted in Fun, Math
Tagged Bond Math Puzzle, Finance Math Puzzle, Financial Math, Puzzle, Puzzle #1, Weighted Average Life
4 Comments
Puzzle #1: Mortgage Average Life
Here is the first in a series of puzzles that might have something to do with finance or math. The first to respond with a correct answer will be recognized in The WellTempered Spreadsheet Hall of Really Smart People. First, … Continue reading
Posted in Fun, Math, Puzzles
Tagged Average Life Formula, Bond Math Puzzle, Finance Math Puzzle, Financial Math, Puzzle, Puzzle #1, Weighted Average Life
21 Comments