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 Appendix B below and provide a brief analysis of the ratios calculated. You do not need to perform vertical analysis for this assignment. Include historical stock price information and outstanding common share information below.
PLEASE USE APPENDIX B WHICH IS AN ANALYSIS OF STARBUCKS AS REFERENCE FOR HELP WITH THIS ASSIGNMENT. THE STARBUCKS ASSIGNMENT IS FOR YOUR ADDED GUIDANCE ONLY. DO NOT COPY AND PASTE STARBUCKS ASSIGNMENT INTO YOUR ASSIGNMENT.
YOU DONT NEED TO COMPARE HOME DEPOT RATIOS WITH INDUSTRY RATIOS. You do not need to look beyond the financial statements to complete this assignment.
Answer all the questions. Please submit your work in Word or PDF formats only. Submit an Excel file to support your calculations, and please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations. YOU SHOULD CALCULATE THE RATIOS USING THE AUDIO CHAT SESSON UNDER THE HOME DEPOT ASSIGNMENT TAB – WHICH EXPLAINS CLEARLY HOW TO CALCULATE THE RATIOS FOR LIQUIDITY , PROFITABILITY ETC….