final answer of all Q pls

Assume that you are the CFO of Microsoft Company and you were asked to estimate the cost of capital. Microsoft has 1500 bonds that now has 20 years to maturity and a 7.00% annual coupon. The bond currently sells for $925 and the company's tax rate is 30%. Moreover, Microsoft has 60,000 common stock ($10 par value) and the risk premium over its own debt cost is 5.00% and the the yield on a Treasury bond is 4%. The company recently decided that its target capital structure should have 35% debt, with the balance being common equity. Furthermore, the CEO identified two investments opportunities. Project A will cost $50,000 and Project B will cost $90,000. The CEO has decided that it will invest in one project but not both. The expected cash flow that will be generated by both project are listed below: Project A Project B Initial capital expenditure 1 2 Cash year $50,000 25,000 20,000 15,000 10,000 10,000 $90.000 30,000 40,000 14,000 26.000 10,000 4 5 In addition, the following table provides the close share price for Microsoft Corporation (MSFT) and NASDAQ, and the net income for MSFT: 2015 2016 2017 2018 2019 2020 MSFT NASDAQ Net Income S50 $5,000 S200,000.00 S55 $5,500 S206,000.00 $50 $6,000 S214,240.00 S60 $6.750 S224,952.00 S66 $7,500 S237,324.36 S72 $7.853 S253,937.07 Total Dividend S130,000.00 S133,900.00 $139,256.00 S146,218.80 154,260.83 S165,059.09 Project A Project B Initial capital expenditure 1 2 Cash year $50,000 25,000 20,000 15,000 10,000 10,000 $90.000 30,000 40,000 14,000 26.000 10,000 4 5 In addition, the following table provides the close share price for Microsoft Corporation (MSFT) and NASDAQ, and the net income for MSFT: 2015 2016 2017 2018 2019 2020 MSFT NASDAQ Net Income S50 $5,000 S200,000.00 S55 $5,500 S206,000.00 $50 $6,000 S214,240.00 S60 $6.750 S224,952.00 S66 $7,500 S237,324.36 S72 $7.853 S253,937.07 Total Dividend S130,000.00 S133,900.00 $139,256.00 S146,218.80 154,260.83 S165,059.09 Required: 1. Calculate the value of total risk and market risk for Microsoft. 2. Calculate the best estimate of the cost of debt and the cost of equity? 3. In your opinion, what is the best estimate of the firm's WACC, justify your answer? 4. Calculate each of the following for both investments opportunities (Project A and B) i) The Payback Period (PP) 11) The Accounting Rate of Return (ARR) 111) The discounted Payback Period (DPP) iv) The Net Present Value (NPV) v) The Profitability Index (PI) vi) The Internal Rate of Return (IRR) vii) The Modified Internal Rate of Return (MIRR) 5. Advice the CEO, with reasons, which project should be selected. 6. Choose TWO of the above methods of investment appraisal and discuss its advantages and disadvantages. 7. If you have one million dollar, would you invest in MSFT, NASDAQ, or both, justify your answer? Assume that you are the CFO of Microsoft Company and you were asked to estimate the cost of capital. Microsoft has 1500 bonds that now has 20 years to maturity and a 7.00% annual coupon. The bond currently sells for $925 and the company's tax rate is 30%. Moreover, Microsoft has 60,000 common stock ($10 par value) and the risk premium over its own debt cost is 5.00% and the the yield on a Treasury bond is 4%. The company recently decided that its target capital structure should have 35% debt, with the balance being common equity. Furthermore, the CEO identified two investments opportunities. Project A will cost $50,000 and Project B will cost $90,000. The CEO has decided that it will invest in one project but not both. The expected cash flow that will be generated by both project are listed below: Project A Project B Initial capital expenditure 1 2 Cash year $50,000 25,000 20,000 15,000 10,000 10,000 $90.000 30,000 40,000 14,000 26.000 10,000 4 5 In addition, the following table provides the close share price for Microsoft Corporation (MSFT) and NASDAQ, and the net income for MSFT: 2015 2016 2017 2018 2019 2020 MSFT NASDAQ Net Income S50 $5,000 S200,000.00 S55 $5,500 S206,000.00 $50 $6,000 S214,240.00 S60 $6.750 S224,952.00 S66 $7,500 S237,324.36 S72 $7.853 S253,937.07 Total Dividend S130,000.00 S133,900.00 $139,256.00 S146,218.80 154,260.83 S165,059.09 Project A Project B Initial capital expenditure 1 2 Cash year $50,000 25,000 20,000 15,000 10,000 10,000 $90.000 30,000 40,000 14,000 26.000 10,000 4 5 In addition, the following table provides the close share price for Microsoft Corporation (MSFT) and NASDAQ, and the net income for MSFT: 2015 2016 2017 2018 2019 2020 MSFT NASDAQ Net Income S50 $5,000 S200,000.00 S55 $5,500 S206,000.00 $50 $6,000 S214,240.00 S60 $6.750 S224,952.00 S66 $7,500 S237,324.36 S72 $7.853 S253,937.07 Total Dividend S130,000.00 S133,900.00 $139,256.00 S146,218.80 154,260.83 S165,059.09 Required: 1. Calculate the value of total risk and market risk for Microsoft. 2. Calculate the best estimate of the cost of debt and the cost of equity? 3. In your opinion, what is the best estimate of the firm's WACC, justify your answer? 4. Calculate each of the following for both investments opportunities (Project A and B) i) The Payback Period (PP) 11) The Accounting Rate of Return (ARR) 111) The discounted Payback Period (DPP) iv) The Net Present Value (NPV) v) The Profitability Index (PI) vi) The Internal Rate of Return (IRR) vii) The Modified Internal Rate of Return (MIRR) 5. Advice the CEO, with reasons, which project should be selected. 6. Choose TWO of the above methods of investment appraisal and discuss its advantages and disadvantages. 7. If you have one million dollar, would you invest in MSFT, NASDAQ, or both, justify your