Project Work

profileRavi12
KINGFISHERRATIOANALYSIS2.xlsx
Home>Computer Science homework help>Project Work

Summary Requirement

Sr. No Category Ratios
1 Profitability Ratios ROCE - Return on Capital Employed
ROE - Return on Equity / Shareholders Funds
Capital Turnover
Net and Gross Margins
2 Efficiency Ratios Inventory Days
Trade Receivable Days
Trade Payable Days
Asset Turnover
3 Liquidity Ratios Current Ratio
Acid Test Ratio/ Quick Ratio
4 Financial Ratios Debt to Equity
Gearing
Interest coverage
5 Investment Ratios EPS
PE
Dividend Coverage
Dividend Yield

Cons Balance Sheet Kingfisher

Consolidated Balance Sheet of Kingfisher plc - FY 2019,2020 and 2021
USD ($) in Millions % USD ($) in Millions % USD ($) in Millions
CONDENSED CONSOLIDATED BALANCE SHEETS Jan. 31, 2020/21 Change Jan. 31, 2019/20 Change Jan. 31, 2018/19
CURRENT ASSETS
Cash and cash equivalents 1,142 45% p 790 -7% 🔻 850
assets held for sale 12 -94% p 196 120% 🔻 89
TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS 1,154 17% p 986 5% 🔻 939
Derivative assets 5 -64% 🔻 14 -46% 🔻 26
Trade accounts receivable - Net 290 -1% 🔻 293 -28% p 406
Inventories 2,488 0% 🔻 2,485 -3% p 2,574
current tax assets 20 122% p 9 800% 🔻 1
TOTAL CURRENT ASSETS 3,957 4% 🔻 3,787 -4% 🔻 3,946
NON-CURRENT ASSETS
right of use assets 1,845 -4% p 1,916 -5% 🔻 2,017
Other Investments 40 67% 🔻 24 4% 🔻 23
OTHER ASSETS 561 39% p 405 26% p 321
Deferred Income Tax Assets 15 36% p 11 -8% 🔻 12
Property, plant and equipment - Net 3,075 3% 🔻 2,988 -10% p 3,302
other receivables 29 7% p 27 -34% p 41
GOODWILL 2,427 0% p 2,416 -1% p 2,436
Other Intangible Assets 320 -6% 🔻 339 -9% 🔻 371
TOTAL NON-CURRENT ASSETS 8,312 2% p 8,126 -5% p 8,523
TOTAL ASSETS 12,269 3% p 11,913 -4% p 12,469
CURRENT LIABILITIES
Trade and other payables 2,520 14% 🔻 2,210 -8% p 2,415
borrowings 101 -84% p 644 4% p 622
lease and derivative liabilities 389 11% 🔻 349 6% 🔻 329
provisions 46 -29% 🔻 65 141% 🔻 27
Accrued income taxes 127 -23% 🔻 166 41% p 118
TOTAL CURRENT LIABILITIES 3,183 -7% 🔻 3,434 -2% 🔻 3,511
NON-CURRENT LIABILITIES
borrowings 13 -87% 🔻 98 -32% 🔻 145
lease and derivatives liabilities 2,092 -6% p 2,224 -4% p 2,320
provisions and other benefits 178 7% p 166 9% p 152
Deferred Income Tax Liabilities 232 23% 🔻 189 -2% 🔻 192
TOTAL NON-CURRENT LIABILITIES 2,515 -6% p 2,677 -5% p 2,809
SHAREOWNERS' EQUITY
share capital 332 0% 332 0% 332
share premium 2,228 0% p 2,228 0% p 2,228
own shares held in ESOP (23) 0% p (23) -8% p (25)
retained earnings 3,630 21% p 2,994 -6% p 3,192
capital redemption reserve 43 0% 43 0% p 43
EQUITY ATTRIBUTABLE TO SHAREOWNERS OF COMPANY 6,210 11% p 5,574 -3% p 5,770
Other researves 361 58% 🔻 228 -40% p 379
TOTAL EQUITY 6,571 13% p 5,802 -6% p 6,149
TOTAL LIABILITIES 12,269 3% p 11,913 -4% p 12,469

