Within the ratio tab, you need to show 3 things for each of the ratios: 1. Written formula 2. Detailed numbers for the calculation 3. Result of the calculation When showing all of these items you will receive as many points as possible. For example, if the current ratio is = $10,296 / $8,876 = 1.16. When the work is submitted in this manner, I can see where you may have made an error, but still provide some points. An answer showing of just 1.24, for example, you receive no points (it's incorrect and I can't see what numbers you used). An answer of $11,006 / $8,876 = 1.24 would receive partial credit (the denominator is correct, but an incorrect numerator was used). Calculations to Perform (on the most recent year): 1. Prepare a horizontal (trend) analysis for the balance sheet - 1 point 2. Prepare a horizontal (trend) analysis for the income statement - 1 point 3. Prepare a vertical (common size) analysis for the balance sheet - 1 point 4. Prepare a vertical (common size) analysis for the income statement 1 point 5. Net profit margin - 2 points Page 112 6. Gross profit percentage - 2 points 7. Fixed asset turnover ratio - 3 points 8. Return on Equity (ROE) - 3 points 9. Earnings per Share (EPS) - 3 points 10. Price / Earnings Ratio (P/E) - 2 points 11. Receivables turnover ratio and days to collect - 4 points 12. Inventory turnover ratio and days to sell - 4 points 13. Current ratio - 2 point 14. Debt-to-assets ratio - 3 points 15. Times interest earned - 3 points Within the ratio tab, you need to show 3 things for each of the ratios: 1. Written formula 2. Detailed numbers for the calculation 3. Result of the calculation When showing all of these items you will receive as many points as possible. For example, if the current ratio is = $10,296 / $8,876 = 1.16. When the work is submitted in this manner, I can see where you may have made an error, but still provide some points. An answer showing of just 1.24, for example, you receive no points (it's incorrect and I can't see what numbers you used). An answer of $11,006 / $8,876 = 1.24 would receive partial credit (the denominator is correct, but an incorrect numerator was used). Calculations to Perform (on the most recent year): 1. Prepare a horizontal (trend) analysis for the balance sheet - 1 point 2. Prepare a horizontal (trend) analysis for the income statement - 1 point 3. Prepare a vertical (common size) analysis for the balance sheet - 1 point 4. Prepare a vertical (common size) analysis for the income statement 1 point 5. Net profit margin - 2 points Page 112 6. Gross profit percentage - 2 points 7. Fixed asset turnover ratio - 3 points 8. Return on Equity (ROE) - 3 points 9. Earnings per Share (EPS) - 3 points 10. Price / Earnings Ratio (P/E) - 2 points 11. Receivables turnover ratio and days to collect - 4 points 12. Inventory turnover ratio and days to sell - 4 points 13. Current ratio - 2 point 14. Debt-to-assets ratio - 3 points 15. Times interest earned - 3 points
