## Questions on Fixed Assets Turnover

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse where asked.

Please review the Home Depot Annual Report before beginning the assignment.

Don’t use plagiarized sources. Get Your Custom Essay on
Questions on Fixed Assets Turnover
Just from \$10/Page

Below are the financial statements of HP which you should use for the group participation activity. I have also included the Excel file that you need to return to me completed with the HP data. This worksheet can be helpful in the completion of the Home Depot assignment too.

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years:

Net Working Capital

FYE  1/28/18

FYE 2/3/19

Flag this Question

Question 24 pts

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years:

Net Operating Working Capital

FYE  1/28/18

FYE 2/3/19

Tip: Use the formula NOWC = (Total Current Assets – Excess Cash) – (Total Current Liabilities – Short-Term Interest-Bearing Liabilities) and assume that Home Depot’s large cash holdings are not held for operating purposes and it’s all excess cash.

Flag this Question

Question 34 pts

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years:

After Tax Operating Income

FYE  1/28/18

FYE 2/3/19

Tip: use the effective tax rates from the notes to the financials

Flag this Question

Question 44 pts

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the indicated fiscal year:

Free Cash Flow

FYE 2/3/19

Flag this Question

Question 56 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

1) Current Ratio (x)

FYE  1/28/18

FYE 2/3/19

Better/Worse

Flag this Question

Question 66 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

2) Quick Ratio (x)

FYE  1/28/18

FYE 2/3/19

Better/Worse

Flag this Question

Question 76 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

3) Inventory Turnover(x)

FYE  1/28/18

FYE 2/3/19

Better/Worse

Flag this Question

Question 86 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

4) Days Sales Outstanding (Days)

FYE  1/28/18

FYE 2/3/19

Better/Worse

Flag this Question

Question 96 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

5) Fixed Asset Turnover (x)

FYE  1/28/18

FYE 2/3/19

Better/Worse

Flag this Question

Question 106 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

6) Total Asset Turnover (x)

FYE  1/28/18

FYE 2/3/19

Better/Worse

Flag this Question

Question 116 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

7) Total Debt to Total Capital (%)

FYE  1/28/18            %

FYE 2/3/19               %

Better/Worse

Flag this Question

Question 126 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

8) Times Interest Earned (x)

FYE  1/28/18

FYE 2/3/19

Better/Worse

Flag this Question

Question 136 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

9) Operating Profit Margin (%)

FYE  1/28/18            %

FYE 2/3/19               %

Better/Worse

Flag this Question

Question 146 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

10) Net Profit Margin (%)

FYE  1/28/18            %

FYE 2/3/19               %

Better/Worse

Flag this Question

Question 156 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

11) Return on Assets (%)

FYE  1/28/18   %

FYE 2/3/19               %

Better/Worse

Flag this Question

Question 166 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

12) Return on Common Equity (%)

FYE  1/28/18   %

FYE 2/3/19               %

Better/Worse

Flag this Question

Question 176 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

13) Return on Invested Capital (%)

FYE  1/28/18   %

FYE 2/3/19               %

Better/Worse

Flag this Question

Question 186 pts

Ratio Analysis

Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse:

14) Basic Earning Power (%)

FYE  1/28/18   %

FYE 2/3/19               %

Better/Worse