--%>

Calculating Dixons Retail plc in Accounting

Assignment

Mina Patel has seen attractive advertisements for Dixons Retail plc and its UK-based brands. She is also aware of the intense competition between retailers of electronic and electrical goods, at a time of global economic uncertainty. Mina has recently inherited several thousand pounds and has started building a portfolio of investments, and she seeks your advice on whether or not to buy shares in the company.

She has provided you with the following summarised information taken from the Annual Report and Accounts 2011/12 of Dixons Retail plc, for the 52 weeks ended 28 April 2012 and 30 April 2011.

1098_Untitled1223.png

* Assume that all sales and purchases are made on credit rather than by cash payment.

Note that figures are extracted from the consolidated financial statements of the Group.

The share price of Dixons Retail plc in April 2012 is £0.18 per share (£0.11 pence in 2011) and it has been around this level for the past few months (note: the current value of shares might be different at the time of completing this assignment). The retail association to which Dixons Retail plc belongs compiles ratios taken from the annual accounts of its members, and from other sources, and you have obtained the following recent industry averages for some key ratios:

  1. gross profit margin - 15%
  2. current ratio - 2.05 times
  3. acid test ratio - 1.10:1
  4. average settlement period for trade receivables - 20 days
  5. average inventories turnover period - 30 days
  6. gearing ratio - 55%
  7. price/earnings ratio - 10 times

(a) Calculate the above ratios 1-7 for Dixons Retail plc for the 2012 and 2011 periods. Show how you have arrived at your answers, so your tutor can provide specific feedback if errors have been made. (15 marks)

(b) Comment on how the company's overall performance compares to the average for its industry, pointing out any significant features, assumptions and limitations of the information used to analyse the company's performance. (30 marks)

(c) On the basis of the data available, what advice would you give to Mina Patel about investing in shares in Dixons Retail plc? In compiling your advice, comment on the differential risks and returns investors may expect from investing in shares as opposed to bank deposit accounts. What further information, in addition to the financial information in question (a), would you advise Mina Patel to seek before she makes her decision about investing in the shares of Dixons Retail plc? (30 marks)

Guideline length: 1500 words.

For (a) it is essential to treat ratio analysis with caution and to understand the basis of calculations and the nature of the data used. In this assignment sufficient information has been made available to you to compare and interpret the ratios of Dixons Retail plc and industry averages. Marks will be awarded for the correct calculation of each of the seven ratios, and provided you show how you have arrived at your answers your tutor will be able to reward correct calculations and explain what you should have done if parts of the answers are incorrect.

For (b) the key approach is to ask yourself 'What value do we expect for each ratio? What might any apparent trends over time signify? What is relatively "good" or "poor" performance for each ratio?' You should explain any assumptions that you have made and give your interpretation of the similarities and differences between Dixons and the industry average.

You will see from the learning outcomes that what is required is application of module concepts, a clear account of your analysis and relevant conclusions. Your own interpretation of the relative performance of Dixons might be influenced by your wider knowledge of the company or industry sector, but your tutor will not be expecting students to have 'inside knowledge' in order to give an excellent answer here.

For (c) you should think about how factors affecting the value of publicly owned companies are included in the kinds of financial statements you met in Session 41. Ask yourself 'What additional information would be useful for interpreting the company's performance?' In thinking about the likely future performance of the company you could draw on the bigger picture, such as news about competitors or your impressions about the company's management gained from the case study materials

Many people today invest in a personal share portfolio, and in answering this question it is important to consider the sorts of information relevant to an individual like Mina Patel. Other shareholders such as pension schemes and managers of short-term investment funds will probably consider different factors. Again, it is important to specify any assumptions you make, for example about Mina's priorities, or economic or technological environmental factors affecting company performance. (You should note that that in reality one might not make a share purchase decision in February based on information about the year to the previous April.)

 

 

 

 

 

   Related Questions in Financial Accounting

  • Q : Income Tax and Investment Calculator

    Introduction Your task is to produce a Java program, which can calculate income tax and investment growth based on the yearly income/salary of an individual. Below the details are descr

  • Q : Define Income Statement How to do

    How to do income statement = from the revenues we will deduct all the expenses related to that period to get the income or loss. When the revenues are more than the expenses then it is income and when the expenses are more than the revenues then it is

  • Q : Uncertainty in dollar/franc exchange

    Suppose that your company has an equity position within the French firm. Explain some of the condition under which the dollar/franc exchange rate uncertainty does not have the exchange exposure for your company.

  • Q : Meaning of Goodwill Meaning of Goodwill

    Meaning of Goodwill: Goodwill puts the association at a good position due to which the organization is capable to earn huge profits without any additional efforts. Goodwill can’t be seen although felt. Thus goodwill is termed as an Intangible as

  • Q : A technically oriented software design

    Design: For this assignment you are to produce, one per group, a technically oriented software  design document. As the scope of the project is quite small and basically encompasses an extension to an existing

  • Q : Hedging transaction exposure and money

    Compare and discuss the hedging transaction exposure by using the forward contract vs. money market instruments. When the optional hedging approaches do creates the same result?

  • Q : Rule of nominal account Why the rule of

    Why the rule of nominal account is just opposite with the rule of personal account and real account?

  • Q : Parallel and back-to-back loan

    Distinguish between the parallel loan and the back-to-back loan.

  • Q : Architectural Symbolism-house-style

    Wriet a report on the term Architectural Symbolism:a study of house-style meanings ?

  • Q : Drawback of Electronic Funds Transfer

    What are the drawback of Electronic Funds Transfer?