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
2.82B
8.01B
15.4B
25.9B
36.41B
46.27B
55.07B
60.64B
Revenue
276.19B
302.02B
364.48B
371.43B
371.44B
416.6B
424.05B
439.17B
475.11B
492.27B
513.27B
538.53B
566.63B
Net CapEx
-21.12B
-27.49B
-79.69B
-68.69B
-65.49B
-63.74B
-60.64B
-57.09B
-54.16B
-48.24B
-43.63B
-40.39B
-40.23B
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
54.89B
57.55B
62.04B
70.15B
75.82B
81.91B
88.07B
93.51B
Net Margin
32.6%
-7.5%
26.4%
24%
18%
13.2%
13.6%
14.1%
14.8%
15.4%
16%
16.4%
16.5%
Net CapEx Financed by Equity
-17.23B
-21.83B
-64.87B
-57.62B
-55.5B
-52.07B
-49.54B
-46.64B
-44.25B
-39.41B
-35.64B
-33B
-32.87B
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: 5.4%.
The model’s net margin for 2033 is 16.5%. 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.