Companion files · The Private Markets Career Guides

The Municipal Bond Analyst

Municipal Bonds and Muni Credit: General Obligation and Revenue Bonds, Debt Service Coverage, Pensions, Tax-Exempt Investing, Ratings, Underwriting and the Career.

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 workbook, the toolkit and the read-me, in one archive61 KB

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 →

The files

Three numbers to reproduce first

The utilityNet 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 planFunded 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.

Also by Julian R. Sterling

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.