Building the modelReading this company's statements and building the valuation. Usually under 10 seconds.
Tata Motors Limited (TATAMOTORS)
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.
From a local fixture file, not the accounts
Market Price
₹294.50
As of 2026-11-04 · Successor ticker
Statements
FY26
Ended 2026-03-31
Enterprise Value
₹2.00L Cr
PV FCFF + PV TV
Terminal value 64.7% of EV
Equity Value
₹2.41L Cr
Net Debt Adjusted
WACC
14.78%
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.10
Equity Risk Premium (ERP)7.08%
Cost of Equity (Ke)14.58%
Pre-Tax Cost of Debt (Kd)20.51%
Effective Tax Rate (t)25.17%
After-Tax Cost of Debt15.34%
Weights (Equity / Debt)73.2% / 26.8%
Weighted Average Cost of Capital14.78%
Source: CAPM: Rfr=6.78% (INDIA market default for rfr (10Y sovereign yield %)), Beta=1.10 (Per-company registry benchmark beta vs primary index (1.15), Blume-adjusted), ERP=7.08% (INDIA market default for erp (Equity Risk Premium %)). Cost of Equity=14.58% = Rf + Beta x ERP. Pre-tax Cost of Debt=20.51% (after-tax 15.34%). Capital Weights: Equity=73.2%, Debt=26.8%.
Return Metrics & Financial Health
Terminal ROIC
11.9%
-2.9% vs WACC
FCF Yield (Yr 1)
7.0%
FCFF / Equity Val
Implied EV / EBIT
5.7x
Forward Multiple
Net Debt Position
+₹40,500
Net Cash Balance
FCFF & DCF Valuation Schedule
PV FCFF: ₹70,714 Cr
|PV TV: ₹1.30L Cr
|Net: +₹40,500@ 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 | 35,148 | 37,801 | 40,655 | 43,725 | 47,026 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 26.4% | 26.1% | 25.8% | 25.5% | 25.2% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 25,862 | 27,931 | 30,166 | 32,584 | 35,189 |
+ D&A + D&ADefinition Depreciation & Amortization added back because it is a non-cash accounting expense. Formula: Cash Flow Statement D&A Add-back | 32,808 | 35,285 | 37,949 | 40,814 | 43,896 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (40,091) | (43,118) | (46,373) | (49,874) | (53,640) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | -1,631 | -1,709 | -1,838 | -1,976 | -2,126 |
= 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 | 16,947 | 18,390 | 19,905 | 21,547 | 23,320 |
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.9335 | 0.8130 | 0.7084 | 0.6172 | 0.5378 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | 15,820 | 14,952 | 14,101 | 13,300 | 12,542 |
| Σ PV of Explicit Forecasts (PV FCFF) | ₹70,714 | ||||
| + PV of Terminal Value (4.0% g, 65% of EV) | ₹129,603 | ||||
| Enterprise Value (EV) | ₹200,317 | ||||
| + Net Cash & Liquid Assets | + ₹40,500 | ||||
| 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: 14.78%Cost of Equity: 14.58%Cost of Debt: 15.34%Equity Wt: 73.2%
Terminal ROIC: 11.9% (Reinvest 33.7%)
Financial Forecast Summary
| Line Item | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
| Revenue | ₹539,901 | ₹580,664↑ | ₹624,504↑ | ₹671,654↑ | ₹722,364↑ |
| EBITDA | ₹67,956 | ₹73,086↑ | ₹78,604↑ | ₹84,539↑ | ₹90,922↑ |
| EBIT (Operating Profit) | ₹35,148 | ₹37,801↑ | ₹40,655↑ | ₹43,725↑ | ₹47,026↑ |
| Net Profit (PAT) | ₹23,139 | ₹25,197↑ | ₹27,421↑ | ₹29,826↑ | ₹32,421↑ |
| D&A | ₹32,808 | ₹35,285↑ | ₹37,949↑ | ₹40,814↑ | ₹43,896↑ |
| CapEx | ₹40,091 | ₹43,118↑ | ₹46,373↑ | ₹49,874↑ | ₹53,640↑ |
| Operating Cash Flow | ₹54,316 | ₹58,774↑ | ₹63,532↑ | ₹68,664↑ | ₹74,191↑ |