Financial and Managerial Accounting Project

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.