← Back to Research Portfolio

Project 03 · Valuation Modeling

Interactive DCF Valuation Workbench

Adjust fundamental cash flow and risk drivers below to see how intrinsic share value updates in real time. Model baseline calibrated to Titan Company Ltd (NSE: TITAN).

Key Value Drivers

5-Year Revenue CAGR 15.0%
8.0% (Bear)15.0% (Base)24.0% (Bull)
Operating EBIT Margin 11.0%
8.5% (Trough)11.0% (Current)14.0% (Peak)
Cost of Capital (WACC) 11.0%
9.0% (Low Risk)11.0% (Base WACC)14.0% (High Beta)
Terminal Growth Rate (g) 5.5%
4.0% (Inflation)5.5% (India GDP-proxy)7.0% (Optimistic)
Baseline Parameters: FY24 Revenue = ₹51,084 Cr · Tax Rate = 25% · Net Debt = ₹10,650 Cr · Shares = 88.78 Cr · CMP = ₹3,460.

Valuation Output

Dynamic
Intrinsic Fair Value ₹3,924
+13.4% Upside
PV of 5-Year Free Cash Flows ₹32,450 Cr
PV of Terminal Value ₹3,26,400 Cr
Implied Enterprise Value (EV) ₹3,58,850 Cr
Less: Net Debt (incl. gold lease) -₹10,650 Cr
Implied Equity Value ₹3,48,200 Cr
Sensitivity Matrix: Target Price (₹) vs WACC & Terminal Growth

Methodology & DCF Mechanics

This tool uses a standard Free Cash Flow to Firm (FCFF) framework. Over the 5-year explicit forecast horizon, revenues are projected based on the compound growth assumption, EBIT margins determine operating profitability, and Net Operating Profit After Tax (NOPAT) is adjusted for reinvestment into capital expenditures and gold working capital.

The terminal value utilizes the Gordon Growth formula, discounted back to present value using WACC. Deducting net debt (which includes bank gold-on-lease liabilities) yields equity value, which divided by diluted shares yields intrinsic value per share.