Companion files · The Private Markets Career Guides
The Practitioner's Guide to Toll Roads, P3 Concessions, Airports and Seaports: Traffic, Tolls, Financing, Valuation and Risk.
These are the companion files of the book. Six workbooks follow the Fennwick Expressway, the fictional toll road of the case, and the 50 percent stake that Ridgemere Infrastructure Partners studies, from traffic to the price: traffic and revenue, costs and the reserve, debt and coverage, the stake valuation, an availability-payment P3, and an airport and a container terminal. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six 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.
Chapters 4 and 5
Traffic by vehicle class from 2027 to 2066, the toll rule (3.50 percent a year, capped), elasticity, the extension’s ramp-up and toll revenue, $162.0 million in 2027 and $300.0 million in 2036. Sheets: Inputs, Traffic, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: no exercise.
Download workbook 138 KBChapter 6
Operations and maintenance, the major maintenance reserve and the handback works on top of the traffic sheet: EBITDA of $129.8 million and CFADS of $113.4 million in 2027. Sheets: Inputs, Traffic, Costs, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: no exercise.
Download workbook 254 KBChapters 7, 12 and 15
The bonds and the federal loan repaid in level payments ($91.4 million a year), total and senior coverage, the lock-up test and distributions; lowest total DSCR 1.24 times in 2027. Sheets: Inputs, Traffic, Costs, Debt, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: no exercise.
Download workbook 379 KBChapters 8 and 14
Ridgemere’s 50 percent stake as a finite-life DCF: an internal rate of return of 9.81 percent against a hurdle of 9.00 percent, a value of $939.5 million at the hurdle, the multiples the price implies; exercises 1 to 8 run here. Sheets: Inputs, Traffic, Costs, Debt, Stake, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercises 1, 2, 3, 4, 5, 6, 7 and 8.
Download workbook 485 KBChapter 9
The Brindlecourt Crossing: debt sized on coverage ($459.4 million), deductions for unavailability and what the O&M contractor carries. Sheets: Inputs, Availability, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercise 9.
Download workbook 512 KBChapters 10 and 11
Ellsmoor Regional Airport under a single and a dual till ($15.00 against $30.00 per enplaned passenger) and the Kestrelmouth Container Terminal’s throughput, fees and EBITDA ($41.0 million). Sheets: Inputs, Airport, Terminal, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercise 10.
Download workbook 613 KBAppendix B
Reading a concession agreement; Reviewing a traffic and revenue study; Tolls and elasticity; Costs, major maintenance and handback; The financing documents; Valuing a finite concession; Diligence on a stake; The annual review.
Download the toolkit40 KBRead first
What each file holds, which workbook answers which chapter and which exercise, and the two inputs to change first.
Download the read-me5 KB| Toll revenue in 2027 | 36.6 million light-vehicle transactions at $3.31 and 4.1 million heavy-vehicle transactions at $9.94: $162.0 million |
| Coverage in 2027 | CFADS of $113.4 million over debt service of $91.4 million: a total DSCR of 1.24 times, the lowest year of the debt |
| The stake | $820.0 million for 50 percent: an internal rate of return of 9.81 percent against a hurdle of 9.00 percent, and a value of $939.5 million at the hurdle |
The files are provided as they are, without warranty of any kind. The model is illustrative: Ridgemere Infrastructure Partners, Fennwick Mobility Partners, the Fennwick Expressway, the Brindlecourt Crossing, Ellsmoor Regional Airport, the Kestrelmouth Container Terminal and their state are fictional, and the traffic, tolls, costs, debt terms, prices and discount rates are the book’s teaching assumptions, not market terms, averages or the terms of any real concession. The years 2027 to 2066 are projections of the case model.