Percentage of Sales method
Not what you're looking for?
The attachments include a project I am having difficulty putting together. Unfortunately I am not a guru with finance. However, the 2nd file includes a financial statement for the first part of the question and the 3rd file is for the 2nd portion.
My question is how do I configure what calculations to add? For example; what am I looking for to determine the year to year percentage annual growth in total net sales? Honestly, I don't even know where to begin.
Help!
For selected financial statements for Micro Chip Computer Corporation click here . 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 will hit its sales goal of +10% annual revenue growth in 2005? Determine the target revenue figure, and explain why you do or do not feel that the company can hit this target.
Next, consider Micro Chip's Consolidated Statement of Operations for the year ended September 25, 2004 (click here to download) and answer questions 1 and 2.
1. Use the Percentage Sales Method and a 20% increase in sales to forecast Micro Chip's Consolidated Statement of Operations for the period September 26, 2004 through September 25, 2005. Assume a 15% tax rate and restructuring costs of 2% 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 financial values. Students who are using Excel must provide an adequate explanation of the methodology used to arrive at that answer
Purchase this Solution
Solution Summary
The solution explains the use of percentage of sales method to forecast the income statement for Microchip.
Solution Preview
1. Determine the year-to-year percentage annual growth in total net sales.
The year-to-year percentage is calculated by the following formula (Year2-Year1)/Year1 and the figure as a percentage. The calculation are in the attached file.
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? Determine the target revenue figure, and explain why you do or do not feel that the company can hit this target.
The target revenue figure comes to 9,167.4. In order to answer this, we need to look at the growth rates in the previous years. In 2002 ...
Purchase this Solution
Free BrainMass Quizzes
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
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.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.