Projected Income Statement: Tesco

Forecast Balance Sheet: Tesco

Fiscal Period: February 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 10,516 10,493 9,764 9,454 10,563 10,544 10,347 10,247
Change - -0.22% -6.95% -3.17% 11.73% -0.18% -1.87% -0.97%
Announcement Date 4/13/22 4/13/23 4/10/24 4/10/25 4/16/26 - - -
1GBP in Million
Estimates

Cash Flow Forecast: Tesco

Fiscal Period: February 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 949 971 1,386 1,539 1,666 1,598 1,618 1,641
Change - 2.32% 42.74% 11.04% 8.25% -4.08% 1.28% 1.41%
Free Cash Flow (FCF) 1 2,808 2,751 2,453 1,383 2,240 1,891 2,068 2,189
Change - -2.03% -10.83% -43.62% 61.97% -15.58% 9.39% 5.83%
Announcement Date 4/13/22 4/13/23 4/10/24 4/10/25 4/16/26 - - -
1GBP in Million
Estimates

Forecast Financial Ratios: Tesco

Fiscal Period: February 2022 2023 2024 2025 2026 2027 2028 2029

Profitability

        
EBITDA Margin (%) 7.41% 6.58% 6.66% 6.9% 6.79% 6.8% 6.89% 6.96%
EBIT Margin (%) 4.61% 4% 4.14% 4.47% 4.33% 4.34% 4.42% 4.5%
EBT Margin (%) 3.31% 1.52% 3.34% 3.17% 3.26% 3.53% 3.65% 3.73%
Net margin (%) 2.41% 1.13% 2.55% 2.33% 2.42% 2.6% 2.73% 2.87%
FCF margin (%) 4.58% 4.18% 3.6% 1.98% 3.04% 2.52% 2.68% 2.77%
FCF / Net Income (%) 189.6% 369.26% 141.3% 85.06% 125.35% 97.08% 98.29% 96.58%

Profitability

        
ROA 4.5% 3.54% 3.79% 4.41% 4.95% 5.01% 5.29% 5.58%
ROE 10.68% 12.12% 14.72% 16.23% 16.78% 17.05% 17.79% 18.33%

Financial Health

        
Leverage (Debt/EBITDA) 2.31x 2.42x 2.15x 1.96x 2.11x 2.07x 1.95x 1.86x
Debt / Free cash flow 3.75x 3.81x 3.98x 6.84x 4.72x 5.58x 5x 4.68x

Capital Intensity

        
CAPEX / Current Assets (%) 1.55% 1.48% 2.03% 2.2% 2.26% 2.13% 2.1% 2.08%
CAPEX / EBITDA (%) 20.89% 22.42% 30.5% 31.9% 33.27% 31.32% 30.49% 29.85%
CAPEX / FCF (%) 33.8% 35.3% 56.5% 111.28% 74.38% 84.5% 78.24% 74.98%

Items per share

        
Cash flow per share 1 0.485 0.4975 0.535 0.4224 0.5913 0.5554 0.5713 0.6029
Change - 2.58% 7.54% -21.05% 39.99% -6.06% 2.86% 5.52%
Dividend per Share 1 0.109 0.109 0.121 0.137 0.145 0.157 0.1713 0.1858
Change - 0% 11.01% 13.22% 5.84% 8.25% 9.11% 8.5%
Book Value Per Share 1 2.045 1.673 1.626 1.707 1.762 1.825 1.902 1.984
Change - -18.21% -2.76% 4.94% 3.21% 3.61% 4.23% 4.27%
EPS 1 0.1964 0.1008 0.2453 0.2351 0.271 0.3043 0.3347 0.366
Change - -48.68% 143.35% -4.16% 15.27% 12.29% 9.99% 9.35%
Nbr of stocks (in thousands) 7,574,218 7,268,607 6,968,930 6,696,942 6,355,483 6,232,138 6,232,138 6,232,138
Announcement Date 4/13/22 4/13/23 4/10/24 4/10/25 4/16/26 - - -
1GBP
Estimates
2027 *2028 *
P/E 16.5x 15x
PBR 2.75x 2.64x
EV / Sales 0.56x 0.54x
Yield 3.13% 3.41%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
15
Last Close Price
5.018GBP
Average target price
5.170GBP
Spread / Average Target
+3.03%

Quarterly revenue - Rate of surprise