Not sure how to do this question or what formulas to start with

121.75 -368.63 -499.87 1492.88 -425.82 -240.35 -256.02 -2537.25 1903.52 166.81 -509.02 415.88 -752.69 -140.50 -319.59 -288.20 1452.08 1186.92 1016.08 1093.70 -861.91 471.40 -985.72 -1712.10 380.49 -320.82 1982.14 -841.15 -1117.70 -362.74 -487.40 162.06 90.59 -1754.40 504.53 -772.61 301.59 1161.84 768.57 207.59 -2384.05 -1216.12 178.87 75.61 1782.29 794.71 455.88 269.84 353.06 -1480.46

Question 10, 12.4.21 HW Score: 5.26%, 1 of 19 points Save Part 1 of 2 O Points: 0 of 1 A plant manager is considering investing in a new $32,500 machine. Use of the new machine is expected to generate a cash flow of about $7,500 per year for each of the next five years. However, the cash flow is uncertain, and the manager estimates that the actual cash flow will be normally distributed with a mean of $7,500 and a standard deviation of $550. The discount rate is set at 5% and assumed to remain constant over the next five years. The company evaluates capital investments using net present value. How risky is this investment? Develop and run a simulation model to answer this question using 50 trials. Click the icon to view a sample of 50 simulation trial results. Say the values of the mean of the cash flow distribution, the standard deviation of the cash flow distribution, the initial investment, and the discount rate are entered in cells B3, B4, B5, and B6, respectively. Then, for the Monte Carlo simulation, the cash flow for an individual year is randomly generated using the Excel formula =NORM. INV(RAND(), B|, B|). If the randomly-generated cash flows for the five years are in cells B9, C9, D9, E9, and F9, then the Excel formula for the net present value is = - B|+ NPV(B|,B : (Type whole numbers.)