1. Calculate the ratios shown, for each of the last three years. Enter the values in the white cells below.

The only way to successfully calculate these ratios is to carefully work through the examples in the online materials (as well as the relevant online exercise). Don’t just look at the formulas. Make sure you can see where the numbers have come from in the worked examples.

2. Analyse the firm's performance over the last 3 years. Identify any strengths or weaknesses, in terms of positive or negative trends.It is recommended that you consider each of the 5 types of ratios separately. Use subheadings. That will make your report easier to read and comprehend. Begin with profitability ratios, and then identify, for each ratio, whether there is a clear upward or downward trend. If there is minimal change, or the figures go up and down, then there isn’t an identifiable trend. Then discuss efficiency ratios, and so on.

3. Analyse the firm's performance in comparison to industry averages for each of the ratios, identifying any apparent strengths or weaknesses. value for each ratio with the industry average, and indicate whether the firm is doing better, worse or about the same as other firms in the industry.

4. Based on your answers to Questions 2 and 3, summarise the firm's performance in terms of profitability, efficiency, liquidity, leverage and potential for investment.

Again, take each of the 5 groups of ratios separately. Give an overall indication of whether the firm is doing will or badly in terms of profitability,based on identifiable trends and by comparison with the industry averages. If all of the ratios indicate strength or weakness, say so. If the story is mixed, so say. Do the same for each category.

5. Briefly explain to the client any possible problems with your analysis that the client should bear in mind.

## Answer:

Return on equity | PAT | 205 | 217 | 250 |

Return on capital employed | PAT | 205 | 217 | 250 |

Operating Profit Margin | Operating Profit | 353 | 366 | 405 |

Gross Margin Profit | Gross Profit | 1053 | 1166 | 1428 |

Average Inventory turnover Period | COGS | 1275 | 1438 | 1626 |

Average settlement period for Account receivable | Net Sales | 2328 | 2604 | 3054 |

Average settlement period for Account payable | Net Purchases | 1270 | 1431 | 1617 |

Sales Revenue to Capital Employed | Capital Employed | 712 | 727 | 779 |

Current Ratio | Current Assets | 653 | 639 | 632 |

Acid Test Ratio | Current Assets- Stock | 420 | 413 | 415 |

Gearing Ratios | Long term liabilities | 1531 | 1495 | 1463 |

Interest Coverage Ratio | Interest | 97 | 95 | 93 |

Dividend payout ratio | Total Dividend | 154 | 156 | 158 |

Dividend Yield | Cash dividend per share | 0.19 | 0.21 | 0.23 |

EPS | PAT | 205 | 217 | 250 |

P/E ratio | MPS | 1.96 | 2.26 | 2.27 |

## Follow Us