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