# The Transportation Infrastructure Investor: companion files

Julian R. Sterling

## What is here

- TII_1_Traffic_and_Revenue.xlsx (Chapters 4 and 5; Traffic and revenue workbook of Appendix A; no exercise): sheets Inputs, Traffic, then Checks. 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.
- TII_2_Costs_and_Reserve.xlsx (Chapter 6; Costs and reserve workbook of Appendix A; no exercise): sheets Inputs, Traffic, Costs, then Checks. 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.
- TII_3_Debt_and_Coverage.xlsx (Chapters 7, 12 and 15; Debt and coverage workbook of Appendix A; no exercise): sheets Inputs, Traffic, Costs, Debt, then Checks. 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.
- TII_4_Stake_Valuation.xlsx (Chapters 8 and 14; Stake valuation workbook of Appendix A; exercises 1, 2, 3, 4, 5, 6, 7 and 8): sheets Inputs, Traffic, Costs, Debt, Stake, then Checks. 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.
- TII_5_Availability_P3.xlsx (Chapter 9; Availability P3 workbook of Appendix A; exercise 9): sheets Inputs, Availability, then Checks. The Brindlecourt Crossing: debt sized on coverage ($459.4 million), deductions for unavailability and what the O&M contractor carries.
- TII_6_Airport_and_Terminal.xlsx (Chapters 10 and 11; Airport and terminal workbook of Appendix A; exercise 10): sheets Inputs, Airport, Terminal, then Checks. 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).
- TII_Transportation_Investor_Checklists.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every assumption of the case, followed by an empty yellow column for yours and a Used column: the case's figures in blue on a light blue background, your figure in the yellow column when you type one. The Used column takes your figure when there is one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Each workbook carries every calculation sheet its outputs need, so it works on its own; the sheets are the same in every file. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 10 exercises of Appendix A is done in the workbook listed above: change the one input the exercise names, read the answer, then clear the cell.

Two inputs to try first:

1. In TII_4_Stake_Valuation.xlsx, on Inputs, type 90 percent for traffic in every year: toll revenue, coverage and distributions fall at once, and Ridgemere's internal rate of return on the Stake sheet drops below the hurdle.
2. In TII_4_Stake_Valuation.xlsx, on Inputs, type 2.50 percent as the cap on the annual toll increase: tolls follow inflation only, and the value of the stake falls further still.

To use a workbook on a real concession, replace every input with figures from the concession agreement, the traffic and revenue study, the financing documents and the concessionaire's own accounts, rebuild the base case until it matches what the concessionaire reports, and only then make your own changes. Take questions of law, tax and engineering to counsel, the tax adviser, the traffic consultant and the independent engineer. The workbooks are separate files with no link between them.

## A word of caution

Ridgemere Infrastructure Partners, Fennwick Mobility Partners, the Fennwick Expressway, the Brindlecourt Crossing, Ellsmoor Regional Airport and the Kestrelmouth Container Terminal are fictional, and their state is not named. Traffic, tolls, toll rules, elasticities, costs, debt terms, covenants, prices and discount rates are teaching assumptions, not market norms, averages or the terms of any real concession. The years 2027 to 2066 are projections of the case model, never a forecast of traffic. No real concessionaire, fund, authority, airport or port is described. Nothing here is investment, legal, tax or accounting advice.
