Companion files

Financial Modeling from First Principles

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.

Everything on this page, in one archive

Download the ZIP215 KB Read the related analysis

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 →

Get an email if these files are corrected

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 list

Run by MailerLite, off this site. How your address is used.

The four workbooks

The documents the chapters describe

Seven pages to print and use. A4, with margins wide enough for US Letter.

Three cases the book does not work

New 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.

Conventions used throughout

Dates2026 is the base year; forecast 2027 to 2031; valuation and deal close at 31 December 2026; exit at 31 December 2031.
DiscountingEnd 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.
InterestOn opening balances, so the workbook has no circular reference.
DepreciationRate applied to opening PP&E plus half of the year’s capital expenditure.
InputsScenarios (base inputs and adjustments), the LBO inputs block and Historical. Nothing is typed inside a formula.

Opening the files

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.

What changed, and when

15 Nov 2026Added 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 2026Companion files published with the revised edition.

Articles on this book

Also by Julian R. Sterling

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.