The Chapter 9 Business Application Case is attached. The assignment can also be found in the text as ATC 91 at the end of the chapter. Note that some amounts may be different from the text version. An excel template is also attached to assist with your calculations. Your work should be completed using either word or excel and uploaded in your submission. Bo sure to submit your calculations. It is recommended that you use excel formulas for calculations. This helps avoid salculation errors and allows me to see your work and be able to determine where you got off track. The Business Case grading rubric is included below so you can see how the assignments will be scored. ATC 9-1 Business Applications Case Analyzing Home Depot and Lowe's The following information relates to Home Depot for its 2017 and 2016 fiscal years, and Lowe's Companies for its 2017 and 2016 fiscal years. Required a. Compute the following ratios for the companies' most recent fiscal years: [Note - some amounts are different from the printed text version] (1) Current ratio. (2) Average days to sell inventory. (Use average inventory.) (3) Debt to assets ratio. (4) Return on investment. (Use average assets and use "earnings from continuing operations" rather than "net earnings.") (5) Gross margin percentage. (6) Asset turnover. (Use average assets.) (7) Net margin. (Use "earnings from continuing operations" rather than "net earnings.") (8) Plant assets to long-term debt ratio. b. Which company appears to be more profitable? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. c. Which company appears to have the higher level of financial risk? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. d. Which company appears to be charging higher prices for its goods? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. e. Which company appears to be the more efficient at using its assets? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. HOME DEPOT. INC. Selected Financial Information (amounts in milions, except per share amounts) January 28, February 29. 20182017 Total current assets $18,933$17.724 Merchandise inventory 12,74812,549 Property and equipment, net of depreciation 22,07521,914 Total assets 44,52942,966 Totar current llabilities 16,19414,133 Total tong-term liabilites 26.88124,500 Total liabiuties 43,07538,633 Totat shareholders' equity 1,4544,333 Revenue 100,90494,595 Cost of goods sold 66.54802.282 Gross profit 34.35032.313 Operating income 14,68113,427 Eamings from continuing operations before income tax expense 13,69812,491 income tax expense Net earnings Basic earnings per share LOWES COMPANIES, INC. Selected Financial information (amounts in milions except per share data) February 2, February 3. 20182017 Total current assets $12,772$12,000 Merchandise inventory 11,39310,459 Property and equipment, net of clepreciation 19,72119,949 Total assets 35,29134,408 Total current liabilities 12,09611.974 Total long-term liabilities 17,32216,000 Total liabilities Total stockholders' equity Revenues Cost of goods sold Gross profit Operating income Earnings from continuing operations berore income taxes Income tax expense \begin{tabular}{llll} Net earnings & 3,447 & 3,093 \\ \hline Besic earnings pershare \end{tabular} Basic earnings per share $4.09$3.48 Press esc to exit full screen
