question is below:
In the ratio analysis sheet, calculate financial ratios for Walmart (as target company) & Target (as peer) for the latest 5 years. The ratios are grouped into four categories:
- Profitability Ratios: Gross Margin, Profit Margin, ROA, ROE
- Liquidity and Efficiency Ratios: Current Ratio, Quick Ratio, A/R turnover, Inventory turnover, Total Assets Turnover
- Solvency Ratios: Debt to Equity Ratio, Times Interest Earned
- Market Oriented Ratios: Price-Earnings Ratio, Dividend Yield
- In the ratio analysis sheet, calculate financial ratios for Walmart (as target company) & Target (as peer) for the latest 5 years. The ratios are grouped into four categories:
- Profitability Ratios: Gross Margin, Profit Margin, ROA, ROE
- Liquidity and Efficiency Ratios: Current Ratio, Quick Ratio, A/R turnover, Inventory turnover, Total Assets Turnover
- Solvency Ratios: Debt to Equity Ratio, Times Interest Earned
- Market Oriented Ratios: Price-Earnings Ratio, Dividend Yield
Walmart Inc. Consolidated Statements of Cash Flows Y 2022 Y 2021 Y 2020 Y 2019 Y 2018 Y 2017 2022-01-31 2021-01-31 2020-01-31 2019-01-31 2018-01-31 2017-01-31 Cash flows from operating activities: Consolidated net income $13,940,000,000 $13,706,000,000 $15,201,000,000 $7,179,000,000 $10,523,000,000 $14,293,000,000 Adjustments to reconcile consolidated net income to net cash provided by operating activities: Depreciation and amortization $10,658,000,000 $11,152,000,000 $10,987,000,000 $10,678,000,000 $10,529,000,000 $10,080,000,000 Net unrealized and realized (gains) and losses $2,440,000,000 ($8,589,000,000) ($1,886,000,000) $3,516,000,000 Losses on disposal of business operations $433,000,000 $8,401,000,000 $15,000,000 $4,850,000,000 Asda pension contribution ($1,036,000,000) Deferred income taxes ($755,000,000) $1,911,000,000 $320,000,000 ($499,000,000) ($304,000,000) $761,000,000 Loss on extinguishment of debt $2,410,000,000 $3,136,000,000 Other operating activities $1,652,000,000 $1,521,000,000 $1,981,000,000 $1,734,000,000 $1,210,000,000 $206,000,000 Changes in certain assets and liabilities, net of effects of acquisitions and dispositions: Receivables, net ($1,796,000,000) ($1,086,000,000) $154,000,000 ($368,000,000) ($1,074,000,000) ($402,000,000 Inventories ($11,764,000,000) ($2,395,000,000) ($300,000,000) ($1,311,000,000) ($140,000,000) $1,021,000,000 Accounts payable $5,520,000,000 $6,966,000,000 ($274,000,000) $1,831,000,000 $4,086,000,000 $3,942,000,000 Accrued liabilities $1,404,000,000 $4,623,000,000 $186,000,000 $183,000,000 $928,000,000 $1,280,000,000 Accrued income taxes $39,000,000 ($136,000,000) $93,000,000) ($40,000,000) ($557,000,000) $492,000,000 Net cash provided by operating activities $24,181,000,000 $36,074,000,000 $25,255,000,000 $27,753,000,000 $28,337,000,000 $31,673,000,000 Cash flows from investing activities: Payments for property and equipment ($13,106,000,000) ($10,264,000,000) ($10,705,000,000) ($10,344,000,000) ($10,051,000,000) ($10,619,000,000) Proceeds from the disposal of property and equipment $394,000,000 $215,000,000 $321,000,000 $519,000,000 $378,000,000 $456,000,000 Proceeds from the disposal of certain operations $7,935,000,000 $56,000,000 $833,000,000 $876,000,000 $1,046,000,000 $662,000,000 Purchase of available for sale securities ($1,901,000,000) Payments for business acquisitions, net of cash acquired ($359,000,000) ($180,000,000) ($56,000,000) ($14,656,000,000) ($375,000,000) ($2,463,000,000) B D F G Y 2017 Y 2022 2022-01-29 Y 2021 2021-01-30 $8.72 E Y 2019 2019-02-02 $5.54 $0.01 $5.55 Y 2020 2020-02-01 $6.39 $0.02 $6.42 $14.23 Y 2018 2018-02-03 $5.32 $0.01 $5.32 2017-01-28 $4.61 $0.12 $4.73 $14.23 $8.72 A Target Corp Consolidated Statements of Income Continuing operations (in dollars per share) Discontinued operations (in dollars per share) Net earnings per share (in dollars per share) Diluted earnings per share Continuing operations (in dollars per share) Discontinued operations (in dollars per share) Net earnings per share (in dollars per share) Weighted average common shares outstanding Basic (in shares) Diluted (in shares) Antidilutive shares (in shares) $14.10 $8.64 $6.34 $0.02 $6.36 $5.50 $0.01 $5.51 $5.29 $0.01 $5.29 $4.58 $0.12 $4.69 $14.10 $8.64 488,100,000 492,700,000 500,600,000 505,400,000 510,900,000 515,600,000 528,600,000 533,200,000 546,800,000 550,300,000 4,100,000 577,600,000 582,500,000 100,000 H 8 Total H6 XV fx A B D E F G 1 Target Corp Y 2022 Y 2021 Y 2020 Y 2019 Y 2018 Y 2017 2 Consolidated Balance Sheets 2022-01-29 2021-01-30 2020-02-01 2019-02-02 2018-02-03 2017-01-28 Land $6,164,000,000 $6,141,000,000 $6,036,000,000 $6,064,000,000 $6,095,000,000 $6,106,000,000 0 Buildings and improvements $32,985,000,000 $31,557,000,000 $30,603,000,000 $29,240,000,000 $28,131,000,000 $27,611,000,000 1 Fixtures and equipment $6,407,000,000 $5,914,000,000 $6,083,000,000 $5,912,000,000 $5,623,000,000 $5,503,000,000 2 Computer hardware and software $2,505,000,000 $2,765,000,000 $2,692,000,000 $2,544,000,000 $2,645,000,000 $2,651,000,000 3 Construction-in-progress $1,257,000,000 $780,000,000 $533,000,000 $460,000,000 $440,000,000 $200,000,000 4 4 Accumulated depreciation ($21,137,000,000) ($20,278,000,000) ($19,664,000,000) ($18,687,000,000) ($18,398,000,000) ($17,413,000,000) 5 Property and equipment, net $28,181,000,000 $26,879,000,000 $26,283,000,000 $25,533,000,000 $24,536,000,000 $24,658,000,000 6 Operating lease assets $2,556,000,000 $2,227,000,000 $2,236,000,000 $1,965,000,000 $1,884,000,000 7 Other noncurrent assets $1,501,000,000 $1,386,000,000 $1,358,000,000 $1,273,000,000 $1,343,000,000 $783,000,000 Total assets $53,811,000,000 $51,248,000,000 $42,779,000,000 $41,290,000,000 $40,303,000,000 $37,431,000,000 9 Liabilities and shareholders' investment 0 Accounts payable $15,478,000,000 $12,859,000,000 $9,920,000,000 $9,761,000,000 $8,677,000,000 $7,252,000,000 1 Accrued and other current liabilities $6,098,000,000 $6,122,000,000 $4,406,000,000 $4,201,000,000 $4,094,000,000 $3,737,000,000 2 Current portion of long-term debt and other borrowings $171,000,000 $1,144,000,000 $ 161,000,000 $1,052,000,000 $281,000,000 $1,718,000,000 3 Total current liabilities $21,747,000,000 $20,125,000,000 $14,487,000,000 $15,014,000,000 $13,052,000,000 $12,707,000,000 4 Long-term debt and other borrowings $13,549,000,000 $11,536,000,000 $11,338,000,000 $10,223,000,000 $11,117,000,000 $11,031,000,000 5 Noncurrent operating lease liabilities $2,493,000,000 $2,218,000,000 $2,275,000,000 $2,004,000,000 $1,924,000,000 6 Deferred income taxes $1,566,000,000 $990,000,000 $1,122,000,000 $972,000,000 $693,000,000 $861,000,000 7 Other noncurrent liabilities $1,629,000,000 $1,939,000,000 $1,724,000,000 $1,780,000,000 $1,866,000,000 $1,879,000,000 8 Total noncurrent liabilities wa $19,237,000,000 $16,683,000,000 $16,459,000,000 $14,979,000,000 $15,600,000,000 $13,771,000,000 9 Shareholders' investment -U 0 Common stock $39,000,000 $42,000,000 $42,000,000 $43,000,000 $45,000,000 $46,000,000 1 Additional paid-in capital $6,421,000,000 $6,329,000,000 $6,226,000,000 $6,042,000,000 $5,858,000,000 $5,661,000,000 2 Retained earnings $6,920,000,000 $8,825,000,000 $6,433,000,000 $6,017,000,000 $6,495,000,000 $5,884,000,000 3 Accumulated other comprehensive loss ($553,000,000) $756,000,000) ($868,000,000) ($805,000,000) ( $747,000,000) ($638,000,000) -4 Total shareholders' investment $12,827,000,000 $14,440,000,000 $11,833,000,000 $11,297,000,000 $11,651,000,000 $10,915,000,000 5 Total liabilities and shareholders' investment $53,811,000,000 $51,248,000,000 $42,779,000,000 $41,290,000,000 $40,303,000,000 $37,431,000,000 6 6 =7 8 9 A B D E F G H K L M Walmart Profitability Ratios Y 2021 Y 2020 J Target Profitability Ratios Y 2021 2 B Y 2022 Y 2019 Y 2018 Y 2022 Y 2020 Y 2019 Y 2018 1 5 5 Gross Margin Profit Margin ROA Gross Margin Profit Margin ROA ROE 7 ROE B Liquidity and Efficiency Ratios Y 2022 Y 2021 Y 2020 Liquidity and Efficiency Ratios Y 2022 Y 2021 Y 2020 Y 2019 Y 2018 Y 2019 Y 2018 2 0 1 2 3 Current Ratio Quick Ratio A/R Turnover Inventory Turnover Total Asset Turnover Current Ratio Quick Ratio A/R Turnover Inventory Turnover Total Asset Turnover 4. Profitability Ratios Y 2021 Y 2020 Profitability Ratios Y 2021 6 Y 2022 Y 2019 Y 2018 Y 2022 Y 2020 Y 2019 Y 2018 7 Debt to Equity Ratio Times Interest Earned Debt to Equity Ratio Times Interest Earned 8 9 Profitability Ratios Y 2021 Y 2020 Profitability Ratios Y 2021 0 Y 2022 Y 2019 Y 2018 Y 2022 Y 2020 Y 2019 Y 2018 1 Price-Earnings Ratio L2 Dividends Yield 3 Price at Fiscal Year End Price-Earnings Ratio Dividends Yield Price at Fiscal Year End A Walmart Inc. Consolidated Statements of Cash Flows Y 2022 Y 2021 Y 2020 Y 2019 Y 2018 Y 2017 2022-01-31 2021-01-31 2020-01-31 2019-01-31 2018-01-31 2017-01-31 Cash flows from operating activities: Consolidated net income $13,940,000,000 $13,706,000,000 $15,201,000,000 $7,179,000,000 $10,523,000,000 $14,293,000,000 Adjustments to reconcile consolidated net income to net cash provided by operating activities: Depreciation and amortization $10,658,000,000 $11,152,000,000 $10,987,000,000 $10,678,000,000 $10,529,000,000 $10,080,000,000 Net unrealized and realized (gains) and losses $2,440,000,000 ($8,589,000,000) ($1,886,000,000) $3,516,000,000 Losses on disposal of business operations $433,000,000 $8,401,000,000 $15,000,000 $4,850,000,000 Asda pension contribution ($1,036,000,000) Deferred income taxes ($755,000,000) $1,911,000,000 $320,000,000 ($499,000,000) ($304,000,000) $761,000,000 Loss on extinguishment of debt $2,410,000,000 $3,136,000,000 Other operating activities $1,652,000,000 $1,521,000,000 $1,981,000,000 $1,734,000,000 $1,210,000,000 $206,000,000 Changes in certain assets and liabilities, net of effects of acquisitions and dispositions: Receivables, net ($1,796,000,000) ($1,086,000,000) $154,000,000 ($368,000,000) ($1,074,000,000) ($402,000,000 Inventories ($11,764,000,000) ($2,395,000,000) ($300,000,000) ($1,311,000,000) ($140,000,000) $1,021,000,000 Accounts payable $5,520,000,000 $6,966,000,000 ($274,000,000) $1,831,000,000 $4,086,000,000 $3,942,000,000 Accrued liabilities $1,404,000,000 $4,623,000,000 $186,000,000 $183,000,000 $928,000,000 $1,280,000,000 Accrued income taxes $39,000,000 ($136,000,000) $93,000,000) ($40,000,000) ($557,000,000) $492,000,000 Net cash provided by operating activities $24,181,000,000 $36,074,000,000 $25,255,000,000 $27,753,000,000 $28,337,000,000 $31,673,000,000 Cash flows from investing activities: Payments for property and equipment ($13,106,000,000) ($10,264,000,000) ($10,705,000,000) ($10,344,000,000) ($10,051,000,000) ($10,619,000,000) Proceeds from the disposal of property and equipment $394,000,000 $215,000,000 $321,000,000 $519,000,000 $378,000,000 $456,000,000 Proceeds from the disposal of certain operations $7,935,000,000 $56,000,000 $833,000,000 $876,000,000 $1,046,000,000 $662,000,000 Purchase of available for sale securities ($1,901,000,000) Payments for business acquisitions, net of cash acquired ($359,000,000) ($180,000,000) ($56,000,000) ($14,656,000,000) ($375,000,000) ($2,463,000,000) B D F G Y 2017 Y 2022 2022-01-29 Y 2021 2021-01-30 $8.72 E Y 2019 2019-02-02 $5.54 $0.01 $5.55 Y 2020 2020-02-01 $6.39 $0.02 $6.42 $14.23 Y 2018 2018-02-03 $5.32 $0.01 $5.32 2017-01-28 $4.61 $0.12 $4.73 $14.23 $8.72 A Target Corp Consolidated Statements of Income Continuing operations (in dollars per share) Discontinued operations (in dollars per share) Net earnings per share (in dollars per share) Diluted earnings per share Continuing operations (in dollars per share) Discontinued operations (in dollars per share) Net earnings per share (in dollars per share) Weighted average common shares outstanding Basic (in shares) Diluted (in shares) Antidilutive shares (in shares) $14.10 $8.64 $6.34 $0.02 $6.36 $5.50 $0.01 $5.51 $5.29 $0.01 $5.29 $4.58 $0.12 $4.69 $14.10 $8.64 488,100,000 492,700,000 500,600,000 505,400,000 510,900,000 515,600,000 528,600,000 533,200,000 546,800,000 550,300,000 4,100,000 577,600,000 582,500,000 100,000 H 8 Total H6 XV fx A B D E F G 1 Target Corp Y 2022 Y 2021 Y 2020 Y 2019 Y 2018 Y 2017 2 Consolidated Balance Sheets 2022-01-29 2021-01-30 2020-02-01 2019-02-02 2018-02-03 2017-01-28 Land $6,164,000,000 $6,141,000,000 $6,036,000,000 $6,064,000,000 $6,095,000,000 $6,106,000,000 0 Buildings and improvements $32,985,000,000 $31,557,000,000 $30,603,000,000 $29,240,000,000 $28,131,000,000 $27,611,000,000 1 Fixtures and equipment $6,407,000,000 $5,914,000,000 $6,083,000,000 $5,912,000,000 $5,623,000,000 $5,503,000,000 2 Computer hardware and software $2,505,000,000 $2,765,000,000 $2,692,000,000 $2,544,000,000 $2,645,000,000 $2,651,000,000 3 Construction-in-progress $1,257,000,000 $780,000,000 $533,000,000 $460,000,000 $440,000,000 $200,000,000 4 4 Accumulated depreciation ($21,137,000,000) ($20,278,000,000) ($19,664,000,000) ($18,687,000,000) ($18,398,000,000) ($17,413,000,000) 5 Property and equipment, net $28,181,000,000 $26,879,000,000 $26,283,000,000 $25,533,000,000 $24,536,000,000 $24,658,000,000 6 Operating lease assets $2,556,000,000 $2,227,000,000 $2,236,000,000 $1,965,000,000 $1,884,000,000 7 Other noncurrent assets $1,501,000,000 $1,386,000,000 $1,358,000,000 $1,273,000,000 $1,343,000,000 $783,000,000 Total assets $53,811,000,000 $51,248,000,000 $42,779,000,000 $41,290,000,000 $40,303,000,000 $37,431,000,000 9 Liabilities and shareholders' investment 0 Accounts payable $15,478,000,000 $12,859,000,000 $9,920,000,000 $9,761,000,000 $8,677,000,000 $7,252,000,000 1 Accrued and other current liabilities $6,098,000,000 $6,122,000,000 $4,406,000,000 $4,201,000,000 $4,094,000,000 $3,737,000,000 2 Current portion of long-term debt and other borrowings $171,000,000 $1,144,000,000 $ 161,000,000 $1,052,000,000 $281,000,000 $1,718,000,000 3 Total current liabilities $21,747,000,000 $20,125,000,000 $14,487,000,000 $15,014,000,000 $13,052,000,000 $12,707,000,000 4 Long-term debt and other borrowings $13,549,000,000 $11,536,000,000 $11,338,000,000 $10,223,000,000 $11,117,000,000 $11,031,000,000 5 Noncurrent operating lease liabilities $2,493,000,000 $2,218,000,000 $2,275,000,000 $2,004,000,000 $1,924,000,000 6 Deferred income taxes $1,566,000,000 $990,000,000 $1,122,000,000 $972,000,000 $693,000,000 $861,000,000 7 Other noncurrent liabilities $1,629,000,000 $1,939,000,000 $1,724,000,000 $1,780,000,000 $1,866,000,000 $1,879,000,000 8 Total noncurrent liabilities wa $19,237,000,000 $16,683,000,000 $16,459,000,000 $14,979,000,000 $15,600,000,000 $13,771,000,000 9 Shareholders' investment -U 0 Common stock $39,000,000 $42,000,000 $42,000,000 $43,000,000 $45,000,000 $46,000,000 1 Additional paid-in capital $6,421,000,000 $6,329,000,000 $6,226,000,000 $6,042,000,000 $5,858,000,000 $5,661,000,000 2 Retained earnings $6,920,000,000 $8,825,000,000 $6,433,000,000 $6,017,000,000 $6,495,000,000 $5,884,000,000 3 Accumulated other comprehensive loss ($553,000,000) $756,000,000) ($868,000,000) ($805,000,000) ( $747,000,000) ($638,000,000) -4 Total shareholders' investment $12,827,000,000 $14,440,000,000 $11,833,000,000 $11,297,000,000 $11,651,000,000 $10,915,000,000 5 Total liabilities and shareholders' investment $53,811,000,000 $51,248,000,000 $42,779,000,000 $41,290,000,000 $40,303,000,000 $37,431,000,000 6 6 =7 8 9 A B D E F G H K L M Walmart Profitability Ratios Y 2021 Y 2020 J Target Profitability Ratios Y 2021 2 B Y 2022 Y 2019 Y 2018 Y 2022 Y 2020 Y 2019 Y 2018 1 5 5 Gross Margin Profit Margin ROA Gross Margin Profit Margin ROA ROE 7 ROE B Liquidity and Efficiency Ratios Y 2022 Y 2021 Y 2020 Liquidity and Efficiency Ratios Y 2022 Y 2021 Y 2020 Y 2019 Y 2018 Y 2019 Y 2018 2 0 1 2 3 Current Ratio Quick Ratio A/R Turnover Inventory Turnover Total Asset Turnover Current Ratio Quick Ratio A/R Turnover Inventory Turnover Total Asset Turnover 4. Profitability Ratios Y 2021 Y 2020 Profitability Ratios Y 2021 6 Y 2022 Y 2019 Y 2018 Y 2022 Y 2020 Y 2019 Y 2018 7 Debt to Equity Ratio Times Interest Earned Debt to Equity Ratio Times Interest Earned 8 9 Profitability Ratios Y 2021 Y 2020 Profitability Ratios Y 2021 0 Y 2022 Y 2019 Y 2018 Y 2022 Y 2020 Y 2019 Y 2018 1 Price-Earnings Ratio L2 Dividends Yield 3 Price at Fiscal Year End Price-Earnings Ratio Dividends Yield Price at Fiscal Year End A
