Building the modelReading this company's statements and building the valuation. Usually under 10 seconds.
Tata Steel Limited (TATASTEEL)
The model for this company lays out financial schedules across multiple columns. Open it on a viewport at least 900px wide to work with the figures.
MINIMUM VIEWPORT: 900PX
DCF Implied Price
n/a
Inputs not verified
Models publish once a filing is in the store; where both exist the filing wins.
Mostly NSE filing, partly other sources
Market Price
₹181.00
As of 2026-11-04 · Close
Statements
FY26
Ended 2026-03-31
Enterprise Value
₹75,191 Cr
PV FCFF + PV TV
Terminal value 77.0% of EV
Equity Value
-₹9,925 Cr
Net Debt Adjusted
WACC
12.16%
CAPM / Capital Cost
Terminal Growth (g)
4.00%
Gordon Growth
Valuation Drivers
base scenario
WACC & Capital Cost
Risk-Free Rate (Rf)6.78%
Beta (β)1.17
Equity Risk Premium (ERP)7.08%
Cost of Equity (Ke)15.04%
Pre-Tax Cost of Debt (Kd)7.07%
Effective Tax Rate (t)25.17%
After-Tax Cost of Debt5.29%
Weights (Equity / Debt)70.4% / 29.6%
Weighted Average Cost of Capital12.16%
Source: CAPM: Rfr=6.78% (INDIA market default for rfr (10Y sovereign yield %)), Beta=1.17 (Per-company registry benchmark beta vs primary index (1.25), Blume-adjusted), ERP=7.08% (INDIA market default for erp (Equity Risk Premium %)). Cost of Equity=15.04% = Rf + Beta x ERP. Pre-tax Cost of Debt=7.07% (after-tax 5.29%). Capital Weights: Equity=70.4%, Debt=29.6%.
Return Metrics & Financial Health
Terminal ROIC
9.0%
-3.2% vs WACC
FCF Yield (Yr 1)
n/a
FCFF / Equity Val
Implied EV / EBIT
5.5x
Forward Multiple
Net Debt Position
-₹85,116
Net Debt Obligations
FCFF & DCF Valuation Schedule
PV FCFF: ₹17,277 Cr
|PV TV: ₹57,913 Cr
|Net: -₹85,116@ 2026-03-31
|Price: not verified
| DCF Line Item (Mid-Year) | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
EBIT (Operating Profit) EBIT (Operating Profit)Definition Earnings Before Interest and Taxes: core operating profitability before capital structure and taxes. Formula: Revenue - COGS - Operating Expenses - D&A | 13,687 | 14,522 | 15,408 | 16,348 | 17,345 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 34.7% | 32.3% | 29.9% | 27.6% | 25.2% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 8,933 | 9,825 | 10,793 | 11,842 | 12,979 |
+ D&A + D&ADefinition Depreciation & Amortization added back because it is a non-cash accounting expense. Formula: Cash Flow Statement D&A Add-back | 12,172 | 12,915 | 13,703 | 14,538 | 15,425 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (17,453) | (17,479) | (17,758) | (18,340) | (19,282) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | -1,552 | -1,616 | -1,715 | -1,819 | -1,930 |
= FCFF (Free Cash Flow) = FCFF (Free Cash Flow)Definition Free Cash Flow to Firm: unlevered cash flow available to all debt and equity capital providers. Formula: NOPAT + D&A − CapEx − ΔNWC − Stock Comp | 2,101 | 3,645 | 5,023 | 6,221 | 7,193 |
Discount Factor (Mid-Year) Discount Factor (Mid-Year)Definition Mid-year discount factor assuming cash flows arrive continuously throughout the year. Formula: 1 / (1 + WACC)^(t - 0.5) | 0.9443 | 0.8417 | 0.7505 | 0.6692 | 0.5967 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | 1,984 | 3,068 | 3,770 | 4,163 | 4,292 |
| Σ PV of Explicit Forecasts (PV FCFF) | ₹17,277 | ||||
| + PV of Terminal Value (4.0% g, 77% of EV) | ₹57,913 | ||||
| Enterprise Value (EV) | ₹75,191 | ||||
| − Total Net Debt | - ₹85,116 | ||||
| Equity Value and implied share price | not published: this model failed a check that decides whether its output may be presented as a valuation | ||||
WACC: 12.16%Cost of Equity: 15.04%Cost of Debt: 5.29%Equity Wt: 70.4%
Terminal ROIC: 9.0% (Reinvest 44.6%)
Financial Forecast Summary
| Line Item | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
| Revenue | ₹273,738 | ₹290,436↑ | ₹308,153↑ | ₹326,950↑ | ₹346,894↑ |
| EBITDA | ₹25,859 | ₹27,437↑ | ₹29,110↑ | ₹30,886↑ | ₹32,770↑ |
| EBIT (Operating Profit) | ₹13,687 | ₹14,522↑ | ₹15,408↑ | ₹16,348↑ | ₹17,345↑ |
| Net Profit (PAT) | ₹5,931 | ₹6,713↑ | ₹7,571↑ | ₹8,510↑ | ₹9,537↑ |
| D&A | ₹12,172 | ₹12,915↑ | ₹13,703↑ | ₹14,538↑ | ₹15,425↑ |
| CapEx | ₹17,453 | ₹17,479↑ | ₹17,758↑ | ₹18,340↑ | ₹19,282↑ |
| Operating Cash Flow | ₹16,552 | ₹18,012↑ | ₹19,559↑ | ₹21,229↑ | ₹23,032↑ |