Course curriculum

  • 01

    Introduction to Financial Modeling and Business Valuation

  • 02

    Business Understanding

    • Understanding subject company

    • Industry analysis

    • Weekly Office Hours

  • 03

    Fundamental analysis

    • Boston Matrix

    • Mckinsey Matrix

    • Boston and McKinsey - USL

    • Weekly Office Hours

  • 04

    Forecasting Income Statement

  • 05

    Forecasting Balance Sheet

    • Understanding Tangible Assets

    • Tangible Assets

    • Non-Current Assets

    • Current Assets

    • Non-Current Liabilities

    • Current Liabilities

    • Weekly Office Hours

  • 06

    Forecasting Cashflow Statement

    • Operating Cash flow

    • Investing and Financing Cash Flow

  • 07

    Valuation

    • Cost of Equity

    • Weighted Average Cost of Capital

    • Discounted Cashflow (DCF) Approach

    • Relative Valuation

    • Scenario Analysis

    • Football Field Analysis

    • Relative Valuation Multiples- All industries

  • 08

    Mergers & Acquisitions

    • Why M&As fail | Why valuations matter | How to value deals

  • 09

    Excel Crash Course

    • Excel for Finance

    • Excel- Tools & Tricks

    • Macros for regular financial analysis from data dump

    • Core Finance on Excel- IRR, NPV, Payback Period