Level 1 — Foundational 

Session 1 —  Excel 101

Build modeling fundamentals: consistent formatting, keyboard shortcuts, core formulas, and cell referencing.

Session 2 —  Profit & Loss Statement

Understand the structure of a P&L and model operating assumptions into a pro-forma income statement.

Session 3 —  Balance Sheet & Cash Flow

Learn the balance sheet and cash flow statement, and build them from working capital and operational assumptions.

Session 4 —  FCFF Drivers

Calculate free cash flow to the firm and to equity, and see how depreciation, debt, and tax shields shape it.

Session 5 —  Valuation

Apply time value of money to value cash flows, estimate terminal value, and separate enterprise from equity value.

Session 6 —  Discount Rate

Build the discount rate from the ground up: cost of debt, cost of equity, and WACC.

Session 7 —  Sensitivity & Scenario Analysis

Run one- and two-variable sensitivity tables and multi-variable scenarios to test how assumptions move value.

Level 1 Material Recap

A summary of every session, in one document to keep and reference