Discounted Cash Flow (DCF) Analysis Levered
Alphageo (India) Limited (ALPHAGEO.NS)
296.8 ₹
+4.75 (+1.63%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Actual | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected |
Revenue | 4,050.77 | 2,675.19 | 1,430.99 | 1,548.83 | 659.50 | 445.73 | 301.26 | 203.61 | 137.61 | 93.01 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 1,090.15 | 34.53 | 301.63 | 794.19 | 126.37 | 106.73 | 72.13 | 48.75 | 32.95 | 22.27 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -85.05 | -257.65 | -242.25 | -63.67 | -166.05 | -51.66 | -34.92 | -23.60 | -15.95 | -10.78 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 1,005.09 | -223.12 | 59.38 | 730.52 | -39.69 | 55.07 | 37.22 | 25.15 | 17 | 11.49 |
Weighted Average Cost Of Capital
Share price | $ 296.8 |
---|---|
Beta | 0.997 |
Diluted Shares Outstanding | 6.36 |
Cost of Debt | |
Tax Rate | 27.20 |
After-tax Cost of Debt | 3.64% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 9.333 |
Total Debt | - |
Total Equity | 1,888.96 |
Total Capital | 1,888.96 |
Debt Weighting | 0.00 |
Equity Weighting | 100.00 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Actual | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected |
Revenue | 4,050.77 | 2,675.19 | 1,430.99 | 1,548.83 | 659.50 | 445.73 | 301.26 | 203.61 | 137.61 | 93.01 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 1,090.15 | 34.53 | 301.63 | 794.19 | 126.37 | 106.73 | 72.13 | 48.75 | 32.95 | 22.27 |
Capital Expenditure | -85.05 | -257.65 | -242.25 | -63.67 | -166.05 | -51.66 | -34.92 | -23.60 | -15.95 | -10.78 |
Free Cash Flow | 1,005.09 | -223.12 | 59.38 | 730.52 | -39.69 | 55.07 | 37.22 | 25.15 | 17 | 11.49 |
WACC | ||||||||||
PV LFCF | 50.37 | 31.14 | 19.25 | 11.90 | 7.36 | |||||
SUM PV LFCF | 120.01 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 9.33 |
Free cash flow (t + 1) | 11.72 |
Terminal Value | 159.89 |
Present Value of Terminal Value | 102.36 |
Intrinsic Value
Enterprise Value | 222.37 |
---|---|
Net Debt | -325.21 |
Equity Value | 547.58 |
Shares Outstanding | 6.36 |
Equity Value Per Share | 86.04 |