Discounted Cash Flow (DCF) Analysis Unlevered

Eni S.p.A. (E)

$32.97

-0.17 (-0.51%)
All numbers are in Millions, Currency in USD
Stock DCF: 186.92 | 32.97 | undervalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 75,82269,88143,98776,575133,440167,952.98211,392.41266,067.04334,882.74421,496.95
Revenue (%)
EBITDA 22,25120,4579,56522,86930,31844,658.9156,209.5170,747.5789,045.75112,076.58
EBITDA (%)
EBIT 15,26312,3512,26115,80623,11327,177.0234,206.0943,053.1754,188.4668,203.79
EBIT (%)
Depreciation 6,9888,1067,3047,0637,20517,481.8922,003.4227,694.3934,857.2843,872.79
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 17,68813,13815,16918,86319,91039,021.5149,114.0561,816.9477,805.3097,928.89
Total Cash (%)
Account Receivables 14,85313,06511,11019,04521,15735,024.5644,083.3355,485.0669,835.7487,898.08
Account Receivables (%)
Inventories 4,6514,7343,8936,0727,70911,913.0514,994.2518,872.3623,753.5229,897.14
Inventories (%)
Accounts Payable 16,74715,54412,93621,72025,71040,769.2151,313.7864,585.6081,290.04102,314.94
Accounts Payable (%)
Capital Expenditure -9,119-8,376-4,632-5,236-783-14,097.25-17,743.37-22,332.52-28,108.62-35,378.64
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 32.97
Beta 1.149
Diluted Shares Outstanding 1,745
Cost of Debt
Tax Rate 37.02
After-tax Cost of Debt 18.45%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.579
Total Debt 31,868
Total Equity 57,532.65
Total Capital 89,400.65
Debt Weighting 35.65
Equity Weighting 64.35
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 75,82269,88143,98776,575133,440167,952.98211,392.41266,067.04334,882.74421,496.95
EBITDA 22,25120,4579,56522,86930,31844,658.9156,209.5170,747.5789,045.75112,076.58
EBIT 15,26312,3512,26115,80623,11327,177.0234,206.0943,053.1754,188.4668,203.79
Tax Rate 59.18%97.42%-44.33%45.52%37.02%38.96%38.96%38.96%38.96%38.96%
EBIAT 6,230.84318.133,263.288,610.8314,557.1316,588.2420,878.6326,278.6933,075.4241,630.07
Depreciation 6,9888,1067,3047,0637,20517,481.8922,003.4227,694.3934,857.2843,872.79
Accounts Receivable -1,7881,955-7,935-2,112-13,867.56-9,058.77-11,401.73-14,350.68-18,062.35
Inventories --83841-2,179-1,637-4,204.05-3,081.20-3,878.12-4,881.16-6,143.62
Accounts Payable --1,203-2,6088,7843,99015,059.2110,544.5713,271.8216,704.4521,024.89
Capital Expenditure -9,119-8,376-4,632-5,236-783-14,097.25-17,743.37-22,332.52-28,108.62-35,378.64
UFCF 4,099.84550.136,123.289,107.8321,220.1316,960.4923,543.2929,632.5337,296.7046,943.14
WACC
PV UFCF 15,043.9018,522.9920,679.2423,086.5125,774.01
SUM PV UFCF 103,106.65

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 12.74
Free cash flow (t + 1) 47,882
Terminal Value 445,828.68
Present Value of Terminal Value 244,781.08

Intrinsic Value

Enterprise Value 347,887.73
Net Debt 21,713
Equity Value 326,174.73
Shares Outstanding 1,745
Equity Value Per Share 186.92