Financial Modeling in Excel

Complete syllabus

Every chapter and lesson

1. 01

   Chapter 1 · 3 lessons

   Model Foundations

   1. 1.1

      Modeling best practices

      9 min · Quick check

   2. 1.2

      Formatting & formula hygiene

      9 min · Quick check

   3. 1.3

      Functions every modeler uses

      9 min · Quick check

2. 02

   Chapter 2 · 3 lessons

   The Three Statements

   1. 2.1

      The income statement

      9 min · Quick check

   2. 2.2

      The balance sheet

      9 min · Quick check

   3. 2.3

      The cash flow statement

      9 min · Quick check

3. 03

   Chapter 3 · 3 lessons

   Linking & Building the Model

   1. 3.1

      Linking the statements

      10 min · Quick check

   2. 3.2

      Making it balance

      9 min · Quick check

   3. 3.3

      Supporting schedules

      9 min · Quick check

4. 04

   Chapter 4 · 3 lessons

   Forecasting & Assumptions

   1. 4.1

      Driving assumptions

      9 min · Quick check

   2. 4.2

      Scenarios & sensitivity

      9 min · Quick check

   3. 4.3

      Stress-testing the model

      9 min · Quick check

5. 05

   Chapter 5 · 3 lessons

   Valuation & Review

   1. 5.1

      Discounted cash flow (DCF)

      11 min · Quick check

   2. 5.2

      Comparables & sanity checks

      9 min · Quick check

   3. 5.3

      Auditing & presenting the model

      9 min · Quick check