Go to the SEC website and search for the Home Depot company. Download the companys 10-K filed in 2020 to an Excel file (see the video presentation in this sessions Reading and Viewing Assignments for an example of how to do this). Do the following in the Consolidated Statement of Earnings tab in the Excel file: In the columns to the right of the income statement information (statement of earnings information), prepare a trend (horizontal) analysis using two columns to show the percentage increase or decrease over the base year (using the earliest year as base year). In the columns to the right of your trend analysis, use three columns to create a common size (vertical) analysis for each year. Interpret company results below the horizontal and/or vertical analysis columns by answering the following questions: (Place your answers in the Excel file beneath the table.) Did Net Sales increase or decrease in 2019? 2020? Did Net Earnings (Income) increase or decrease in 2019? 2020? How have Net Earnings (Income) as a % of Sales changed since 2018? How have absolute Net Earnings (Income) and Net Earnings (Income) as a % of Sales changed in relation to one another? (For example, did absolute Net Earnings increase by 10% while Net Earnings as a % of Sales decrease by .1%?)

Consolidated Sensofarming-usosasin Millions Sin Millions 12 Months Ended Feb. 02. 2012) Feb 03, 2018 Heriteras 2020 2009 Vertical 2009 income Sun Abtract $ 11025 22.0 32.522 $ 108 209 2104 $ 100304 BER 34356 19 20 Costess Gres pot Opening op Sdling and administrative Depreciation and amertation Imprimant les Todo Operating income Instand other income) Indimenti come Interest 12,464 1,811 0 0 21,720 21630 25. 530 1051 0 1,057 D 983 194 Island, Enings before provision for income Les Provision for income DASSE 14715 3423 $11, 242 3435 $ 11,121 1,132 $94 1,14 $923 5068 5860 1,178 $233 Basic weighted avecommonshas (ins) ing perstar turn dalam pershare) Diluted with a commons (ins) Diuidelines per share turn dalamparshan) $ 1023 1,01 $ 10.5 $729 Consolidated Sensofarming-usosasin Millions Sin Millions 12 Months Ended Feb. 02. 2012) Feb 03, 2018 Heriteras 2020 2009 Vertical 2009 income Sun Abtract $ 11025 22.0 32.522 $ 108 209 2104 $ 100304 BER 34356 19 20 Costess Gres pot Opening op Sdling and administrative Depreciation and amertation Imprimant les Todo Operating income Instand other income) Indimenti come Interest 12,464 1,811 0 0 21,720 21630 25. 530 1051 0 1,057 D 983 194 Island, Enings before provision for income Les Provision for income DASSE 14715 3423 $11, 242 3435 $ 11,121 1,132 $94 1,14 $923 5068 5860 1,178 $233 Basic weighted avecommonshas (ins) ing perstar turn dalam pershare) Diluted with a commons (ins) Diuidelines per share turn dalamparshan) $ 1023 1,01 $ 10.5 $729