help pls!

From the Iable of Contents, select Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 38). *Fiscal 2022 is the same as Fiscal year ended January 29, 2023. Home Depot's statement uses "Fiscal 2022", and Lowe's statement uses "Fiscal year ended February 2023"; these mean the same thing. Wr Write down the Oneratine Income Write dowen the Conealidated Net Income Fored Cortects THE MOME DEPOT, INC. CONSOLIOATED STATEMENTS OF EARNNGS Net sales Cost of sales Gross profe Operating expenses: Selling general and adminiatrative Cepreciation and amortzation Total operating expenses Operating incones Operating incone Intevest and other (income) expense. interest income and other, net Inberest expense Interest and offer, net. Earnings befoce provision for income taxes Provision bor inoome taxes Net eaminge Aatic weighted average common shares Banic earnings per share Diuted weightod average common shaves Diuled eamings per share. \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{\begin{tabular}{c} Niscal \\ sozz \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} nucal \\ 20021 \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} Facat \\ 2020 \end{tabular}} \\ \hlines & 157.403 & s & 151,157 & 5 & 132.110 \\ \hline & 104,625 & & 100.325 & & 87,257 \\ \hline & 52,778 & & 50832 & & 44.853 \\ \hline & 26,234 & & 25.406 & & 24,447 \\ \hline & 2.455 & & 2306 & & 2,128 \\ \hline & 26.739 & & 27.782 & & 26.575 \\ \hline & 24,039 & & 23040 & & 18.278 \\ \hline & (55) & & (44) & & (47) \\ \hline & 1,617 & & 1347 & & 1,347 \\ \hline & 1.562 & & 1.303 & & 1,300 \\ \hline & 22,477 & & 21,737 & & 16.97s \\ \hline & 5.372 & & \begin{tabular}{r} 5.304 \\ \end{tabular} & & 4,112 \\ \hline$ & 17.106 & $ & 16.433 & 5 & 12.866 \\ \hline & 1.002 & & 1.054 & & 1,074 \\ \hline 5 & 16.74 & $ & 15.59 & 5 & 11.98 \\ \hline & 1,005 & & 1.068 & & 1,078 \\ \hline 5 & 16.69 & s & 15.53 & 5 & 1194 \\ \hline \end{tabular} 37 teans Lene's Casapanirs Inc. Canelidatrel Statemrat ef Earniag \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{ Currve I.arning: } & \multicolumn{9}{|c|}{ Fieral Yiers Eaded } \\ \hline & \multicolumn{3}{|c|}{ Fehreary 3, 203} & \multicolumn{3}{|c|}{ Jahear 28.262} & \multicolumn{3}{|c|}{ January 29.2021 } \\ \hline & \multicolumn{2}{|c|}{ Ameant } & SSales & \multicolumn{2}{|c|}{ Anoent } & \%Sales & \multicolumn{2}{|c|}{ Amatunt } & \multirow{2}{*}{100.00%8salk4} \\ \hline Net vales & 5 & noss & 160.00% & 5 & w.25 & 1000% & 5 & m.sv & \\ \hline Cest of sales & & 4sin2 & 4h.77 & & 64.194 & 6670 & & 60025 & 66.99 \\ \hline Cren wargis & & 32.257 & 312s & & 12.056 & ista & & 20,572 & 31.91 \\ \hline \multicolumn{10}{|l|}{ Fxprnace: } \\ \hline Selling, pesenal and adrinitrative & & 20312 & 2004 & & x>01 & 10.01 & & 18,526 & 20.68 \\ \hline Depeociatice and anertiration & & 1.764 & 1.82 & & 1,602 & 1.23 & & 1,399 & 156 \\ \hline Oprratiag incene & & lease & I8.47 & & & ines & & 9,47 & 10.77 \\ \hline laterent- net & & 1.123 & 1.16 & & kss & 0.92 & & s4s & 0.94 \\ \hline & & & & & 31 & - & & 1.060 & 1.4 \\ \hline Fre-4as earaines & & 9.336 & 9.31 & & 11. das & 11.64 & & 7,739 & \\ \hline lacome tas provient & & 2504 & 264 & & 2.74 & 287 & & 1,506 & 2.13 \\ \hline Set caraing: & 5 & e.tst & 6.61% & 3 & 8,442 & 8.79 & s & sxis & \\ \hline Hasic earaines per camenen tharr & 5 & 10.20 & & 5 & 12.97 & & s & & \\ \hline Biluted earainge per comenen shars & 5 & 1a.17 & & & 1204 & & s & & \\ \hline \end{tabular} Lene's Cesapanins, Iac. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & & 300 & 032 & & 100 & a.11 & & & (000) \\ \hline \end{tabular} chen 35 Open an Excel Spreadsheet. Type the Revenues for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Revenues and Lowe's Companies Ine revenues respectively. Make a simple line chart for each. Title the line charts as Home Depot Inc and Lowe's Companies Inc revenues respectively. Next, type the Operating Income for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Operating Income and Lowe's Companies Inc Operating Income respectively. Make a simple line chart for each. Title the line charts as Home Depot Inc and Lowe's Companies Inc Operating Income respectively. Next, type the Net Income for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Net Income and Lowe's Companies Inc Net Income respectively. Make a simple line chart for each. Title them as Home Depot Inc and Lowe's Companies Inc Net Income respectively. Once all six-line charts are ready, write down a brief analysis on Home Depot Inc's revenue, operating income and net income trends. Next, write down a brief analysis on Lowe's Companies Inc's revenue, operating income and net income trends. Contrast the two. There is no one correct answer. Is there any indication that the current disruptions to global supply chain had an impact on the bottom-line of Home Depot or Lowe's? Substantiate your answer. Research this by using recent news discussion on the internet. Fill in your brief response in the worksheet, keep it ready and then type it in the Canvas assessment when you take it. HORIZONTAL ANALYSIS Horizontal analysis is also known as trend analysis. By looking at recent trends, and also taking into disclosures and press releases from the company and outside the company, the financial markets often try to predict the future stock prices. In the next few steps, do a simple 3-year trend analysis. Go to Home Depot Inc and Lowe's Companies Inc 10-K for 2022 and open Consolidated Income Statements. (Click the link below and download the 202210K ) Home Depot Ine 10-K: (For the fiscal year ended January 29, 2023) From the Table of Contents, seleet Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 37). Lowe's Companies Inc 10-K: (For the fiscal year ended February 3, 2023) From the Table of Contents, select Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 38). From the Iable of Contents, select Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 38). *Fiscal 2022 is the same as Fiscal year ended January 29, 2023. Home Depot's statement uses "Fiscal 2022", and Lowe's statement uses "Fiscal year ended February 2023"; these mean the same thing. Wr Write down the Oneratine Income Write dowen the Conealidated Net Income Fored Cortects THE MOME DEPOT, INC. CONSOLIOATED STATEMENTS OF EARNNGS Net sales Cost of sales Gross profe Operating expenses: Selling general and adminiatrative Cepreciation and amortzation Total operating expenses Operating incones Operating incone Intevest and other (income) expense. interest income and other, net Inberest expense Interest and offer, net. Earnings befoce provision for income taxes Provision bor inoome taxes Net eaminge Aatic weighted average common shares Banic earnings per share Diuted weightod average common shaves Diuled eamings per share. \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{\begin{tabular}{c} Niscal \\ sozz \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} nucal \\ 20021 \end{tabular}} & \multicolumn{2}{|c|}{\begin{tabular}{c} Facat \\ 2020 \end{tabular}} \\ \hlines & 157.403 & s & 151,157 & 5 & 132.110 \\ \hline & 104,625 & & 100.325 & & 87,257 \\ \hline & 52,778 & & 50832 & & 44.853 \\ \hline & 26,234 & & 25.406 & & 24,447 \\ \hline & 2.455 & & 2306 & & 2,128 \\ \hline & 26.739 & & 27.782 & & 26.575 \\ \hline & 24,039 & & 23040 & & 18.278 \\ \hline & (55) & & (44) & & (47) \\ \hline & 1,617 & & 1347 & & 1,347 \\ \hline & 1.562 & & 1.303 & & 1,300 \\ \hline & 22,477 & & 21,737 & & 16.97s \\ \hline & 5.372 & & \begin{tabular}{r} 5.304 \\ \end{tabular} & & 4,112 \\ \hline$ & 17.106 & $ & 16.433 & 5 & 12.866 \\ \hline & 1.002 & & 1.054 & & 1,074 \\ \hline 5 & 16.74 & $ & 15.59 & 5 & 11.98 \\ \hline & 1,005 & & 1.068 & & 1,078 \\ \hline 5 & 16.69 & s & 15.53 & 5 & 1194 \\ \hline \end{tabular} 37 teans Lene's Casapanirs Inc. Canelidatrel Statemrat ef Earniag \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{ Currve I.arning: } & \multicolumn{9}{|c|}{ Fieral Yiers Eaded } \\ \hline & \multicolumn{3}{|c|}{ Fehreary 3, 203} & \multicolumn{3}{|c|}{ Jahear 28.262} & \multicolumn{3}{|c|}{ January 29.2021 } \\ \hline & \multicolumn{2}{|c|}{ Ameant } & SSales & \multicolumn{2}{|c|}{ Anoent } & \%Sales & \multicolumn{2}{|c|}{ Amatunt } & \multirow{2}{*}{100.00%8salk4} \\ \hline Net vales & 5 & noss & 160.00% & 5 & w.25 & 1000% & 5 & m.sv & \\ \hline Cest of sales & & 4sin2 & 4h.77 & & 64.194 & 6670 & & 60025 & 66.99 \\ \hline Cren wargis & & 32.257 & 312s & & 12.056 & ista & & 20,572 & 31.91 \\ \hline \multicolumn{10}{|l|}{ Fxprnace: } \\ \hline Selling, pesenal and adrinitrative & & 20312 & 2004 & & x>01 & 10.01 & & 18,526 & 20.68 \\ \hline Depeociatice and anertiration & & 1.764 & 1.82 & & 1,602 & 1.23 & & 1,399 & 156 \\ \hline Oprratiag incene & & lease & I8.47 & & & ines & & 9,47 & 10.77 \\ \hline laterent- net & & 1.123 & 1.16 & & kss & 0.92 & & s4s & 0.94 \\ \hline & & & & & 31 & - & & 1.060 & 1.4 \\ \hline Fre-4as earaines & & 9.336 & 9.31 & & 11. das & 11.64 & & 7,739 & \\ \hline lacome tas provient & & 2504 & 264 & & 2.74 & 287 & & 1,506 & 2.13 \\ \hline Set caraing: & 5 & e.tst & 6.61% & 3 & 8,442 & 8.79 & s & sxis & \\ \hline Hasic earaines per camenen tharr & 5 & 10.20 & & 5 & 12.97 & & s & & \\ \hline Biluted earainge per comenen shars & 5 & 1a.17 & & & 1204 & & s & & \\ \hline \end{tabular} Lene's Cesapanins, Iac. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & & 300 & 032 & & 100 & a.11 & & & (000) \\ \hline \end{tabular} chen 35 Open an Excel Spreadsheet. Type the Revenues for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Revenues and Lowe's Companies Ine revenues respectively. Make a simple line chart for each. Title the line charts as Home Depot Inc and Lowe's Companies Inc revenues respectively. Next, type the Operating Income for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Operating Income and Lowe's Companies Inc Operating Income respectively. Make a simple line chart for each. Title the line charts as Home Depot Inc and Lowe's Companies Inc Operating Income respectively. Next, type the Net Income for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Net Income and Lowe's Companies Inc Net Income respectively. Make a simple line chart for each. Title them as Home Depot Inc and Lowe's Companies Inc Net Income respectively. Once all six-line charts are ready, write down a brief analysis on Home Depot Inc's revenue, operating income and net income trends. Next, write down a brief analysis on Lowe's Companies Inc's revenue, operating income and net income trends. Contrast the two. There is no one correct answer. Is there any indication that the current disruptions to global supply chain had an impact on the bottom-line of Home Depot or Lowe's? Substantiate your answer. Research this by using recent news discussion on the internet. Fill in your brief response in the worksheet, keep it ready and then type it in the Canvas assessment when you take it. HORIZONTAL ANALYSIS Horizontal analysis is also known as trend analysis. By looking at recent trends, and also taking into disclosures and press releases from the company and outside the company, the financial markets often try to predict the future stock prices. In the next few steps, do a simple 3-year trend analysis. Go to Home Depot Inc and Lowe's Companies Inc 10-K for 2022 and open Consolidated Income Statements. (Click the link below and download the 202210K ) Home Depot Ine 10-K: (For the fiscal year ended January 29, 2023) From the Table of Contents, seleet Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 37). Lowe's Companies Inc 10-K: (For the fiscal year ended February 3, 2023) From the Table of Contents, select Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 38)