Valuation Workshop: Building Financial Models that Predict MTA
Hands-on templates and case studies for forecasting earnings and valuing companies

About this book:

*Valuation Workshop: Building Financial Models that Predict* is a comprehensive manual designed to transition practitioners from basic spreadsheet mechanics to sophisticated, decision-oriented financial analysis. The book emphasizes a "hypothesis-driven" mindset, where models are viewed as testable frameworks of a business's economics rather than mere accounting exercises. It advocates for clarity, transparency, and intellectual honesty, urging modelers to embrace ranges and probabilities rather than the false precision of single-point estimates.

The core of the text provides a systematic, step-by-step guide to constructing an integrated three-statement model. It moves from data collection and cleaning through the granular forecasting of revenue drivers, unit economics, and cost structures. Key chapters demystify complex interdependencies, such as working capital mechanics, capital expenditure schedules, and debt financing—including the technical handling of cash sweeps and circular references. By linking the income statement, balance sheet, and cash flow statement, the author demonstrates how to reveal a company's true liquidity and operational health.

The latter half of the book focuses on translating these integrated forecasts into robust valuations. It provides a deep dive into Discounted Cash Flow (DCF) analysis, the calculation of the Weighted Average Cost of Capital (WACC), and terminal value methodologies. Furthermore, it explores complementary techniques like relative valuation with multiples, Sum-of-the-Parts analysis, and advanced risk assessment tools such as Monte Carlo simulations and scenario design. Each concept is reinforced with audit checklists and quality control protocols to ensure model integrity.

The workshop concludes with three distinct case studies—a mature dividend payer, a high-growth disruptor, and a cyclical mining company—applying the book's principles to diverse business lifecycles. By combining technical spreadsheet skills with strategic narrative and attribution analysis, the book aims to equip professionals with the ability to not only predict financial outcomes but to clearly communicate the "why" behind a valuation to drive informed investment decisions.

What You'll Find Inside:

• How to build integrated three-statement financial models that correctly link income statements, balance sheets, and cash flow statements
• Techniques for calculating Free Cash Flow to Firm (FCFF) and avoiding common pitfalls in cash flow analysis
• Methods for determining Weighted Average Cost of Capital (WACC) and applying it in discounted cash flow valuation
• Approaches to scenario design, sensitivity analysis, and probabilistic forecasting to model uncertainty
• Best practices for model auditing, quality checks, and communicating valuation results effectively

Who's It For:

This book is designed for investors, corporate operators, financial analysts, and students who want to build practical financial models that inform real-world decisions. It's ideal for those moving beyond basic valuation rules of thumb to create robust, audit-able models that stress-test assumptions and clarify what must be true for an investment to succeed under various scenarios.