Reference no: EM131406260
Financial Assignment
Use number 1 attachment financial statements for Micro Chip Computer Corporation. 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 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. Use number 2 attachment for these 2 questions.
1. Use the Percentage Sales Method and a 25% 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.
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 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:- Data.rar
|
Commit to buy a vacation home in the climate of your choice
: Using net present value calculations, determine which has a higher ROI. Assume the average mileage under both options is 15,000 miles. The car will be sold for its Kelly Blue Book value at the end of ownership or it will be returned to the leasing..
|
|
Employee sabbatical benefits others at little tokyo service
: In the Case Study link under Module Activities, develop a 500- to 800- word (2-3 page) case study analysis that addresses the case study "HR IN SMALL BUSINESS: Employee Sabbatical Benefits Others at Little Tokyo Service Center," found on pages 445..
|
|
Differences between a virtual and traditional organization
: What are some of the major differences between a virtual and traditional organization? Are there any beneficial elements within a virtual organization that could give them an advantage in today's global market?
|
|
Estimate the heat generated in the weld zone
: Two flat copper sheets (each 1.0 mm thick) are being spot welded by the use of a current of 7000 A and a current flow time of 0.3 s. The electrodes are 4 mm in diameter. Estimate the heat generated in the weld zone. Assume that the resistance is 2..
|
|
Determine year-to-year percentage annual growth in net sales
: 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?
|
|
Riskiness of projects in health care organizations
: Diagnose the key factors which can influence the riskiness of projects (investments) in health care organizations. Justify your response.
|
|
Write a paper on computer policies
: Write a paper on computer policies and why they are important. U.S. Compliance Laws should be mentioned in the paper. In addition to the 4-6 pages of the paper itself, you must include a title page and a reference page
|
|
Major concerns regarding us energy policy
: (1) Identify at least three major concerns regarding US energy policy. What are our vulnerabilities and challenges?
|
|
Develop a foundational understanding of employment law
: Employers must commit to managing unfairness and inequality among its employees, but if these workplace issues arise, they are commonly handled by HR departments and at times, attorneys who can also be a part of the investigative process. For this..
|