Comprehensive Financial Modeling & Valuation of Tata Motors Ltd
• Developed a comprehensive Excel-based financial model to analyze the financial performance, valuation, and risk profile of Tata Motors.
• Analyzed historical Income Statement, Balance Sheet, and Cash Flow Statement and performed ratio analysis and common-size analysis to evaluate profitability, liquidity, and efficiency.
• Built financial forecasts based on historical growth trends and industry assumptions to project future performance.
• Estimated Equity Beta and Weighted Average Cost of Capital (WACC) to determine the company’s cost of capital.
• Performed Discounted Cash Flow (DCF) valuation and Relative Valuation using industry comparables to estimate intrinsic value.
• Conducted Sensitivity Analysis, DuPont Analysis, Altman Z-Score, and Value at Risk (VaR) to evaluate valuation drivers, financial stability, and downside risk
FinOptix Dashboard / Forecasting and Budgeting
Developed an Excel-based financial dashboard to support budgeting, cash-flow forecasting, and variance analysis, improving MIS reporting accuracy and management decision-making
Tata Motors Comprehensive Financial Model & Valuation
Built a full-scale Excel financial model covering income statement, balance sheet, cash flow, ratio analysis, WACC estimation, DCF valuation, relative valuation with comparables, sensitivity analysis, DuPont, Altman Z-Score, and VaR to evaluate intrinsic value and downside risk. Completed Jul–Dec 2025.
FinOptix Dashboard Budgeting & Cash Flow Analytics
Integrated Excel and Python dashboard for rolling cash-flow forecasts, variance tracking, and MIS reporting, improving accuracy and reducing manual effort.
ITC Limited 5-Year Earnings Quality Analysis
Analysed FY21–FY25 sales volatility, EPS normalisation, capital allocation efficiency, and the impact of the Hotels demerger on core earnings quality.
