Using the ratio analysis template listed in the test instructions, complete the financial analysis of Home Depot for the two most recent years.

Access Yahoo Finance, enter HD in stock symbol field, Scroll to "Financials" to select financial statements. For each statement, select "Expand All" in top right corner of statement, to view detailed information. Complete the analysis spreadsheet

Using the space below, analyze the company using the two most recent years of data and reference the industry averages in the following areas:

Staying Power

Profitability

Overall efficiency ratios

Working capital cycle ratios

Use the CSImarket.com website, listed in the instructions, to look up industry averages (Go to site, enter stock symbol, select Fundamentals. Use Industry column to retrieve data for all ratios except Earnings Quality and Accounts Payable turnover). Use TTM industry data. Enter the data in the analysis spreadsheet.

Submit the spreadsheet via question # 24 below.