Question: Information about the cash flows for a four'year financial project are listed in the following table. The cash flows are assumed to follow a triangular

Information about the cash flows for a four'year financial project are listed in the following table. The cash flows are assumed to follow a triangular distribution. The cost of implementing the project is expected to be between $60,000 and $70,000, with all values in this range being equally likely. Analysis of changes in the Consumer Price Index suggests that the annual rate of inflation can be approximated with a normal distribution with a mean of 4 percent and standard deviation of 1.5 percent. The organization's required rate of return is 20 percent. Develop a model in CB to analyze this situation and answer the following questions.


Information about the cash flows for a four–year financial proje


(a) What is the expected NPV of this project?
(b) What is the range of NPVs?
(c) How would you characterize the level of risk associated with this project?
(d) Would you recommend undertaking the project? Why or why not?

Minimm Most Likely Maximum Year Inflow 15,000 $20,000 $30,000 $20,000 $25,000 $35,000 3$20,000 30,000 $35,000 $40,000 $50,000 $60,000 Inflow Inflow

Step by Step Solution

3.42 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

In the spreadsheet below assumption cells were defined for the inflows outflows and inflation based ... 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

132-B-M-L-P-M (936).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!