Discounted Cash Flow (DCF) Analysis Levered
Alphageo (India) Limited (ALPHAGEO.NS)
326.4 ₹
-5.45 (-1.64%)
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,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 | $ 326.4 |
---|---|
Beta | 0.911 |
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 | 8.615 |
Total Debt | - |
Total Equity | 2,077.46 |
Total Capital | 2,077.46 |
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,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.70 | 31.55 | 19.63 | 12.22 | 7.60 | |||||
SUM PV LFCF | 121.71 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 8.61 |
Free cash flow (t + 1) | 11.89 |
Terminal Value | 232.73 |
Present Value of Terminal Value | 153.99 |
Intrinsic Value
Enterprise Value | 275.70 |
---|---|
Net Debt | -325.21 |
Equity Value | 600.91 |
Shares Outstanding | 6.36 |
Equity Value Per Share | 94.41 |