Financial Modeling Fundamentals

About This Course

This course introduces the principles and practice of building structured, assumption-driven financial models in Microsoft Excel. You will apply Excel modeling best practices to design clear input, calculation, and output sections; write robust formulas; and document assumptions for transparency and auditability. Starting with model layout and dynamic functions such as INDEX/MATCH and IFERROR, you will develop driver-based forecasts for revenue, expenses, capital expenditures, and working capital. You will then integrate these projections into a fully linked three-statement financial model—connecting the income statement, balance sheet, and cash flow statement with automated logic and validation checks. The course also covers scenario analysis, sensitivity testing using data tables, and model error-checking to support sound financial decision-making. By the end, you will be able to build dynamic, assumption-driven Excel models suitable for business planning, valuation, and performance analysis.

Instructor

Michael McDonald