Discounted Cash Flow (DCF) Analysis Levered
Tenaris S.A. (TS)
$31.98
+0.11 (+0.35%)
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 | 7,658.59 | 7,294.05 | 5,146.73 | 6,521.21 | 11,762.53 | 13,905.66 | 16,439.27 | 19,434.51 | 22,975.48 | 27,161.62 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 610.80 | 1,527.94 | 1,520.38 | 119.08 | 1,167.22 | 1,952.72 | 2,308.50 | 2,729.11 | 3,226.35 | 3,814.20 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -343.46 | -348.08 | -194.35 | -244.59 | -397.35 | -560.73 | -662.89 | -783.67 | -926.46 | -1,095.26 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 267.34 | 1,179.86 | 1,326.03 | -125.52 | 769.87 | 1,391.99 | 1,645.61 | 1,945.44 | 2,299.90 | 2,718.94 |
Weighted Average Cost Of Capital
Share price | $ 31.98 |
---|---|
Beta | 1.611 |
Diluted Shares Outstanding | 590.27 |
Cost of Debt | |
Tax Rate | 19.35 |
After-tax Cost of Debt | 4.40% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 12.254 |
Total Debt | 840.94 |
Total Equity | 18,876.79 |
Total Capital | 19,717.73 |
Debt Weighting | 4.26 |
Equity Weighting | 95.74 |
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 | 7,658.59 | 7,294.05 | 5,146.73 | 6,521.21 | 11,762.53 | 13,905.66 | 16,439.27 | 19,434.51 | 22,975.48 | 27,161.62 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 610.80 | 1,527.94 | 1,520.38 | 119.08 | 1,167.22 | 1,952.72 | 2,308.50 | 2,729.11 | 3,226.35 | 3,814.20 |
Capital Expenditure | -343.46 | -348.08 | -194.35 | -244.59 | -397.35 | -560.73 | -662.89 | -783.67 | -926.46 | -1,095.26 |
Free Cash Flow | 267.34 | 1,179.86 | 1,326.03 | -125.52 | 769.87 | 1,391.99 | 1,645.61 | 1,945.44 | 2,299.90 | 2,718.94 |
WACC | ||||||||||
PV LFCF | 1,243.73 | 1,313.75 | 1,387.70 | 1,465.81 | 1,548.32 | |||||
SUM PV LFCF | 6,959.31 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 11.92 |
Free cash flow (t + 1) | 2,773.32 |
Terminal Value | 27,956.84 |
Present Value of Terminal Value | 15,920.24 |
Intrinsic Value
Enterprise Value | 22,879.54 |
---|---|
Net Debt | -250.59 |
Equity Value | 23,130.13 |
Shares Outstanding | 590.27 |
Equity Value Per Share | 39.19 |