Question

In: Accounting

ACT 5140 – Accounting for Decision Makers HW #1 Directions: Answer all the questions. Please submit...

ACT 5140 – Accounting for Decision Makers HW #1 Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations. Also, please be sure to include your name at the top of the first page of your file. Question #1 • Using the accompanying financial statements (Excel Workbook), assess The Home Depot concerning liquidity, solvency, profitability, and stock performance. For each area, you should calculate the ratios from the “Ratios for Home Depot file “ and provide a brief analysis of the ratios calculated. You do not need to perform vertical analysis for this assignment. I include historical stock price information and outstanding common share information below. You do not need to look beyond the financial statements to complete this assignment. Fiscal Year Ended 2/1/2015 2/2/2014 2/3/2013 1/29/2012 Adjusted Closing Price $103.34 $74.44 $63.87 $41.67 Common Shares Outstanding (millions) 1,307 1,380 1,486 1,523 HOME DEPOT INC $ in millions Year Ending 2/1/2015 2/2/2014 2/3/2013 1/29/2012 OPERATING ACTIVITIES: Net earnings $6,345 $5,385 $4,535 $3,883 Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization 1,786 1,757 1,684 1,682 Stock-based compensation expense 225 228 218 215 Goodwill impairment (323) 0 97 0 Changes in Assets and Liabilities, net of the effects of acquisition and disposition Receivables, net (81) (15) (143) (170) Merchandise inventories (124) (455) (350) 256 Other current assets (199) (5) 93 159 Accounts payable and accrued expenses 244 605 698 422 Deferred revenue 146 75 121 (29) Income taxes payable 168 119 87 14 Deferred income taxes 159 (31) 107 170 Other long-term liabilities (152) 13 (180) (2) Other 48 (48) 8 51 Net cash provided by operating activities $8,242 $7,628 $6,975 $6,651 INVESTING ACTIVITIES: Capital expenditures (1,442) (1,389) (1,312) (1,221) Proceeds from sales of investments 323 0 0 0 Proceeds from sale of business 0 0 0 101 Payments for business acquired (200) (206) (170) (65) Proceeds from sales of property & equipment 48 88 50 56 Net cash used by investing activities ($1,271) ($1,507) ($1,432) ($1,129) FINANCING ACTIVITIES: Proceeds from short-term borrowings, net 290 0 0 0 Proceeds from long-term borrowings, net of discount 1,981 5,222 0 1,994 Repayments of long-term debt (39) (1,289) (32) (1,028) Repurchases of common stock (7,000) (8,546) (3,984) (3,470) Proceeds from sales of common stock 252 241 784 306 Cash dividends paid to stockholders (2,530) (2,243) (1,743) (1,632) Other financing activities (25) (37) (59) (218) Net cash used by financing activities ($7,071) ($6,652) ($5,034) ($4,048) Change in Cash and Cash Equivalents ($100) ($531) $509 $1,474 Effect of exchange rate changes on cash and cash equivalents (106) (34) (2) (32) Cash and cash equivalents at beginning of year 1,929 2,494 1,987 545 Cash and cash equivalents at end of year $1,723 $1,929 $2,494 $1,987 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR Interest, net of capitalized interest $782 $639 $617 $580 Income taxes $3,435 $2,839 $2,482 $1,865 HOME DEPOT INC $ in millions Year Ending 2/1/2015 2/2/2014 2/3/2013 1/29/2012 OPERATING ACTIVITIES: Net earnings $6,345 $5,385 $4,535 $3,883 Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization 1,786 1,757 1,684 1,682 Stock-based compensation expense 225 228 218 215 Goodwill impairment (323) 0 97 0 Changes in Assets and Liabilities, net of the effects of acquisition and disposition Receivables, net (81) (15) (143) (170) Merchandise inventories (124) (455) (350) 256 Other current assets (199) (5) 93 159 Accounts payable and accrued expenses 244 605 698 422 Deferred revenue 146 75 121 (29) Income taxes payable 168 119 87 14 Deferred income taxes 159 (31) 107 170 Other long-term liabilities (152) 13 (180) (2) Other 48 (48) 8 51 Net cash provided by operating activities $8,242 $7,628 $6,975 $6,651 INVESTING ACTIVITIES: Capital expenditures (1,442) (1,389) (1,312) (1,221) Proceeds from sales of investments 323 0 0 0 Proceeds from sale of business 0 0 0 101 Payments for business acquired (200) (206) (170) (65) Proceeds from sales of property & equipment 48 88 50 56 Net cash used by investing activities ($1,271) ($1,507) ($1,432) ($1,129) FINANCING ACTIVITIES: Proceeds from short-term borrowings, net 290 0 0 0 Proceeds from long-term borrowings, net of discount 1,981 5,222 0 1,994 Repayments of long-term debt (39) (1,289) (32) (1,028) Repurchases of common stock (7,000) (8,546) (3,984) (3,470) Proceeds from sales of common stock 252 241 784 306 Cash dividends paid to stockholders (2,530) (2,243) (1,743) (1,632) Other financing activities (25) (37) (59) (218) Net cash used by financing activities ($7,071) ($6,652) ($5,034) ($4,048) Change in Cash and Cash Equivalents ($100) ($531) $509 $1,474 Effect of exchange rate changes on cash and cash equivalents (106) (34) (2) (32) Cash and cash equivalents at beginning of year 1,929 2,494 1,987 545 Cash and cash equivalents at end of year $1,723 $1,929 $2,494 $1,987 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR Interest, net of capitalized interest $782 $639 $617 $580 Income taxes $3,435 $2,839 $2,482 $1,865 HOME DEPOT INC $ in millions Year Ending 2/1/2015 2/2/2014 2/3/2013 1/29/2012 OPERATING ACTIVITIES: Net earnings $6,345 $5,385 $4,535 $3,883 Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization 1,786 1,757 1,684 1,682 Stock-based compensation expense 225 228 218 215 Goodwill impairment (323) 0 97 0 Changes in Assets and Liabilities, net of the effects of acquisition and disposition Receivables, net (81) (15) (143) (170) Merchandise inventories (124) (455) (350) 256 Other current assets (199) (5) 93 159 Accounts payable and accrued expenses 244 605 698 422 Deferred revenue 146 75 121 (29) Income taxes payable 168 119 87 14 Deferred income taxes 159 (31) 107 170 Other long-term liabilities (152) 13 (180) (2) Other 48 (48) 8 51 Net cash provided by operating activities $8,242 $7,628 $6,975 $6,651 INVESTING ACTIVITIES: Capital expenditures (1,442) (1,389) (1,312) (1,221) Proceeds from sales of investments 323 0 0 0 Proceeds from sale of business 0 0 0 101 Payments for business acquired (200) (206) (170) (65) Proceeds from sales of property & equipment 48 88 50 56 Net cash used by investing activities ($1,271) ($1,507) ($1,432) ($1,129) FINANCING ACTIVITIES: Proceeds from short-term borrowings, net 290 0 0 0 Proceeds from long-term borrowings, net of discount 1,981 5,222 0 1,994 Repayments of long-term debt (39) (1,289) (32) (1,028) Repurchases of common stock (7,000) (8,546) (3,984) (3,470) Proceeds from sales of common stock 252 241 784 306 Cash dividends paid to stockholders (2,530) (2,243) (1,743) (1,632) Other financing activities (25) (37) (59) (218) Net cash used by financing activities ($7,071) ($6,652) ($5,034) ($4,048) Change in Cash and Cash Equivalents ($100) ($531) $509 $1,474 Effect of exchange rate changes on cash and cash equivalents (106) (34) (2) (32) Cash and cash equivalents at beginning of year 1,929 2,494 1,987 545 Cash and cash equivalents at end of year $1,723 $1,929 $2,494 $1,987 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR Interest, net of capitalized interest $782 $639 $617 $580 Income taxes $3,435 $2,839 $2,482 $1,865

