Marks & Spencer - balance sheet exracts

Balance Sheet 2022 2023

Longterm Debt 891.60 1,120.00

Total Equity 2,910.00 2,810.00

3,802 3,930

2022 2023
IN MILLIONS
Total Assets 9,440.00 9,100.00
Cash and Cash Equivalents 1,322.00 1,080.00
current assets 2,180.00 2,150.00
INVENTORY 706.10 764.40

Total Liabilities 6,530.00 6,280.00

Current Liabilities 2,370.00 2,710.00

Total Equity 2,910.00 2,810.00

Total revenue 10,890.00 11,930.00

PROFIT 306.60 363.40

Key Ratios
Current Ratio Current Assets / Current Liabilities​

2022 2023
Current Ratio 0.56 0.40

Asset Efficiency Ratio Revenue / Total Assets

2022 2023
Asset Turnover Ratio 1.15 1.31
Quick Ratio (Current Asset - Inventory)/Current Liability
2022 2023
Quick ratio 0.62 0.51

Debt Equity Ratio Total Debt/ Total Shareholders Equity

2022 2023
Debt Equity Ratio 2.24 2.23

Profitability Ratio

Return on Assets (ROA): Net Profit/Total Assets * 100

2022 2023
Return on Assets (ROA): 3.2% 4.0%

Net Profit Margin Net Loss/Revenue * 100

2022 2023
Net Profit Margin 2.82% 3.05%

Return on Equity (ROE): Net loss/ Total Shareholders Equity *100

2022 2023
Return on Equity (ROE): 10.54% 12.93%

NET PRESENT VALUE

WACC 10.61%

Year 0 1
Revenue 1,800,000
Variable Costs (1,080,000)
Fixed Costs (500,000)
Depreciation (200,000)
EBIT 20,000
Tax (15%) 3,000
NOPAT 17,000
Add back: Depreciation 200,000
Cash Flow (NOPAT + Depreciation) (1,000,000) 217,000
Investment

PV @ 11.91% (1,000,000) 196,185

NPV (+ive) 261,134

IRR 19.098%
 2024

8,916.00
2,830.00

11,746

2024
LIONS
8,640.00
1,030.00
2,150.00
776.90

5,850.00
2,520.00

2,830.00

13,040.00
431.20

2024
0.41

2024
1.51
 2024
0.54

2024
2.07

2024
5.0%

2024
3.31%

2024
15.24%

E
 2 3 4 5
1,980,000 2,178,000 2,395,800 2,635,380
(1,188,000) (1,306,800) (1,438,680) (1,581,228)
(500,000) (500,000) (500,000) (500,000)
(200,000) (200,000) (200,000) (200,000)
92,000 171,200 257,120 354,152
13,800 25,680 38,568 53,123
78,200 145,520 218,552 301,029
200,000 200,000 200,000 200,000
278,200 345,520 418,552 501,029

227,388 255,323 279,622 302,615

Current Ratio
2024 2023 2022 Current Rati
Current Ratio 0.41 0.40 0.56 0.60
0.50
0.40
2024 2023 2022 0.30
Asset Turnover Ratio 1.51 1.31 1.15 0.20
0.10
0.00
2024 2023
2024 2023 2022
Debt Equity Ratio 2.07 2.23 2.24
Debt
2.30
2024 2022 2021
Return on Asse 5.00% 4.00% 3.20% 2.25

2.20
2024 2023 2022
Net Profit Marg 3.31% 3.05% 2.82% 2.15

2.10
2023 2022 2021
2.05
Return on Equit 15.24% 12.93% 10.54%
2.00

1.95
1

Net Profit Margin Return o

3.40% 5.00%
3.30% 4.50%
3.20% 4.00%
3.50%
3.10%
3.00%
3.00%
2.50%
2.90%
2.00%
2.80%
1.50%
2.70%
1.00%
2.60%
0.50%
2.50%
2024 2023 2022 0.00%
2024
 Current Ratio Asset Turnover Ratio

2
1.5
1
0.5
0
Asset Turnover Ratio
2024 2023 2022
2024 2023 2022

Debt Equity Ratio

1 2 3

Debt Equity Ratio

Return on Assets (ROA): Return on Equity (ROE):

16.00%
14.00%
12.00%
10.00%
8.00%
6.00%
4.00%
2.00%
0.00%
2024 2022 2021 2023 2022 2021
n on Equity (ROE):

2022 2021