Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the following Ratios for 2023 and 2022 Current ratio Working capital (not really a ratio) Inventory turnover ratio Accounts Receivable turnover ratio Debt to

Calculate the following Ratios for 2023 and 2022

Current ratio

Working capital (not really a ratio)

Inventory turnover ratio

Accounts Receivable turnover ratio

Debt to total assets ratio

Return on assets

Asset turnover ratio

Return on equity

Gross profit ratio

Profit margin ratio

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed Consolidated Balance Sheets - USD [\$] $ in Millions Jan. 28, 2023 Jan. 29, 2022 Current assets Cash and cash equivalents Receivables, net Merchandise inventories Dther current assets Total current assets $1,874 $2,936 Property and equipment Land and buildings Leasehold improvements Fintures and equipment Property under finance leases Gross property and equipment Less accumulated depreciation Net property and equipment Operating lease assets Goodwill Dther assets Total assets Current liabilities Accounts payable Acorued compensation and related expenses Acorued liabilities Current portion of operating lease liabilities Current portion of long-term debt Total current liabilities Long-term operating lease liabilities Long-term liabilities Long-term debt Contingencies and commitments (Note 13) Equity Preferred stock, \$1.00 par value: Authorized 400,000 shares; Issued and outstanding-none Common stock, $0.10 par value: Authorized - 1 .0 billion shares; Issued and outstanding - 218.1 million and 227.4 million shares, respectively Additional paid-in capital Retained earnings Acoumulated other comprehensive income Total equity Total liabilities and equity Gift Card [Member] Current liabilities Short-term contract liabilities Deferred Revenue [Member] Current liabilities Short-term contract liabilities $1,116 $1,103 \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{ Consolidated Statements of Cash Flows (Parenthetical) - USD (\$\$) \$ in Millions } & \multicolumn{3}{|c|}{12 Months Ended } \\ \hline & Jan. 28,2023 & Jan. 29, 2022 & Jan. 30, 2021 \\ \hline Consolidated Statements of Cash Flows [Abstract] & & & \\ \hline Non-cash capital expenditures & $35 & $46 & $32 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{ Consolidated Statements of Earnings - USD (\$) shares in Millions, \$ in Millions } & \multicolumn{3}{|c|}{12 Months Ended } \\ \hline & Jan. 28,2023 & Jan. 29, 2022 & Jan. 30, 2021 \\ \hline \multicolumn{4}{|l|}{ Consolidated Statements of Earnings [Abstract] } \\ \hline Revenue & $46,298 & $51,761 & $47,262 \\ \hline Cost of sales & 36,386 & 40,121 & 36,689 \\ \hline Gross profit & 9,912 & 11,640 & 10,573 \\ \hline Selling, general and administrative expenses & 7,970 & 8,635 & 7,928 \\ \hline Restructuring charges & 147 & (34) & 254 \\ \hline Operating income & 1,795 & 3,039 & 2,391 \\ \hline \multicolumn{4}{|l|}{ Other income (expense): } \\ \hline Investment income and other & 28 & 10 & 38 \\ \hline Interest expense & (35) & (25) & (52) \\ \hline Earnings before income tax expense and equity in income of affiliates & 1,788 & 3,024 & 2,377 \\ \hline Income tax expense & 370 & 574 & 579 \\ \hline Equity in income of affiliates & 1 & 4 & \\ \hline Net earnings & $1,419 & $2,454 & $1,798 \\ \hline Basic earnings per share & $6.31 & $9.94 & $6.93 \\ \hline Diluted earnings per share & $6.29 & $9.84 & $6.84 \\ \hline \multicolumn{4}{|l|}{ Weighted-average common shares outstanding: } \\ \hline Basic & 224.8 & 246.8 & 259.6 \\ \hline Diluted & 225.7 & 249.3 & 263 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{ Consolidated Statements of Comprehensive Income - USD (\$\$) \$ in Millions } & \multicolumn{3}{|c|}{12 Months Ended } \\ \hline & Jan. 28,2023 & Jan. 29, 2022 & Jan. 30, 2021 \\ \hline \multicolumn{4}{|l|}{ Consolidated Statements of Comprehensive Income [Abstract] } \\ \hline Net earnings & $1,419 & $2,454 & $1,798 \\ \hline Foreign currency translation adjustments, net of tax & (7) & 1 & (4) \\ \hline Cash flow hedges & & & (2) \\ \hline \begin{tabular}{l} Reclassification of cumulative translation adjustments into earnings due to exit of \\ business \end{tabular} & & & 39 \\ \hline Comprehensive income & $1,412 & $2,455 & $1,831 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{ Consolidated Statements of Cash Flows - USD [\$) \$ in Millions } & \multicolumn{3}{|c|}{12 Months Ended } \\ \hline & Jan.28,2023 & Jan.29,2022 & Jan. 30,2021 \\ \hline \multicolumn{4}{|l|}{ Dperating activities } \\ \hline Net earnings & $1,419 & $2,454 & $1,798 \\ \hline \multicolumn{4}{|l|}{ Adjustments to reconcile net earnings to total cash provided by } \\ \hline Depreciation and amortization & 918 & 869 & 839 \\ \hline Restructuring charges & 147 & [34] & 254 \\ \hline Stock-based compensation & 138 & 141 & 135 \\ \hline Deferred income takes & 51 & 14 & (36) \\ \hline Other, net & 12 & 11 & 3 \\ \hline \multicolumn{4}{|l|}{ Changes in operating assets and liabilities, net of acquired assets } \\ \hline Receivables & (103) & 17 & 73 \\ \hline Merchandise inventories & 809 & (328) & (435) \\ \hline Dther assets & (21) & [14] & (51) \\ \hline Acoounts payable & (1,099) & (201) & 1,676 \\ \hline Income tares & 36 & (156) & 173 \\ \hline Other liabilities & (483) & 479 & 498 \\ \hline Total cash provided by operating activities & 1,824 & 3,252 & 4,927 \\ \hline \multicolumn{4}{|l|}{ Investing activities } \\ \hline \begin{tabular}{l} Additions to property and equipment, net of $35,$46 and $32, respectively, of non- \\ cash capital expenditures \end{tabular} & (930) & (737) & (713) \\ \hline Purchases of investments & (46) & (233) & (620) \\ \hline Sales of investments & 7 & 66 & 546 \\ \hline Acquisitions, net of cash acquired & & (468) & \\ \hline Dther, net & 7 & & (1) \\ \hline Total cash used in investing activities & (962) & (1,372) & (788) \\ \hline \multicolumn{4}{|l|}{ Financing activities } \\ \hline Repurchase of common stock & (1,014) & (3,502] & (312) \\ \hline Issuance of common stock & 16 & 29 & 28 \\ \hline Dividends paid & (789) & (688) & (568) \\ \hline Borrowings of debt & & & 1,892 \\ \hline Repayments of debt & (19) & (133) & (1,916) \\ \hline Other, net & & (3) & \\ \hline Total cash used in financing activities & (1,806) & (4,297) & (876) \\ \hline Effect of exchange rate changes on cash & (8) & (3) & 7 \\ \hline Increase (decrease) in cash, cash equivalents and restricted cash & (952) & (2,420) & 3,270 \\ \hline Cash, cash equivalents and restricted cash at beginning of period & 3,205 & 5,625 & 2,355 \\ \hline Cash, cash equivalents and restricted cash at end of period & 2,253 & 3,205 & 5,625 \\ \hline \multicolumn{4}{|l|}{ Supplemental cash flow information } \\ \hline Income tares paid & 283 & 716 & 442 \\ \hline Interest paid & $31 & $22 & $50 \\ \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

Cost Accounting Principles And Applications

Authors: Horace R. Brock

5th Edition

0070081522, 978-0070081529

More Books

Students also viewed these Accounting questions

Question

Have a brief review of human motivation theories

Answered: 1 week ago