Reference no: EM131407353
Accounting and Forecasting
Download the selected financial statements for Micro Chip Computer Corporation. Answer questions 1 and 2 below based on the financial data.
1. Determine the year-to-year percentage annual growth in total net sales.
2. Based only on your answers to question #1, do you think the company achieved its sales goal of +10% annual revenue growth in 2009? Determine the target revenue figure, and explain why you do or do not feel that the company hit its target.
Next, consider Micro Chip's Consolidated Statement of Operations for the year ended September 25, 2008. Download the file here and answer questions 1 and 2.
1. Use the Percentage Sales Method and a 25% increase in sales to forecast Micro Chip's Consolidated Statement of Operations for the period of September 26, 2008 through September 25, 2009. Assume a 15% tax rate and restructuring costs of 5% of the new sales figure.
2. Discuss your results from question number #1. What assumptions have you made? Do any of your assumptions seem unreasonable?
To receive full credit on this assignment, please show all work, including formulae and calculations used to arrive at the financial values. Students using Microsoft Excel must provide an adequate explanation of the methodology used to arrive at that answer.
Assignment Guidelines
• Download the financial statements and consolidated statement of operations by clicking on the links above in the assignment description.
• Analyze the statements and then answer the four questions listed in the assignment description.
• Show all work including calculations and formulas. If applicable, provide a detailed explanation of how you used Microsoft Excel to arrive at your answers.
• Organize your answers, mathematical calculations, and Microsoft Excel data into a Word document of 1-2 pages.
Your submitted assignment must include the following:
• A double-spaced Word document of 1-2 pages that contains your answers to the four questions listed in the assignment description, any calculations you performed, and all formulae that were used. Also, provide your Excel data table(s) along with an explanation of how you arrived at your answers if applicable.
Attachment:- Data.pdf
|
Calculate the firm''s estimated free cash flow
: Calculate the firm's estimated free cash flow
|
|
Proportion of community college males live athome
: According to asurvey, 52% of males between the ages of 18 and 24 lived at home in 2005(unmarried college students living in dorms are counted as living athome). A survey is administered at a community college to 19 randomly selected male students ..
|
|
Should the company revise its current dividend policy
: Historically the company has made profits in the range $-20 million to $25 million per year the last decade. The company has needs for making large investments in emerging markets. Should the company revise its current dividend policy?
|
|
Arrest or exceptional means
: According to a survey,62%of murders committed last year were cleared by arrest or exceptional means. Fifty murders committed last year are randomly selected, and the number cleared by arrest or exceptional means is recorded.
|
|
Determine the year-to-year percentage annual growth
: Determine the year-to-year percentage annual growth in total net sales. Determine the target revenue figure, and explain why you do or do not feel that the company hit its target.
|
|
What do you envision as the future of public health
: What do you envision as the future of Public Health? If you could make an impact upon a single aspect of public health, what aspect would that be, and what would your strategy be
|
|
What were the specific strategies and tools
: How did various stakeholder groups influence the final outcome of Medicare Part D legislation? What were the specific strategies and tools that were used most effectively
|
|
Consider the series verge
: Let an = 4 - n12 does this sequence converge to a limit. If so what is that limit and show that the sequence does converge to the limit in according to the definition on page 4 in section 10.1. P ∞ 1 (3) Let an = n1.003 n=1 an . Does the series co..
|
|
Create a sequence diagram and a communication diagram
: Create a sequence diagram.- Create a communication diagram.- Create a behavioral state machine diagram.- Perform a CRUD analysis.
|