Independent financial analysis of Tata Motors' Order-to-Cash (O2C) performance using publicly available FY2024 audited financial data. Built using Power BI and Microsoft Excel to demonstrate domain expertise in O2C processes, working capital management, and financial analytics.
| Metric | Value | Benchmark |
|---|---|---|
| Days Sales Outstanding (DSO) | 14.1 Days | 45 Days (Industry) |
| Working Capital Advantage | ₹37,039 Cr | - |
| Receivables Turnover | 25.83x | World-Class |
| Bad Debt Ratio | 0.53% | Excellent |
| DSO Improvement (3 Years) | 30% | FY22→FY24 |
- Executive Summary with key findings
- 4 KPI Cards (DSO, Industry Benchmark, Working Capital, Receivables Turnover)
- DSO 3-Year Trend Line Chart (FY2022 → FY2024)
- Revenue Segment Donut Chart (JLR 68.21% dominance)
- Benchmark Comparison Bar Chart (Tata vs competitors vs industry)
- 4 Strategic Insights
- Strategic Recommendations Table (6 actions with owner & timeline)
- Key Risks to Monitor Framework (4 risks with status indicators)
- Scenario Analysis: DSO Impact Table (6 scenarios with risk levels)
| Tool | Purpose |
|---|---|
| Power BI Desktop | Dashboard & Visualizations |
| Microsoft Excel | Data Modeling & Calculations |
| DAX | Calculated Measures |
Company: Tata Motors Limited (NSE: TATAMOTORS)
Document: Audited Consolidated Financial Results - FY2024
Availability: Publicly available
URL: https://www.tatamotors.com/financials/
Tata-Motors-O2C-FY2024/
│
├── README.md
├── Building_Process.md
├── Data_Sources.md
├── Tata_Motors_O2C_Analysis.pbix
│
├── data/
│ └── Tata_Motors_OTC_Analysis.xlsx
│
├── screenshots/
│ ├── Page1_O2C_Performance_Overview.png
│ └── Page2_Strategic_Analysis_Risk.png
│
└── documentation/
├── KPI_Definitions.md
└── Project_Summary.md
| File | Description |
|---|---|
Tata_Motors_O2C_Analysis.pbix |
Power BI Dashboard (2 pages) |
data/Tata_Motors_OTC_Analysis.xlsx |
Source data with 9 sheets |
Building_Process.md |
How the project was built |
Data_Sources.md |
Data sources and verification |
documentation/KPI_Definitions.md |
All metrics explained with formulas |
documentation/Project_Summary.md |
Executive summary of findings |
Domain Knowledge
- Order-to-Cash process expertise
- DSO calculation and interpretation
- Working capital management
- Automotive industry understanding
Technical Skills
- Financial statement analysis
- Excel data modeling
- Power BI dashboard creation
- DAX measures
- Data visualization
Business Acumen
- Competitive advantage identification
- Risk framework development
- Scenario analysis
- Strategic recommendations
- Download
Tata_Motors_O2C_Analysis.pbix - Open with Power BI Desktop (free download from Microsoft)
- If prompted, update data source path to your local Excel file
- Explore both dashboard pages
Smichi Rekha Mohanty | February 2026
Independent Analysis - Portfolio Project
This analysis is based on publicly available data and is for educational and portfolio purposes only. It does not constitute financial advice or investment recommendations.