
Copyright 20112019. All Rights Reserved.
Twitter Updates
 RT @MrAndrewCotter: Some sports are slower. More about the strategy. https://t.co/JMBaGJ1tSd 5 months ago
 RT @R_Thaler: Brilliant piece by Michael Lewis. Needs to go viral so please RT bloomberg.com/opinion/articl… 5 months ago
 A #LeapYear puzzle welltemperedspreadsheet.wordpress.com/2012/01/27/puz… 6 months ago
 Join us at QWAFAFEW Denver on March 5th for our firstever presentation on Environmental, Social and Governance (ES… twitter.com/i/web/status/1… 6 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
 Puzzle #2: Weighted Average LTV
 Financial Math Puzzles
 Good Fences Make Good Spreadsheets, Part 1
 Puzzle #3: A Better Answer
 Fast Formulas #3 (Followup): The Derivation
 Fast Formulas #1: Average Life of Mortgage (as Scheduled)
 Puzzle #2: Answers to Followup Questions
 Fast Formulas #2: Average Life of Mortgage (Amortizing with Balloon)
 Fast Formulas #3: Pool Average Life with CPR Prepayments
 Fast Formulas #3: The Spreadsheet
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: Bond Math Puzzle
Puzzle #8: James Bond
Few know that a scene was cut from the James Bond movie Goldfinger. Bond has been captured by Goldfinger and is strapped tightly to a large turntable. Bond’s feet are at the center of the platter and his head rests … Continue reading
Posted in Bonds, Fun, Math, Puzzles
Tagged Bond Math, Bond Math Puzzle, James Bond, laser blasts, Puzzle
2 Comments
Puzzle #6: Treasury Debt
Last week was historic for U.S. Treasury debt. The yield on the 10year Treasury dipped below 1.44% to its lowest level ever, and the total debt held by the public* rose to $11,006,251,094,374.26. Some might argue that $11 trillion in public … Continue reading
Posted in Bonds, Economics, Fun, Math
Tagged Bond Math Puzzle, Finance Math Puzzle, Financial Math, Puzzle, Treasury Debt
8 Comments
Puzzle #4: Bond Pricing
Here’s another puzzle I’ve used to teach bond math. It’s not hard, but it requires some understanding of bond concepts that I will explain as we go (I beg the patience of bond mavens). Suppose you are the financial advisor … Continue reading
Posted in Bonds, Fun, Math, Puzzles
Tagged Bond Math Puzzle, Callable Premium Bonds, Finance Math Puzzle, Financial Math, Math, Price to Call, Price to Maturity, Puzzle, Puzzle #4, Yield to Maturity
12 Comments
Puzzle #3: Mortgage with Balloon
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 Fun, Math, Puzzles
Tagged Average Life Formula, Bond Math Puzzle, Finance Math Puzzle, Financial Math, Math, Puzzle, Puzzle #3, Weighted Average Life
22 Comments
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