Financial Modeling

Behind every serious investment decision—whether it's an analyst valuing a stock, a founder pitching to investors, or a company planning its next five years—there's usually a financial model doing the heavy lifting. This course teaches you how to build these models yourself, using the tool that still powers most of the finance world: Excel.

You'll start by learning how to structure a financial model properly—setting up historical financials, driving future projections off clear assumptions, and building in the flexibility to test different scenarios without breaking your formulas. You'll learn the discipline that separates a professional model from a messy spreadsheet: clean formatting, traceable logic, and inputs that are clearly separated from calculations.

From there, you'll build toward actual valuation models, learning how to project a company's future cash flows and translate them into a present-day value. You'll work through core valuation approaches like discounted cash flow (DCF) analysis and comparable company analysis, understanding not just the mechanics of each formula, but the reasoning behind every assumption you plug in.

Along the way, you'll pick up practical Excel skills tailored specifically for finance—formulas, sensitivity tables, and structuring outputs so that changing one assumption cleanly flows through your entire model.

By the end of this course, you'll be able to build a working valuation model from scratch—giving you the same analytical toolkit used by equity analysts and investment professionals to answer one core question: what is this company really worth?