Financial Modelling in Excel: Concepts, Cases, and Valuation: From Financial Statements to Valuation

Financial Modelling in Excel: Concepts, Cases, and Valuation is a comprehensive, hands-on guide designed to take readers from the fundamentals of financial statements to building robust valuation models and decision-ready dashboards in Excel.

Written for college students, MBA learners, and entry-level finance professionals, this book bridges the gap between financial theory and real-world application. It does not treat financial modelling as a collection of Excel formulas, but as a structured way of thinking about businesses, cash flows, risk, and value.

Starting with a strong foundation in accounting and financial statement analysis, the book progressively builds modelling skills across forecasting, assumption design, valuation, scenario analysis, and presentation. Each chapter follows a practical, model-first approach, integrating Excel-style formulas, step-by-step logic, visual layouts, and worked examples throughout.

Readers will learn how to:

• Read, reconstruct, and normalize financial statements for modelling

• Build integrated three-statement financial models from scratch

• Develop defensible assumptions for revenue, costs, and capital structure

• Perform Discounted Cash Flow (DCF) valuation using FCFF and WACC

• Handle non-cash items, one-off adjustments, and accounting distortions

• Apply scenario analysis, sensitivity testing, and stress modelling

• Design professional dashboards and present insights effectively

• Think like an analyst, not just operate Excel

The book emphasizes clarity, structure, and discipline, reflecting how financial models are built and reviewed in professional environments such as investment banking, corporate finance, equity research, and consulting. Complex concepts are explained using intuitive logic, real-world cases, and clean Excel frameworks that readers can immediately apply.

With review questions, practical exercises, and a comprehensive MCQ assessment at the end, this book is suitable both as a core academic textbook and as a self-learning reference for aspiring finance professionals.

Whether you are preparing for a career in finance, strengthening your analytical skills, or teaching financial modelling in an academic setting, this book offers a complete, structured pathway from financial statements to valuation and decision-making.