ACCT 7080 Project 2 Fall 2023

xlsx

School

University of Memphis *

*We aren’t endorsed by this school

Course

7080

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

4

Uploaded by nvongchampa

Report
Project 2 Question #1 Question #2 Question #3 Question #4 Question #5 Question #6 How does Home Depot define what Goodwill is? Question #7 How does Home Depot calculate its liability for returns? Question #8 Question #9 What was Home Depot's Gross Profit Margin in 2021? Question #10 What method (LIFO, FIFO, Average Cost) does Home Depot use to value a majority of its inventories? Describe how COVID-19 affected how Home Depot conducted their physical inventories in 2020. What method (Straight-line, accelerated) does Home Depot use to depreciate Buildings, furniture, and equipment? What are the useful lives of Home Depot's property and equipment. Using the Consolidated Statements of Cash Flows describe what impacted Home Depot's cash position in 2021. What merchandising department at Home Depot had the highest percentage of Net Sales in 2021? 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 Question #14 Question #15 In 2021 what was the average ticket at Home Depot? Question #16 At what point does Home Depot expense advertising costs? In 2021 what percentage of Home Depot's Net Sales were in the U.S.? 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.
FIFO Straight-line Indoor Garden at 10.3%. 33.60% 90.05% Home Depot conducted physical inventories from a sample of stores since physical inventory counts were temporarily suspended during FY2020 due to COVID-19. The company believes the sampled stores provided a reasonable shrink estimate. Regular physical inventory counts resumed in FY2021, and the difference for FY2020 and FY2021 was not material. The estimated useful life of Home Depot's property and equipment are as follows: buildings 5-45 years, furniture, fixtures and equipement 2-20 years, and leasehold improvements 5-45 years. Net earnings for 2021 were $16,433 million. The positive net earnings of cash flow are from operating activities. There was a substantial decrease in merchandise inventories, resulting in a cash outflow of -$5,403 million. This could be due to the pandemic. Home Depot also spent a significant amount on repurchasing common stock, with a net amount of -$14,809 million. The net impact on Home Depot's cash position for 2021 was a decrease. The company experienced significant cash outflows that were driven by stock repurchases and dividend payments, offset to some extent by positive operating activities and debt-related inflows. Home Depot defines goodwill as the excess of purchase price over the fair value of net assets acquired. Home Depot's liability for sales returns is estimated based on historial return levels and expected future returns.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3.58% Advertising costs are expensed when the advertisement first appears. 91.90% $83.04 Costs of sales include the actual cost of merchandise sold/services performed, the cost of transportation of merchandise from vendors to distribution network, stores, or customers, shipping and handling, operating costs, depreciation of the company's out sourcing and distribution network, and vendor allowances that are not reimbursements of specific, incremental, and identifiable costs. Home Depot experienced an increase in Net Sales from $132,110 million in 2020 to $151,157 million in 2021. This represents a growth of 14.4%. The Gross Profit Margin slightly decreased from 34.0% in 2020 to 33.6% in 2021, but while the gross profit margin declined slightly, the absolute gross profit increased ($44,853 million in 2020 to $50,832 in 2021), contributing positively to net earnings. Operating income as a percentage of net sales increased from 13.8% in 2020 to 15.2% in 2021. The increase in operating income percentage suggests that Home Depot was able to manage its operating expenses effectively and improve operating efficiency. Interest and other (income) expense as a percentage of net sales decreased slightly from 1.0% in 2020 to 0.9% in 2021. The decrease in interest and other (income) expense contributed positively to net earnings.