Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started