Cons Income Statement kingfish

Consolidated Income Statement of Kingfisher - FY 2018/19,2019/20 and 2020/21
Part 1
USD ($) in Millions % USD ($) in Millions % USD ($) in Millions Pestle 770 500
CONDENSED CONSOLIDATED INCOME STATEMENT Dec. 31, 2021 Change Dec. 31, 2020 Change Dec. 31, 2019 SWOT 850 500
Revenues 12,343 7% 🔻 11,513 -1% p 11,685 Ratio 1700 1700
Cost of Goods and Services Sold (7,770) 7% 🔻 (7,258) -1% p (7,367) 3320 2700
GROSS PROFIT 4,573 7% 🔻 4,255 -1% p 4,318 Part 2 300
Part 3 238
Selling, General and Administrative Expense (3,646) -9% 🔻 (4,011) 5% p (3,836) 3238
Other Cost and Expense, income (11) -128% p 39 -2050% 🔻 (2)
OPERATING INCOME 916 224% 🔻 283 -41% p 480
Interest income 20 11% 🔻 18 13% 🔻 16
Interest expense (180) -9% p (198) 1% (196)
Equity income (loss) - net 0 ERROR:#DIV/0! 🔻 0 ERROR:#DIV/0! p 0
Other income (loss) - net 0 ERROR:#DIV/0! p 0 ERROR:#DIV/0! 🔻 0
Profit Before Tax 756 634% 🔻 103 -66% p 300
Tax (164) 73% p (95) -11% p (107)
Profit After Tax 592 7300% 🔻 8 -96% p 193
remeasurement of post employment benefit 68 42 78
inventory gain/loss (48) 20 85
tax on items not reclassified (13) (24) (53)
Other comprehensive income
Net foreign currency translation adjustment 112 (134) (46)
joint venture (2) (1) 0
transferred to income statement 49 (3) (2)
fair value difference- net 0 3 2
other Comprehensive Income / (Loss), Net of Tax 166 -271% 🔻 (97) -252% p 64
total items not reclassified as income or loss 159 (135) (46)
TOTAL COMPREHENSIVE INCOME (LOSS) ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY 758 (89) (3) 257
BASIC NET INCOME PER SHARE (in dollars per share) 28.1 0.4 9.1
DILUTED NET INCOME PER SHARE (in dollars per share) 27.9 0.4 9.0
adjusted basic 28.7 19.1 19.8
diluted basic 28.5 19.0 19.7
proposed dividend 8.3 0.0 0.0

Cons Balance Sheet Home depot

