welltemperedspreadsheet.wordpress.com
Presentations | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/presentations
Financial Modeling and Math. These posts will connect you to some of my presentations. They all concern the debt issued by the U.S. Treasury and the Fed’s holdings of that debt. After the Taper: Risks for the Fed and the Treasury. Talk at the Chicago Fed. QWAFAFEW Talk on the National Debt: The Slides. GARP Presentation on Interest Rate Risk and the Treasury. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). Fast Formu...
welltemperedspreadsheet.wordpress.com
Win Analytics | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/my-company
Financial Modeling and Math. Is an independent research and advisory firm. The company provides financial advice, transaction structuring, cash flow modeling, portfolio valuations, research, and litigation support to participants in markets such as mortgage-backed securities, asset-backed securities, commercial real estate, education finance, project finance, public finance and renewable energy. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:.
welltemperedspreadsheet.wordpress.com
Fast Formulas #1: Average Life of Mortgage (as Scheduled) | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/2011/07/14/fast-formulas-1-average-life-of-mortgage-as-scheduled
Financial Modeling and Math. Puzzle #4: Bond Pricing. Fast Formulas #2: Average Life of Mortgage (Amortizing with Balloon) →. Fast Formulas #1: Average Life of Mortgage (as Scheduled). July 14, 2011. See Puzzle #1: Epilogue. The WAL for a standard mortgage can be found with the simple formula:. Is the weighted average life, in years;. Is the principal amount;. Is the annual interest rate;. Is the term of the mortgage, in months; and. Is the monthly payment. Is the monthly interest rate. You could work ou...
welltemperedspreadsheet.wordpress.com
Fast Formulas #6: Finding the Time | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/2015/06/30/fast-formulas-6-finding-the-time
Financial Modeling and Math. Fourth Annual Municipal Finance Conference. The Money We Live With →. Fast Formulas #6: Finding the Time. June 30, 2015. Florence Cathedral 24-Hour Clock: Wikimedia Commons. On this blog provide shortcut calculations for financial instruments such as mortgages and bonds. Most formulas involve the symbol. To represent the number of periods (e.g. years or months) until the end of the instrument. Usually. Time to Required Future Value. In other words, what is. You could also app...
welltemperedspreadsheet.wordpress.com
Economics | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/economics
Financial Modeling and Math. Some of the posts on this blog deal with economics. They fall into three categories:. Insights into how the Treasury and the Fed are managing their portfolios. The Treasury has begun to issue its floating rate notes. I questioned part of the Treasury’s rationale for floaters. There are three posts on the Reinhart-Rogoff controversy, two about precious metals, and one about a proposed reform of the municipal bond market. My Comment to the Treasury on Floating Rate Notes. You a...
welltemperedspreadsheet.wordpress.com
Fast Formulas | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/fast-formulas
Financial Modeling and Math. Posts on this blog provide shortcuts to laborious financial calculations. They were inspired by the Financial Math Puzzles. Some of the formulas are ancient, and some of them might be new. Here is a guide to the Fast Formulas (“FF”) posts and the key formulas they contain:. Average Life of Mortgage (As Scheduled). New Insight into an Old Formula. Average Life of Mortgage (Amortizing with Balloon). Pool Average Life with CPR Prepayments. Geometric Series (One of the Tricks).
welltemperedspreadsheet.wordpress.com
Win Smith | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/author/welltemperedspreadsheet
Financial Modeling and Math. Author Archives: Win Smith. August 10, 2016. The Bond Buyer published my commentary Taming Premium Bonds earlier today. Although callable premium bonds are very popular in the municipal market, I argue that they hurt issuers and the market. Market rules dictate that the proceeds to the issuer compensate only for high … Continue reading →. Fifth Annual Municipal Finance Conference. June 17, 2016. Generating Sitemap Links with Excel. April 13, 2016. January 5, 2016. Speaking of...
welltemperedspreadsheet.wordpress.com
Financial Math Puzzles | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/puzzles
Financial Modeling and Math. These fun, original puzzles can help sharpen your understanding of financial math. Some have been used in college finance courses. I learn valuable insights from your responses. For example, the shortcut formula I developed for Fast Formulas #3. Was based on a very clever solution to Puzzle #3. Answers to Follow-up Questions. Treasury Island, Part 1. Binary Sudoku and the Limits of Visualization. A Pi Day Problem. The Answer (Pi-Fingered Aliens). Leave a Reply Cancel reply.
welltemperedspreadsheet.wordpress.com
Fourth Annual Municipal Finance Conference | The Well-Tempered Spreadsheet
https://welltemperedspreadsheet.wordpress.com/2015/06/12/fourth-annual-muncipal-finance-conference
Financial Modeling and Math. Puzzle #11: The Answer (Pi-Fingered Aliens). Fast Formulas #6: Finding the Time →. Fourth Annual Municipal Finance Conference. June 12, 2015. I hope you can join us in Boston this summer at the Fourth Annual Municipal Finance Conference. As a discussant on one of the panels, I will respond to a paper on the economic impact of ratings outlooks. Space is limited, so please register before it is too late! This entry was posted in Bonds. And tagged Brandeis University. Enter your...
