Determine the year-to-year percentage annual growth

Assignment Help Financial Management

Reference no: EM131950295

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. The file to use in answering questions 1 and 2 is ATTACHED.

Use the Percentage Sales Method and a 30% 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.

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:- Financial Table.rar

Reference no: EM131950295

Questions Cloud

What benefits does schaffer hope to achieve : What benefits does Schaffer hope to achieve from outsourcing its IT infrastructure and Describe the steps taken to develop the RFP and the role that an outside

The duration of two-year bond that pays annual coupon : What is the duration of a two-year bond that pays an annual coupon of 10 percent and has a current yield to maturity of 12 percent?

Is following schedule conflict serializable : Is following schedule conflict serializable? If YES then give the serial schedule.

Discuss issues of regulation and compliance : If that person comes into his office for a service, he will give an additional 5% of the Medicare-billable amount to the FEMA inspector making the referral.

Determine the year-to-year percentage annual growth : Determine the target revenue figure, and explain why you do or do not feel that the company hit its target.

Thinking about starting business : If you currently own a business or are thinking about starting a business. What was the stock’s return for the missing year?

Number of times the interest : Write a program that asks for the principal, the interest rate, and the number of times the interest is compounded.

Determining the distributed database : Draw wait for graph for following history. Is following history conflict serialize-able? If yes then give an equivalent serial history.

Evaluate the effectiveness of communication of given company : Evaluate the effectiveness of the communication of Geico's total rewards program based upon the Website's descriptions of the benefits.

User Account

All Pages