Consolidated Balnce Sheet of home depot 2018/19,19/20,2021
USD ($) in Millions % USD ($) in Millions % USD ($) in Millions
CONDENSED CONSOLIDATED BALANCE SHEETS Jan. 31, 2021 Change Jan. 31, 2020 Change Jan. 31, 2019
CURRENT ASSETS
Cash & Equivalents 7,895 270% p 2,133 20% 🔻 1,778
Short Term Investments - 0 ERROR:#DIV/0! p - 0 ERROR:#DIV/0! 🔻 - 0
Trade Receivables 2,992 42% p 2,106 9% p 1,936
Other Receivables - 0 ERROR:#DIV/0! p - 0 ERROR:#DIV/0! p - 0
Total Inventory 16,627 14% p 14,531 4% p 13,925
Prepaid Expenses & Other Current Assets 963 -7% p 1,040 17% 🔻 890
Total Current Assets 28,477 44% p 19,810 7% 🔻 18,529
NON-CURRENT ASSETS
Property/Plant/Equipment, Total - Net 24,705 8% p 22,770 2% p 22,375
Goodwill, Net 7,126 216% p 2,254 0% p 2,252
operating lease 5,962 7% p 5,595 ERROR:#DIV/0! p - 0
Long Term Investments - 0 ERROR:#DIV/0! p - 0 ERROR:#DIV/0! p - 0
Other Assets 4,311 434% p 807 -5% p 847
Deffered Income Taxes - 0 ERROR:#DIV/0! p - 0 ERROR:#DIV/0! p - 0
TOTAL NON-CURRENT ASSETS 42,104 34% p 31,426 23% p 25,474
TOTAL ASSETS 70,581 38% p 51,236 16% p 44,003
Current Liabilities
Short-term debt obligations - 0 -100% p 974 -27% 🔻 1,339
Trade Payables 11,606 49% p 7,787 0% p 7,755
Other Current Liabilities 11,560 20% p 9,614 26% 🔻 7,622
Total Current Liabilities 23,166 26% p 18,375 10% 🔻 16,716
Non-Current Liabilities
Long Term Debt 35,822 25% p 28,670 7% p 26,807
Deferred Income Tax 1,131 60% p 706 44% p 491
Other Liabilities, Total 7,163 9% p 6,601 254% p 1,867
TOTAL NON-CURRENT LIABILITIES 44,116 23% p 35,977 23% p 29,165
Shareowners Equity
Common Stock, Total 89 0% p 89 0% 89
Additional Paid-In Capital 11,540 5% p 11,001 4% 🔻 10,578
Retained Earnings (Accumulated Deficit) 58,134 12% p 51,729 11% p 46,423
Treasury Stock - Common (65,793) 1% p (65,196) 12% p (58,196)
Accumulated other comprehensive loss (671) -9% p (739) -95% 🔻 (15,119)
Total Common Shareholders’ Equity 3,299 -206% 🔻 (3,116) 66% p (1,878)
Non-controlling interest - 0 ERROR:#DIV/0! p - 0 ERROR:#DIV/0! 🔻 - 0
TOTAL EQUITY 3,299 -206% 🔻 (3,116) 66% p (1,878)
TOTAL LIABILITIES 70,581 38% p 51,236 16% p 44,003

Conso Income stmnt home depot

Consolidated Income Statement of Home depot - FY 2019/20/21.
USD ($) in Millions % USD ($) in Millions % USD ($) in Millions
CONDENSED CONSOLIDATED INCOME STATEMENT Jan 31, 2021 Change Jan 31, 2020 Change Jan 31, 2019
Net Revenue 132,110 20% p 110,225 2% p 108,203
Cost of Sales 87,257 20% p 72,653 2% p 71,043
Gross Profit 44,853 19% p 37,572 1% p 37,160
Selling/General/Admin. Expenses / other 26,575 22% p 21,729 0% p 21,630
OPERATING INCOME 18,278 15% 🔻 15,843 2% p 15,530
interest expense 1,347 -12% p 1,201 13% 🔻 1,067
Interest Income (Expense), Net Non-Operating (47) -36% p (73) -22% 🔻 (93)
Net Income Before Taxes 16,978 15% 🔻 14,715 1% p 14,556
Provision for Income Taxes 4,112 18% 🔻 3,473 1% 🔻 3,435
Net Income After Taxes 12,866 14% 🔻 11,242 1% 🔻 11,121
Less: Net income attributable to noncontrolling interests - 0 - 0 - 0
Net Income Attributable to Shareholders 12,866 11,242 11,121
Other comprehensive income
Net currency translation adjustment (650) 628 (1,641)
Net change on cash flow hedges 7 (90) 40
Net pension and retiree medical adjustments (532) 283 (467)
Other (1) (2) 6
Total Comprehensive Income / (Loss), Net of Tax 11,690 -3% 🔻 12,061 33% 🔻 9,059
Less: Comprehensive income / (loss) attributable to noncontrolling interests - 0 - 0 - 0
Comprehensive Income Attributable to shareholders 11,690 12,061 9,059
Dilution Adjustment - - 2.00
Diluted Net Income 7,120.00 7,314.00 12,515.00
Diluted Weighted Average Shares 1,078.00 1,093.00 1,143.00
Basic eps 11.98 10.29 9.78
basic weighted average common shares 1,074.00 1,094.00 1,137.00
Diluted Normalized EPS 11.94 10.25 9.73

