The Excel Financial Model Library · Kai London
40 Tested Models for Budgeting, Valuation, Cash Flow, Forecasting and Sensitivity Analysis
Your board, lender and auditor rely on spreadsheets. Can you prove they are right before someone else asks?
No downloads, no subscriptions: every one of the 40 models is printed sheet by sheet with every formula, check and expected result, so you can rebuild it in Excel and prove it matches the printed numbers before you rely on it.
Premium Practitioner Edition. A complete working reference, not a quick read: practitioner chapters holding forty financial models printed in full, a field toolkit of worked case studies and labs, and a reference section with practice questions, checklists, an executive summary and an operating model you can adopt.
Your board, lender and auditor rely on spreadsheets. Can you prove they are right before someone else asks?
Every finance team runs its biggest decisions through workbooks that nobody can prove are right. This book gives you forty tested models, FM-01 to FM-40, each with the decision it supports, a workbook map, worked inputs, the Excel formulas, built-in checks, a sensitivity test, the expected result a correct rebuild must return and a reviewer's note on the faults that break it.
Twelve chapters follow the order a finance function should build its model estate: inventory, risk tiering and design standards; inputs and provenance; budgets, revenue, workforce, cash and covenants; capital and depreciation; DCF and valuation; scenarios and Monte Carlo; three-statement linkage; and error detection, independent review and handoff. Twelve real, publicly reported failures show what each control prevents, with 2025 cases on hidden receivables and supplier financing and on AI-assisted work nobody checked. Updated for the 2027 cycle: IFRS 18 presentation, the first Provision 29 declarations and the review of Copilot-assisted and Python-in-Excel models.
Inside you will find:
• Forty models printed in full with formulas, checks and expected results
• Governance, risk tiering and a design standard that make errors visible
• Budget, revenue, workforce, cash, capex, DCF and three-statement models
• Independent review, AI-cell checks, shadow recalculation and release
• Case studies, ten labs, templates, sixty questions and a 90-day plan
Part II is a field toolkit: two fictional case studies, ten hands-on labs, thirteen completed and annotated templates, a ten-dimension maturity model with twenty-eight metrics for annual assessment, and a ninety-day plan. Each element is designed to be lifted straight into your own finance function and adapted to it.
Part III adds a standards and regulatory crosswalk, six tabletop exercises, a sixty-question practice bank, thirty failure patterns with recovery steps and a tooling and vendor evaluation guide. Consolidated checklists in the appendix bring every chapter together for quick reference. The models support analysis and planning and do not constitute investment, lending or tax advice.
Who it is for: FP&A leads, finance managers and financial controllers, valuation and transaction consultants, and the reviewers and audit committee members who rely on their models.
Part of the Professional Validation Library by Professor Kai London: practical books that turn standards, technology and regulation into work you can evidence. The print editions include twelve framework figures, key takeaways for every chapter, a RACI matrix, an eight-dimension quarterly scorecard mapped to the ten-dimension model, a 90-day plan, a reviewer quick reference of twenty-five tests, a list of abbreviations and a full index.
Professor Kai London