--%>

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 : Fundamenetal Issues on Management

    1.  Somerset Ltd manufactures components for the motor industry. In one of its workshops it has three workers, Joe, Jack and Jonny, who at any one time work on batches of the same component. The standard time allowed to produce one unit is one hour. The workers rate of pay is

  • Q : REDUMPTION OF DEBENTURS WHAT IS

    WHAT IS REDUMPTION? AND WHAT ARE THE CONDITIONS?

  • Q : Payment method-Buy pound or investing

    When you have visited the London, you have purchased a Jaguar for £35,000, which is payable within the three months. Enough cash is there at your bank in the New York City that pays 0.35% of interest per month, compounding monthly, to pay for car. Presently, spo

  • Q : Merits of Budgetary Control Write down

    Write down the merits of Budgetary Control?

  • Q : Calculation Of IRR Calculation Of IRR :

    Calculation Of IRR: IRR is the rate at which your discounted cash inflow becomes equal to your discounted cash outflow. In other words NPV=0. To determine this following steps are followed:- 1. Determine cash inflo

  • Q : What is Assets in Accounting Assets are

    Assets are those resources that the business owns. Assets are the things of value owned which enable the firm to get cash or befit in future. There are mainly two types of assets: - Current assets & Fixed assets for e.g. cash, f

  • Q : Calculate the bad debt expense for the

    The Webster Company uses the aging method to estimate the allowance for doubtful accounts. The following schedule of accounts receivable was prepared as at December 31, 20x6: Age Balance %

  • Q : Benefit of Electronic Funds Transfer

    Illustrate the benefit of Electronic Funds Transfer?

  • Q : Interference of two light waves Find

    Find and make a graph of the light intensity distribution at the interference between 2 laser beams. The data parameter are : Question Each beam has a equal diameter of 20 micro meter The angle

  • Q : Explain Agricultural business Explain

    Explain the term Agricultural business in term of Accounting?