please calculate Scenario 1,2 and 3 for this question. Thanks

Your grandfather would like to share some of his fortune with you. He offers to give you money under one of the following scenarios (you get to choose) 1. $7,750 a year at the end of each of the next eight years 2. $49,950 (lump sum) now 3. $98,650 (lump sum) eight years from now Calculate the present value o each scenario using an 8% interest rate which scenario yields the highest present value? Would your preference change if you used a 12% interest rate? (Click the icon to view the present value annuity factor table.) (Click the icon to view the future value annuity factor table.) (Click the icon to view the present value factor table.) (Click the ioon to view the future value factor table.) Using an 8% interest rate, calculate the present values for each scenario. (Round the amounts to the nearest dollar.) Present value 44,537 Scenario 14 Scenario 2 S49,950 Scenario 3S 53,298 Which scenario yields the highest present value? Scenario 3 appears to be the best option. Based on an 8% interest rate, its present value is the highest Using a 12% interest rate, calculate the present values for each scenario Round the amounts to the nearest dollar Present value Scenario 1 Present Value of $1 | 2% Periods 1% 3% | 4% 8% | 10% | 12% | 14% | 16% | 18% | 20% 1 0.990 0.980 0.971 0.962 0.952 0.943 0.926 0.909 0.893 0.877 0.862 0.8470.833 2 0.980 0.961 0.943 0.925 0.907 0.890 0.857 0.826 0.797 0.769 0.743 0.718 0.694 3 0.971 0.942 0.915 0.889 0.864 0.840 0.794 0.751 0.712 0.675 0.641 0.6090.579 4 0.961 0.924 0.888 0.855 0.823 0.792 0.735 0.683 0.636 0.592 0.552 0.516 0.482 5 0.951 0.906 0.863 0.822 0.784 0.747 0.681 0.621 0.567 0.519 0.476 0.4370.402 5% 5% 6 0.942 0.888 0.837 0.7900.746 0.705 0.630 0.564 0.507 0.456 0.410 0.370 0.335 7 0.933 0.871 0.813 0.760 0.711 0.665 0.583 0.513 0.452 0.400 0.354 0.314 0.279 8 0.923 0.853 0.789 0.7310.677 0.627 0.540 0.467 0.404 0.351 0.305 0.266 0.233 90.914 0.837 0.766 0.703 0.645 0.592 0.500 0.424 0.361 0.308 0.263 0.225 0.194 10 0.905 0.820 0.744 0.676 0.614 0.558 0.463 0.386 0.322 0.270 0.227 0.191 0.162 11 0.896 0.804 0.722 0.650 0.585 0.527 0.429 0.350 0.287 0.237 0.195 0.162 0.135 12 0.887 0.788 0.701 0.625 0.557 0.497 0.397 0.319 0.257 0.208 0.168 0.137 0.112 13 0.879 0.773 0.681 0.601 0.530 0.469 0.368 0.290 0.229 0.182 0.145 0.116 0.093 14 0.870 0.758 0.661 0.577 0.505 0.442 0.340 0.263 0.205 0.160 0.125 0.099 0.078 15 0.861 0.743 0.642 0.555 0.481 0.417 0.315 0.239 0.183 0.140 0.108 0.084 0.065 20 0.820 0.673 0.554 0.456 0.377 0.312 0.215 0.149 0.104 0.073 0.051 0.0370.026 25 0.780 0.610 0.478 0.375 0.295 0.233 0.146 0.092 0.059 0.038 0.024 0.016 0.010 30 0.742 0.552 0.412 0.308 0.231 0.174 0.099 0.057 0.033 0.020 0.012 0.007 0.004 40 0.672 0.453 0.307 0.2080.142 0.097 0.046 0.022 0.0110.0050.003 0.,001 0.,001 Print Done Periods 1080 1260 1 1.041 1.0821.126 1.170 1216 1.262 1360 1.464 1.574 1689 7 7 1 0 0 1.094 1.105 1219344 1.480 629 1.792.159 2.594 3.106 3.707 4.411 1.116 12431384 1539 1.710 1.8982.332 2.853 3.479 4226 5.1176.176 7.430 7 1220 14861806 2.191 2653 3.207466 6.727 9.646 13.743 9.46127.393 38.338 1.282 1642.094 2.666 3.386 4.292 6.848 10.835 7.000 26.462 40.87462.669 95.396 1.348 1.81124273.243 4.322 5.74310.063 17.449 29.960 50.95085.850143.371 237.376 10.286 21.725 45.25993.051 188.884 378.721 750.378 1469.772 0 Present Value of Annuity of $1 Periods| 1% | 2% 3% | 4% 8% | 10% | 12% | 14% | 16% | 18% | 20% 1 0.990 0.980 0.971 0.962 0.952 0.943 0.926 0.909 0.893 0.8770.862 0.8470.833 2 1.970 1.942 1.913 1.886 1.859 1.833 1.783 1.736 1.690 1.6471.605 1.566 1.528 3 2.9412.884 2.829 2.775 2.723 2.673 2.5772.487 2.402 2.322 2.2462.174 2.106 4 3.902 3.808 3.717 3.630 3.546 3.465 3.312 3.170 3.037 2.914 2.798 2.690 2.589 5 4.853 4.713 4.580 4.452 4.329 4.212 3.993 3.791 3.605 |3.433 3.274 3.1272.991 5% 5% 6 5.7955.601 5.417 5.242 5.076 4.917 4.623 4.355 4.111 3.889 3.685 3.498 3.326 7 6.728 6.472 6.230 6.002 5.786 5.582 5.206 4.868 4.564 4.288 4.039 3.812 3.605 8 7.652 7.325 7.020 6.7336.463 6.210 5.747 5.335 4.968 4.639 4.344 4.078 3.837 98.566 8.162 7.786 7.435 7.108 6.802 6.247 5.759 5.328 4.946 4.6074.303 4.031 10 9.471 8.983 8.530 8.111 7.722 7.360 6.710 6.145 5.650 5.216 4.833 4.494 4.192 11 10.368 9.787 9.253 8.760 8.306 7.8877.139 6.495 5.938 5.453 5.029 4.656 4.327 12 11.255 10.575 9.9549.385 8.863 8.384 7.536 6.814 6.194 5.660 5.1974.793 4.439 13 12.134 11.348 10.635 9.9869.394 8.853 7.904 7.103 6.424 5.842 5.342 4.910 4.533 14 13.004 12.106 11.296 10.5639.899 9.295 8.244 7.367 6.628 6.002 5.468 5.008 4.611 15 13.865 12.849 11.938 11.118 10.380 9.712 8.559 7.606 6.811 6.1425.575 5.092 4.675 20 18.046 16.351 14.877 13.590 12.462 11.470 9.818 8.514 7.469 6.623 5.929 5.353 4.870 25 22.023 19.523 17.413 15.622 14.094 12.783 10.675 9.077 7.843 6.8736.097 5.4674.948 30 25.808 22.396 19.600 17.292 15.372 13.765 11.258 9427 8.055 7.003 6.177 5.517 4.979 40 32.835 27.355 23.115 19.793 17.159 15.046 11.925 9.7798.2447.1056.2335.5484.997 Print Done Future Value of Annuity of $1 Periods 6% 8 5.1015.2045.3095.416 5526 5.6375867 6.105 6.353 6.6106.8777.154 7.442 6.152 6.3086.468 6.633 6.802 6.9757336 7.716 8.115 8.536 8.9779.442 9.930 7.214 7.4347.662 7898 8.142 8.3948.923 9.487 10.089 10.73011.41412.142 12.916 8.286 8.5838.892 9.214 9.549 9.89710.63711.436 12.300 13.233 14.24015.327 16.499 4 8 2 9.7550.15910.583 11.027 11.491 12.48813.579 14.776 16.085 17.519 19.08620.799 2 10.462 0.95011.464 12.006 12.578 13.18114.48715.937 17.549 19.337 21.32123.521 25.959 11567.16912808 13.486 14.20714.97216.645 18.531 20.655 23.04525.733 28.755 32.150 12.683 13.41214.192 526 15.917 16.87018.97721.384 24.133 27.271 30.85034.931 39.581 13.80914.68015.618 6.627 17.713 18.88221.495 24.523 28.029 32.08936.786 42.219 48.497 4.9475.974 17.086 18.292 1959921.01524.215 27.975 32.393 37.58143.672 50.818 59.196 16.09717.29318.599 20.024 21.57923.27627.152 31.772 37.280 43.84251.660 60.965 72.035 220192429726.870 29778 33.066 36.786 45.762 57.275 72.05291.025 115.380 146.628 186.688 28243 32.030 36.459 41.646 47.727 54.865 73.106 98.347 133.334 181.871 249.214 342.603471.981 34.785 40.568 47.575 56.085 66.439 79.058 113.283164.494 241.333 356.787530.312 790.9481,181.882 48.8866040275 401 95.026 120.800 154.762 259.057442.593 767.091 1,342.025 2,360.7574,163.213 7,343.858 2 1