Companion files · The Private Markets Career Guides

The Healthcare Finance Director

A Practitioner's Guide to Healthcare Finance: Hospital Revenue and Payer Mix, Contractual Allowances, Cost per Case, Labor Productivity, Budgeting, Capital Planning and Bond Covenants.

These are the companion files of the book. Five workbooks follow Callowbeck Community Hospital, the fictional community hospital of the case, across two calendar years by month: revenue from gross charges to net by payer, labor and productivity, the budget and its variances, liquidity and the covenants, and the three options of the year-two decision. Each keeps the case’s figures in blue input cells that you overwrite with your own, guards every division against an empty divisor, and ends with a Checks tab. A toolkit holds the check-lists of Appendix B in editable form.

The five workbooks, the toolkit and the read-me, in one archive167 KB

The archive holds the five workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

Gross to net$221,026,053 - $109,407,895 - $2,873,339 = $108,744,819: commercial net revenue in 2025, the final denial write-offs on their own line
One definition3,744 x $70,488,224 / $35,822,592 = 7,367: adjusted patient days for January 2025, computed month by month
The covenant$52,399,369 / (($270,080,782 - $15,420,000) / 365) = 75.1: days cash on hand at the end of 2025, against a covenant of 75

The files are provided as they are, without warranty of any kind. The model is illustrative: Callowbeck Community Hospital, the city of Rendlemoor, its people and its partners are fictional; the volumes, charges, payment ratios, hours, rates, covenant levels and effects are the book’s assumptions, not market norms or the record of any real hospital. The workbooks compute; they decide nothing about compliance, reimbursement or tax status, and nothing here promises any financial result. Not legal, tax, reimbursement or investment advice.