Ratios Calculation

Kingfisher Home depot
Profitability Ratios Ideal Ratio 2021 2020 2019 2021 2020 2019
1 ROCE - Return on Capital Employed = Operating Profit x 100 > 15 % 11% 4% 6% 47% 62% 62%
Total Equity + Long-Term Debt (Outside borrowings)
2 Return on Equity = Net Profit after Interest and Tax x 100 > 15 % - 20 % 9% 0% 3% 390% -361% -592%
Total Equity
3 Capital Turnover = Sales x times : 1 1.42 1.43 1.38 3.38 4.31 4.34
Capital Employed ( Total Equity + Long-Term Debt ( Outside borrowings))
4 Gross Margin = Gross Profit x 100 > 20 % is High 37% 37% 37% 34% 34% 34%
Sales
5 Net Margin = Net Profit x 100 > 10 % is High 5% 0% 2% 9.74% 10% 10%
Sales
6 Cost of Sales to Sales = Cost of Sales x 100 63% 63% 63% 66% 66% 66%
Sales Sales
COS
Efficiency Ratios Eq
LTD
1 Inventory Days = Inventory (Closing or Average) x 365 Profit 117 125 128 70 73 72
Cost of Goods Sold Fixed cost
2 Trade Receivable Days = Trade Receivables x 365 < Payable Days 9 9 13 8 7 7
Sales
3 Trade Payable Days = Trade Payables x 365 > Receivable Days 118 111 120 49 39 40
Cost of Goods Sold
4 Asset Turnover = Sales 0.25 - 5 1.01 0.97 0.94 1.87 2.15 2.46
Total Assets
Liquidity Ratios
1 Current Ratio = Current Assets 2:1 1.24 1.10 1.12 1.23 1.08 1.11
Current Liabilities
2 Acid Test Ratio / Quick Ratio = Current Asset - Inventory 1:1 0.46 0.38 0.39 0.51 0.29 0.28
Current Liabilities
Financial Ratios
1 Debt to Equity Ratio = Non-Current Outside Liability 0.015 0.023 0.026 11.28 -10.1 -14.27
Equity
2 Gearing Ratio = Non-Current Outside Liability 25%-50% 24% 28% 27% 92% 112% 108%
Non-Current Outside Liability + Equity
3 Interest Coverate Ratio = Net Profit before Interest and Tax 3-5 5.20 1.52 2.53 362 203 158
Interest Payable
Investment Ratios
1 Earnings per share = Net profit after interest and tax attributable to shareholders 28.70 0.01 9.10 4.52 4.03 2.29
Weighted averag number of ordinary shares
2 Price Earning Ratio = Market Price per Share 8.42 465.00 19.10 18.66 20.89 17.24
Earnings per share
3 Divident Cover Ratio = EPS 2.19 0.80 1.70 1.12 1.06 0.64
Dividend per share
4 Dividend Yield Ratio = Dividend per share 5.48% 3.20% 3.31% 2.71% 2.76% 3.25%
Market Price per Share

Ratio Requirements

Profitability Ratio
•Identify trends over last 3 years (increase/decrease?)
•Look at Chairpersons Report or CFO Report to identify reasons for increase/decrease in profit ratios
•Compare to competitors
•What was happening in that industry sector (Google it!)
•Look at the ratio of cost of sales to sales - increasing or decreasing over the period you are analysing? (increase could suggest increase in cost of raw materials)?
•Compare to Rules of Thumb
Efficiency Ratio
Identify trends over last 3 years (increase/decrease?)
Inventory days look very high – keeping stock for half a year – quite long but need to see what competitors/industry norm is
Trade receivable much lower than payable – good for cashflow
However 136 days to pay looks long – need to see what norm is for this industry and check contracts
Asset turnover – looks reasonable – again compare to competitors and industry norm

Kingfisher Ratio Analysis

