Projected Income Statement: Tesco PLC

Forecast Balance Sheet: Tesco PLC

Fiscal Period: February 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 12,298 12,000 10,516 10,493 9,764 9,602 9,862 9,694
Change - -2.42% -12.37% -0.22% -6.95% -1.66% 2.71% -1.7%
Announcement Date 08/04/20 14/04/21 13/04/22 13/04/23 10/04/24 - - -
1GBP in Million
Estimates

Cash Flow Forecast: Tesco PLC

Fiscal Period: February 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 1,003 1,171 949 971 1,386 1,370 1,391 1,399
Change - 16.75% -18.96% 2.32% 42.74% -1.12% 1.47% 0.58%
Free Cash Flow (FCF) 1 -965 -569 2,808 2,751 2,453 1,654 1,680 1,681
Change - -41.04% -593.5% -2.03% -10.83% -32.58% 1.57% 0.08%
Announcement Date 08/04/20 14/04/21 13/04/22 13/04/23 10/04/24 - - -
1GBP in Million
Estimates

Forecast Financial Ratios: Tesco PLC

Fiscal Period: February 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 7.63% 5.79% 7.41% 6.58% 6.66% 6.66% 6.71% 6.71%
EBIT Margin (%) 4.64% 3.14% 4.61% 4% 4.14% 4.24% 4.3% 4.33%
EBT Margin (%) 2.03% 1.43% 3.31% 1.52% 3.34% 3.43% 3.51% 3.63%
Net margin (%) 1.5% 10.61% 2.41% 1.13% 2.55% 2.5% 2.55% 2.62%
FCF margin (%) -1.49% -0.98% 4.58% 4.18% 3.6% 2.36% 2.35% 2.3%
FCF / Net Income (%) -99.38% -9.26% 189.6% 369.26% 141.3% 94.47% 92.01% 87.71%

Profitability

        
ROA 1.78% 2.04% 4.5% 3.54% 3.79% 3.73% 3.71% 3.75%
ROE 7.26% 7.84% 10.68% 12.12% 14.72% 15.43% 15.24% 16.03%

Financial Health

        
Leverage (Debt/EBITDA) 2.49x 3.58x 2.31x 2.42x 2.15x 2.06x 2.05x 1.98x
Debt / Free cash flow -12.74x -21.09x 3.75x 3.81x 3.98x 5.81x 5.87x 5.77x

Capital Intensity

        
CAPEX / Current Assets (%) 1.55% 2.02% 1.55% 1.48% 2.03% 1.96% 1.94% 1.92%
CAPEX / EBITDA (%) 20.3% 34.92% 20.89% 22.42% 30.5% 29.4% 28.97% 28.53%
CAPEX / FCF (%) -103.94% -205.8% 33.8% 35.3% 56.5% 82.87% 82.79% 83.21%

Items per share

        
Cash flow per share 1 0.00507 0.0623 0.485 0.4975 0.535 0.4887 0.5165 0.5419
Change - 1,129.59% 677.99% 2.58% 7.54% -8.65% 5.68% 4.93%
Dividend per Share 1 0.1159 0.0915 0.109 0.109 0.121 0.1298 0.1414 0.1531
Change - -21.05% 19.13% 0% 11.01% 7.26% 8.99% 8.25%
Book Value Per Share 1 1.735 1.282 2.045 1.673 1.626 1.667 1.713 1.786
Change - -26.13% 59.53% -18.21% -2.76% 2.52% 2.75% 4.27%
EPS 1 0.1208 0.0754 0.1964 0.1008 0.2453 0.253 0.2722 0.29
Change - -37.6% 160.48% -48.68% 143.35% 3.13% 7.61% 6.51%
Nbr of stocks (in thousands) 7,685,869 7,685,051 7,574,786 7,268,607 6,968,930 6,784,871 6,784,871 6,784,871
Announcement Date 08/04/20 14/04/21 13/04/22 13/04/23 10/04/24 - - -
1GBP
Estimates
2025 *2026 *
P/E ratio 14.4x 13.4x
PBR 2.19x 2.13x
EV / Sales 0.49x 0.48x
Yield 3.55% 3.87%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG Refinitiv
A
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
14
Last Close Price
3.655GBP
Average target price
3.665GBP
Spread / Average Target
+0.28%
Consensus

Quarterly revenue - Rate of surprise

-40% Limited-time offer: Our subscriptions help you unlock the best investment opportunities. Last hours!
BENEFIT NOW