Purchase Solution

Analyze Annual Growth in Past Sales and Forecast Next Year

Not what you're looking for?

Ask Custom Question

See attached files.

Determine the year-to-year percentage annual growth in total net sales.

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.

Use the Percentage Sales Method and a 20% 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 2% of the new sales figure.

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.

Guidelines:

The financial statements and consolidated statement of operations will be attached.
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.
The submitted assignment must include the following:

A double-spaced Word document 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 Microsoft Excel data table(s) along with an explanation of how you arrived at your answers if applicable.

Attachments
Purchase this Solution
Solution Summary

The solution analyzes annual growth in past sales and forecast for next year.

Solution provided by:
Elisa Valdez, PhD
Education
  • Bachelor of Science in Business Administration, University of the Philippines
  • Master in Business Administration, Saint Mary's University
  • Doctor of Philosophy in Education, University of the Philippines
  • Doctor in Business Adminstration (IP), Polytechnic University of the Philippines
Recent Feedback
  • "Excellent information thanks for the input"
  • "Thank you"
  • "Very thorough and informative. Thank you."
  • "Good response. Very detailed"
  • "This solution is excellent. Thank you"
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Sales Trend Analysis

    Simply repeat this with 10 instead of 5 for the 10-year forecast. The expert examines a sales trend analysis. A company's growth rate in sales is determined.

  • 5-year forecast of Net Income

    394753 financial statement spreedsheet Prepare a 5-year forecast of Net Income using the data provided for the base year and the following anticipated annual changes; * Annual growth in sales is forecasted at 12% per year * Annual growth in

  • Forecasting and Demand

    Forecast sales for each of the next years. 1st year: 100,000 x 1.08=108,000 2nd year: 108,000 x 1.08=116,640 3rd year: 116,640x 1.08=125,971.20 B) If sales in 2004 were $60,000 and they grew to $100,000 by 2008 (a four year period), what was the

  • Economic Forecasting; Year-to-Year Percentage Growth

    377421 Year-to-Year percentage of growth in sales; forecast Micro Chip's statement of operations See attached files. 1. Determine the year-to-year percentage annual growth in total net sales. 2.

  • Apple Computers: Questions on Financial statements

    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 will hit its sales goal of +20% annual revenue growth in 2000?

  • Sales growth/percentage of sales method

    366370 Micro Chip Computer: Annual sales growth; forecast using percentage sales method See attached file. Determine the year-to-year percentage annual growth in total net sales.

  • Forecast for a time series with trend and seasonal factors

    Use time series decomposition to forecast quarterly sales for the next year. The following table shows the past two years of quarterly sales information.

  • Pro-forma Statements

    Current industrywide annual sales were estimated at $5 billion, with annual growth rates modestly estimated to range between 30 percent and 50 percent for the next 10 years.

  • Percentage of Sales

    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 will hit its sales goal of +10% annual revenue growth in 2005?

View More Related Solutions