Use the SEC website and search for the Home Depot company. Download the company's $10-$K filed in $2020$ to an Excel file $($see the video presentation in this session's Reading and Viewing Assignments for an example of how to do this$).$

Use 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$),$ use 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 $\mathrm{.}1\%?)$

Please help create and do this excel based assigment

Answer rating: 100% (QA)

To complete the Excelbased assignment based on the SEC filing of Home Depot for the year 2020 follow the steps outlined below 1 Download the 10K Filin... View the full answer