Projected Income Statement: Tesco PLC

Forecast Balance Sheet: Tesco PLC

Forecast Balance Sheet - Tesco PLC
Fiscal Period: February 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 10,516 10,493 9,764 9,454 10,563 11,124 10,840 10,638
Change - -0.22% -6.95% -3.17% 11.73% 5.31% -2.55% -1.86%
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 PLC

Fiscal Period: February 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 949 971 1,386 1,539 1,666 1,730 1,665 1,673
Change - 2.32% 42.74% 11.04% 8.25% 3.82% -3.75% 0.49%
Free Cash Flow (FCF) 1 2,808 2,751 2,453 1,383 2,240 1,867 2,034 2,140
Change - -2.03% -10.83% -43.62% 61.97% -16.64% 8.92% 5.2%
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 PLC

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.93% 7.01% 7.06%
EBIT Margin (%) 4.61% 4% 4.14% 4.47% 4.33% 4.4% 4.48% 4.56%
EBT Margin (%) 3.31% 1.52% 3.34% 3.17% 3.26% 3.54% 3.71% 3.78%
Net margin (%) 2.41% 1.13% 2.55% 2.33% 2.42% 2.67% 2.81% 2.93%
FCF margin (%) 4.58% 4.18% 3.6% 1.98% 3.04% 2.49% 2.64% 2.71%
FCF / Net Income (%) 189.6% 369.26% 141.3% 85.06% 125.35% 93.38% 94.19% 92.45%

Profitability

        
ROA 4.5% 3.54% 3.79% 4.41% 4.95% 5.23% 5.48% 5.76%
ROE 10.68% 12.12% 14.72% 16.23% 16.78% 17.51% 18.29% 18.83%

Financial Health

        
Leverage (Debt/EBITDA) 2.31x 2.42x 2.15x 1.96x 2.11x 2.14x 2.01x 1.91x
Debt / Free cash flow 3.75x 3.81x 3.98x 6.84x 4.72x 5.96x 5.33x 4.97x

Capital Intensity

        
CAPEX / Current Assets (%) 1.55% 1.48% 2.03% 2.2% 2.26% 2.31% 2.16% 2.12%
CAPEX / EBITDA (%) 20.89% 22.42% 30.5% 31.9% 33.27% 33.29% 30.87% 30.04%
CAPEX / FCF (%) 33.8% 35.3% 56.5% 111.28% 74.38% 92.63% 81.86% 78.19%

Items per share

        
Cash flow per share 1 0.485 0.4975 0.535 0.4224 0.5913 0.5603 0.5828 0.616
Change - 2.58% 7.54% -21.05% 39.99% -5.24% 4.02% 5.69%
Dividend per Share 1 0.109 0.109 0.121 0.137 0.145 0.1616 0.1747 0.1898
Change - 0% 11.01% 13.22% 5.84% 11.46% 8.09% 8.63%
Book Value Per Share 1 2.045 1.673 1.626 1.707 1.762 1.869 1.904 1.98
Change - -18.21% -2.76% 4.94% 3.21% 6.07% 1.89% 4.03%
EPS 1 0.1964 0.1008 0.2453 0.2351 0.271 0.3135 0.3456 0.3763
Change - -48.68% 143.35% -4.16% 15.27% 15.68% 10.26% 8.87%
Nbr of stocks (in thousands) 7,574,218 7,268,607 6,968,930 6,696,942 6,355,483 6,236,625 6,236,625 6,236,625
Announcement Date 4/13/22 4/13/23 4/10/24 4/10/25 4/16/26 - - -
1GBP
Estimates
2027 *2028 *
P/E 17.1x 15.6x
PBR 2.88x 2.82x
EV / Sales 0.6x 0.58x
Yield 3.01% 3.25%

EPS & Dividend

EPS & Dividend - Tesco PLC


Y-o-Y evolution of P/E

Valuation ratios - P/E - Tesco PLC
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Tesco PLC
Trader
Investor
Global
Quality
ESG MSCI
AA
MarketScreener Ratings - Tesco PLC
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
15
Last Close Price
5.376GBP
Average target price
5.293GBP
Spread / Average Target
-1.54%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Tesco PLC
  1. Stock Market
  2. Stocks
  3. TSCO Stock
  4. Financials Tesco PLC