Ratio analysis - Kingfisher
Sr. No Category Ratio 2021 2020 2019
1 Profitability Ratios ROCE - Return on Capital Employed 11% 🔻 4% p 6%
2 Profitability Ratios ROE - Return on Equity / Shareholders Funds 9% 🔻 0% p 3%
3 Profitability Ratios Capital Turnover 1.42 🔻 1.43 p 1.38
4 Profitability Ratios Gross Margins 37% 🔻 37% 🔻 37%
5 Profitability Ratios Net Margin 5% p 0% p 2%
6 Profitability Ratios Cost of Sales to Sales 63% p 63% p 63%
7 Efficiency Ratios Inventory Days 117 p 125 🔻 128
8 Efficiency Ratios Trade Receivable Days 9 🔻 9 p 13
9 Efficiency Ratios Trade Payable Days 118 p 111 p 120
10 Efficiency Ratios Asset Turnover 1.01 🔻 0.97 p 0.94
11 Liquidity Ratios Current Ratio 1.24 p 1.10 🔻 1.12
12 Liquidity Ratios Acid Test Ratio / Quick Ratio 0.46 p 0.38 🔻 0.39
13 Financial Ratios Debt to Equity 2% p 2% 🔻 3%
14 Financial Ratios Gearing 24% p 28% p 27%
15 Financial Ratios Interest Coverage 5 🔻 2 p 3
s Investment Ratio Earnings per share 28.70 🔻 0.01 p 9.10
17 Investment Ratio Price earning ratio 8.42 p 4.65 🔻 19.10
18 Investment Ratio Dividend Cover ratio 2.19 🔻 0.80 p 1.70
19 Investment Ratio Divident yeild ratio 5.48% p 3.20% 🔻 3.31%

Competitor Ratio Analysis

Competitor Ratio Analysis (Home-Depot)
Kingfisher Company Home depot
Sr. No Category Ratio 2021 2020 2019 2021 2020 2019
1 Profitability Ratios ROCE - Return on Capital Employed 10.6% 3.5% 5.7% 47% 62% 62%
2 Profitability Ratios ROE - Return on Equity / Shareholders Funds 9.0% 0.1% 3.1% 390% -361% -592%
3 Profitability Ratios Capital Turnover 1.42 1.43 1.38 3.38 4.31 4.34
4 Profitability Ratios Gross Margins 37.0% 37.0% 37.0% 34.0% 34.1% 34.3%
5 Profitability Ratios Net Margin 4.8% 0.1% 1.7% 9.7% 10.2% 10.3%
6 Profitability Ratios Cost of Sales to Sales 62.95% 63.04% 63.05% 66.05% 65.91% 65.66%
7 Efficiency Ratios Inventory Days 117 125 128 70 73 72
8 Efficiency Ratios Trade Receivable Days 9 9 13 8 7 7
9 Efficiency Ratios Trade Payable Days 118 111 120 49 39 40
10 Efficiency Ratios Asset Turnover 1.01 0.97 0.94 1.87 2.15 2.46
11 Liquidity Ratios Current Ratio 1.24 1.10 1.12 1.23 1.08 1.11
12 Liquidity Ratios Acid Test Ratio / Quick Ratio 0.46 0.38 0.39 0.51 0.29 0.28
13 Financial Ratios Debt to Equity 0.02 0.02 0.03 11.28 (10.10) (14.27)
14 Financial Ratios Gearing 24% 28% 27% 92% 112% 108%
15 Financial Ratios Interest Coverage 5.20 1.52 2.53 362.23 202.58 157.52
16 Investment Ratio Earnings per share 28.70 0.01 9.10 4.52 4.03 2.29
17 Investment Ratio Price earning ratio 8.42 465.00 19.10 18.66 20.89 17.24
18 Investment Ratio Dividend Cover ratio 2.19 0.80 1.70 1.12 1.06 0.64
19 Investment Ratio Divident yeild ratio 5.48% 3.20% 3.31% 2.71% 2.76% 3.25%

Charts and Graphs

