Share price
| Item | FY2025 | FY2026 | FY2027 | FY2028E |
|---|---|---|---|---|
| Revenue | 275,235 | 303,154 | 327,736 | 352,339 |
| NOPAT | 7,831 | 8,811 | 9,518 | 10,227 |
| Equity | 29,164 | 35,803 | 42,903 | 39,892 |
| Net debt | -7,036 | -12,725 | -16,554 | -10,073 |
Price vs model value
market cap vs the model’s equity value · r2DCF against the market -62.0% (tolerance 15.0%). the cost of capital (WACC 9.63 per cent, beta 1) against the steady state the market prices in: Beyond the tolerance, about 62 per cent below, caused by the cost of capital against the steady state the market prices in: the DCF's equity value at the snapshot is 171.6 billion against a market capitalisation of 451.7 billion. In the steady-state reading the market's enterprise value at the valuation date, 467.9 billion, implies a WACC of about 5.6 per cent at the model's 3.7 per cent growth and 25 per cent RONIC (the market-implied WACC), against the model's 9.63 per cent: a WACC near 5.6 per cent closes the gap. At the model's WACC the market prices in residual operating income growing ab
Residual income against the market -61.0% (tolerance 15.0%). the same cost of capital (WACC 9.63 per cent) and the growth of residual operating income after the fade's end, FY2037: Beyond the tolerance, about 61 per cent below, caused by the same cost of capital and steady state as the DCF's: residual income's equity value at the snapshot is 176.3 billion against 451.7 billion. At the model's 9.63 per cent WACC the market's value needs FY2037's residual operating income of 12.2 billion to grow about 8.2 per cent a year for ever (the market-implied growth) instead of at the 3.7 per cent GDP growth, a continuing value at the fade's end of 957.2 billion against the model's 213.5 billion; in the steady-state reading, a WACC of about 5.6 per cent (the market-implied WACC) clo
What if
Moving a driver re-runs the model; that opens shortly. The sliders show the Official’s own values.The model
Open the modelProfit & loss
| USD millions | FY2025 | FY2026 | FY2027 | FY2028E |
|---|---|---|---|---|
| Profit & loss | ||||
| Total revenue | 275,235 | 303,154 | 327,736 | 352,339 |
| Merchandise costs | 239,886 | 264,279 | 285,712 | 307,164 |
| Selling, general and administrative expenses | 24,966 | 27,190 | 29,393 | 31,598 |
| Operating income | 10,383 | 11,685 | 12,631 | 13,577 |
| Income before income taxes | 10,818 | 12,251 | 13,471 | 14,523 |
| Net income including noncontrolling interests | 8,099 | 9,226 | 10,090 | 10,877 |
| Net income attributable to noncontrolling interests | 0.00 | 0.00 | 0.00 | 0.00 |
| Net income | 8,099 | 9,226 | 10,090 | 10,877 |
No comments yet.