need help on this question please i'm really confused and stuck
Solve various time value of money scenarios. Click the icon to view the scenarios) (Click the icon to view the present value of $1 table.) (Click the icon to view the future value of $1 table) (Click the icon to view the present value of annuity of $1 table) (Click the icon to view the future value of annuity of $1 table.) Scenario 1. Eddie just hit the jackpot in Las Vegas and won $45,0001 If he invests it now at a 10% interest rate how much will it be worth in 15 years? (Round your answer to the nearest whole dollar) Future value=$ Scenario 2. Alan would like to have $2,500,000 saved by the time he retires in 40 years. How much does he need to invest now at a 14% interest rate to fund his retirement goal? (Round your answer to the nearest whole dollar) Present value = $ Scenario 3. Assume that Tina accumulates savings of $1.5 million by the time she retires. If she invests this savings at 8%, how much money will she be able to withdraw at the end of each year for 15 years? (Round your answer to the nearest whole dollar and enter as a positive amount) Amount able to withdraw = $ Scenario 4. Faith plans to invest $4,000 at the end of each year for the next eight years. Assuming a 12% interest rate, what will her investment be worth eight years from now? (Round your answer to the nearest whole dollar) Future value=$ Scenario 5. Assuming a 10% interest rate, how much would Sarah have to invest now to be able to withdraw $13,000 at the end of every Enter any number in the edit fields and then continue to the next question. O I e a 8 9 hp Solye various time value of money scenarios @ Click the icon to view the scenarios.) (Click the icon to view the present value of $1 table.) (Click the icon to view the present value of annuity of $1 table.) (Click the icon to view the future value of $1 table) (Click the icon to view the future value of annuity of $1 table.) Future value=$ Scenario 5. Assuming a 10% interest rate, how much would Sarah have to invest now to be able to withdraw $13,000 at the end of every year for the next nine years? (Round your answer to the nearest whole dollar.) Present value = $ Scenario 6. Earl is considering a capital investment that costs $505,000 and will provide net cash inflows for three years. Using a hurdle rate of 12%, find the NPV of the investment. (Round your answer to the nearest whole dollar Use parentheses or a minus sign to represent a negative NPV) Net Present Value (NPV) =$ Scenario 7. What is the IRR of the capital investment described in Question 6? The IRR is the interest rate at which the investment NPV = 0. We tried 12% in question 6. now we'll try 14% and calculate the NPV. (Round your answer to the nearest whole dollar. Use parentheses or a minus sign to represent a negative NPV) Net Present Value (NPV) =$ The IRR for the project is ? Enter any number in the edit fields and then continue to the next question e a 54 arious time i More Info - X ck the icon Click the ic able.) Click the ic ble) e value end of every io 5. Assur the next n nt value ing a hurdle io 6. Earl 12%, find Live NPV.) 1. Eddie just hit the jackpot in Las Vegas and won $45,000! If he invests it now at a 10% interest rate, how much will it be worth in 15 years? 2. Alan would like to have $2,500,000 saved by the time he retires in 40 years. How much does he need to invest now at a 14% interest rate to fund his retirement goal? 3. Assume that Tina accumulates savings of $15 million by the time she retires. If she invests this savings at 8%, how much money will she be able to withdraw at the end of each year for 15 years? 4. Faith plans to invest $4,000 at the end of each year for the next eight years. Assuming a 12% interest rate, what will her investment be worth eight years from now? 5. Assuming a 10% interest rate how much would Sarah have to invest now to be able to withdraw $13,000 at the end of every year for the next nine years? 6. Earl is considering a capital investment that costs $505,000 and will provide the following net cash inflows Year Net Cash Inflow $305,000 $208,000 3 $108,000 Using a hurdle rate of 12%, find the NPV of the investment. 7. What is the IRR of the capital investment described in Question 6? pn to represent esent Value tio 7. What 1 2 he NPV. R is the inte your answ esent Value R for the pre Print Done ny number a 54 ve various time value of money scenarios (Click the icon to view the scenarios.) i Reference OUT uture Present Value of $1 enari ar for 3% of every tesen Periods 1 2 3 4 5 1% 0.990 0.980 0.971 0.961 0.951 2% 0.980 0.961 0.942 0.924 0.906 0.971 0.943 0.915 0.888 0.863 4% 0.962 0.925 0.889 0.855 0.822 5% 0.952 0.907 0 884 0.823 0.784 6% 0.943 0.890 0.840 0.792 0.747 8% 0.926 0.857 0.794 0.735 0.681 10% 0.909 0.826 0.751 0.683 0.621 12% 0.893 0.797 0.712 0.636 0.567 14% 0.877 0.769 0.675 0.592 0.519 16% 0.862 0.743 0.641 0.552 0.476 18% 0.847 0.718 0.609 0.516 0.437 20% 0.833 0.694 0 579 0.482 0.402 enari of 1 negati hurdle represel et Prel 6 7 8 9 10 0942 0.933 0.923 0.914 0.905 0.888 0.871 0.853 0.837 0.820 0.837 0.813 0.789 0.766 0.744 0.790 0.760 0.731 0.703 0.676 0.746 0.711 0.677 0.645 0.614 0.705 0.665 0.627 0.592 0.558 0.630 0.583 0.540 0.500 0.463 0.564 0.513 0.467 0.424 0.386 0.507 0.452 0.404 0.361 0.322 0.456 0.400 0.351 0.308 0.270 0.410 0.354 0.305 0.263 0.227 0.370 0.314 0.266 0.225 0.191 0.335 0.279 0.233 0.194 0.162 enari e IRR ound PV 11 12 13 14 15 0.896 0.887 0.879 0.870 0.861 0.804 0.788 0.773 0.758 0.743 0.722 0.701 0.681 0.661 0.642 0.650 0.625 0.601 0.577 0.555 0.585 0.557 0.530 0.505 0.481 0.527 0.497 0.469 0.442 0.417 0.429 0.397 0.368 0.340 0.315 0.350 0.319 0.290 0.263 0.239 0.287 0.257 0.229 0.205 0.183 0.237 0.208 0.182 0.160 0.140 0.195 0.168 0.145 0.125 0.108 0.162 0.137 0.116 0.099 0.084 0.135 0.112 0.093 0.078 0.065 et Pre e IRRI 20 25 30 40 0.820 0.780 0.742 0.672 0.673 0.610 0.552 0.453 0.554 0.478 0.412 0.307 0.456 0.375 0.308 0.208 0.377 0.295 0.231 0.142 0.312 0.233 0.174 0.097 0.215 0.146 0.099 0.046 0.149 0.092 0.057 0.022 0.104 0.059 0.033 0.011 0.073 0.038 0.020 0.005 0.051 0.024 0.012 0.003 0.037 0.016 0.007 0.001 0.028 0.010 0.004 0.001 er an Print Done O a 54 hp Solve various time value of money scenarios i (Click the icon to view the scenarios) (Click the icon to view the present value of $1 table.) (Click the icon to view the future value of S1 table) (Click the icon to view the present value of annuity of $1 table.) (Click the icon to view the future value of annuity of $1 table.) - X Reference 20% 12% 1.120 1 254 Periods 1 2 3 4 5 1% 1.010 1.020 1.030 1.041 1.051 2% 1.020 1040 1 061 1082 1 104 3% 1.030 1.081 1.093 1.126 1 159 1.194 1230 1 267 1.305 1.344 4% 1.040 1,082 1.125 1.170 1217 5% 1.050 1.103 1.158 1216 1278 10% 1.100 1.210 1.331 1 484 1.611 14% 1.140 1 300 1.482 1.689 1.925 16% 1.160 1.346 1.561 1811 2.100 18% 1 180 1.392 1643 1939 2288 1.405 1 574 1.762 1 200 1.440 1.728 2074 2488 2.988 3583 4300 5.180 6.192 6 7 8 1.062 1.072 1 083 1.094 1.105 1.128 1.149 1 172 1.196 1.219 1.265 1 316 1 369 1423 1.480 1.340 1407 1.477 1551 1629 Future Value of $1 6% 1.050 1080 1.124 1.166 1.191 1.260 1.262 1.360 1338 1.489 1.419 1.587 1.504 1.714 1.594 1.851 1.689 1 999 1.791 2.159 1.898 2332 2012 2518 2.133 2.720 2281 2.937 2397 3.172 3207 4.661 4292 6.848 5.743 10.063 10.286 21.725 1.772 1.949 2.144 2358 2594 1.974 2211 2478 2773 3.106 2.195 2 502 2853 3.252 3.707 2.438 2 826 3278 3.803 4.411 2.700 3.185 3.759 4435 5.234 10 3.479 3896 11 12 13 14 15 1.116 1.127 1.138 1.149 1.243 1.268 1.294 1.319 1.346 1.384 1426 1.489 1.513 1.558 1710 1.796 1 886 1980 1.539 1.601 1 665 1.732 1 801 2.191 2666 3243 4801 4226 4 818 5.492 6.261 7.138 2.853 3.138 3.452 3.797 4.177 6.727 10.835 17.449 45 259 5.117 5 936 6.888 7.988 9.265 1 181 6.178 7289 8.599 10.147 11.974 2079 7.430 8 916 10.699 12839 15.407 38.338 95 396 237 378 1.489 772 20 25 30 40 1220 1282 1.348 1.489 1.486 1641 1811 2208 1 806 2094 2427 3 262 4.887 5.474 9.646 17 000 29 960 93051 2653 3 386 4322 7.040 13.743 26.462 50.950 188 884 19.461 40.874 85 850 378.721 27.393 62.669 143 371 750 378 Type here to search O BE e a OO alue of money scenarios view the scenarios) to view the present value of $1 table.) (Click the icon to view the present value of annuity of $1 table.) Reference dil Present Value of Annuity of $1 It be worth lar Periods in 1 12% 0.893 1.690 2402 3.037 3.605 14% 0.877 1.647 2.322 2.914 3.433 2 3 4 5 16% 18% 0.862 0.847 1.605 1.566 2.246 2.174 2.798 2.690 3.274 3.127 20% 0.833 1.528 2.106 2589 2.991 for the ne ing $ 12%, finc Col neg 6 7 8 4.111 4.564 4.968 5328 5.650 1% 2% 3% 4% 5% 6% 8% 10% 0.990 0.980 0.971 0.962 0.952 0.943 0.926 0.909 1.970 1.942 1.913 1.886 1.859 1.833 1.783 1.736 2.941 2 884 2.829 2.775 2.723 2.673 2577 2.487 3.902 3.808 3.717 3.630 3.546 3.465 3.312 3.170 4.853 4.713 4.580 4.452 4.329 4212 3.993 3.791 5.795 5.601 5.417 5.242 5.076 4917 4.623 4355 6.728 6.472 6.230 6.002 5.786 5.582 5.206 4.868 7.652 7325 7.020 6.733 6.463 6.210 5.747 5.335 8.566 8.162 7.786 7.435 7.108 6.802 6 247 5.759 9.471 8.983 8.530 8.111 7.722 7.360 6.710 6.145 10.368 9.787 9.253 8.760 8.306 7.887 7.139 6.495 11.255 10.575 9.954 9.385 8.853 8.384 7.536 6.814 12.134 11.348 10.635 9.986 9.394 8.853 7.904 7. 103 13.004 12 106 11 296 10.563 9.899 9.295 8.244 7.367 13.865 12.849 11.938 11.118 10.380 9.712 8.559 7.606 18.046 16 351 14.877 13.590 12.462 11.470 9818 8.514 22.023 19.523 17 413 15.622 14.094 12.783 10.675 9.077 25 808 22.396 19.600 17.292 15.372 13.765 11.258 9.427 32.835 27.355 23.115 19.793 17.159 15.046 11.925 9.779 3.889 4.288 4.639 4.946 5.216 3.685 4.039 4.344 4.607 4.833 3.498 3.812 4.078 4.303 4.494 3.326 3.605 3.837 4.031 4.192 9 (NIH 10 is til ur answer erest 11 12 13 14 15 5.938 6.194 6.424 6.628 6.811 5.453 5.660 5.842 6.002 6.142 5029 5.197 5.342 5.468 5.575 4.656 4.793 4.910 5.008 5.092 4.327 4439 4.533 4611 4.675 (NE mojed 20 25 30 40 7.469 7.843 8.055 8 244 6.623 6.873 7.003 7.105 5.929 6.097 6.177 6233 5.353 5.467 5.517 5.548 4.870 4.948 4.979 4.997 rint Print Done e here to search O SI e a 54 ime value of money scenarios con to view the scenarios.) icon to view the present value of $1 table.) icon to view the future value of $1 table. (Click the icon to view the present value of annuity of $1 table.) (Click the icon to view the future value of annuity of $1 table.) X Reference Periods 1 2 15 1.000 2010 3.030 4.050 5.101 2% 1.000 2020 3.060 4.122 5204 3 4 5 3% 1.000 2030 3.091 4.184 5309 6.468 7662 8.892 10.159 11.464 4% 1.000 2010 3.122 4246 5.416 6.633 7.898 9.214 10.583 12.006 12% 1.000 2.120 3.374 4.779 6353 6 8 9 10 6.152 7.214 8.286 9.369 10.462 6.300 7434 8.583 9.755 10.950 Future Value of Annuity of $1 5% 6% 8% 10% 1.000 1.000 1.000 1.000 2050 2060 2080 2100 3.153 3.184 3.246 3310 4310 4 375 4506 4641 5.526 5.637 5.867 6.105 6 802 6.975 7.336 7.716 8.142 8.394 8.923 9.487 9549 9.897 10.637 11436 11027 11.491 12.488 13.579 12578 13.181 14.487 15.937 14 207 14.972 16,645 18.531 15.917 16,870 18.977 21384 17.713 18 882 21.495 24.523 19.590 21015 24 215 27.975 21570 23 276 27. 152 31772 33.066 36786 45.762 57 275 47.722 54 865 73.106 98.347 66.439 79.058 113 283 164.494 120.800 154 762 259,057 442580 8.115 10.089 12 300 14.776 17.549 16% 18% 20% 1.000 1000 1 000 1.000 2.140 2.160 2.180 2 200 3.440 3 506 3.572 3.640 4.921 5.066 5.215 5368 6.610 6877 7.154 7.442 8.536 8.977 9442 9.930 10.730 11.414 12 142 12916 13.233 14.240 15.327 16.490 16.085 17519 19.088 20.799 19.337 21 321 23.521 25.959 23.045 25 733 28.755 32.150 27.271 30 850 34.931 39.581 32089 36 780 42219 48.497 37 581 43 672 50.818 59.196 43 842 51.660 60.965 72.035 91025 115 380 146.628 188.688 181.871 249 214 342 603 471 981 356.787 530 312 790 948 1.181 382 1,342.025 2360 757 4,163 2137.343 858 11 12 13 14 15 11.567 12 683 13.800 14.947 16.097 12. 169 13.412 14 680 15.974 17.293 12808 14.192 15.618 17.080 18.500 13.486 15.026 16.627 18.292 20.024 20.655 24133 28.029 32.393 37 280 72052 133 334 241.333 767,091 20 25 30 40 22.019 28.243 34785 48 886 24 297 32030 40.568 60.402 26.870 36.459 47575 75401 29.778 41.648 56 085 95.026 "pe here to search OP e E a
