Question
1. Consider a project with free cash flows in one year of $141,494 or $182,105, with each outcome being equally likely. The initial investment required
1.
Consider a project with free cash flows in one year of $141,494 or $182,105, with each outcome being equally likely. The initial investment required for the project is $100,368, and the projects cost of capital is 20%. The risk-free interest rate is 5%. 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 waythat is, what is the initial market value of the unlevered equity? c. Suppose the initial $100,368 is instead raised by borrowing at the risk-free interest rate. What are the cash flows of the levered equity, and what is its initial value according to MM?
PLEASE DO ONLY IN EXCEL ! And write what formulas used in the table, not just show the numbers!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started