Please provide answers in EXCEL formulas following the format provide below. Thank you
You are considering attending an MBA Program. The cost of the MBA program is $
In addition, you will have to stop working for one year and you are making $ a year thus
the total cost is $ Assume both costs occur at time You expect the MBA program to
increase your current salary by $ for each of the next five years and nothing after year
However, the actual increase is uncertain, and you estimate a standard deviation of $
Assume a discount rate of Total Points
a Conduct a Monte Carlo simulation with iterations. What is the average NPV and
the standard deviation of the NPV points
b What percentage of the time does the project have a positive NPV points
c What are the values at the th and th percentiles? pointsPlease provide answers in EXCEL with formulas following the format provide below
