Companion files · The Private Markets Career Guides

The Transportation Infrastructure Investor

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 six workbooks, the toolkit and the read-me, in one archive311 KB

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.

The files

Three numbers to reproduce first

Toll revenue in 202736.6 million light-vehicle transactions at $3.31 and 4.1 million heavy-vehicle transactions at $9.94: $162.0 million
Coverage in 2027CFADS 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.