Problem #1 Part A,B,C

Need to show work on excel/formulas used in excel.

All problems are available in MyFinanceLab. The icon indicates problems Sthat are easier to solve using Excel and have data in an Excel format available in MyfinanceLab. An asterisk indicates problems with a higher level of dificulty. Capital Structure in Perfect Capital Markets For problems in this section assume no taxes or distress costs. Consider a project with free cash flows in one year of $130,000 or $180,000, with each outcome being equally likely. The initial investment required for the project is $100,000, and the project's cost of capital is 20%. The risk-free interest rate is 10%. a. What is the NPV of this project? b. Suppose that to raise the funds for the initial investment, the project is sold to investors as an all-equity firm. The equity holders will receive the cash flows of the project in one year. How much money can be raised in this way that is, what is the initial market value of the unlevered equity? c. Suppose the initial $100,000 is instead raised by borrowing at the risk-free inter- est rate. What are the cash flows of the levered equity, and what is its initial value according to MM? All problems are available in MyFinanceLab. The icon indicates problems Sthat are easier to solve using Excel and have data in an Excel format available in MyfinanceLab. An asterisk indicates problems with a higher level of dificulty. Capital Structure in Perfect Capital Markets For problems in this section assume no taxes or distress costs. Consider a project with free cash flows in one year of $130,000 or $180,000, with each outcome being equally likely. The initial investment required for the project is $100,000, and the project's cost of capital is 20%. The risk-free interest rate is 10%. a. What is the NPV of this project? b. Suppose that to raise the funds for the initial investment, the project is sold to investors as an all-equity firm. The equity holders will receive the cash flows of the project in one year. How much money can be raised in this way that is, what is the initial market value of the unlevered equity? c. Suppose the initial $100,000 is instead raised by borrowing at the risk-free inter- est rate. What are the cash flows of the levered equity, and what is its initial value according to MM