 Copyright 20112017. All Rights Reserved.
Twitter Updates
Error: Twitter did not respond. Please wait a few minutes and refresh this page.

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: Pool Average Life with CPR Prepayments
 Puzzle #3: A Better Answer
 Fast Formulas #2: Average Life of Mortgage (Amortizing with Balloon)
 Puzzle #2: Weighted Average LTV
 Puzzle #1: Mortgage Average Life
 Fast Formulas #3: The Spreadsheet
 Extending the Weighted Average Maturity: Complete Nonsense?
 Fast Formulas #5: QuasiGeometric Series (The Other Trick)
 Puzzle #9: Island of Games
Recent Comments
Win Smith on Puzzle #7: The Mysterious… Elijah DePalma on Puzzle #7: The Mysterious… Rod on Puzzle #2: Weighted Average… 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… 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 Maturity
Blogroll
Consultants
Father/Daughter Math Adventures
LinkedIn
My Company
Recommended Music
Tumblr
Meta
Tag Archives: Fast Formulas
Fast Formulas #6: Finding the Time
The Fast Formulas on this blog provide shortcut calculations for financial instruments such as mortgages and bonds. Most formulas involve the symbol n to represent the number of periods (e.g. years or months) until the end of the instrument. Usually … Continue reading
Posted in Bonds, Fast Formulas, Math
Tagged Bond Math, Fast Formulas, Math, Mortgage Math, Time Value of Money
2 Comments
Fast Formulas #1 (Followup): New Insight into an Old Formula
Ugarte (Peter Lorre): You despise me, don’t you? Rick (Humphrey Bogart): If I gave you any thought I probably would. – Casablanca If you work in finance, I bet there is something you use all the time, but … Continue reading
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
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 Guide
There is now a handy Fast Formulas Guide at the top of this blog. It summarizes the key formulas and the posts that describe them. The guide may help you see connections between the formulas. By the way, I upgraded … Continue reading
Fast Formulas #4: Geometric Series (One of the Tricks)
In Fast Formulas #3: Pool Average Life with CPR Prepayments, I presented Formula 3.1, a shortcut calculation for the average life of a loan pool under a constant prepayment assumption. I mentioned that Formula 3.1 was derived by using “a … Continue reading
Posted in Fast Formulas, Math
Tagged David Hilbert, Fast Formulas, Geometric Series, Math, Matt Henderson
5 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