Three Months Ended \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Current Earnings } & \multicolumn{3}{|c|}{ May 5, 2023} & \multicolumn{3}{|c|}{ April 29,2022 } \\ \hline & \multicolumn{2}{|c|}{ Amount } & \multirow{2}{*}{100.00%Sales} & \multicolumn{2}{|c|}{ Amount } & \multirow{2}{*}{100.00%Sales} \\ \hline Net sales & $ & 22,347 & & \$ & 23,659 & \\ \hline Cost of sales & & 14,820 & 66.32 & & 15,609 & 65.97 \\ \hline Gross margin & & 7,527 & 33.68 & & 8,050 & 34.03 \\ \hline \multicolumn{7}{|l|}{ Expenses: } \\ \hline Selling general and administrative & & 3.824 & 17.12 & & 4,303 & 18.19 \\ \hline Depreciation and amortiation & & 415 & 185 & & 445 & 1.88 \\ \hline Operating iscome & & 3.288 & 14.71 & & 3,302 & 13.96 \\ \hline laterest - net & & 349 & 156 & & 243 & 1.03 \\ \hline Pre-tax earning & & 2,939 & 13.15 & & 3,059 & 12.93 \\ \hline Income taxprovision & & 679 & 3.04 & & 726 & 3.07 \\ \hline Net earning: & s. & 2,260 & 10.11 & s & 2.333 & 9.86 \\ \hline Weighted average coamon stares outstanding - basic & & 396 & & & 660 & \\ \hline Basic earnings per cominoa share (?) & s. & 3.78 & & s & 3.52 & \\ \hline Weighted average common shares outstanding-diloted & & & & & 662 & \\ \hline Diluted earniegs per common stare it & s & 3.77 & & s & 3.51 & \\ \hline Cash dividends per share & s & 1.05 & & s. & 0.80 & \\ \hline \multicolumn{7}{|l|}{ Accumulated Deficit } \\ \hline Balance at beginaing of period & (5) & (14,862) & & s & (5,115) & \\ \hline Net carbing: & & 2,260 & & & 2,333 & \\ \hline Cash dividends declaned & & (624) & & & (524) & \\ \hline Share tepurctias & & & & & (4,061) & \\ \hline Balance at end of period & $ & (15,310) & & s & (7,367) & \\ \hline \end{tabular} May 5, 2023 April 29, 2022 \begin{tabular}{|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Assets } & & \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Current assets: } \\ \hline Cash and cash equivalents & $ & 2,950 & s & 3,414 \\ \hline Short-term investments & & 423 & & 368 \\ \hline Merchandise inventory - net & & 19,522 & & 20,239 \\ \hline Other current assets & & 1,023 & & 1,590 \\ \hline Total current assets & & 23,918 & & 25,611 \\ \hline Property, less accumulated depreciation & & 17,402 & & 18,890 \\ \hline Operating loase right-of-use assets & ff & 3,504 & & 4,131 \\ \hline Long-lerm investments & & 103 & & 76 \\ \hline Deferred income taxes-net & (f) & 150 & & 33 \\ \hline Other assets & & 840 & 14 & 984 \\ \hline Total assets & S & 45.917 & s & 49,725 \\ \hline \multicolumn{5}{|l|}{ Liabilities and shareholders' deficit } \\ \hline \multicolumn{5}{|l|}{ Current liabilities: } \\ \hline Short-term bortowings & s & 72 & $ & 3 \\ \hline Curfent maturites of hong-7em debe & & 589 & & 121 \\ \hline Current operating lease liabilities: & & 525 & & 639 \\ \hline Accounts paysble & & 11,85 & & 13,831 \\ \hline Acented cornpensation and eaployev beneffits. & & 766 & & 1,190 \\ \hline Defaried revonue & & 1.645 & & 2,094 \\ \hline Incume taxes paysble & & 526 & & 741 \\ \hline Other current liabilities & & 3,202 & & 3,215 \\ \hline Total currest liabilities & & 19,210 & & 21,831 \\ \hline Long-term debe, excluding current matusioes & & 35,863 & & 28,776 \\ \hline Noncunctit operating lcase liabilities & & 33 & & 4,061 \\ \hline Deferred revenue - Lowe's protectoon plane & & 1,206 & & 1,137 \\ \hline Other liabilities & & & & \\ \hline Total liabilities & & 60,627 & & 56,602 \\ \hline \end{tabular} Noncurrent operating lesise liabilities Deferred revenue - Lowe's protection plans Other liabilities Total liabilities Sbareholders' deficit: none Common stock, 50 so par value: Authorized 5,6 billion shares, isucd and outstanding $92 miltion and 652 million, respectively Accumalated deficit Accumulated other comprehensive income Total shareholders'deficit Total tiabitities and shareholders' deficit 3. VerticalAnalysis: Prepare a common-size Balance Sheet and Income Statement for your company in an Excel Spreadsheet. All accounts are a percentage of Total Assets or Net Income
