Purchase Solution

# Micro Chip Computer - year-to-year percentage annual growth

Not what you're looking for?

Hello out there,

Can someone please assist me with figuring out the solution to the assignment below and what formulas do I use to solve the problem in Excel format. I must provide an adequate explanation of the method I used to get to my answers

I have attached the financial statement for the Micro Chip Computer Corporation and the statement for Micro Chip's Consolidated Statement of Operations for the year end:

ASSIGNMENT:

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

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.

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?

##### Solution Summary

**Attached is the step by step solution**

Solution provided by:
###### Education
• Chartered Accountant (Equivalent to CPA in US), Institute of Charted Accountants of India
• Bachelor of Commerce, West Bengal University
###### Recent Feedback
• "I got this feedback and I wanted to know if you can explain it to me. I noticed something within your workings which I believe is incorrect.  It looks like you've mistaken the Debt ratio for the Equity Multiplier.  You've done a calculation to determine Return on Equity (ROE) but if you take a look at the ratios provided for us you'll see ROE listed on the bottom line already.  You can use ROE, Profit Margin and Total Asset Turnover to figure out the Equity Multiplier amount.  Equity multiplier is not provided for us and we need to calculate it.  I really hope this is helpful to you.  "
• "Very attentive to detail. Answers are designed in easy to understand format."
• "Fast response and thorough answer"
• "thank you very much! "
• "thank you so much !!!!!!!"

##### Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

##### 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.