Module 3 • 18 Min Read

Valuation Modeling & Sector Playbooks

Learn how to value a business based on its future cash flows. Then, build core sector analytical toolkits for Banking, IT, Auto, and Pharma companies.

What You'll Learn

How to figure out the true "fair price" of a stock using basic math.
Why ₹100 today is worth more than ₹100 next year, and how that impacts investing.
The key secrets to analyzing banks and tech companies differently.
How to spot red flags in auto and pharma companies before everyone else.

01. Intrinsic Valuations: Discounted Cash Flow (DCF)

DCF is like calculating what winning the lottery is truly worth today. Since ₹1 crore in 10 years is not worth ₹1 crore right now due to inflation and missed opportunities, we have to "discount" it back to today's value.

A business is ultimately worth exactly the sum of its future cash flows. We take all the money it will make in the future and discount it back to the present day. We use an appropriate cost of capital to do this.

To calculate the intrinsic or "true" value using a DCF model, we follow three basic steps. Let's break them down simply.

Step A: Calculate Cost of Equity (CAPM)

CAPM is like demanding extra interest from a friend who has a history of paying you back late. If the government gives you a guaranteed 7%, you'd want at least 12% to lend to your risky friend. The extra 5% is the "risk premium."

We find the expected return on equity using the Capital Asset Pricing Model (CAPM):

\(R_e = R_f + \beta \times (R_m - R_f)\)

Where \(R_f\) is the risk-free rate (e.g., Indian 10Y Government Bond yield), \(\beta\) is the asset's volatility relative to index benchmarks, and \((R_m - R_f)\) is the market risk premium.

Step B: Weighted Average Cost of Capital (WACC)

WACC is like figuring out your total cost of throwing a party when half the money came from your savings (equity) and half was borrowed from a bank (debt). You blend the costs together to find the average cost of your total party budget.

WACC represents the discount rate reflecting the company's blended cost of debt and equity:

\(WACC = \left( \frac{E}{V} \times R_e \right) + \left( \frac{D}{V} \times R_d \times (1 - T_c) \right)\)

Where \(E\) is market value of equity, \(D\) is market value of debt, \(V = E + D\), \(R_d\) is pre-tax cost of debt, and \(T_c\) is corporate tax rate.

Step C: Gordon Growth Terminal Value (TV)

Terminal Value is like estimating the price you could sell your house for in 10 years, rather than trying to guess the exact rent you'd collect every single month for the rest of eternity.

Since we cannot forecast cash flows to infinity, we forecast Free Cash Flow (FCF) for 5-10 years and calculate a terminal value representing all cash flows beyond:

\(Terminal\ Value\ (TV) = \frac{FCF_n \times (1 + g)}{WACC - g}\)

Where \(FCF_n\) is the final forecasted year's cash flow, and \(g\) is the perpetual growth rate (which must never exceed the long-term GDP growth rate of the nation).

DCF Forecast and Discounting Timeline

💡 Key Takeaway: A company's true value isn't its current stock price. It's the total cash it will generate over its entire lifetime, adjusted for the fact that money today is worth more than money tomorrow.

02. Sector Playbooks: Structuring Industry Filters

Different sectors require completely unique ways to measure their success. You wouldn't judge a fish by its ability to climb a tree. Similarly, applying standard metrics everywhere leads to mistakes.

For example, applying a standard P/E ratio across banking and IT leads to catastrophic valuation mistakes. Let's study the four core Indian sector playbooks.

A. Banking & Financials (BFSI) Capital Playbook

Banks use cash as inventory. They buy money (deposits) and sell it (loans). You cannot use traditional metrics like Operating Cash Flow. Instead, analyze:

NIM is like a retailer's profit margin. If a store buys a shirt for ₹500 and sells it for ₹600, their margin is ₹100. For banks, they borrow at 4% and lend at 8%. The spread is NIM.
NIM (Net Interest Margin): The spread between interest earned on loans and interest paid on deposits. A healthy margin is typically > 3.5%.
NPA is like giving a loan to a friend who ghosts you. The money is gone, and your "asset" is no longer performing.
GNPA / NNPA (Non-Performing Assets): Percentage of loans defaulting. GNPA indicates asset quality; NNPA accounts for provisions. Keep NNPA < 1.5%.
PCR is like an emergency savings fund just in case your friend never pays you back. It ensures you can survive the loss.
PCR (Provision Coverage Ratio): Cash set aside to cover bad debts. Higher PCR (> 70%) protects future profits.
CAR is like the shock absorbers on a car to handle bumpy financial roads. It acts as a buffer to protect depositors.
CAR (Capital Adequacy Ratio): Buffer capital required by RBI to absorb shocks. Basel III limits CAR to > 12%.

