Calculate the ratios , for each of the last three years. Enter the values in the white cells below.Mark Allocation: 50% (16 ratios for 3 years). That means 48 ratios, worth 1 mark each. All students will get a bonus 2%, but if you change the nameof the Excel spreadsheet when you save it you will lose the 2% bonus.The only way to successfully calculate these ratios is to carefully work through the examples in the online materials (as well as the relevant onlineexercise). Dont just look at the formulas. Make sure you can see where the numbers have come from in the worked examples.

Document Preview:

INTRODUCTION TO ACCOUNTING AND FINANCE Assignment Part 3  Marking Guidelines Tasks, descriptions and assessment weightings 1 Calculation of 16 specified financial ratios 50% 2 Analysis of the firms recent performance, in terms of positive or negative trends 15%  Identify which ratios have shown a positive or negative trend over the past three years. 3 Analysis of the firms performance, in terms of a comparison with industry averages 15%  Identify which ratios have shown a positive or negative performance in comparison with industry averages. 4 Summarise the firms overall performance 15%  Summarise the firms overall position in terms of profitability, efficiency, liquidity, leverage and potential for investment. 5 Analysis of possible problems with your analysis 5%  Advise your client if there are reasons why ratio analysis such as this may not be entirely reliable. What should they keep in mind when reviewing the conclusions from the analysis? 100% Grading criteria for tasks 1 As this is a calculation and accounting exercise, marks will be deducted for errors made, in proportion to the seriousness of the error. Specific line items, if incorrect, will be penalised between 0.5 and 1 marks out of the 50 marks for that part. Grading criteria for tasks 2  5 Criteria Excellent/Extended Relational/Very Good/ (B 70- Multi-structural/Good/ Uni-structural/ Pre-structural/ Abstract/(A 80-100%) 79%) (C 60-69%) Pass/ (D 50-59) Fail/ (F 0-49) Clarity and completeness All elements are complete and The most important elements Many of the most important Many of the most Few if any of the detailed, structured clearly are complete but not clear, or elements are complete but not clear, important elements are most important (50%) with no missing links. all are complete but some are or all are complete but some are included, but are elements are unclear. unclear. Some important elements incomplete or unclear. included. are.