ROCE
Year 2021 2020 2019
Kingfisher 11% 4% 6%
Home Depot 47% 62% 62%
ROE
Year Kingfisher Home Depot
2021 9.0% 390.0%
2020 0.1% -361.0%
2019 3.1% -592.0%
Capital Turnover
Year 2021 2020 2019
kingfisher 1.42 1.43 1.38
home depot 3.38 4.31 4.38
Gross Margin
Year kingfisher homedepot
2021 37.0% 34.0%
2020 37.0% 34.1%
2019 37.0% 34.3%
Net Margin
Year 2021 2020 2019
kingfisher 4.8% 0.1% 1.7%
home depot 9.7% 10.2% 10.3%
Cost of Sales to Sales
Year 2021 2020 2019
kingfisher 62.95% 63.04% 63.05%
home depot 66.05% 65.91% 65.66%
Inventory Days
Year kingfisher home depot
2021 117 70
2020 125 73
2019 128 72
Trade Receivable Days
Year kingfisher home depot
2021 9 8
2020 9 8
2019 13 7
Trade Payable Days
Year 2021 2020 2019
kingfisher 118 111 120
home depot 49 39 40
Asset Turnover
Year 2021 2020 2019
kingfisher 1.01 0.97 0.94
home depot 1.87 2.15 2.46
Current Ratio
Year Kingfisher Home depot
2021 1.24 1.23
2020 1.10 1.08
2019 1.12 1.11
Quick Ratio
Year kingfisher Home depot
2021 0.46 0.51
2020 0.38 0.29
2019 0.39 0.28
Debt to Equity Ratio
Year Kingfisher Home depot
2021 0.32 10.86
2020 0.38 (9.20)
2019 0.38 (14.27)
Gearing Ratio
Year 2021 2020 2019
Kingfisher 24% 28% 27%
Home Depot 92% 112% 108%
Interest Coverage Ratio
Year Kingfisher Home Depot
2021 5.20 8.54
2020 1.52 10.96
2019 2.53 9.04
EPS
Year 2021 2020 2019
Kingfisher 0.72 0.01 0.27
Home Depot 4.52 4.03 2.29
Price Earning Ratio
Year 2021 2020 2019
Kingfisher 8.42 465.00 19.10
Home Depot 18.66 20.89 17.24
Earnings Per Share
Year 2021 2020 2019
Kingfisher 28.70 0.01 9.10 - 0
Home Depot 4.52 4.03 2.29
Price Earning Ratio
Year 2021 2020 2019
Kingfisher 8.42 4.65 19.10
Home Depot 18.66 20.89 17.24
Dividend Cover Ratio
Year 2021 2020 2019
Kingfisher 2.19 0.80 1.70
Home Depot 1.12 1.06 0.64
Dividend Yeild Ratio
Year 2021 2020 2019
Kingfisher 5.48% 3.20% 3.31%
Home Depot 2.71% 2.76% 3.25%

Return on Equity

2021

Kingfisher Home Depot 0.09 3.9 2020

Kingfisher Home Depot 1E-3 -3.61 2019

Kingfisher Home Depot 3.1E-2 -5.92

Current Ratio

2021

Kingfisher Home depot 1.24 1.23 2020

Kingfisher Home depot 1.1000000000000001 1.08 2019

Kingfisher Home depot 1.1200000000000001 1.1100000000000001

Quick Ratio

2021

kingfisher Home depot 0.46 0.51 2020

kingfisher Home depot 0.38 0.28999999999999998 2019

kingfisher Home depot 0.39 0.28000000000000003

Debt to Equity Ratio

2021

Kingfisher Home depot 0.32 10.86 2020

Kingfisher Home depot 0.38 -9.1999999999999993 2019

Kingfisher Home depot 0.38 -14.27

Gearing Ratio

Kingfisher

2021 2020 2019 0.24 0.28000000000000003 0.27 Home Depot

2021 2020 2019 0.92 1.1200000000000001 1.08

Interest Coverage

2021

Kingfisher Home Depot 5.2 8.5399999999999991 2020

Kingfisher Home Depot 1.52 10.96 2019

