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

    This also reflects the bonus. F). This task involves me looking at a situation that occurred in the recent years and how the business and stakeholders dealt with it. The most recent one that happened in ASDA was the WAL-MART takeover.

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

    And know how external factors in the business environment impact on organisations. Section 1 I will see therefore that the businesses environment consists of all those things outside the businesses. The businesses need to keep a watchful eye on the environment because it is continually changing, to assist in this process they might use PEST analysis.

  1. BMW PEST Analysis

    Also, it has been proven that people are getting richer as their investments in businesses are growing. This will increase customer purchase power, which the customer can decide whether or not to have a BMW. If the customer decides to buy one this will increase sales and promote BMW to expand its product range even further.

  2. Introduction to J Sainsbury plc

    Judgement 8 Sainsbury's Supermarkets joined a groundbreaking partnership, between leading businesses in London, environmental groups and government to launch think about London, the Ford Motor Company's innovative sustainable mobility initiative: "The scheme will see Ford's quiet and clean Think City electric cars on London's streets a year before they become generally available to the public".

  1. Business report on J Sainsbury's.

    They also reinvested some of their cost savings in price adjustments. Alongside this they are continuously running a highly attractive, sustainable promotional programme. J Sainsbury's has been making great strides in retaining their colleagues to serve their customers better. The business has replaced their legacy system with 'best in class' IT solutions to help them gain competitive advantages.

  2. Interpretation of Financial Statements.

    then the analyst should be concerned. Although there may be a genuine business reason for the discrepancy, the analyst should certainly further explore the reasons for the difference. As well as comparing ratios in the same firm over successive years, it is also desirable to compare ratios against similar businesses

  1. Business development

    Objectives An objective helps to set targets to achieve an aim. Pink Ladies objectives are: * Maximum sales- This helps me achieve my aim of getting maximum profit as the more sales the more profit I will get. I will do this by advertising Pink Ladies and making sure I

  2. Applied Business. Investigating a business Preston Manor High School

    This objective is met because better teaching quality means better results and the school is improving on their results every year. 2. To improve support for learning and so academic success and personal development for all students, they will: 1 ? Strengthen pastoral support and social inclusion polices, and promote good behaviour and high motivation.

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