Module 07 Written Assignment – Ratio Analysis

Download the Module 07_Ratio Analysis Problem. Excel template and complete the included problems.

 

Criteria

 

Points

 

Liquidity Ratios(Current and Quick Ratio)-7.5 pts each

 

15 out of 15

 

Activity Ratios(6 pts each)

 

Inventory turnover

 

Receivables turnover

 

Days sales outstanding

 

Fixed asset turnover

 

Total asset turnover

 

30 out of 30

 

Profitability ratios(5 pts each)

 

Gross profit margin

 

Operating profit margin

 

Net profit margin

 

Return on assets

 

Return on equity

 

25 out of 25

 

Leverage ratios(7.5 pts each)

 

Debt / Net worth

 

Debt ratio

 

15 out of 15

 

Coverage ratio(15 pts)

 

Times-interest-earned

 

15 out of 15

 

Total

 

 

 

100 out of 100