--%>

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 : Describe JOC in accounting Describe JOC

    Describe JOC in accounting?

  • Q : Determining interest rate parity

    Presently, spot exchange rate is $1.50/£ and three-month forward exchange rate is $1.52/£. Three-month interest rate is 8.0% per annum within the U.S. and 5.8% per annum within the U.K. Suppose that you can borrow as much as $1,500,000 or £1,000,000.

  • Q : Case study of gene expression analysis

    The paper by Golub et al. that was the focus of the second part of the BioConductor practical was the first analysis of its kind, demonstrating that gene expression analysis could potentially be used to classify leukaemia sub-types. Since its publication in 1999 there

  • Q : Advanced Accounting-Consolidated

    I have worked the problem. I need to know if it is correct. If not, what I'm missing.

  • 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 : Claim depreciation When an asset is

    When an asset is purchased and the similar is not employed for the financial year, must the company charge the depreciation and the reason for the similar?

  • Q : Pricing spill-over effect Discuss

    Discuss pricing spill-over effect.

  • Q : Firms attaining the U.S. firms

    Presently, several foreign firms from both the developed and developing countries attained high-tech U.S. firms. What would have motivated these firms in order to attain the U.S. firms?

  • Q : Flexible and fixed budgets Give a brief

    Give a brief contrast between flexible and fixed budgets?

  • Q : Performing the capital budgeting

    Explain difference between performing the capital budgeting analysis from the parent firm’s perspective as opposed to the project perspective.