q5

please do all requirements.

Relerence Data table Requirements 1. What is the project's NPV? Is the investment attractive? Why or why not? 2. Assume the expansion has no residual value. What is the project's NPV? Is the investment still attractive? Why or why not? Future Value of Annuity of \$1 rence \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{14}{|c|}{ Future Value of Annuity of \$1 } \\ \hline Periods & 1% & 2% & 3% & 4% & 5% & 6% & 8% & 10% & 12% & 14% & 16% & 18% & 20% \\ \hline Period 1 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 \\ \hline Period 2 & 2.010 & 2.020 & 2.030 & 2.040 & 2.050 & 2.060 & 2.080 & 2.100 & 2.120 & 2.140 & 2.160 & 2.180 & 2.200 \\ \hline Period 3 & 3.030 & 3.060 & 3.091 & 3.122 & 3.153 & 3.184 & 3.246 & 3.310 & 3.374 & 3.440 & 3.506 & 3.572 & 3.640 \\ \hline Period 4 & 4.060 & 4.122 & 4.184 & 4.246 & 4.310 & 4.375 & 4.506 & 4.641 & 4.779 & 4.921 & 5.066 & 5.215 & 5.368 \\ \hline Period 5 & 5.101 & 5.204 & 5.309 & 5.416 & 5.526 & 5.637 & 5.867 & 6.105 & 6.353 & 6.610 & 6.877 & 7.154 & 7.442 \\ \hline Period 6 & 6.152 & 6.308 & 6.468 & 6.633 & 6.802 & 6.975 & 7.336 & 7.716 & 8.115 & 8.536 & 8.977 & 9.442 & 9.930 \\ \hline Period 7 & 7.214 & 7.434 & 7.662 & 7.898 & 8.142 & 8.394 & 8.923 & 9.487 & 10.089 & 10.730 & 11.414 & 12.142 & 12.916 \\ \hline Period 8 & 8.286 & 8.583 & 8.892 & 9.214 & 9.549 & 9.897 & 10.637 & 11.436 & 12.300 & 13.233 & 14.240 & 15.327 & 16.499 \\ \hline Period 9 & 9.369 & 9.755 & 10.159 & 10.583 & 11.027 & 11.491 & 12.488 & 13.579 & 14.776 & 16.085 & 17.519 & 19.086 & 20.799 \\ \hline Period 10 & 10.462 & 10.950 & 11.464 & 12.006 & 12.578 & 13.181 & 14.487 & 15.937 & 17.549 & 19.337 & 21.321 & 23.521 & 25.959 \\ \hline Period 11 & 11.567 & 12.169 & 12.808 & 13.486 & 14.207 & 14.972 & 16.645 & 18.531 & 20.655 & 23.045 & 25.733 & 28.755 & 32.150 \\ \hline Period 12 & 12.683 & 13.412 & 14.192 & 15.026 & 15.917 & 16.870 & 18.977 & 21.384 & 24.133 & 27.271 & 30.850 & 34.931 & 39.581 \\ \hline Period 13 & 13.809 & 14.680 & 15.618 & 16.627 & 17.713 & 18.882 & 21.495 & 24.523 & 28.029 & 32.089 & 36.786 & 42.219 & 48.497 \\ \hline Period 14 & 14.947 & 15.974 & 17.086 & 18.292 & 19.599 & 21.015 & 24.215 & 27.975 & 32.393 & 37.581 & 43.672 & 50.818 & 59.196 \\ \hline Period 15 & 16.097 & 17.293 & 18.599 & 20.024 & 21.579 & 23.276 & 27.152 & 31.772 & 37.280 & 43.842 & 51.660 & 60.965 & 72.035 \\ \hline Period 20 & 22.019 & 24.297 & 26.870 & 29.778 & 33.066 & 36.786 & 45.762 & 57.275 & 72.052 & 91.025 & 115.380 & 146.628 & 186.688 \\ \hline Period 25 & 28.243 & 32.030 & 36.459 & 41.646 & 47.727 & 54.865 & 73.106 & 98.347 & 133,334 & 181.871 & 249.214 & 342.603 & 471.981 \\ \hline Period 30 & 34.785 & 40.568 & 47.575 & 56.085 & 66.439 & 79.058 & 113.283 & 164.494 & 241.333 & 356.787 & 530.312 & 790.948 & 1,181.882 \\ \hline Period 40 & 48.886 & 60.402 & 75.401 & 95.026 & 120.800 & 154.762 & 259.057 & 442.593 & 767.091 & 1,342.025 & 2,360,757 & 4,163.213 & 7,343.858 \\ \hline \end{tabular} Print Done more help. Consider how Chenry Valey, a popular ski cesort, could uso captal budgeting to decide whether the $9.5 million Autumet Park Lodge expansicn would be a good investment. ;Cick the icon to wiew the expansion estimates.) (Cick the icon lo view the presend valie annusy tactor tabie) (Click the icon to virw the tubure value annuty factor table) (Cick the icon to view the present value factor table) (Cock the icen to view the future value factor table.) Read the tequacecents Requirement 1, What is the projecr's NPV? is the investmont aftractive? Why or why not? Calculate the net present value of the expavsion. (Found your answer to the nearest whole dollar. Use parentheses or a minus sign foe a negative nat present value) Net present vatue of expansion \begin{tabular}{|l|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Periods & 1% & 2% & 3% & 4% & 5% & 6% & 8% & 10% & 12% & 14% & 16% & 18% & 20% \\ \hline Period 1 & 0.990 & 0.980 & 0.971 & 0.962 & 0.952 & 0.943 & 0.926 & 0.909 & 0.893 & 0.877 & 0.862 & 0.847 & 0.833 \\ Period 2 & 1.970 & 1.942 & 1.913 & 1.886 & 1.859 & 1.833 & 1.783 & 1.736 & 1.690 & 1.647 & 1.605 & 1.566 & 1.528 \\ Period 3 & 2.941 & 2.884 & 2.829 & 2.775 & 2.723 & 2.673 & 2.577 & 2.487 & 2.402 & 2.322 & 2.246 & 2.174 & 2.106 \\ Period 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 \\ Period 5 & 4.853 & 4.713 & 4.580 & 4.452 & 4.329 & 4.212 & 3.993 & 3.791 & 3.605 & 3.433 & 3.274 & 3.127 & 2.991 \\ \hline Period 6 & 5.795 & 5.601 & 5.417 & 5.242 & 5.076 & 4.917 & 4.623 & 4.355 & 4.111 & 3.889 & 3.685 & 3.498 & 3.326 \\ Period 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 \\ Period 8 & 7.652 & 7.325 & 7.020 & 6.733 & 6.463 & 6.210 & 5.747 & 5.335 & 4.968 & 4.639 & 4.344 & 4.078 & 3.837 \\ Period 9 & 8.566 & 8.162 & 7.786 & 7.435 & 7.108 & 6.802 & 6.247 & 5.759 & 5.328 & 4.946 & 4.607 & 4.303 & 4.031 \\ Period 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 \\ Period 11 & 10.368 & 9.787 & 9.253 & 8.760 & 8.306 & 7.887 & 7.139 & 6.495 & 5.938 & 5.453 & 5.029 & 4.656 & 4.327 \\ Period 12 & 11.255 & 10.575 & 9.954 & 9.385 & 8.863 & 8.384 & 7.536 & 6.814 & 6.194 & 5.660 & 5.197 & 4.793 & 4.439 \\ Period 13 & 12.134 & 11.348 & 10.635 & 9.986 & 9.394 & 8.853 & 7.904 & 7.103 & 6.424 & 5.842 & 5.342 & 4.910 & 4.533 \\ Period 14 & 13.004 & 12.106 & 11.296 & 10.563 & 9.899 & 9.295 & 8.244 & 7.367 & 6.628 & 6.002 & 5.468 & 5.008 & 4.611 \\ Period 15 & 13.865 & 12.849 & 11.938 & 11.118 & 10.380 & 9.712 & 8.559 & 7.606 & 6.811 & 6.142 & 5.575 & 5.092 & 4.675 \\ Period 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 \\ Period 25 & 22.023 & 19.523 & 17.413 & 15.622 & 14.094 & 12.783 & 10.675 & 9.077 & 7.843 & 6.873 & 6.097 & 5.467 & 4.948 \\ Period 30 & 25.808 & 22.396 & 19.600 & 17.292 & 15.372 & 13.765 & 11.258 & 9.427 & 8.055 & 7.003 & 6.177 & 5.517 & 4.979 \\ Period 40 & 32.835 & 27.355 & 23.115 & 19.793 & 17.159 & 15.046 & 11.925 & 9.779 & 8.244 & 7.105 & 6.233 & 5.548 & 4.997 \\ \hline \end{tabular} Print Done