• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Ratio Analysis Fiscal 2005 was another successful year for Amstrad by any measure

Extracts from this document...

Introduction

CONTENTS PAGE 2 Shareholder Letter 3 Ratios Calculations 6 Balance Sheet 2004 Formulas 8 Balance sheet 2005 Formulas 9 Profit and Loss Account 2005 Formulas 10 Cash Flow Statement Formulas 11 AMSTRADS ACCOUNTS 13 SCREEN PRINT OF SPREADSHEET MAIN MENU 19 Shareholder Letter Dear Mr. Wall Fiscal 2005 was another successful year for Amstrad by any measure, as we continued to outdistance the competition and solidify our leadership in each of our major businesses. Customers around the world continue to benefit from our innovations, while our development of new technologies will position the company for future growth. With healthy demand across all our customer segments and channels, 2005 revenue increased above �45 million to a record �102,513 000. Operating income increased by 84 percent from �15,152,000 in 2004 to 17,904,000 in 2005. Meanwhile, Sales have almost doubled this year but the gross margin reduced reflecting our competitive pricing to secure large volume orders. We reported a profit before tax of �19.1m (2004: �15.6m) on sales of �102.5m (2004: �57.4m). The earnings per share were 16.9p (2004: 14.6p) We increased our annual investment in research and development by 96 percent from 2004 (2432m) to 2005 (2513m) As is customary in the consumer electronics industry, there is consistent demand for price reduction as existing models mature. Our experienced team continue to focus on cost reduction through re engineering, component price and manufacturing cost reductions. ...read more.

Middle

The product will be sold on-line through a dedicated website. This new but controlled venture takes the Group into the growing consumer electronic healthcare market, one which dependent on the success of this venture has a lot of potential for the introduction of other products. The product has been designed and produced to take into account other World markets. Dependent on the success of the UK launch, we plan to roll the product out to other European and World markets. (www.amstrad.co.uk) Amstrad accomplished a great deal during its 21st year. Our people understand that and are justifiably proud. However; we see fiscal 2005 as simply the first of our next 20 years. We see our obligation to clients growing every day. And we see extraordinary opportunity for Amstrad and its stakeholders, through existing and new customers, products and services. The future holds great challenge and promise for Amstrad. While we approach our future respectfully, we also do so confidently. It's a view we like very much. And our intention is to fully realize what it offers over time. So we begin 2006 with confidence that we can build our future on a foundation of strength and also have developed leaders that will take us into a future of boundless possibilities. It is challenging, but it is exciting. And we are up to the challenge. In conclusion, as outlined above, this year has seen very significant sales of standard and PVR set top boxes. ...read more.

Conclusion

Corporation Tax 40 Net Profit after Tax =(D19-D20) Dividends - Paid 14 - Proposed 31 Net Profit =(D21-D22) Cash Flow Statement Formulas Operating Activities �000 �000 Net Cash inflow from Operating Activities =C39 Return on Investment and Servicing of Finance Less Interest Paid ='P and L Account'!D18 Interest Received ='P and L Account'!D11 =(B9-B8) Taxation Less Corporation Tax =('Balance Sheet'!D24-'Balance Sheet'!I24)+('P and L Account'!D20) Capital Expenditure and Financial Investments Less Payments to acquire intangible Fixed Assets ='Balance Sheet'!K7-'Balance Sheet'!F7 Less Payments to acquire tangible Fixed Assets =('Balance Sheet'!I9-'Balance Sheet'!D9) =SUM(B15:B16) Equity Dividends Paid Less Dividend Paid During year =('Balance Sheet'!D25-'Balance Sheet'!I25)+('P and L Account'!D22+'P and L Account'!D23) Net Cash before Financing =(C5+C9-C12-C16-C19) Financing Proceeds from Issue of Ordinary Shares =('Balance Sheet'!K35+'Balance Sheet'!K34)-('Balance Sheet'!F35+'Balance Sheet'!F34) Issue of Long term Borrowing =('Balance Sheet'!K30-'Balance Sheet'!F30) =SUM(B24:B25) Decrease in Cash =(C20+C25) � 0 0 0 Reconciliation of Operating Profit to net Cash inflows from Operating Activities Operating Profit ='P and L Account'!D17 Interest paid ='P and L Account'!D18 Interest Received ='P and L Account'!D11 Depreciation ='Balance Sheet'!J9-'Balance Sheet'!E9 Increase in Stock ='Balance Sheet'!J17-'Balance Sheet'!E17 Increase Debtors ='Balance Sheet'!J18-'Balance Sheet'!E18 Decrease in Creditors ='Balance Sheet'!I23-'Balance Sheet'!D23 Net Cash Flow from Operating Activities =(C32+C33-C34+C35-C36-C37+C38) Reconciliation of net Cash to movements in net debt �0 0 0 Cash as at 31 December 2005 ='Balance Sheet'!J19 Cash as at 31 January 2004 ='Balance Sheet'!E19 Net Debt =(B43-B44) SCREEN PRINT OF SPREADSHEET MAIN MENU The above shows the macro codes used. ?? ?? ?? ?? Page 1 of 12 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Structures, Objectives & External Influences section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Structures, Objectives & External Influences essays

  1. Marked by a teacher

    ASDA's Ownership

    4 star(s)

    It was first considered a dangerous move, as ASDA didn't realise how much they were loosing and then started to fall into debt. WAL-MART then saw this as an opening into the British business industry and bought ASDA for �7 Billion in 1999.

  2. How successful is Cathay Pacific Airline

    Total Revenue (HK$M) Market Shares (2d.p.) 25,243 23,884 94.62% Brand Recognition Cathay Pacific Airways is a well know brand all round Asia or even the whole world. It is definitely well know with in the industry. Cathay Pacific Airways had been voted Airline of the Year in the Skytrax passenger

  1. Btec National Business Level 3 Year 1 - Exploring Business Activity

    The government is elected to set policy for agencies. The department for Customs and Revenue works on behalf of the government and is staffed by civil servants, known as customs and revenue officers. Their jobs are to take out income tax and other taxes on behalf of the government, to

  2. Introduction to J Sainsbury plc

    Administrative tasks include dealing with enquiries, communicating messages and producing documents for the workforce. The administrative system can be summarised in the following diagram below: Sales Production Transport Administrative System Personnel Finance Catering/Security Maintenance (Source: Lewis, R. & Trevitt, R.

  1. Business report on J Sainsbury's.

    When managers are concerned with survival they tend to be very cautious and reluctant to take any risks, this can mean that profits stay very low and the policy is self-defeating. In Sainsbury's: As part of surviving, Sainsbury's rigorously monitor 10,000 lines weekly to ensure that they remain competitive.

  2. Tesco financial review

    The table shows that there are nearly 2000 stores in the UK, and that is the expected amount after 2007. There are also 11 other countries were Tesco is an established organisation, mainly throughout Europe and in Asia. Year of entry No.

  1. Interpretation of Financial Statements.

    in the business as an indicator of investment potential and for continuity of trading. It is possible to use ratios to compare successive years of data. Within the same company it is possible to establish a trend pattern over the years.

  2. Report composed of an interpretation of the ratios for Marks and Spencers and the ...

    some 5% down on the steadily rising gross profit on cost % of Marks and Spencer. PRODUCTIVITY Sales per Employee (�) sales = � No of employees This ratio is useful in measuring the productivity of the employees in a business.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work