B. Information Technology (IT) Intellectual Playbook

IT companies are talent businesses. Their raw material is human brainpower. Cost structures are driven almost entirely by payroll and headcounts. Analyze:

Attrition Rate is like the turnover at a fast-food restaurant. If everyone keeps quitting, you spend all your time and money training new people instead of serving customers.
Attrition Rate: Percentage of employees leaving annually. High attrition (> 20%) forces expensive hiring, hurting operating margins.
Utilization Rate is like filling seats on an airplane. An empty seat makes no money but still costs gas to fly. A benched IT worker still gets a salary.
Utilization Rate: Percentage of developers billed to clients. Optimal range is 80-85%.
Concentration Risk is like having only one big client. If they leave, you lose everything. You want your eggs in multiple baskets.
Concentration Risk: Percentage of revenue coming from the top 5-10 clients. De-risk by seeking client diversification.

C. Automobile (Cyclical Manufactures) Volume Playbook

These businesses are highly cyclical and asset-heavy. They own massive factories and are very sensitive to raw material prices. Analyze:

SIAM Monthly Sales are like checking the weekly box office numbers for a movie. It tells you instantly if people are buying, rather than waiting months for the official profit report.
SIAM Monthly Sales: Track volume numbers instead of quarterly reports to detect early cycle turns.
Commodity Price Index is like tracking the cost of flour and sugar for a bakery. When ingredients get expensive, profits shrink fast.
Commodity Price Index (Steel, Rubber): Surging commodity input costs instantly squeeze operating EBITDA margins.
Capacity Utilization is like running a half-empty factory. It's like renting a whole bus for two people—highly inefficient.
Capacity Utilization: Fixed cost leverage. Factories operating below 70% capacity suffer margin degradation.

D. Pharmaceuticals & Healthcare Regulatory Playbook

Pharma is a game of science and strict rules. They are subject to high compliance audits and drug discovery timelines. Analyze:

USFDA warning audits (Form 483) are like the health inspector giving a restaurant a failing grade. Until it's fixed, they can't sell their food.
USFDA warning audits (Form 483): Form 483 lists compliance violations. Unresolved warnings lead to import alerts, blocking facility revenues.
R&D Expensing Strategy is like writing off failed experiments immediately as costs, rather than pretending they hold future value on the books.
R&D Expensing Strategy: Ensure R&D is expensed immediately rather than capitalized on the balance sheet.
Patent Expiry Pipeline is like a musician losing the copyright to their biggest hit song. Anyone can now copy it and sell it cheaper.
Patent Expiry Pipeline: Identify block-buster drugs losing exclusivity (patent cliffs) to project revenue declines.

💡 Key Takeaway: Never use a one-size-fits-all approach. Evaluate banks on their loans, tech companies on their people, auto makers on their sales volume, and pharma on their factory compliance.

Glossary of Terms

DCF (Discounted Cash Flow): A valuation method used to estimate the value of an investment based on its expected future cash flows.
WACC (Weighted Average Cost of Capital): The average rate a company pays to finance its assets, calculated by blending the cost of debt and equity.
CAPM (Capital Asset Pricing Model): A model that describes the relationship between systematic risk and expected return for assets, particularly stocks.
Terminal Value: The estimated value of a business beyond the explicit forecast period in a DCF model.
P/E Ratio (Price-to-Earnings): The ratio for valuing a company that measures its current share price relative to its per-share earnings.
NPA (Non-Performing Asset): A loan or advance for which the principal or interest payment remained overdue for a period of 90 days.
NIM (Net Interest Margin): A measure of the difference between the interest income generated by banks and the amount of interest paid out to lenders.
GNPA (Gross Non-Performing Assets): The absolute amount of non-performing loans in a bank's portfolio before deducting provisions.
Attrition Rate: The rate at which employees leave a workforce over a given period.
USFDA Warning Letter: An official message from the US Food and Drug Administration indicating that a manufacturer has violated regulations.

← Module 2 Next Module →