Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Setup and conduct a Monte Carlo analysis for the following assumptions. Costs in year 0 = mean of $1000, follows a uniform distribution (ranging from

Setup and conduct a Monte Carlo analysis for the following assumptions.

Costs in year 0 = mean of $1000, follows a uniform distribution (ranging from $550 to $1450) Benefits in years 1-5 = mean $300, follows a normal distribution with SD=$50 Discount rate = 4%

a. Conduct a baseline, fixed analysis (non-random/non-Monte Carlo) using the mean values. What is the NPV? Should we do the project?

b. Now conduct a Monte Carlo analysis using software* with 1000 draws (simulations). Report all information: i. Average NPV from 1000 draws ii. Minimum iii. Maximum iv. SD of your 1000 draws v. "Low likely" range (your average minus 1.96*the SD) vi. "High likely" range (your average plus 1.96*the SD) vii. # of times out of 1000 that your NPV is negative viii. Probability of a positive NPV

c. Include a histogram** of your results. What does the height of the bars represent? (Bonus if you can label the "bins" meaningfully along the X-axis.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Expenditure Decisions In The Urban Community

Authors: Howard G Schaller

1st Edition

1317310985, 9781317310983

Students also viewed these Economics questions

Question

Cite common obstacles to reaching your goals.

Answered: 1 week ago

Question

7. One or other combination of 16.

Answered: 1 week ago