Companion files · The Private Markets Career Guides
Municipal Bonds and Muni Credit: General Obligation and Revenue Bonds, Debt Service Coverage, Pensions, Tax-Exempt Investing, Ratings, Underwriting and the Career.
PDF, $19.99 Apple Books Google Play
These are the companion files of the book. One workbook rebuilds the City of Harlow Bend, the fictional city the book follows from its audited statements to the closing of its bond issue: the general fund and fund balance, debt and pension ratios, fixed costs, the water and sewer system's coverage and stress test, the twenty maturities of the new issue priced to maturity or to the call, the true interest cost, and the investor's tax arithmetic. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Chapters 3, 5 to 9, 11 to 13
One Inputs sheet holds every assumption: the city, the pension plan, the utility, the new issue and its benchmark scale, taxes and the fund's trades. One sheet each for the city, the pension plan, the utility, the new issue and the investor's tax arithmetic, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook23 KBAppendix B
Reading an official statement, general obligation review, revenue bond review, pension and OPEB review, pricing day for the public finance associate, surveillance and EMMA monitoring, and an interview preparation plan.
Download the toolkit41 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| The utility | Net revenues of $82.0 million cover $47.0 million of debt service 1.74 times; an 8 percent revenue decline takes coverage to 1.43 times |
| The pension plan | Funded 73.0 percent at a 7.00 percent discount rate, 65.2 percent at 6.00 percent |
| The new issue | $150 million of 5.00 percent bonds sold for $164.977 million, a true interest cost of 3.95 percent |
The files are provided as they are, without warranty of any kind. The model is illustrative: the City of Harlow Bend, its utility, the underwriter, the advisor and the fund are fictional, and every market level is a teaching assumption, not the market on any date. Nothing here is investment, legal, tax or accounting advice.
More in credit and debt, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.