Solutions

Expert Solution


Related Solutions

Please follow the directions and answer all questions properly. Type the answers please. NO hand written...
Please follow the directions and answer all questions properly. Type the answers please. NO hand written answer. This is a Marketing class. Thanks Please write no more than 100 words for each question. The questions are about fast food chain “Chick-Fil-A. These questions were asked by my professor. Please make sure that answers are good. I would really appreciate. Thanks again. I’m having a hard time understanding differences among needs, wants and demands of “Chick-Fil-A” customers. How would you explain...
PLEASE ANSWER ALL QUESTIONS AND PARTS!! 1. Only two horizontal forces act on a 3.0 kg...
PLEASE ANSWER ALL QUESTIONS AND PARTS!! 1. Only two horizontal forces act on a 3.0 kg body that can move over a frictionless floor. One force is 9.0 N, acting due east, and the other is 7.2 N, acting 61° north of west. What is the magnitude of the body's acceleration? 2. The 1 kg standard body has an acceleration of 2.00 m/s2 at 31° to the positive direction of the x axis. (a) What are the x and y...
please answer all three questions 1.) The US Safe Drinking Water Act requires the US EPA...
please answer all three questions 1.) The US Safe Drinking Water Act requires the US EPA regulate contaminates in drinking water. Bromate ion is a carcinogen that is produced as a by-product of water disinfection, and the bromate ion concentration in finished drinking water can be no higher than 0.010 mg/L as an annual average. Calculate the annual average limit for bromate ion in terms of a.) ppb and b.) molarity. Assume that the density of drinking water is 1...
Directions: Answer the questions below (taken from the Winston book) using the indicated data set. Submit...
Directions: Answer the questions below (taken from the Winston book) using the indicated data set. Submit this on Blackboard in this Word document by the due date indicated on Blackboard. Only submissions in this format will be accepted. This homework will rely heavily on a close reading of the assigned text. Please show all work! This is an abbreviated version in order to complete the full version. Date S and P return Dell return 1-Sep-88 0.042 0.282112845 1-Oct-88 0.027 0.1582397...
Directions: Answer ALL of the following questions. Show ALL calculations and present them in a neat...
Directions: Answer ALL of the following questions. Show ALL calculations and present them in a neat and an orderly fashion. Credit will not be given for either unsupported answers or illegible answers. This is NOT a group assignment. Any indication of collaboration with your classmates will earn all involved a grade of zero (0). This assignment is due Monday, October 5, 2020. However, you may submit it before the due date. Late assignments are NOT accepted. The following is information...
Directions for written assignment (about 150 words). Please answer these questions: 1. What are two of...
Directions for written assignment (about 150 words). Please answer these questions: 1. What are two of the visible impacts of the human response to the COVID-19 pandemic on the environment? 2. What are three of the "ten lessons the coronavirus has taught us about the planet"? Refer to the article: Degnarain 2020: Ten Lessons The Coronavirus Has Taught Us About The Planet 3. Which of these three do you think is the most important? Explain your reasoning.
Both managerial accounting and financial accounting provide useful information to decision makers.
Exercise 14-1 Sources of accounting information LO C1 Both managerial accounting and financial accounting provide useful information to decision makers. Indicate in the following table the primary source of information for each business decision. Primary Information Source Business Decision.Business DecisionPrimary Information Source1.Prepare budgets for the next year2.Estimate profits from a new service opportunity3.Prepare GAAP-based financial statements for external auditor4.Estimate product cost for a new line of shoes5.Determine whether to automate a production process6.Prepare financial reports according to GAAP7.Report financial performance to...
CAN YOU PLEASE ANSWER ALL QUESTIONS AND PLEASE ANSWER AS SOON AS POSSIBLE 1. The processing,...
CAN YOU PLEASE ANSWER ALL QUESTIONS AND PLEASE ANSWER AS SOON AS POSSIBLE 1. The processing, where different kinds of information are processed in different brain structures, is called: a. Stream segregation b. Serial processing c. Distributed processing d. Parallel processing 2. In vision, what does dark adaptation mean? a. Decrease in color discrimination that occurs after a period in the dark b. The increased sensitivity of the eye that occurs when being in the dark for a long time...
1153 – Chapter 12 & 5 HW Questions 1. ACT scores follow an approximately normal distribution....
1153 – Chapter 12 & 5 HW Questions 1. ACT scores follow an approximately normal distribution. One year, the mean score was 18.2 with standard deviation 5.8. Round proportions to 4 decimal places and scores to the appropriate integer. (a) What proportion of students scored below 20? Above 25? Between 20 and 30? (b) What score did someone at the 80th percentile have? (c) Describe the top 10% of ACT scores: (d) Describe the middle 50% of ACT scores: 2....
Please prepare accounting entries or answer the questions asked for the following independent situations (SHOW ALL...
Please prepare accounting entries or answer the questions asked for the following independent situations (SHOW ALL WORK): Diamond Company owns 40% of the stock of Silver Company. On January 1, 2019, Silver reports total income of $4,000,000. On June 1, 2019, Silver pays total dividends to its shareholders of $1,000,000. Prepare the necessary accounting entries for Diamond. May Company purchased a bond issued by August Company on September 1, 2019 for $1,000,000. The bond is properly classified as Trading. On...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT