Hello, this is a project where you access the data and fill it the answers in on the attached spreadsheet. I will send my log in to access the textbook to see the data after a tutor is selected. I will tip for good work!
Project 2 (40 Points)
In this deliverable we will continue to focus on the important business information found in the annual
statements of publicly traded corporations and how to interpret and understand it. We will be using the
information found in your textbook under Appendix A Home Depot 2021Financial Statements.
Complete the provided Excel spreadsheet.
Project 2 is due on 11/21/2023 by 11:59 pm. Upload your Excel Spreadsheet to Canvas.
Project 2
Question #1
What method (LIFO, FIFO, Average Cost) does Home Depot
use to value a majority of its inventories?
Question #2
Describe how COVID-19 affected how Home Depot
conducted their physical inventories in 2020.
Question #3
What method (Straight-line, accelerated) does Home Depot
use to depreciate Buildings, furniture, and equipment?
Question #4
What are the useful lives of Home Depot’s property and
equipment.
Question #5
Using the Consolidated Statements of Cash Flows describe
what impacted Home Depot’s cash position in 2021.
Question #6
How does Home Depot define what Goodwill is?
Question #7
How does Home Depot calculate its liability for returns?
Question #8
What merchandising department at Home Depot had the
highest percentage of Net Sales in 2021?
Question #9
What was Home Depot’s Gross Profit Margin in 2021?
Question #10
What percentage of Home Depot’s Net Property and
Equipment is located in the U.S.?
Question #11
What percentage of Home Depot’s Net Sales are Services?
Question #12
What costs are included in Home Depot’s Cost of Sales?
Question #13
At what point does Home Depot expense advertising costs?
Question #14
In 2021 what percentage of Home Depot’s Net Sales were
in the U.S.?
Question #15
In 2021 what was the average ticket at Home Depot?
Question #16
Under the heading, Selected Section of Management
Discussion and Analysis, you will see that Net Earnings in
2021 increased to 10.9% of Net Sales. Provide commentary
as to how Home Depot achieved this increase from 2020.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more