Determine the market capital structure weights for microsoft

Assignment Help Finance Basics

Reference no: EM131464551

Question: 1. Determine the market capital structure weights for Microsoft?

Weight of Debt=?

Weight of Equity=?

2. Estimate the cost of equity (rf) in two different ways:

(d0) = $0.39, (P0) = $64.90, Find (g) =?, Cost of Equity (using either the constant dividend model or the dividend growth model)= ?

b) Capital Asset Pricing Model

• Download the historical stock price of Microsoft and use Excel to calculate returns?

• Download the historical price of the S&P index to use it as an approximation of market performance. Use the price to find returns.

• Run a regression in which the returns are the dependent variable and the S&P 500 index returns are the independent variable. Estimate beta? Show regression results.

• Find (rf)=? What is the risk-free rate based on? State the source of (rf).

• Assume that the MRP is 6.1%. Using the information above, calculate the cost of equity using the CAPM. Cost of Equity =?

• Based on your different estimates, what do you think the cost of equity is? Cost of Equity=?

3. What is Microsofts WACC? Show the formula and numbers.

4. If Microsoft is considering a new project. At the end of the first year of the project they could earn net operating cash flow of $1 million, $2 million the following year and, $3 million in the last year. If the project requires an initial investment of $5 million, would you advise them to accept the project?

5. If Microsoft is considering a different project which could earn net operating cash flow of $500,000 per year for the next 10 years. The project costs $4 million. Would you advise them to accept the project?

Reference no: EM131464551

Questions Cloud

Describe the origins of budgetary reform in the us : Describe the origins of budgetary reform in the U.S. What were the major influences and the prevailing themes of the budget reform movement?

Prepare presentation that covers types of domestic violence : Prepare a PowerPoint presentation that covers the types of domestic violence, statistical data concerning the prevalence of domestic violence in the U.S.

Terms of cause-and-effect relationship : your interrelationship diagraph in terms of a cause-and-effect relationship between your key driver(s) and key outcome(s).

How does your level of anxiety affect the way you manage : Personality Assessment- How does your level of anxiety affect the way you manage? How does your level of openness affect the way you manage?

Determine the market capital structure weights for microsoft : Determine the market capital structure weights for Microsoft? Weight of Debt=? Weight of Equity=?

Discuss some of the justifications for using given method : Discuss some of the justifications for using this method in police agencies. Be prepared to discuss the appraisal system and how it can be used effectively.

Why do departments require an officer to wait for backup : Why do departments require an officer to wait for backup before answering a domestic violence call? What should an officer look for in the given situation.

What do you think of competencies : What do you think of competencies? Do they have a sound basis and should we pay people for having them?

Upload the scorecard presentation : upload the scorecard presentation you created for the assignment in this unit,

User Account

All Pages