This repository delivers a comprehensive suite of professional valuation models and reports for Tata Motors. It supports investment analysis, academic work, equity research preparation, and portfolio presentations. The repo uniquely integrates Discounted Cash Flow (DCF), Relative Valuation (Comps with integrated SOTP), and a synthesized Equity Valuation Report—each fully documented for transparency and adaptability.
/Tata Motors-valuation │ ├── README.md # This file │ ├── Valuation Report │ ├── dcf/ │ ├── DCF_Model.xlsx │ └── README.md │ ├── ddm/ │ ├── DDM_Model.xlsx │ └── README.md │ ├── relative/ │ ├── Relative_Valuation_Model.xlsx └── README.md
-
DCF Model:
Complete bottom-up DCF Excel model featuring segment-based and scenario-driven projections, WACC/terminal value sensitivity, and scenario tables. Follows professional equity research standards. -
Relative Valuation Model:
Peer multiples-based model (EV/EBITDA, EV/Revenue, P/E) applying both Indian and global comparables. Includes robust outlier screening (excludes two-wheeler specialists for comparability).- Integrated SOTP: Valuation by segment (JLR, CV, PV, Others) using peer-relevant multiples for each business, leveraging the comps sheets.
-
Valuation Report:
Investment-grade PDF report synthesizing key findings, target prices, segment analysis, methodology, and market context ready for presentations or interviews.
| Company | Exchange / Country | Ticker Symbol |
|---|---|---|
| Indian Peers | ||
| Tata Motors | NSE / BSE (India) | TATAMOTORS / 500570 |
| Maruti Suzuki | NSE / BSE (India) | MARUTI / 532500 |
| M&M | NSE / BSE (India) | M&M / 500520 |
| Force Motors | NSE / BSE (India) | FORCEMOT / 500033 |
| Ashok Leyland | NSE / BSE (India) | ASHOKLEY / 500477 |
| Hyundai India | NSE / BSE (India) | HYUNDAI / 544274 |
| Global Peers | ||
| Mercedes-Benz | Xetra / Germany | MBG |
| Volkswagen Group | Xetra / Germany | VOW3 |
| Toyota Motor Corp | Tokyo / Japan | 7203 |
| BMW | Xetra / Germany | BMW |
| Volvo Cars | Nasdaq Stockholm / Sweden | VOLCAR-B |
| General Motors | NYSE / USA | GM |
| Hyundai Motor Co. | Korea Exchange / S. Korea | 005380 |
| Ford Motor Co. | NYSE / USA | F |
-
DCF Valuation:
Projects future free cash flows using segment- and scenario-specific inputs, discounts at WACC, and computes terminal value. Sensitivity tables provided. -
Relative Valuation:
Benchmarks Tata Motors against listed Indian and global automotive peers using FY24/FY25 data, calculates implied share prices via peer multiples, and excludes outlier business models for fairer comparison. -
SOTP (Integrated in Relative Model):
Values each Tata Motors segment with the most relevant peer group multiple. Sums segment values, subtracts net debt, and provides per-share outputs.
- Explore the
/DCF Modeland/Relative Valuation Modelsubfolders for spreadsheets and detailed READMEs. - Refer to the
/Valuation Reportfor a one-stop, presentation-ready summary. - Update models or report with new data to keep valuations current—formulas auto-update core outputs.
- All financial data and modeling based on FY24 (global) and FY25E (Indian) with full citation of sources where applicable.
- Hyundai India is treated as an Indian peer due to dual market presence.
- Open for academic and non-commercial use. Please attribute this repo if you use the models, code, or report structure elsewhere.
Contact:
For inquiries, feedback, or collaboration requests, please open an issue or connect via LinkedIn.
Last updated: July 31, 2025