Hi I need help with the following:

Exercise

The first part of this assignment asks you to estimate the weighted average cost of capital (WACC) for Microsoft Corporation.

Assume that Microsofts optimal debt ratio is 40%, tax rate is 30% and its cost of debt is 6%.

To compute the required rate of return on equity, go to Yahoo Finance website https://finance.yahoo.com/. Look for Microsoft Corporation data (just search for it either typing the full name or using the symbol of the company MSFT). Once you are on the Microsoft page click on historical data. The time period has to be of 5 years and the frequency is monthly. Secondly, you need to download the data for the market portfolio. Use the S&P 500 index. For both Microsoft and the S&P 500 use the adjusted prices (adj price column when downloading from Yahoo Finance).

In your calculation of the required rate of return using the CAPM formula, assume the riskfree rate to be 3%.

Once you have all the data, you have to:

1) Compute the Beta of Microsoft. What is its interpretation? 2) Plot the trendline (Characteristic line) 3) Compute the return on the market portfolio. Hint: you need to convert the

monthly returns we are using in yearly return by multiplying the monthly returns x 12. 4) Compute the required rate of return. 5) Compute the WACC.

Please upload your spreadsheet on its learning in addition to you solutions for the following exercises.

Microsoft Corporation just constructed a manufacturing plant in Ghana. The construction cost 10 billion Ghanian cedi. Microsoft intends to leave the plant open for three years. During the three years of operation, after-tax cedi cash flows are expected to be 3 billion cedi, 3 billion cedi, and 2 billion cedi, respectively. Operating cash flows will begin one year from today and are remitted back to the parent at the end of each year. At the end of the third year, Microsoft expects to sell the plant for 5 billion cedi. Microsoft has a required rate of return that you just computed. It currently takes 8,700 cedi to buy one U.S. dollar, and the cedi is expected to depreciate by 5 percent per year.

6) Determine the NPV of the project. Should Microsoft build the plant?

7) Determine the APV of the project considering an all-equity required rate of return for Microsoft of 10%. Would the decision of Microsoft change?