Skip to main content

Analysis Ratio (Activity)

Ratio Analysis - Activity

The aim of this Activity is to look at some financial data from some businesses and to use ratio analysis to anlayse their performance and to assess the value of using ratios in drawing conclusions about business performance.

One of the important aspects of ratio analysis is to know what ratio to use and what the resulting figure tells you. Some ratios can be used on their own; others need to be compared with previous years or other companies to make any sense. The most important thing to remember is that a ratio is not used to demonstrate your mathematical prowess (or lack of it as the case may be) but to provide you with some information. All the ratios used are no more difficult that dividing one number by another or doing a simple bit of multiplication. But make sure that you know what the number means!

Using a calculator

Image: The arithmetic involved in using ratio analysis is easy - you are allowed to use a calculator, but make sure you know what the result on the screen actually means! Copyright: Piet Pens

The Task

Step 1:

Go to the Financial Database in the Company Info section of Biz/ed. (http://www.bized.co.uk/cgi-bin/ratios/ratiodata.pl)


Step 2:

The database has a list of businesses to choose from and the financial accounts for those businesses. Use these accounts to calculate the following ratios for three businesses for at least a two-year period (you can do more if you want).

  • Gross Profit Margin
  • Net Profit Margin
  • ROCE
  • Gearing Ratio
  • Asset Turnover
  • Stock Turnover
  • Debtor Days
  • Current Ratio
  • Acid Test

You can print out the following table and use it to input the data.

RatioCompany1, Year 1Company 2, Year 2
Gross Profit Margin
Net Profit Margin
ROCE
Gearing Ratio
Asset Turnover
Stock Turnover
Debtor Days
Current Ratio
Acid Test

Step 3:

Once you have your completed table, comment on the performance of the business over the two years highlighting the possible reasons for the changes that you identify.


Step 4:

Draw some comparisons between the performance of the businesses you have chosen and offer some explanations for the differences that you might identify.


Step 5:

Select ONE of the businesses you have analysed. Imagine that the Board of Directors is considering some strategic changes in the coming years.

  1. Where would you advise the company to focus its attention given the results of your analysis?
  2. What further information would the Board need before making any firm strategic decisions?

Extension work:

There is a range of questions and activities to work through in the ratio analysis section of Biz/ed that will further develop your understanding.

Comments

Popular posts from this blog

Interactive Worksheet: The Accounting Equation

by Ken Delaney-Moore, Sheffield Hallam University Aims: This worksheet deals with: The accounting equation. The accounting concepts of 'business entity' and 'dual aspect'. The effects of transactions on the balance sheet. After having completed the worksheet you should be better able to perform to syllabus specifications relating to these points. When you are done, please fill-in the on-line evaluation form in order for us to monitor the quality of the materials we provide for you. Tell us what we're doing right and wrong. It takes very little time, and your opinions are valued - thank you. A business start-up Imagine that 'Jim Sayers' puts £5,000 of his personal savings into a business bank accoun...

MEMBUAT DATABASE APLIKASI AKUNTANSI DENGAN MICROSOFT ACCESS 2007

Microsoft Office Access 2007 merupakan aplikasi pembuatan database yang diciptakan Raksasa Microsoft Corporation, Hingga saat ini banyak sekali perusahaan menggunakan aplikasi ini dalam membuat database untuk keperluan bisnisnya, baik dengan menggunakan 100% access, maupun dengan memanfaatkan enginenya dan menggabungkan dengan aplikasi visual lainnya seperti Visual Basic, dsb. Access 2007 merupakan dipenyempurnaan dari access 2003. Berikut ini kita akan mencoba membuat database sederhana untuk keperluan akuntansi. Untuk membuat aplikasi database akuntansi tentu diperlukan banyak tabel, query, dan report yang harus dipersiapkan. Apalagi jika akuntansi untuk perusahaan dagang, dan manufaktur. Untuk lebih memudahkan bagi pemula yang ingin belajar membuat aplikasi dengan menggunakan Microsoft office access 2007, maka disini saya akan mencoba membahas aplikasi database akuntansi sederhana untuk perusahaan jasa. dalam menyusun suatu database tentu sebelumnya kita harus menyusun normalisas...

The Current Ratio

The Current Ratio The current ratio is also known as the working capital ratio and is normally presented as a real ratio. That is, the working capital ratio looks like this: Current Assets: Current Liabilities = x: y eg 1.75: 1 The Carphone Warehouse is our business of choice, so here is the information to help us work out its current ratio. Consolidated Balance Sheet 31 March 2001 25 March 2000 £'000 £'000 Total Current Assets 315,528 171,160 Creditors: Amounts falling due within one year 222,348 173,820 As we saw in the brief review of accounts section with Tesco's financial statements, the phrase current liabilities is the same as Creditors: Amounts falling due within one year . Here's the table to fill in. OK, so we've done this one for you! Current Ratio For the Carphone Warehouse 31 March 2001 Current Assets: Current Liabilities 315,528: 222,348 1.42: 1 25 March 2000 Current Assets: Current Liabilities 171,160: 173,820 0.98: 1 Math...