← Back to Curriculum

Intermediate

Practice Drills: Building a DCF Model From Scratch

A practice-first companion to Valuation Methods: DCF, Relative Valuation, and When to Use Each. Instead of more theory, you build a working DCF in Google Sheets from a blank tab: pull ten years of history from screener.in, forecast revenue, margins, capex and working capital, compute free cash flow to the firm, build WACC from the 10-year G-Sec yield, beta and an Indian equity risk premium, add terminal value, and bridge enterprise value to a per-share number you can compare with the NSE price. Then stress-test it with sensitivity tables, bull/base/bear scenarios and a reverse DCF, and finish by building a full model for a company of your choice.

DCF ModellingFree Cash FlowWACCTerminal ValueSensitivity AnalysisReverse DCF

MODULES

6

DURATION

4 Hours

TRACK

Value Investing

What You'll Master

Lay out a clean, auditable DCF sheet from a blank Google Sheets tab

Turn ten years of screener.in history into defensible forecast assumptions

Calculate free cash flow to the firm year by year and reconcile it with reported cash flow

Build a WACC for an Indian company from the G-Sec yield, beta, equity risk premium and cost of debt

Compute terminal value two ways and bridge enterprise value to value per share

Stress-test your output with sensitivity tables, scenarios and a reverse DCF

Access Level

LEARNER

Start Learning Now →Sign in to resume

Everything included

Full Text Playbooks

Actionable Exercises

Mobile Reading Mode

Lifetime Updates

Curriculum Breakdown

Chapter 1: Setting Up the Model

3 Lessons

How This DCF Drill Course Works8 min read

Drill: Laying Out a DCF Sheet From a Blank Tab12 min read

Drill: Pulling Ten Years of History From screener.in12 min read

Chapter 2: Forecasting the Operating Business

4 Lessons

Drill: Building the Revenue Forecast13 min read

Drill: Forecasting EBITDA Margins and Depreciation12 min read

Drill: From EBIT to NOPAT at the Indian Corporate Tax Rate10 min read

Drill: Forecasting Capex and Working Capital13 min read

Chapter 3: From Profits to Free Cash Flow

2 Lessons

Drill: Calculating Free Cash Flow to the Firm Year by Year12 min read

Drill: Reconciling Your FCFF With the Reported Cash Flow Statement11 min read

Chapter 4: Building the Discount Rate

3 Lessons

Drill: Cost of Equity From the G-Sec Yield, Beta and Equity Risk Premium13 min read

Drill: Cost of Debt and Capital Structure Weights11 min read

Drill: Putting WACC Together and Sanity-Checking It10 min read

Chapter 5: Terminal Value and Value per Share

4 Lessons

Drill: Terminal Value Using the Perpetual Growth Method11 min read

Drill: Cross-Checking Terminal Value With an Exit Multiple10 min read

Drill: Discounting Cash Flows to Enterprise Value11 min read

Drill: Bridging Enterprise Value to Value per Share11 min read

Chapter 6: Stress-Testing and Using Your Model

5 Lessons

Drill: Building a WACC vs Terminal Growth Sensitivity Table11 min read

Drill: Bull, Base and Bear Scenarios12 min read

Drill: Running a Reverse DCF on a Nifty 50 Stock12 min read

Drill: Auditing a DCF for the Twelve Most Common Errors11 min read

Capstone Drill: Build a Full DCF for a Company of Your Choice15 min read