Companion files · The Private Markets Career Guides
How Funds Run Infrastructure After the Deal: The 100-Day Plan, Boards, KPIs, Regulated and Contracted Assets, Covenants, Refinancing, LP Reporting, ESG and Exit.
These are the companion files of the book. One workbook rebuilds Aldmere Infrastructure, the fictional mid-market platform the book follows from completion to a modeled exit: the RAB roll-forward and allowed revenue of a regulated water utility, a solar portfolio under PPAs with its 2026 outage and lock-up, an availability-based schools concession to 2044, and the holding company with its 2026 refinancing, the quarterly valuation convention, the exit, the multiple and the IRR. A second file holds the asset manager’s checklists and templates in editable form. No sign-up, no email is asked for, nothing is locked. Blue type is an input, black type is a formula.
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 3, 7 to 13 and 15
One Inputs sheet holds every assumption: regulation, operations, contracts, debt, the refinancing, valuation and exit. One sheet per business, one for the holding company and the fund's returns, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook21 KBAppendix B
Day-one checklist, 100-day plan template, board pack and monthly pack contents, covenant and obligations calendar, quarterly LP report checklist and exit readiness 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| The lock-up | A 2026 DSCR of 1.18x at Aldmere Solar against a 1.20x lock-up: $2.6 million trapped, released in 2027 |
| The refinancing | A $250 million holding company loan replaces $150 million, $96.0 million goes to the fund, and interest cover falls to 1.14x against a 1.10x covenant |
| The return | $436.1 million invested, $815 million returned in the plan: 1.87x and an IRR of 10.8 percent |
The files are provided as they are, without warranty of any kind. The model is illustrative: Ferrand Capital, its funds, Aldmere Infrastructure and its businesses are fictional, the water regulation is a teaching simplification, and the figures are the book’s assumptions, not market terms or forecasts. Nothing here is investment, legal, tax or accounting advice.