Solid: reported annual data. Dashed: source model assumptions, including partially reported forecast years. These are not full analyst financial estimates.
Discounted cash flow model
Read only
Reported and forecast periods are kept separate. Forecasts are model assumptions, not full analyst consensus.
Model inputs
2021
2022
2023
2024
2025
2026E
2027E
2028E
2029E
2030E
2031E
2032E
2033E
Free Cash Flow to Equity
72.71B
-44.59B
31.36B
31.38B
11.47B
1.6B
6.59B
11.57B
20.97B
29.89B
38.24B
45.67B
50.36B
Revenue
276.19B
302.02B
364.48B
371.43B
371.44B
394.75B
407.83B
358.04B
405.36B
420B
437.92B
459.46B
483.44B
Net CapEx
-21.12B
-27.49B
-79.69B
-68.69B
-65.49B
-60.4B
-58.32B
-46.54B
-46.21B
-41.16B
-37.22B
-34.46B
-34.32B
Debt Ratio
18.4%
20.6%
18.6%
16.1%
15.2%
18.3%
18.3%
18.3%
18.3%
18.3%
18.3%
18.3%
18.3%
Net Income
89.94B
-22.76B
96.22B
89B
66.97B
50.94B
54.23B
49.59B
58.72B
63.51B
68.65B
73.83B
78.4B
Net Margin
32.6%
-7.5%
26.4%
24%
18%
12.9%
13.3%
13.9%
14.5%
15.1%
15.7%
16.1%
16.2%
Net CapEx Financed by Equity
-17.23B
-21.83B
-64.87B
-57.62B
-55.5B
-49.34B
-47.64B
-38.02B
-37.75B
-33.62B
-30.41B
-28.15B
-28.04B
Put the assumptions in perspective
Reported revenue grew at a compound annual rate of 2020–2025: 8.6%. The model implies a compound annual revenue change of 2025–2033: 3.3%.
The model’s net margin for 2033 is 16.2%. The reported 2021–2025 average is 18.7%.
These comparisons use this model’s own annual series. Forecast periods can contain reported portions; they remain forecasts. They are not a separate Wall Street consensus or a judgment that the assumptions will be achieved.
Reading this DCF model
What does a DCF estimate tell me?
It expresses a stream of future cash flows as a value today. A cash flow expected several years from now is discounted because waiting and business risk have a cost. The result depends on the cash flow definition and assumptions used in that model.
How do cash flows become a value per share?
The model projects business performance, estimates the cash remaining for investors and discounts those amounts. A terminal value represents the years beyond the explicit forecast. Depending on the template, debt and other adjustments connect business value to equity value before the per-share calculation.
How precise is the result?
Small changes in growth, margins, discount rates or terminal assumptions can materially change the estimate. Read the bear, base and bull cases together and check whether their assumptions fit the business. Extra decimal places do not make a forecast more certain.
Does a DCF value above the price mean I should buy?
That difference indicates a discount under the selected assumptions. It does not identify a purchase date or guarantee a return. Read the financial statements, consider the risks and compare alternative scenarios before drawing a conclusion.