Please use Excel and show and define your steps.to show FW versus MARR which varies by 1 from 0-50

1 consider the data from Problem 62 a Plot a graph of FW versus MARR where MARR varies from 0 percent to 50 percent by l percent increments. 0-50% FW should be on the y-axis and MARR on the x-axis. b. Explain the significance of the y-axis intercept. c. Explain the significance of the x-axis intercept. PB 62 MARR CF(1ti(EOYmax-EOYstart Nu Things, Inc., is considering an investment in a business venture with the following anticipated cash flow results: Cash FloiYears left F/P Cash Flow* F/P-FW 70000 0.20% 20000 0.20% 2 19000 0.20% 3 18000 0.20% 4 17000 0.20% 5 16000 0.20% 6 15000 0.20% 7 14000 0.20% 8 13000 0.20% 9 12000 0.20% 11000 0.20% 11 10000 0.20% 12 9000 0.20% . 20% 14 7000 0.20% 6000 0.20% 5000 0.20% 4000 0.20% O. 20% 19 2000 0.20% 20 1000 0.20% 20 38.338 (2,683,660.00) $ 638,960.00 $ 505,037.00 $ 399,348.00 $ (2,683,631.99 638,960.D0 505,843.33 99,350.00 314,303.24 246,512.35 192,5B7.77 149,790,49 115,909.31 89,161.00 58,109.10 51,597.B0 30,690.35 2B,665.45S 20,901.B9 14,929.92 10,368.00 6,912.00 4,320.00 2,4D0.D0 1,000.00 216,688.00 EOY Cash FloW EOY Cash FlowEOYCash Flow 18 25.623 $ 0 $70,000 7 16 18.488 S 15 15.407 $ 12839 $ 13 10.699 $ 8.916 $ 14,296.00 15 16 17 18 19 20 Assume MARR is 20 percent per year. Based on a future worth analysis, () determine the investment's worth. 6,512.00 $ 192,585.00 $ 149,705.00$ 115,908.00 $ 89,160.00 $ 66,112.00 $ 51,600.00 $ 38,700.00 $ 28,664.00 $ 20,000 13,000 6,000 11,000 10,000 9,000 10 17,000 3,000 16,000 2,000 3.583 $ 13 20,902.00 5 2.468 $ 2.074 S 3 172B S 14,926.00 $ 16 10,37000 (2) state whether or not your results indicate the investment should be undertaken, and (3) state the decision rule .912.00$ 4,320.00 $ 2400.00$ 1,000.00$ 16,640.00 $ you used to arrive at this conclusion. 3000 Total 1 consider the data from Problem 62 a Plot a graph of FW versus MARR where MARR varies from 0 percent to 50 percent by l percent increments. 0-50% FW should be on the y-axis and MARR on the x-axis. b. Explain the significance of the y-axis intercept. c. Explain the significance of the x-axis intercept. PB 62 MARR CF(1ti(EOYmax-EOYstart Nu Things, Inc., is considering an investment in a business venture with the following anticipated cash flow results: Cash FloiYears left F/P Cash Flow* F/P-FW 70000 0.20% 20000 0.20% 2 19000 0.20% 3 18000 0.20% 4 17000 0.20% 5 16000 0.20% 6 15000 0.20% 7 14000 0.20% 8 13000 0.20% 9 12000 0.20% 11000 0.20% 11 10000 0.20% 12 9000 0.20% . 20% 14 7000 0.20% 6000 0.20% 5000 0.20% 4000 0.20% O. 20% 19 2000 0.20% 20 1000 0.20% 20 38.338 (2,683,660.00) $ 638,960.00 $ 505,037.00 $ 399,348.00 $ (2,683,631.99 638,960.D0 505,843.33 99,350.00 314,303.24 246,512.35 192,5B7.77 149,790,49 115,909.31 89,161.00 58,109.10 51,597.B0 30,690.35 2B,665.45S 20,901.B9 14,929.92 10,368.00 6,912.00 4,320.00 2,4D0.D0 1,000.00 216,688.00 EOY Cash FloW EOY Cash FlowEOYCash Flow 18 25.623 $ 0 $70,000 7 16 18.488 S 15 15.407 $ 12839 $ 13 10.699 $ 8.916 $ 14,296.00 15 16 17 18 19 20 Assume MARR is 20 percent per year. Based on a future worth analysis, () determine the investment's worth. 6,512.00 $ 192,585.00 $ 149,705.00$ 115,908.00 $ 89,160.00 $ 66,112.00 $ 51,600.00 $ 38,700.00 $ 28,664.00 $ 20,000 13,000 6,000 11,000 10,000 9,000 10 17,000 3,000 16,000 2,000 3.583 $ 13 20,902.00 5 2.468 $ 2.074 S 3 172B S 14,926.00 $ 16 10,37000 (2) state whether or not your results indicate the investment should be undertaken, and (3) state the decision rule .912.00$ 4,320.00 $ 2400.00$ 1,000.00$ 16,640.00 $ you used to arrive at this conclusion. 3000 Total