Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

calaculate the following based on the 2022 and 2023 financial analysis provided in the photos attached Current ratio Working capital (not really a ratio) Inventory

calaculate the following based on the 2022 and 2023 financial analysis provided in the photos attached
  1. Current ratio
  2. Working capital (not really a ratio)
  3. Inventory turnover ratio
  4. Accounts Receivable turnover ratio
  5. Debt to total assets ratio
  6. Return on assets
  7. Asset turnover ratio
  8. Return on equity
  9. Gross profit ratio
  10. Profit margin ratio
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|} \hline Consolidated Balance Sheets - USD (\$) \$ in Millions & Jan. 28,2023 & Jan. 29,2022 \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} Current assets \\ Cash and cash equivalents \end{tabular}} \\ \hline \begin{tabular}{l} Cash and cash equivalents \\ Receivables, net \end{tabular} & $1,874 & $2,936 \\ \hline \begin{tabular}{l} Receivables, net \\ Merchandise inventories \end{tabular} & 1,141 & 1,042 \\ \hline \begin{tabular}{l} Merchandise inventories \\ Other current assets \end{tabular} & 5,140 & 5,965 \\ \hline \begin{tabular}{l} Other current assets \\ Total current assets \end{tabular} & 647 & 596 \\ \hline Total current assets & 8,802 & 10,539 \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} Property and equipment \\ Land and buildings \end{tabular}} \\ \hline Land and buildings & 688 & 671 \\ \hline Leasehold improvements & 2,260 & 2,160 \\ \hline Fixtures and equipment & 3,928 & 5,419 \\ \hline Property under finance leases & 100 & 91 \\ \hline Gross property and equipment & 6,976 & 8,341 \\ \hline Less accumulated depreciation & 4,624 & 6,091 \\ \hline Net property and equipment & 2,352 & 2,250 \\ \hline Operating lease assets & 2,746 & 2,654 \\ \hline Goodwill & 1,383 & 1,384 \\ \hline Other assets & 520 & 677 \\ \hline Total assets & 15,803 & 17,504 \\ \hline \multicolumn{3}{|l|}{ Current liabilities } \\ \hline Accounts payable & 5,687 & 6,803 \\ \hline Accrued compensation and related expenses & 405 & 845 \\ \hline Accrued liabilities & 843 & 946 \\ \hline Current portion of operating lease liabilities & 638 & 648 \\ \hline Current portion of long-term debt & 16 & 13 \\ \hline Total current liabilities & 8,979 & 10,674 \\ \hline Long-term operating lease liabilities & 2,164 & 2,061 \\ \hline Long-term liabilities & 705 & 533 \\ \hline Long-term debt & 1,160 & 1,216 \\ \hline \multicolumn{3}{|l|}{ Contingencies and commitments (Note 13) } \\ \hline \multicolumn{3}{|l|}{ Equity } \\ \hline \multicolumn{3}{|l|}{ Preferred stock, $1.00 par value: Authorized - 400,000 shares; Issued and outstanding - none } \\ \hline \begin{tabular}{l} Common stock, $0.10 par value: Authorized - 1.0 billion shares; Issued and outstanding - 218.1 \\ million and 227.4 million shares, respectively \end{tabular} & 22 & 23 \\ \hline Additional paid-in capital & 21 & \\ \hline Retained earnings & 2,430 & 2,668 \\ \hline Accumulated other comprehensive income & 322 & 329 \\ \hline Total equity & 2,795 & 3,020 \\ \hline Total liabilities and equity & 15,803 & 17.504 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Column1 & Column2 & Column3 & Column4 \\ \hline Consolidated Statements of Earnings - USD (\$) shares in Miltions, $ in Millions & \begin{tabular}{l} 12 Months \\ Ended \end{tabular} & & \\ \hline Consolidated Statements of Eaminga fahstrant & Jan. 29,2022 & Jan.30,2021 & Feb. 01, 2020 \\ \hline \multicolumn{4}{|l|}{\begin{tabular}{l} Consolidated Statements of Earnings [Abstract] \\ Revenue \end{tabular}} \\ \hline Revenue & $51,761 & $47,262 & $43,638 \\ \hline \begin{tabular}{l} Cost of sales \\ Gross profit \end{tabular} & 40,121 & 36,689 & 33,590 \\ \hline Gross profit & 11,640 & 10,573 & 10,048 \\ \hline Selling, general and administrative expenses & 8,635 & 7,928 & 7,998 \\ \hline Restructuring charges & (34) & 254 & 41 \\ \hline \begin{tabular}{l} Operating income \\ Other income (expense). \end{tabular} & 3,039 & 2,391 & 2,009 \\ \hline \multicolumn{4}{|l|}{\begin{tabular}{l} Other income (expense): \\ Gain on sale of investments \end{tabular}} \\ \hline Gain on sale of investments & & 1 & 1 \\ \hline \begin{tabular}{l} Investment income and other \\ Interest expense \end{tabular} & 10 & 37 & 47 \\ \hline & (25) & (52) & (64) \\ \hline \begin{tabular}{l} Earnings before income tax expense and equity in income of affiliates \\ Income tax expense \end{tabular} & 3,024 & 2,377 & 1,993 \\ \hline \begin{tabular}{l} Income tax expense \\ Equity in income of affiliates \end{tabular} & 574 & 579 & 452 \\ \hline \begin{tabular}{l} Equity in income of affiliates \\ Net earnings \end{tabular} & 4 & & \\ \hline \begin{tabular}{l} Net earnings \\ Basic earnings per share. \end{tabular} & $2,454 & $1,798 & $1,541 \\ \hline Basic earnings per share & $9.94 & $6.93 & $5.82 \\ \hline \begin{tabular}{l} Diluted earhings per share \\ Weighted-average commen shares outstanding \end{tabular} & $9.84 & 5684 & $5.75 \\ \hline \multicolumn{4}{|l|}{\begin{tabular}{l} Weighted-average commen shares outstanding \\ Basic \end{tabular}} \\ \hline \begin{tabular}{l} Basic \\ Diluted \end{tabular} & 246,8 & 259.6 & 264.9 \\ \hline Diluted & 249.3 & 263 & 268.1 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Consolidated Balance Sheets - USD (\$) \$ in Millions & Jan. 29,2022 & Jan. 30, 2021 \\ \hline \multicolumn{3}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & $2,936 & $5,494 \\ \hline Receivables, net & 1,042 & 1,061 \\ \hline Merchandise inventories & 5,965 & 5,612 \\ \hline Other current assets & 596 & 373 \\ \hline Total current assets & 10,539 & 12,540 \\ \hline \multicolumn{3}{|l|}{ Property and equipment } \\ \hline Land and buildings & 671 & 658 \\ \hline Leasehold improvements & 2,160 & 2,192 \\ \hline Fixtures and equipment & 5,419 & 6,333 \\ \hline Property under finance leases & 91 & 73 \\ \hline Gross property and equipment & 8,341 & 9,256 \\ \hline Less accumulated depreciation & 6,091 & 6,996 \\ \hline Net property and equipment & 2,250 & 2,260 \\ \hline Operating lease assets & 2,654 & 2,612 \\ \hline Goodwill & 1,384 & 986 \\ \hline Other assets & 677 & 669 \\ \hline Total assets & 17,504 & 19,067 \\ \hline \multicolumn{3}{|l|}{ Current liabilities } \\ \hline Accounts payable & 6,803 & 6,979 \\ \hline Accrued compensation and related expenses & 845 & 725 \\ \hline Accrued liabilities & 946 & 972 \\ \hline Short-term debt & & 110 \\ \hline Current portion of operating lease liabilities. & 648 & 693 \\ \hline Current portion of long-term debt & 13 & 14 \\ \hline Total current liabilities & 10,674 & 10,521 \\ \hline Long-term operating lease liabilities & 2,061 & 2,012 \\ \hline Long-term liabilities & 533 & 694 \\ \hline Long-term debt & 1,216 & 1,253 \\ \hline \multicolumn{3}{|l|}{ Contingencies and commitments (Note 13) } \\ \hline \multicolumn{3}{|l|}{ Equity } \\ \hline \multicolumn{3}{|l|}{ Preferred stock, \$1.00 par value: Authorized - 400,000 shares; Issued and outstanding - none } \\ \hline \begin{tabular}{l} Common stock, \$0.10 par value: Authorized - 1.0 billion shares; Issued and outstanding - 227.4 \\ shares and 256.9 shares, respectively \end{tabular} & 23 & 26 \\ \hline \multicolumn{3}{|l|}{ Additional paid-in capital } \\ \hline Retained earnings: & 2,668 & 4,233 \\ \hline Accumulated other comprehensive income & 329 & 328 \\ \hline Total equity & 3,020 & 4,587 \\ \hline Total liabilities and equity & 17,504 & 19,067 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Bev Vickerstaff, Parminder Johal

1st Edition

1444170414, 978-1444170412

More Books

Students also viewed these Accounting questions

Question

Write a Python program to check an input number is prime or not.

Answered: 1 week ago

Question

Identify and describe basic workplace competencies

Answered: 1 week ago

Question

Describe the steps involved in coaching to improve poor performance

Answered: 1 week ago