# Worksheet

Worksheet

The purpose of the second part of the comprehensive project is to compute financial statement ratios. Based on the company you selected.

**DO ONLY Part – B (DONT do Part – A)**

**Attached Part – A**

Company: ‘**Target corporation’**

**Part – A**

- Based on formulas in your textbook, compute the following ratios for two years. You may use Excel to compute your ratios.
- Debt ratio
- Gross profit margin
- Free cash flow
- Times interest earned
- Accounts receivable turnover
- Inventory turnover

- Prepare a DuPont Analysis of ROE for two years, including computations of
- Return on Sales
- Asset Turnover
- Return on Assets
- Financial Leverage
- Return on Equity

**Part – B**

- Briefly evaluate the ratio trends. Indicate on your worksheet whether each ratio is:
- stronger / weaker
- quicker /slower
- more / less liquid
- more / less risk

- Write a 3-6 page report evaluating trends in all of the above ratios. Discuss whether your company’s profitability, efficiency, liquidity, and solvency are improving or deteriorating. Suggest ways the company can improve the ratios that show problems. The report should be well written with cover page, introduction, the body of the paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited.

Format: Double-spaced, one-inch margins, using a 12-point Times New Roman font. Use APA throughout.

TARGET CORPORATION 2

**1) computed the following ratios for two years**

1) | The debt ratio can be calculated as follows | ||

2020 | 2019 | ||

Total Liabilities | $30,946 | $29,993 | |

Total Assets | $42,779 | $41,290 | |

Total Debt ratio | 72.34% | 72.64% |

2) | Gross Profit margin | ||

2020 | 2019 | ||

Gross Profit margin | $23,248 | $22,057 | |

Total Sales | $78,112 | $75,356 | |

Gross Profit margin | 29.76% | 29.27% |

3) | Free Cash Flow | ||

2020 | 2019 | ||

Cash Flow from operations | $7,117 | $5,973 | |

Capital Expenditure | $2,944 | $3,416 | |

Free Cash Flow | $4,173 | $2,557 |

4) | Time Interest Earned ratio | ||

2020 | 2019 | ||

EBIT | $4,658 | $4,110 | |

Interest Expense | $468 | $434 | |

Time Interest Earned Ratio | 9.95299145 | 9.47004608 |

5) | Receivables Turnover | |||

2020 | 2019 | 2018 | ||

Credit Sale | $78,112 | $75,356 | ||

Receivables Turnover | 0 | 0 | 0 | |

Average Receivable | 0 | 0 | ||

Receivables Turnover | Not defined | Not defined | ||

Since receivables are zero, therefore the receivable turnover is not defined |

6) | Inventory Turnover | |||

2020 | 2019 | 2018 | ||

Cost of goods sold | $54,864 | $53,299 | ||

Inventory Turnover | $8,992 | $9,497 | 8597 | |

Average Inventory | $8,992 | $9,497 | ||

Inventory Turnover | 6.10142349 | 5.61219332 |

**2) DuPont Analysis of ROE for two years**

To perform DuPont analysis for the return on assets, we first compute the return on sales and the asset turnover. The formula for return on sales is net income divided by revenues. Meanwhile, asset turnover is calculated as revenues divided by total assets. Suppose the return on sales and asset turnover is multiplied by each other. In that case, the result will be equal to the return on assets, calculated as net income divided by total assets.

To perform DuPont analysis for the return on equity, we first compute the return on sales, total asset turnover, and financial leverage (equity multiplier). As said earlier, the return on sales is equal to net income divided by revenues. Total asset turnover is equal to revenues divided by total assets. Financial leverage (equity multiplier) is computed as total assets divided by total equity. If you multiply the return on sales by the total asset turnover and by the financial leverage, we can calculate the return on equity, which can alternatively be computed as net income divided by total equity

DuPont Analysis of ROE for two years | 2020 | 2019 |

Net Income | 3,281.00 | 2,937.00 |

Revenue | 78,112.00 | 75,356.00 |

Total Assets | 42,779.00 | 41,290.00 |

Total Equity | 11,833.00 | 11,297.00 |

Return on Sales | 4.20% | 3.90% |

Asset Turnover | 1.83 | 1.83 |

Return on Assets (Return on Sales * Asset Turnover) | 7.67% | 7.11% |

Financial Leverage (Equity Multiplier) | 3.62 | 3.65 |

Return on Equity (Net Income / Total Equity) | 27.73% | 26.00% |

TARGET CORPORATION

1

1) computed the following ratios for two years

1)

The debt ratio can be calculated as follows

2020

2019

Total Liabilities

$30,946

$29,993

Total Assets

$42,779

$41,290

Total Debt ratio

72.34%

72.64%

2)

Gross Profit margin

2020

2019

Gross Profit margin

$23,248

$22,057

Total Sales

$78,112

$75,356

Gross Profit margin

29.76%

29.27%

3)

Free Cash Flow

2020

2019

Cash Flow from operations

$7,117

$5,973

Capital Expenditure

$2,944

$3,416

Free Cash

Flow

$4,173

$2,557

TARGET CORPORATION 1

1) computed the following ratios for two years

1) The debt ratio can be calculated as follows

2020 2019

Total Liabilities $30,946 $29,993

Total Assets $42,779 $41,290

Total Debt ratio 72.34% 72.64%

2) Gross Profit margin

2020 2019

Gross Profit margin $23,248 $22,057

Total Sales $78,112 $75,356

Gross Profit margin 29.76% 29.27%

3) Free Cash Flow

2020 2019

Cash Flow from operations $7,117 $5,973

Capital Expenditure $2,944 $3,416

Free Cash Flow $4,173 $2,557

## Leave a Reply

Want to join the discussion?Feel free to contribute!