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
Free Cash Flow to Equity
92.85B
99.8B
103.52B
103.93B
118.74B
145.27B
170.13B
193.73B
198.38B
211.34B
223.79B
Revenue
365.82B
394.33B
383.29B
391.04B
416.16B
488.77B
569.05B
642.65B
653.54B
692.2B
731.29B
Net CapEx
-5.19B
-6M
17.25B
27.45B
14.67B
15.15B
14.8B
12.85B
8.5B
5.54B
4.39B
Debt Ratio
64.7%
68.4%
62.2%
62.9%
54.1%
62.3%
62.3%
62.3%
62.3%
62.3%
62.3%
Net Income
94.68B
99.8B
97B
93.74B
112.01B
139.56B
164.56B
188.88B
195.18B
209.25B
222.14B
Net Margin
25.9%
25.3%
25.3%
24%
26.9%
28.6%
28.9%
29.4%
29.9%
30.2%
30.4%
Net CapEx Financed by Equity
-1.83B
-1.9M
6.53B
10.19B
6.73B
5.71B
5.58B
4.85B
3.2B
2.09B
1.65B
Put the assumptions in perspective
Reported revenue grew at a compound annual rate of 2020–2025: 8.7%. The model implies a compound annual revenue change of 2025–2031: 9.9%.
The model’s net margin for 2031 is 30.4%. The reported 2021–2025 average is 25.5%.
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.