Purchase Solution

Determining Year-to-Year Percentage Growth

Not what you're looking for?

Ask Custom Question

Answer questions 1 and 2 below based on the financial data attached.

1) 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 will hit 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 can hit this target.

2) Next, consider Micro Chip's Consolidated Statement of Operations for the year ended September 25, 2008
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, 2007 through September 25, 2008. 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?

Purchase this Solution

Solution Summary

Response provides the steps to compute year-to-year percentage annual growth in total net sales, properly formatted in the attached Excel spreadsheet.

Solution Preview

We will also calculate CAGR of 2004-08= (Ending Value/Beginning Value)^(1/number of years)-1

=(8334/11062)^(1/4)-1

-6.83%

http://www.investopedia.com/terms/c/cagr.asp. It is a snapshot of the page as it appeared on 24 Apr 2009 00:15:06 GMT.

Comments:
I feel that the company can achieve the target of 10% inspite of CAGR of last 4 years is in negative -6.83%.
I am hopeful because there has been revival in performance in the last year and the company has grown 35.71% in 07-08.
Hence it can achieve ...

Purchase this Solution


Free BrainMass Quizzes
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.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.