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. $8,000 per year at the end of each of the next eight years 2. $50,250 (lump sum) now 3. $98,500 (lump sum) eight years from now ) (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) Read the requirements. Requirement 1. Calculate the present value of each scenario using an 8% discount rate. Which scenario yields the highest present value? (Round the factors to three decimal places, X.XXX. Round the present value to the nearest whole dollar.) Scenario 1,8% discount rate, Present value = Present Value of $1 \begin{tabular}{|l|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Period 19 & 0.828 & 0.686 & 0.570 & 0.475 & 0.396 & 0.331 & 0.277 & 0.232 & 0.194 & 0.164 & 0.116 & 0.083 & 0.070 & 0.060 & 0.043 & 0.031 \\ Period 20 & 0.820 & 0.673 & 0.554 & 0.456 & 0.377 & 0.312 & 0.258 & 0.215 & 0.178 & 0.149 & 0.104 & 0.073 & 0.061 & 0.051 & 0.037 & 0.026 \\ Period 21 & 0.811 & 0.660 & 0.538 & 0.439 & 0.359 & 0.294 & 0.242 & 0.199 & 0.164 & 0.135 & 0.093 & 0.064 & 0.053 & 0.044 & 0.031 & 0.022 \\ Period 22 & 0.803 & 0.647 & 0.522 & 0.422 & 0.342 & 0.278 & 0.226 & 0.184 & 0.150 & 0.123 & 0.063 & 0.056 & 0.046 & 0.038 & 0.026 & 0.018 \\ Period 23 & 0.795 & 0.634 & 0.507 & 0.406 & 0.326 & 0.262 & 0.211 & 0.170 & 0.138 & 0.112 & 0.074 & 0.049 & 0.040 & 0.033 & 0.022 & 0.015 \\ Period 24 & 0.788 & 0.622 & 0.492 & 0.390 & 0.310 & 0.247 & 0.197 & 0.158 & 0.126 & 0.102 & 0.066 & 0.043 & 0.035 & 0.028 & 0.019 & 0.013 \\ Period 25 & 0.780 & 0.610 & 0.478 & 0.375 & 0.295 & 0.2233 & 0.184 & 0.146 & 0.116 & 0.092 & 0.059 & 0.038 & 0.030 & 0.024 & 0.016 & 0.010 \\ Period 26 & 0.772 & 0.598 & 0.464 & 0.361 & 0.281 & 0.220 & 0.172 & 0.135 & 0.106 & 0.094 & 0.053 & 0.033 & 0.026 & 0.021 & 0.014 & 0.009 \\ Period 27 & 0.764 & 0.586 & 0.450 & 0.347 & 0.268 & 0.207 & 0.161 & 0.125 & 0.098 & 0.076 & 0.047 & 0.029 & 0.023 & 0.018 & 0.011 & 0.007 \\ Period 28 & 0.757 & 0.574 & 0.437 & 0.333 & 0.255 & 0.196 & 0.150 & 0.116 & 0.090 & 0.069 & 0.042 & 0.026 & 0.020 & 0.016 & 0.010 & 0.006 \\ Period 29 & 0.749 & 0.563 & 0.424 & 0.321 & 0.243 & 0.185 & 0.141 & 0.107 & 0.082 & 0.063 & 0.037 & 0.022 & 0.017 & 0.014 & 0.008 & 0.005 \\ Period 30 & 0.742 & 0.552 & 0.412 & 0.308 & 0.231 & 0.174 & 0.131 & 0.099 & 0.075 & 0.057 & 0.033 & 0.020 & 0.015 & 0.012 & 0.007 & 0.004 \\ Period 40 & 0.672 & 0.453 & 0.307 & 0.208 & 0.142 & 0.097 & 0.067 & 0.066 & 0.032 & 0.022 & 0.011 & 0.005 & 0.004 & 0.003 & 0.001 & 0.001 \\ Period 50 & 0.608 & 0.372 & 0.228 & 0.141 & 0.087 & 0.054 & 0.034 & 0.021 & 0.013 & 0.009 & 0.003 & 0.001 & 0.001 & 0.001 & & \\ \hline \end{tabular} Print Done Present Value of Ordinary Annuity of \$1 Requirements 1. Calculate the present value of each scenario using an 8% discount rate. Which scenario yields the highest present value? Round to the nearest whole dollar. 2. Would your preference change if you used a 12% discount rate
