• 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)

    if the prices were to low, not enough profit will be made and the business will have to close down. Consumers/customers always look for the lowest possible prices and aim to get their moneys worth and most prefer quality over quantity.

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

    for dealing with the payment of wages * Who should be responsible in Microsoft for making sure that the IT systems in an organisation are working smoothly There are integers of ways of structuring an organisation: Functional: Functional structure is probably the most common way of grouping employees.

  1. How successful is Cathay Pacific Airline

    poll twice in the past three years - a remarkable achievement by any measure. In this year's poll, they've also won the "Best Airline Asia," "Best First Class" and "Best First and Business Class Lounges" awards.

  2. Introduction to J Sainsbury plc

    "We continue to focus on quality service and price". (Source: www.j-sainsbury.co.uk) This is a significant achievement for Sainsbury's Group because they are now able to provide customers with certain products at reduced prices. This will enable Sainsbury's to increase their sales and improve on financial performance and clearly demonstrates that Sainsbury's have successfully achieved their objective of good value for money, by price reductions.

  1. Tesco financial review

    do not rely on to much cash sales, to reinvest in their businesses. For example if Tesco do not plan for the future and think expect to make a lot of money in the next 6 months and business progresses slowly, employees may need to be fired of to cover the sudden drop in profits and inflows.

  2. Business report on J Sainsbury's.

    Underlying profit before tax changed by 14.2% and the profit before tax changed by 30.7%. On February 2001 Sainsbury's supermarkets Ltd became the first major food retailer to achieve the corporate accreditation Investors in People. The Investors in People Standard is tried and tested flexible framework that helps UK companies succeed and compete through improved people performance.

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

    As both Marks and Spencer and The House of Fraser are in the retail sector of business, it would be expected that they would have a reasonably high stock turnover. Both companies have seasonal changes in stock, and would expect to have to constantly replace stock.

  2. Comparison of stakeholders interest and influence. Apple vs. Mercedes Benz

    But employees don?t have the same or higher importance as customers or directors, for the simple reason that customers bring business and without customers there would be no business and no money to employee staff. With out directors it would be impossible to direct the company and manage the individual departments.

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