Suppose you have a project that will cost $500,000 last for ten years. The cash flows for each year have an expected value of $100,000 with a standard deviation of $15,000. The cost of capital is 10%. Use a Monte Carlo simulation with 1,000 replications to evaluate this project using the NPV and IRR approaches. See the video below for constructing the Excel spreadsheet.