• 100% Satisfaction Guarantee

F. Naz, Chartered Accountant
Category: Homework
Satisfied Customers: 5170
Experience:  Experience with chartered accountancy
20040807
F. Naz is online now

### Customer Question

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 acheived 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. Download the file here and answer questions 1 and 2.

Use the Percentage Sales Method and a 20% 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 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?
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.
Submitted: 4 years ago.
Category: Homework
Expert:  F. Naz replied 4 years ago.
Customer: replied 4 years ago.

 Fiscal Years 2008 2007 2006 2005 2004 (in millions except shares and per share amount) 0 0 0 0 0 Net sales \$ 8,334.00 \$ 6,141.00 \$ 9,181.00 \$ 11,933.00 \$ 11,062.00 net income (Loss) \$ 811 \$ 519 \$ (1,245) \$ (995.00) \$ 424.00 Earnings (loss per common share: 0 0 0 0 0 Basic \$ 5.65 \$ 3.84 \$ (9.15) \$ (6.89) \$ 3.50 Diluted \$ 4.64 \$ 3.07 \$ (9.15) \$ (6.89) \$ 3.45 Cash Dividends delcared per common share 0 0 0 \$ 0.12 \$ 0.48 Shares isned in computing earnings(loss) Per share (in thousand) 0 0 0 0 0 Basic \$ 143,500 135,00 \$ 136,000 \$ 144,500 \$ 121,192 Diluted \$ 174,900 169,00 \$ 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

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

I need this by midnight tonight..

I have tried so many ways and this one has stumped ,,,

Expert:  F. Naz replied 4 years ago.

Have a nice day

Please do not hesitate to ask further and if you are satisfied do not forget to click on ACCEPT button so I get paid for my efforts, thanks
F. Naz, Chartered Accountant
Category: Homework
Satisfied Customers: 5170
Experience: Experience with chartered accountancy
Customer: replied 4 years ago.
I cant open your solution,, to have have to click accept answer before I can open it
Expert:  F. Naz replied 4 years ago.

I am again sending the solution, thanks.
Expert:  F. Naz replied 4 years ago.

You need to spend \$3 to view this post. Add Funds to your account and buy credits.
Customer: replied 4 years ago.

I got it,,.. Thank you so much. Have a great weekend

Expert:  F. Naz replied 4 years ago.
Thanks and take care.
Customer: replied 4 years ago.
• Find an estimate of the risk-free rate of interest (krf). To obtain this value, go to Bloomberg.com: Market Data and use the "U.S. 10-year Treasury" bond rate (middle column) as the risk-free rate. In addition, you also need a value for the market risk premium. Use an assumed market risk premium of 7.5%.
• Using the information from the XYZ Stock Information document, record the following values:
• XYZ's beta (ß)
• XYZ's current annual dividend
• XYZ's 3-year dividend growth rate (g)
• Industry P/E
• XYZ's EPS
• With the information you recorded, use the CAPM to calculate XYZ's required rate of return (ks).
• Use the CGM to find the current stock price for XYZ. We will call this the theoretical price (Po).
• Now use the XYZ Stock Information to find XYZ's current stock quote (P). Compare Po and P and answer the following questions:
• Are there any differences?
• What factors may be at work for such a difference in the two prices?
• Now assume the market risk premium has increased from 7.5% to 10% and this increase is due only to the increased risk in the market. In other words, assume the krf and the stock's beta remain the same for this exercise.
• What will the new price be? Explain.
• Recalculate XYZ's stock price using the P/E ratio model and the needed info found in the XYZ Stock Information file.
• Why is the present stock price different from the price arrived at using CGM (Constant Growth Model)?
• If you used Microsoft Word to arrive at your answers, then you must provide an explanation of the formulas and calculations.

Your submitted assignment (125 points) must include the following:

• A double-spaced Word document of 2-3 pages that contains the following:
• All of the numerical values listed in the assignment guidelines.
• The formulas and calculations that you used to arrive at your answers
• You must include your explanation of how you used Microsoft Excel for your calculations if applicable.

XYZ Stock information

Expert:  F. Naz replied 4 years ago.

You need to spend \$3 to view this post. Add Funds to your account and buy credits.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Previous | Next >
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
• He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX

• ### LogicPro

#### Satisfied Customers:

4925
Expert in Java C++ C C# VB Javascript Design SQL HTML
< Last | Next >

### LogicPro

#### Satisfied Customers:

4925
Expert in Java C++ C C# VB Javascript Design SQL HTML

### Manal Elkhoshkhany

#### Satisfied Customers:

4538
More than 5000 online tutoring sessions.

### Linda_us

#### Satisfied Customers:

3138
Post Graduate Diploma in Management (MBA)

### Chris M.

#### Satisfied Customers:

2602
Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

### F. Naz

#### Satisfied Customers:

2126
Experience with chartered accountancy

### Bizhelp

#### Satisfied Customers:

1887
Bachelors Degree and CPA with Accounting work experience