Balance Sheet

Income Statement

Please do the ratios for 2023 and show the steps

\begin{tabular}{|c|c|c|c|c|} \hline (millions, except footnotes) & 2022 & 2021 & 2020 & 2019 \\ \hline \multicolumn{5}{|l|}{ Assets } \\ \hline Cash and cash equivalents & 2,229 & 5,911 & 8,511 & 2,577 \\ \hline Inventory & 13,499 & 13,902 & 10,653 & 8,992 \\ \hline Other current assets & 2,118 & 1,760 & 1,592 & 1,333 \\ \hline Total current assets & 17,846 & 21,573 & 20,756 & 12,902 \\ \hline \multicolumn{5}{|l|}{ Property and equipment } \\ \hline Land & 6,231 & 6,164 & 6,141 & 6,036 \\ \hline Buildings and improvements & 34,746 & 32,985 & 31,557 & 30,603 \\ \hline Fixtures and equipment & 7,439 & 6,407 & 5,914 & 6,083 \\ \hline Computer hardware and software & 3,039 & 2,505 & 2,765 & 2,692 \\ \hline Construction-in-progress & 2,688 & 1,257 & 780 & 533 \\ \hline Accumulated depreciation & (22,631) & (21,137) & (20,278) & (19,664) \\ \hline Property and equipment, net & 31,512 & 28,181 & 26,879 & 26,283 \\ \hline Operating lease assets & 2,657 & 2,556 & 2,227 & 2,236 \\ \hline Other noncurrent assets & 1,320 & 1,501 & 1,386 & 1,358 \\ \hline Total assets & 53,335 & 53,811 & 51,248 & 42,779 \\ \hline \multicolumn{5}{|l|}{ Liabilities and shareholders'investment } \\ \hline Accounts payable & 13,487 & 15,478 & 12,859 & 9,920 \\ \hline Accrued and other current liabilities & 5,883 & 6,098 & 6,122 & 4,406 \\ \hline Current portion of long-term debt and other borrowings & 130 & 171 & 1,144 & 161 \\ \hline Total current liabilities & 19,500 & 21,747 & 20,125 & 14,487 \\ \hline Long-term debt and other borrowings & 16,009 & 13,549 & 11,536 & 11,338 \\ \hline Noncurrent operating lease liabilities & 2,638 & 2,493 & 2,218 & 2,275 \\ \hline Deferred income taxes & 2,196 & 1,566 & 990 & 1,122 \\ \hline Other noncurrent liabilities & 1,760 & 1,629 & 1,939 & 1,724 \\ \hline Total noncurrent liabilities & 22,603 & 19,237 & 16,683 & 16,459 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|l|}{ Shareholders'investment } \\ \hline Common stock & 38 & 39 & 42 & 42 \\ \hline Additional paid-in capital & 6,608 & 6,421 & 6,329 & 6,226 \\ \hline Retained earnings & 5,005 & 6,920 & 8,825 & 6,433 \\ \hline Accumulated other comprehensive loss & (419) & (553) & (756) & (868) \\ \hline Total shareholders'investment & 11,232 & 12,827 & 14,440 & 11,833 \\ \hline Total liabilities and shareholders' investment & 53,335 & 53,811 & 51,248 & 42,779 \\ \hline & - & - & - & - \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline (millions, except per share data) & 2022 & 2021 & 2020 \\ \hline Sales & 107,588 & 104,611 & 92,400 \\ \hline Other revenue & 1,532 & 1,394 & 1,161 \\ \hline Total revenue & 109,120 & 106,005 & 93,561 \\ \hline Cost of sales & 82,229 & 74,963 & 66,177 \\ \hline Gross profit & 26,891 & 31,042 & 27,384 \\ \hline Selling, general and administrative expenses & 20,658 & 19,752 & 18,615 \\ \hline Depreciation and a mortization & 2,385 & 2,344 & 2,230 \\ \hline Operating income & 3,848 & 8,946 & 6,539 \\ \hline Net interest expense & 478 & 421 & 977 \\ \hline Net other (income)/ expense & (48) & (382) & 16 \\ \hline Earnings before income taxes & 3,418 & 8,907 & 5,546 \\ \hline Provision for income taxes & 638 & 1,961 & 1,178 \\ \hline Net earnings & 2,780 & 6,946 & 4,368 \\ \hline Basic earnings per share & 6 & 14 & 9 \\ \hline Diluted earnings per share & 6 & 14 & 9 \\ \hline \multicolumn{4}{|l|}{ Weighted average common shares outstanding } \\ \hline Basic & 462 & 488 & 501 \\ \hline Diluted & 465 & 493 & 505 \\ \hline Antidilutive shares & 1 & - & - \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & 2020 & 2021 & 2022 & 2023 \\ \hline \multicolumn{5}{|l|}{ LIQUIDITY RATIOS } \\ \hline Current ratio & 1.03 & 0.99 & & \\ \hline Acid test (or quick ratio) & 0.42 & 0.27 & & \\ \hline \multicolumn{5}{|l|}{ SOLVENCY RATIOS } \\ \hline Debt to equity ratio & 2.55 & 3.20 & & \\ \hline Times interest earned ratio & 6.68 & 22.16 & & \\ \hline \multicolumn{5}{|l|}{ PROFITABILITY RATIOS } \\ \hline Return on assets (\%) & 9.29% & 13.22% & & \\ \hline Return on equity (\%) & 33.25% & 50.95% & & \\ \hline \end{tabular}