Reference no: EM131300913
Financial Management Paper
The selected financial statements for Micro Chip Computer Corporation. Answer questions 1 and 2 below based on the financial data.
Micro Chip Computer Corporation Selected Financial Data
|
Fiscal Years (in millions except share and per share amounts)
|
2008
|
2007
|
2006
|
2005
|
2004
|
|
Net Sales
|
$ 8,334
|
$ 6.141
|
$ 9.181
|
$ 11,933
|
$ 11,062
|
|
Net Income (loss)
|
$ 811
|
$ 519
|
$ (1.245)
|
$ (995)
|
$ 424
|
|
Earnings (loss) per common share:
|
|
|
|
|
|
|
Basic
|
$ 5.65
|
$ 3 84
|
$ (9.15)
|
$ (9.15)
|
$ 3.50
|
|
Diluted
|
$ 4.64
|
$ 3.07
|
$ (9.15)
|
$ (6.89)
|
$ 3.45
|
|
Cash Dividends declared per common share
|
$ --
|
$ --
|
$ --
|
$ 0.12
|
$ 0.48
|
|
Shares used in computing earnings (loss) per share (in thousands):
|
|
|
|
|
|
|
Basic
|
143,500
|
135,000
|
13,000
|
144,500
|
121,192
|
|
Diluted
|
174,900
|
169,000
|
136,000
|
144,500
|
123,047
|
|
Cash, cash equivalents, and short-term investments
|
$ 5,426
|
$ 4,600
|
$ 3.859
|
$ 3,945
|
$ 952
|
|
Total Assets
|
$ 6,161
|
$ 5,289
|
$ 5,233
|
$ 6,364
|
$ 6,231
|
|
Long-term Debt
|
$ 300
|
$ 954
|
$ 951
|
$ 949
|
$ 303
|
|
Shareholders' Equity
|
$ 3,104
|
$ 1,642
|
$ 1,200
|
$ 2,058
|
$ 2,901
|
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. Answer questions 1 and 2.
Micro Chip Computer Corporation
Consolidated Statements of Operations For the period September 26, 2007 through September 25, 2008.
|
Sales
|
$8,334.00
|
|
Cost of Sales
|
$5,458.00
|
|
Gross Margin
|
$2,876.00
|
|
Operating expenses:
|
|
R & D
|
$525.00
|
|
Selling, General, and Administrative
|
$691.00
|
|
In-process R & D
|
---------
|
|
Restructuring costs
|
---------
|
|
Total Operating Exp
|
$1,216.00
|
|
Operating income
|
$1,660.00
|
|
Total interest and other Income net
|
$194.00
|
|
Income before provision for Income taxes
|
$1,854.00
|
|
Provision for income Taxes (15%)
|
$278.10
|
|
Net income
|
$1,575.90
|
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.
|
Functions should the website perform
: 1. What Internet business model would be appropriate, and what functions should the website perform (what do you want the website to be used for)? 2. What domain name would you want for this site, and which company would you use for web hosting?
|
|
What are their nomnal yield to maturity
: A firm's bond's have a maturity of 10 years with a $1,000 face value, an 8 percent semiannual coupon, and currently sell at a price of $1,100. what are their nomnal yield to maturity.
|
|
Do you expect to retire at a certain age
: Do you expect to retire at a certain age? How much preplanning will you need to do? Do you expect to retire to a life of leisure, volunteer activity, new career, and so on?
|
|
Formation of the partnership
: Amy and Lester are partners in operating a busy hardware store on Main Street in a large town. Without consulting Amy, Lester enters into a contract to purchase $50,000 of merchandise for the store. Discuss how Amy could have protected herself at the..
|
|
Compute year-to-year percentage annual growth in total sales
: Determine the year-to-year percentage annual growth in total net sales. Discuss your results from question number #1. What assumptions have you made? Do any of your assumptions seem unreasonable?
|
|
Analyze the development of a character in a book or film
: PSYC1323: Developmental Psychology Analysis Assignment. Goal: Using Developmental Theory & Concepts to Analyze the Development of a Character in a Book or Film
|
|
Application of public sector communication strategies
: Additionally, in this assignment you should analyze how employing the public sector communication strategies you selected affects public sector accountability and responsiveness.
|
|
What is debt-to-capital ratio
: Bartley Barstools has a market/book ratio equal to 1. Its stock price is $14 per share and it has 5 million shares outstanding. The firm's total capital is $100 million and it finances with only debt and common equity. What is its debt-to-capital rat..
|
|
If the changes are made what will be its return on equity
: Midwest Packaging’s ROE last year was only 3 percent, but its management has developed a new operating plan that calls for a total debt ratio of 50 percent, which will result in annual interest charges of $300,000. Management projects an EBIT of $1,0..
|