Question: Reconsider the following problem from Chapter 1: A four-year financial project is forecast to have net cash inflows of $20,000; $25,000; $30,000; and $50,000 in

Reconsider the following problem from Chapter 1: A four-year financial project is forecast to have net cash inflows of $20,000; $25,000; $30,000; and $50,000 in the next 4 years. It will cost $75,000 to implement the project, payable at the beginning of the project. If the required rate of return is 0.2, conduct a discounted cash flow calculation to determine the NPV. Now, however, assume that the net cash inflows are probabilistic variables. Further assume that each forecast net cash inflow is normally distributed with standard deviations of $1,000, $1,500, $2,000, and $3,500, respectively. Given a required rate of return of 0.2, find the mean forecast NPV using Crystal BallĀ®. What is the probability that the actual NPV will be positive?

Step by Step Solution

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The NPV is calculated using Excel as follows The NPV is calculated two different ways The first is c... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

1163-B-M-L-P-M(2623).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!