Companion files
Build a Three-Statement Model, DCF, Debt Schedule, and LBO in Excel from One Integrated Case
These are the companion files of Financial Modeling from First Principles by Julian R. Sterling.The book on Amazon →
Also as an ebook on Apple Books · Google Play, and as a DRM-free PDF edition ($19.99).
The four Excel workbooks that go with the book. One company, Alder Ridge Components, carried from its reported statements to a five-year forecast, a revolver and a cash sweep, a DCF and a leveraged buyout. Every figure the book prints comes from these files, and fourteen checks read PASS in all three scenarios. The same operating plan is worth 230.6 million to a buyer who discounts it and returns 2.35x to a sponsor who levers it; read with the wrong debt schedule, it returns 3.10x. The error lab shows you how that happens.
Free to download. No sign-up, no email address, nothing to fill in.
The four workbooks, seven working documents to print, three new worked cases and the read-me. Each file can also be downloaded on its own below. Last revised 15 November 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.
Chapters 1 to 17
Thirteen sheets in dependency order: Historical (2024 and 2025 reported, the 1.2 million plant consolidation cost added back, the opening balance sheet), Scenarios (one selector, base, downside and upside), Operations (three product lines built from units and price), Working Capital, Fixed Assets, Debt (term loan, revolver, minimum cash, sweep), Statements (income statement, balance sheet and an indirect cash-flow statement that ties to it), DCF, LBO, LBO Debt and Checks.
Base case: DCF enterprise value 230,620,021, equity value 209,400,121; LBO at 10.0x with 4.5x of debt, exit at 9.0x, MOIC 2.35x, IRR 18.7 per cent. Downside: 0.82x, and a revolver draw of 3.8 million in 2027 that the model funds and repays by 2029.
Download43 KBChapters 2 to 17, Chapter 20
The same workbook with its 693 formula cells emptied. Historical, Assumptions, Scenarios and Checks stay intact, so the checks are live while you build. A Progress sheet counts the cells still empty on each sheet; the Instructions sheet gives the build order. The target is the same answer as the complete model, to the dollar.
Download38 KBChapters 12 and 18
A full copy of the model with eight defects behind switches: a working-capital sign, a missing depreciation line, typed cash, a sweep that ignores minimum cash, capital expenditure counted twice, tax on EBITDA, a terminal value grown twice, and exit net debt read from the wrong capital structure. Six of them break a check. Two do not, and those are the ones a reviewer has to find by reading. An Audit Register to fill in, and a Guide with the answer.
Download49 KBChapter 19 and Appendix C
A separate, simpler case on the same company: revenue growth of 5 per cent, an 18 per cent margin, debt held flat. Inputs, a build area and an answer key: enterprise value 156,282,391 and equity value 135,062,491 at 31 December 2026, with three checks and the timing convention stated.
Download15 KBSeven pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1, 12, 15 to 19 · Appendices B and C
The decision page of Chapter 1 (the sentence, the purchase arithmetic and the three failure conditions), Appendix B’s integrated model checklist, Chapter 12’s check register with the kind of evidence each check gives, Chapter 18’s five review passes and audit register, the enterprise-to-equity bridge of Chapter 15, sources and uses with the returns bridge, and the ninety-minute budget with the marker’s trace. Alder Ridge’s figures are printed beside an empty column for yours.
Download the PDF20 KBNew material, not a restatement. Each case takes a situation the book names and does not compute. Each is one workbook: the note is the first sheet, then the book’s own LBO Debt schedule rebuilt in live formulas (it reproduces 2.35x and 18.7%), the case beside it, and a checks sheet. Any value the book does not give is marked ADDED.
Chapter 10 · Case one
Chapter 10 sweeps 100% of the cash above the floor and says real agreements step the share down as leverage falls. With 75%, 50% and then nothing (ADDED), exit debt is $72.9 million instead of $48.2 million and $28.5 million of cash sits idle. Net debt barely moves, so the sponsor loses only $1.2 million of exit equity: interest on cash that repaid nothing. In the downside the clause changes almost nothing.
Chapter 17 · Case two
Chapter 17 tests a 30% cap on interest deductions in the base case and finds it immaterial, then says it matters more in the downside. It does: on EBIT the cap never leaves room, $15.7 million of interest is still carried forward at exit, the revolver peaks at $4.64 million instead of $3.78 million, and MOIC falls from 0.819x to 0.786x.
Chapter 17 · Case three
The book warns that MOIC1/5 is valid only without interim dividends. A recap at the end of 2029 to 4.0x EBITDA (ADDED) pays the sponsor $53.2 million: MOIC falls to 2.29x, the IRR on the dated flows rises to 19.8%, and the shortcut reports 18.0%, a fall where there was a rise.
Download the three cases61 KB| Dates | 2026 is the base year; forecast 2027 to 2031; valuation and deal close at 31 December 2026; exit at 31 December 2031. |
| Discounting | End of year, WACC 10.0 per cent, terminal growth 2.5 per cent. The 2026 cash flow is already in the 31 December 2026 net debt and is not discounted again. |
| Interest | On opening balances, so the workbook has no circular reference. |
| Depreciation | Rate applied to opening PP&E plus half of the year’s capital expenditure. |
| Inputs | Scenarios (base inputs and adjustments), the LBO inputs block and Historical. Nothing is typed inside a formula. |
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.
| 15 Nov 2026 | Added seven working documents to print (the decision page, the model checklist, the check register, the review note and audit register, the bridge, sources and uses with the returns bridge, the ninety-minute budget) and three new worked cases: a stepped cash sweep, the interest cap in the downside, and a dividend recap with the IRR shortcut. The four workbooks are unchanged and their checks still pass. |
| 24 Sep 2026 | Companion files published with the revised edition. |
More in corporate finance, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: 3-statement financial model.
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.