Companion files · The Private Markets Career Guides
How to Run the Close, Recognize Revenue, Explain Variances, Report to Lenders and Owners, Pass the Audit and Build a Career in Corporate Accounting.
These are the companion files of the book. One workbook rebuilds the Harlan Instruments case: the June 2026 close corrections, the allocation of a bundled hospital contract with its deferred revenue, the third-quarter volume, price and cost variances, and the covenant certificate with its add-backs, cap and cushion. A toolkit holds the checklists and templates 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.
Chapters 4 to 11
One Inputs sheet holds every assumption: the close corrections, the contract prices, units, prices and costs, the debt, the add-backs and the covenant terms. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook17 KBAppendix B
Close calendar template, balance sheet reconciliation checklist, journal entry review checklist, cut-off checklist, revenue contract review checklist, variance commentary template, covenant certificate checklist and audit PBC checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Close | Freight not accrued and an accrual booked twice turn second-quarter EBITDA of $10.4 million into $9.8 million |
| Revenue | A $1,500,000 contract allocates $352,941 to a three-year service plan: $1,215,686 of revenue in 2026, $284,314 deferred |
| Covenant | Covenant EBITDA of $39.1 million gives leverage of 3.07x against 3.50x, a cushion of $4.8 million |
The files are provided as they are, without warranty of any kind. The models are illustrative: Harlan Instruments, Westbrook Equity and Marrick Credit Partners are fictional, the models are simplified, and the figures are the book’s assumptions, not market terms, ratings or forecasts. Nothing here is investment, legal, tax or accounting advice.
More in fund operations, 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.
Also available as a standalone free template: month-end close and covenant model.