Suppose you have a project that will cost $$800,000$ last for ten years. The cash flows for each year have an expected value of $$175,000$ with a standard deviation of $$20,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.

USE EXCEL AND EXPLAIN EACH STEP