# The Municipal Bond Analyst: companion files

Julian R. Sterling

## What is here

- **Municipal_Bond_Analyst_Model.xlsx**: the workbook that rebuilds the Harlow Bend case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, City Credit, Pension, Water and Sewer, New Issue, Investor Tax, Checks.
- **Municipal_Bond_Analyst_Toolkit.docx**: the checklists of Appendix B (reading an official statement, general obligation review, revenue bond review, pension and OPEB review, pricing day, surveillance and EMMA monitoring, interview preparation), in editable form.

## Which sheet answers which chapter

- Chapters 5, 6 and 7: City Credit (general fund, fund balance, debt ratios, fixed costs, scorecard)
- Chapter 7: Pension (funded ratio, discount rate sensitivity, contributions)
- Chapters 8 and 9: Water and Sewer (coverage, days cash, stress, the decline that reaches the rate covenant)
- Chapters 11 and 12: New Issue (twenty maturities, prices to maturity or call, premium, proceeds, underwriter's discount, TIC)
- Chapters 3 and 13: Investor Tax (tax-equivalent yield, yield to worst, de minimis, AMT)

## Two inputs to change first

1. On Inputs, raise the revenue decline of the stress case from 8 percent to 15 percent: watch the system's coverage fall below the 1.20 times rate covenant.
2. On Inputs, change the coupon of the new issue from 5.00 to 4.00 percent: see the premium, the proceeds and the prices move while the true interest cost barely changes. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

The City of Harlow Bend, its utility, Penwick & Rowe Securities, Tessaly Park Advisors and Orrin Lake are fictional; every market level is a teaching assumption, not the market on any date. Provided as is, without warranty. Not investment, legal, tax or accounting advice.