Kingfisher Home Depot 2.5299999999999998 9.0399999999999991

EPS

Kingfisher

2021 2020 2019 0.72 0.01 0.27 Home Depot

2021 2020 2019 4.5199999999999996 4.03 2.29

Price Earning Ratio

King fisher

2021 2020 2019 8.42 46 5 19.100000000000001 Home Depot

2021 2020 2019 18.66 20.89 17.239999999999998

Capital Turnover

kingfisher

2021 2020 2019 1.42 1.43 1.38 home depot

2021 2020 2019 3.38 4.3099999999999996 4.38

EPS

Kingfisher

2021 2020 2019 28.7 0.01 9.1 Home Depot

2021 2020 2019 4.5199999999999996 4.03 2.29

PE

Kingfisher

2021 2020 2019 8.42 4.6500000000000004 19.100000000000001 Home Depot

2021 2020 2019 18.66 20.89 17.239999999999998

Return on Capital Employed

Kingfisher

2021 2020 2019 0.11 0.04 0.06 Home Depot

2021 2020 2019 0.47 0.62 0.62

Dividend Cover

Kingfishe r

2021 2020 2019 2.19 0.8 1.7 Home Depot

2021 2020 2019 1.1200000000000001 1.06 0.64

Dividend Yeild

Kingfisher

2021 2020 2019 5.4800000000000001E-2 3.2000000000000001E-2 3.3099999999999997E-2 Home Depot

2021 2020 2019 2.7099999999999999E-2 2.7555620183219429E-2 3.2500000000000001E-2

Gross Margin

2021

kingfisher homedepot 0.37 0.34 2020

kingfisher homedepot 0.37 0.34100000000000003 2019

kingfisher homedepot 0.37 0.34300000000000003

Net Margin

kingfisher

2021 2020 2019 4.8000000000000001E-2 1E-3 1.7000000000000001E-2 home depot

2021 2020 2019 9.7000000000000003E-2 0.10199999999999999 0.10299999999999 999

Cost of Sales to sales

ki ngfisher

2021 2020 2019 0.62949999999999995 0.63039999999999996 0.63049999999999995 home depot

2021 2020 2019 0.66049999999999998 0.65910000000000002 0.65659999999999996

Inventory Days

2021

kingfisher home depot 117 70 2020

kingfisher home depot 125 73 2019

kin gfisher home depot 128 72

Trade Receivable Days

2021

kingfisher home depot 9 8 2020

kingfisher home depot 9 8 2019

kingfisher home depot 13 7

Trade Payable Days

kingf isher

2021 2020 2019 118 111 120 home depot

2021 2020 2019 49 39 40

Asset Turnover

kingfishe r

2021 2020 2019 1.01 0.97 0.94 home depot

2021 2020 2019 1.87 2.15 2.46

Company Valuation

Company Valuation - Book Value and Market Value
USD ($) in Millions USD ($) in Millions USD ($) in Millions
Sr.No Method 2021 2020 2019 Method 2018 2019 2020
Book Value 16,981 18,981 19,299
1 Book Value 657.1 580.2 614.9
Book Value / per share 0.62 0.76 0.93
10% 65.71 58.02 61.49
2 Market Value 777.6 610.9 544
Market Value / per share 54.84 55.35 47.20
10% 77.76 61.09 54.40
3 Market Value > Book Value 1.18 1.05 0.88
Times Times Times
Method 2018 2019 2020
Market Value / per share 47.20 55.35 54.84

Book Value

2018 2019 2020 16981 18981 19299

Market Value / per share

2018 2019 2020 47.2 55.35 54.84

Annual Report Links

Annual Report Kingfisher 2020-2021 https://www.kingfisher.com/content/dam/kingfisher/Corporate/Images/Other/2021/Kingfisher%20plc%202020-21%20Annual%20Report_090421.pdf.downloadasset.pdf
Annual Report Home depot 2020-2021 https://ir.homedepot.com/~/media/Files/H/HomeDepot-IR/2022/2021_AnnualReport_IR_Site_FINAL.pdf