Companion files
Modelling, Valuation, Diligence and Risk in Infrastructure Investment
These are the companion files of The Infrastructure Investment Analyst by Julian R. Sterling.The book on Amazon →
These are the workbooks and documents that go with the book. The three original workbooks reproduce every figure the book states — except the three that do not, which the valuation workbook corrects. Around them: the two models with the inputs emptied, four printable working documents, a question book that marks itself, and three cases the book names and never takes to a number. Every number is a live formula. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Nine workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it states can be traced to a live formula. Download these three130 KB
Chapter 4
The Calder Toll Road, live. The chapter gives the parameters — twenty-eight miles, a forty-year concession with fourteen years elapsed, a lender’s floor of 1.25 times coverage in the tightest years, debt of roughly 65 per cent of enterprise value, a resurfacing in year four, an exit around year eight, a levered return in the low teens — then describes the mechanic in prose and never prints the arithmetic. This file is the arithmetic.
The sculpt asks, for every year of the tenor, how large a first-year debt service that year could carry while still clearing 1.25 times, then takes the smallest answer and names the year that gave it. Leverage is not an input anywhere in the file: it comes out at 63.8 per cent, and the equity return comes out at 11.6 per cent. Six controls test those claims and say out loud whether they hold.
Appendices B and C
The fifteen diligence workstreams, one row each, with an owner, a target date and the column most trackers leave out: whether the finding was material to the investment thesis. A finding that changes nothing and a finding that changes the price look identical in a tracker that only records completion.
The risk register uses the four families of Chapter 8 — regulatory, political, construction, demand — and forces every risk to be labelled mitigated, priced or accepted. The progress sheet counts the ones still unlabelled, and that count should be zero before the memo goes out.
Chapter 6, and the valuation appendix
Chapter 6 tells you how to value an infrastructure asset and never values one. It leaves seven quantitative claims standing without arithmetic behind them. This workbook builds the asset — a regulated utility, twenty-five years of concession left, eleven inputs — and computes all seven. Three of them need correcting.
It values the asset twice, by adjusted present value and by an equity discounted cash flow at a cost of equity relevered every year as the debt amortises, and the two routes agree to the last decimal. They agree only because the relevering uses net debt rather than the formula most textbooks print. Reconciling them once teaches more about the discount rate than any amount of reading about it.
The chapter warns that mismatching the cash flow and the rate costs “double digits”. It costs 33 per cent one way and 72 per cent the other — the error is larger than the answer. And there is a third mismatch the chapter does not mention, which is the common one because it does not look like a mistake: holding the weighted average cost of capital constant while the debt amortises overstates equity by 8.6 per cent. Every model with an amortising schedule and a fixed WACC contains it.
The chapter also says leverage lifts the equity return “up to a point”. There is no such point. The return rises all the way to eighty-five per cent gearing, because the cost of equity rises with it one for one. The point is a covenant, not an optimum, and it is set by the lender: coverage falls below one at eighty per cent, where the equity has to inject cash to keep the debt current.
The resurfacing is twelve million dollars, due in year four of the hold and every eight years after. The reserve holds 6 at acquisition and receives 1.5 a year, so it holds exactly 12 each time the road is resurfaced — which is what the chapter means when it describes equity cash flow as the residual after debt service and reserve funding. Set the reserve contribution to zero on the assumptions sheet and the shortfalls come out of operating cash: the binding year moves from year 1 to year 12, the debt falls from 171.3 to 131.1, and leverage from 63.8 to 48.0 per cent.
The second thing to try is the hold. At exit the concession has eighteen years left, not twenty-six, and the file values the exit on the years that actually remain. Push the hold from eight years to twelve and the exit value falls even though the asset has done nothing wrong. The chapter calls that assumption frequently overlooked; here it is priced.
The debt sculpting model and the Calder Water valuation, with the same formulas and every input emptied. Type your own asset into the amber cells and the model runs.
Blank set · two workbooks
Twenty-three inputs on the sculpting model: the concession, traffic and toll, costs and maintenance, the resurfacing and its reserve, the lender’s floor, the tenor and the exit. Sixteen on the valuation: the asset, the tax, the two rates, the gearing, the handback and the hold. Each workbook closes on a checks sheet that counts the inputs still empty and runs the tests that hold on any asset: the binding year clears the floor exactly, the debt is repaid within the tenor, the tenor and the hold end before the concession does, every resurfacing is paid from the reserve, and the two valuation routes agree.
Put the book’s inputs back and the book’s figures come back with them: 63.8 per cent leverage on the Calder Toll Road, 242.18 of equity value by both routes on Calder Water.
Download the blank set75 KBFour pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Structuring · due diligence · Appendix B · monitoring
A concession and handback read-through: each clause that decides the deal, where it sits in the agreement, and the cell of the model that prices it, because a clause with no cell is a clause the model ignores. An adviser report review, one column per report, with the seller’s capex set against the engineer’s. The investment committee memo frame, with the headline metrics the first paragraph must carry in the base case and the downside. And the quarterly asset review: metrics against the underwriting case, covenant headroom four quarters forward, the value bridge and the asset’s own early-warning indicators.
Download the PDF12 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All chapters
The numerical questions work the book’s own assets: the Calder Toll Road sculpt from revenue to the debt quantum, and Calder Water from the unlevered value to the cost of equity, the three mismatches, the dividend discount gap, the terminal value and the leverage table. They are marked against a tolerance, so a reasonable rounding passes. The score sheet counts the wrong answers by chapter, which gives the only revision list worth having.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book18 KBNew material, not a restatement. Three situations the chapters name in passing and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Case one · extends the Calder Toll Road
Four ways to pay for the same resurfacing, on the same road, at the same price. With the reserve bought at closing the road carries 171.3 of debt; with none it carries 85.0, because the lumpy year becomes the binding year. The 6 of reserve bought with the asset adds 43.1 of debt capacity and cuts the equity cheque by 37.1: a pound in the reserve is worth about seven pounds of debt. Pre-funding the resurfacing from year 1 does not escape the constraint either; it moves it to year 1.
Case two · extends the stress-testing section
The debt sculpted on the consultant’s traffic meets traffic 8 per cent lower. No default, but two years of lock-up and 3.79 of trapped cash. The equity return falls from 11.6 to 7.1 per cent, and two thirds of the damage is the exit, not the lock-up. A permanent shortfall of 4.5 per cent reaches the lock-up and 9.1 per cent the default, because the binding year has no cushion by construction. Sized on the downside, the same road carries 154.1 of debt instead of 171.3.
Case three · extends the valuation appendix
Calder Water bought at 646.68, 10.43 times EBITDA, and sold after ten years. The next buyer pays 552.28 for the fifteen years that remain, 7.54 times, although EBITDA has grown 18 per cent, and the return is exactly the 7 per cent cost of capital. At the entry multiple the model reports 9.22 per cent, as a perpetuity 12.20: returns the asset cannot earn. The handback doubles in present value while the fund owns it, and neither shortcut sees it.
Download the three cases67 KB| Amber fill | an input — you may edit these |
| No fill | a formula — do not overtype these |
| Checks sheet | controls that state their own verdict |
The traffic volume and the toll rate are placeholders, and the file says so. The book does not publish them, and presenting invented figures as the book’s would be dishonest. Everything the book does state is reproduced, and the checks sheet tests each one. Change the placeholders to your own asset and the whole file re-solves.
The Infrastructure Investment Analyst develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play · DRM-free PDF edition ($19.99).
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 22 Sep 2026 | Debt sculpting model corrected: a resurfacing the reserve cannot cover is now charged to cash flow, and the equity pays for the reserve it inherits. Leverage and the binding year are unchanged; the equity return is 11.6 per cent rather than 12.2. Blank model set, four printable working documents, the question book and three new cases added. Read-me rewritten. |
| 24 Aug 2026 | The Calder Water valuation workbook added. |
More in infrastructure and energy, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: debt sculpting model.
These files accompany The Infrastructure Investment Analyst. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.