Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Information about the cash ows for a four - year nancial project are listed in the following table. The cash ows are assumed to follow
Information about the cash ows for a four year nancial project are listed in the following table. The cash ows are assumed to follow a triangular distribution. The cost of implementing the project is expected to be between $ and $ with all values in this range being equally likely. Analysis of changes in the Consumer Price Index suggests that the annual rate of ination can be approximated with a normal distribution with a mean of percent and standard deviation of percent The organizations required rate of return ispercent Develop a model in @Risk to analyze this situation and answer the following questions use iterations
Year
Minimum flow
Most likely inflow
Maximum inflow
$
$
$
$
$
$
$
$
$
$
$
$
What is the expected NPV of this project?
What is the range of the NPVsMinimum and maximum values
How would you characterize the level of risk with this project?
Would you recommend undertaking this project? Why or why not?
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