Discounted Cash Flow (DCF) Analysis Levered
Alphageo (India) Limited (ALPHAGEO.NS)
249.35 ₹
+1.80 (+0.73%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 4,294.37 | 4,050.77 | 2,675.19 | 1,430.99 | 1,548.83 | 1,247.17 | 1,004.27 | 808.67 | 651.17 | 524.35 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 589.98 | 1,090.15 | 34.53 | 301.63 | 794.19 | 285.10 | 229.57 | 184.86 | 148.85 | 119.86 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -524.98 | -85.05 | -257.65 | -242.25 | -63.67 | -112.23 | -90.38 | -72.77 | -58.60 | -47.19 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 65 | 1,005.09 | -223.12 | 59.38 | 730.52 | 172.86 | 139.19 | 112.08 | 90.25 | 72.68 |
Weighted Average Cost Of Capital
Share price | $ 249.35 |
---|---|
Beta | 1.066 |
Diluted Shares Outstanding | 6.36 |
Cost of Debt | |
Tax Rate | 30.68 |
After-tax Cost of Debt | 3.47% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 8.775 |
Total Debt | - |
Total Equity | 1,586.73 |
Total Capital | 1,586.73 |
Debt Weighting | 0.00 |
Equity Weighting | 100.00 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 4,294.37 | 4,050.77 | 2,675.19 | 1,430.99 | 1,548.83 | 1,247.17 | 1,004.27 | 808.67 | 651.17 | 524.35 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 589.98 | 1,090.15 | 34.53 | 301.63 | 794.19 | 285.10 | 229.57 | 184.86 | 148.85 | 119.86 |
Capital Expenditure | -524.98 | -85.05 | -257.65 | -242.25 | -63.67 | -112.23 | -90.38 | -72.77 | -58.60 | -47.19 |
Free Cash Flow | 65 | 1,005.09 | -223.12 | 59.38 | 730.52 | 172.86 | 139.19 | 112.08 | 90.25 | 72.68 |
WACC | ||||||||||
PV LFCF | 158.91 | 117.63 | 87.08 | 64.46 | 47.71 | |||||
SUM PV LFCF | 475.79 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 8.78 |
Free cash flow (t + 1) | 74.13 |
Terminal Value | 1,093.36 |
Present Value of Terminal Value | 717.82 |
Intrinsic Value
Enterprise Value | 1,193.61 |
---|---|
Net Debt | -1,076.21 |
Equity Value | 2,269.82 |
Shares Outstanding | 6.36 |
Equity Value Per Share | 356.70 |