please help :)

Consider how Hunter Valley Snow Park Lodge could use capital budgeting to decide whether the $11,000,000 Snow Park Lodge expansion would be a good investment. Assume Hunter Valley's managers developed the following estimates concerning the expansion (Click the icon to view the estimates ) (Click the icon to view additional information) Click the icon to view Present Value of $1 table) (Click the icon to view Present Value of Ordinary Annuity of S1 table) What is the project's NPV (round to nearest dollar)? Is the investment attractive? Why or why not? Net Cash Calculate the net present value of the expansion (Enter any factor amounts to three decimal places, XXXX Round to the nearest whole dollar) Annuity PV Factor PV Factor (i 10% Years Inflow (i=10%, n=7) n-7) Present Value Years 1 - 7 Present value of annuity Year 7 Present value of residual value Total PV of cash inflows Year 0 Initial Investment Ld Net present value of expansion Data table - X 121 skiers 142 days Number of additional skiers per day Average number of days per year that weather conditions allow skiing at Hunter Valley Useful life of expansion (in years) Average cash spent by each skier per day Average variable cost of serving each skier per day Cost of expansion Discount rate 7 years $ 241 83 11,000,000 10% Print Done a Assume that Hunter Valley uses the straight-line depreciation method and expects the lodge expansion to have a residual value of $600,000 at the end of its seven-year life. They have already calculated the average annual net cash inflow per year to be $2,714,756. Print Done Reference Present Value of $1 Periods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18% 20% Period 1 0.990 0.980 09710 962 0 952 0.943 0.935 0.926 0917 0.9090.893 0,877 0.870 0.862 0.8470833 Period 2 0 980 0961 0943 0.925 0.907 0.890 0.873 0857 0 842 0.8260 797 0.769 0.756 0.743 0.7180.694 Period 3 0.971 0.942 0.915 0 889 0 864 0.8400816 0.794 0.772 0.751 0.712 0.675 0.658 0.641 0.6090 579 Period 4 0.961 0.924 0.888 0 855 0.8230.792 0.763 0.735 0.7080683 0.636 0.592 0.572 0.552 0.516 0.482 Period 5 0.951 0.906 0.8630822 0.784 0.747 0.713 0.681 0.650 0.621 0 5670.5190.497 0.4760.437 0.402 Period 6 0.9420 888 0.837 0.790 0.746 0705 0.6660.630 0.596 0.564 0.507 0.456 0.432 0.410 0.3700335 Period 7 0.933 0.871 0.813 0.760 0.711 0.665 0.623 0.58305470513 0.452 0.4000376 0.354 0.314 0.279 Period 8 0.923 08530789 0.731 0.677 0.627 0.5820.540 0.502 0.467 0.404 0.351 0.327 0.305 0 266 0233 Period 9 0.914 0.837 0.766 0703 06450.5920.544 0.5000 460 0.424 0.361 0.308 02840.263 0.225 0.194 Period 10 0.905 0.820 0.7440676 0.614 0.558 0.508 0.463 0.422 0.386 0.3220270 0.2470 227 0.191 0.162 Period 11 0.896 0.804 0.722 0.650 0.585 0.527 0.475 0.429 0.388 03500 287 0237 0215 0.195 0.162 0.135 Period 12 0.887 0788 0.701 0625 0557 0.497 0 444 0.3970356 0.319 0257 0.208 0.187 0.168 0.1370 112 Period 13 0.879 0.773 0.681 0801 0.530 0.469 0.415 0.368 0 326 0.290 0 229 0.182 0.163 0.145 0.116 0.093 Period 14 0870 0.758 0 661 0.577 0.505 0.4420388 0.340 0.299 0.263 0.205 0.160 0.141 0.125 0.099 0.078 Period 15 0 861 0.743 0.642 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.183 0.140 0.123 0.108 0.084 0.065 Period 16 0.853 0.728 0.623 0.534 0.458 0.394 0339 0.2920 2520.218 0.163 0.123 0.107 0.093 0.071 0.054 Period 17 0.844 0.714 0 605 0.513 0.436 0.371 0317 0.270 0.231 0.1980.146 0.108 0.093 0.080 0.060 0.045 Period 18 0.836 0.700 0.587 0.494 0.416 0.3500 296 0.250 0.212 0.180 0.130 0.095 0 081 0.059 0.051 0.038 Period 19 0828 0.686 057004750396 0.331 0.277 0232 0.1940 164 0.116 0.083 0.070 0.0600043 0.031 Period 20 0820057305540456 0.37703120258 0.215 0 1780 1490 104 0.073 0.061 0.051 0.037 0 026 Period 21 0811 0.660 0.538 0.439 0.359 0.294 0.242 0.1990.164 0.135 0.093 0.064 0.053 0.044 0.031 0.022 4 Print Done erence Period 10 0.905 0.820 0.744 0.676 0.614 0.558 0.508 0.463 0.422 0.386 0.322 0.270 0247 0.2270191 0.162 Period 11 0.896 0.804 0.722 0.650 0.585 0.527 0.475 0.429 0.3880 350 0.287 0237 0.215 0.195 0.162 0.135 Period 12 0.887 0.788 0.701 0.62505570.497 0.444 0.397 0.356 0.319 0.257 0.208 0.187 0.168 0.137 0.112 Period 13 0.879 0.773 0 6810601 0.530 0.4690.415 0.368 0326 0.290 0.229 0.182 0.163 0.145 0.116 0.093 Period 14 0.870 0.758 0.661 0.577 0505 0.442 0.388 0.340 0.299 0.263 0.205 0.1600.141 0.125 0.099 0.078 Period 15 0.861 0.743 0.642 0.555 0.481 0.417 0362 0315 0275 0.239 0183 0.140 0.123 0.108 0.084 0.065 Period 16 0.853 0.728 0.623 0.534 0.4580 394 0339 0.292 0.252 0.218 0.163 0.123 0.107 0.093 0.071 0.054 Period 17 0.844 0.7140.605 0513 0.4360 371 0317 0.2700231 0.1980.146 0.108 0.093 0.080 0.060 0.045 Period 18 0836 0.700 0.587 0.494 0.416 0.350 0.296 0.250 0.212 0.180 0.130 0.095 0.081 0.069 0.0510038 Period 19 0.828 0.686 0.570 0.475 0.396 0.3310 277 0.2320 1940.164 0.116 0083 0.070 0.060 0.043 0.031 Period 20 0 820 0 673 0 554 0.456 0377 0.312 0258 0215 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 0242 0.199 0.1640.135 0.093 0.064 0.053 0.044 0.031 0.022 Period 22 0.803 0.647 0.522 0.422 0342 0278 0.226 0.184 0.150 0.123 0.083 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.1700.138 0.112 0.074 0.049 0.040 0.033 0.022 0.015 Period 24 0788 0.622 0.492 0.390 0.3100247 0.1970.158 0.126 0.102 0.066 0.0430035 0.028 0.019 0.013 Period 25 0.780 0.610 0.478 0.375 0295 0233 0.184 0.146 0.116 0.092 0.059 0.038 0.030 0.024 0.0160.010 Period 26 0.772 0.598 0.464 0.361 02810 220 0.172 0.135 0.106 0.084 0.053 0.033 0.026 0.021 0.014 0.009 Period 270.764 0.586 0.450 0.3470268 0.207 0.161 0.125 0.098 0.076 0047 00290023 0.0180.0110.007 Period 28 0.757 0.574 0.437 03330255 0.196 0 150 0.116 0090 0.069 0.042 0026 0.0200.016 0.010 0.006 Period 29 0.749 0.563 0.4240321 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 0231 0.174 0.131 0.099 0.075 0.057 0.033 0.020 0.015 0.0120.007 0.004 Period 40 10 672) 0.4530 30702080.1420.097 0.067 0.046 0.032 0.022 0.011 0.005 0.004 0.003 0.001 0.001 Period 500 608 0372 0.228 0.141 0.087 0054 0034 0.021 00130.009 0.003 0.001 0.001 0.001 Print Done Present Value of Ordinary Annuity of $1 Perods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18% 20% Period 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.9090.893 0.8770870 0.862 0.8470.833 Period 2 1970 1942 1.913 1.886 1.859 1.833 1,808 1.783 1.759 1.736 1.690 1647 1626 1.6051.566 1528 Period 3 2941 28842829 2.775 2723 2673 2624 2577 2 531 2.487 240223222283 2246 2.174 12 106 Period 4 3.902 3 8083717 36303 546 3.4653387 3.3123.240 3.170 3.037 2914 2855 2.798 2690 2.589 Period 5 4 853 4.713 4580 4.452 4329 4 212 4 100 39933.890 3.791 3.605 3.433 33523 274 3.127 2.991 Period 6 5.795 5.601 5417 5.2425.076 4 917 4.767 4.623 4.486 4355 4.111 3.889 3.784 3.685 3.498 3.326 Period 7 6.728 6.472 6230 6.002 5.786 5582 5.3895 206 5,033 4.86845644288 4.160 4.039 3.812 3.605 Period 8 7 652 7325 70206.733 6.463 6210 597157475 535 5335 4.968 4 639 4.487 4344 4.078 3.837 Period 9 8.566 8. 162 7.786 7435 7 108 6.802 6515 6 247 5.995 5759 5328 4 946 4772 4 607 4.303 4031 Period 10 9.471 8.983 8.530 8.111 7722 73607024 6710 6.418 6 145 5650 5216 5019 4 833 4.494 4 192 Period 11 10 368 9.787 | 9.2538.760 8.30678877499 7 1396 805 6.495 5.938 5.453 5234 502946564327 Period 12 11 255 10,575 9.9549,385 8863 8 3847 943 753671616 814 6.194 5.660 5.421 5.1974.7934439 Period 13 12. 134 11 348 10 635 9986939488538.35879047.487 7 103642458425583 53424.910 4 533 Period 14 13.004 12 106 11.296 105639.899 9.29587458 2447.78673676 628 6.002 5.724 5.468 50084611 Period 15 13 865 12 849 11938 11 118 10 3809712 9.108 8.56980617 606 6811 6.1425 847 5.575 5.092 4.675 Period 16 14.718 13.57812561 11.652 10 838 10.106) 9.4478.851 8313 7.824 6.974626559545.6695 162 4.730 Period 17 15 562 14 292 13.106 12 106 11 274 10.4771 9.763 9.1228544802271206.373 6047 5.749 5 222 4.775 Period 18 16 398 14992 13.754 1265911 690 10 828 10 059 93728.7568.201 7.250 6.467 6.128 58185273 4.812 Period 19 17.226 15 6781432413.134 1208511 15810.336 9.6048950 8.3657366 6.550 6.198 5.877 5 316 4 844 Period 20 18.046 16351 14 877 13 59012462111470 10.504 9.818 9.129 85147489 6.623 6.259 5.92953534870 Period 21 18.857 17 01115415 14.029 12 821/11764 10.836 10.0179292 8.6497562 6687 6312 5.973 53844891 Print Done ference Period 10 9:4718.983 85308.111 7722736070246.710 6.418 6.145 5.6505216 5.019 4.833 4.494 4192 Period 11 10 368 9.787 9.2538.760 8 306 7 887 7.499 7.139 6.805 6.495 5.938 5.45352345 029 4.656 4327 Period 12 11.255 10.575 9 954 9.385 8.863 8.384 79437.5367 1616 814 6.194 5.660 5.421 5.19747934439 Period 13 12. 134 11 348 10.635 9.9869.3948.85383587.9047.487 7.103 6.424 58425583 5 342 4.910 4.533 Period 14 13.004 12.106 11.296 10.563 9 899 9.295 8.745 8.2447 786 7.367 6.628 6.002 57245.468 5.0084611 Period 15 13.865 12 849 11 938 11.118 10 380 9.712 9.108 8.559 8.0617 606 6 811 6.142 5.8475.575 5.092 4.675 Period 16 14.718 13.578 12 561 11.652 10.838 10.106 9.447 8.851 8.313 7 824 6 974 6 265 59545.669 5.1624.730 Period 17 15 562 14 292 13.166 12 166 11 274 10.4779.763 9.122 8.544 8.022 7.120 6373 6.047 5.749 5.222 4.775 Period 18 16 398 14992 13.754 12659 11690 10.828 10.059 9 3728 756 8 2017.250 6.467 6.128 5.818 5 273 4.812 Period 19 17 226 15.678 14.324 13.134 12085 11.158 10 33696048.95083657366 6.550 6.1985 877 5.316 4 844 Period 20 18.046 16.351 14 877 13 590 12.462 11 470 10 5949 818 9.129 8.5147.469 6 623 6.259 5.929 5353 4.870 Period 21 18 857 17 01115.415 14.029 12.821 11.764 10.836 10 017 9.292 8.6497.562 6.687 6.3125 973 5.384 4.891 Period 22 19 660 17.65815.93714451 13.163 12.042 11.061 10 2019 442 8.772 | 7 645 6.743 6359 6011 5.410 4.909 Period 23 20 456 18.292 16.444 14857 13.489 12 303 11 272 10.371 95808 883 7.718 6.792 6.399 6.044 5.432 4925 Period 24 21.243 18.914 16.936 15 247 13.79912 550 11.469 10.529 9.707 8.985 7784 6835 6.4346.073 5.451 4.937 Period 25 22 023 1952317413 15.622 14.094 12 783 11.654 10 675 9.8239.077 7.8436.873 6.4646097 5.467 4948 Period 26 22795 20 121 17.877 15.983 14.375 13003 11 826 10 810 9929 9.1617.896 6.906 6.491 6.118 5.480 4.956 Period 27 23.560 20 707 18.327 16 330 14 643 13 211 11 987 1093510.027 9.237 7 943 6.935 6.514 6.136 5.492 4.964 Period 28 24 316 21 28118.764 16.663 14898 13.406 12 137 11.05110 116 93077.984 6.961 6.5346 152 5.502 4 970 Period 29 25.066 21.844 19 188 16.984 15.141 13.591 12 278 11.158 10. 1989.370 8.022 6.983 6.551 6.166 5.510 4.975 Period 30 25 808 22 396 19.600 17.292 15 372 13.765 12.409 11 258 10 274 9.4278.055 7003 6.566 6.177 5517 4979 Period 40 32 835 27 355 23.115 19.793 17 159 15.046 13,332 11.925 10.757 9.779 8.244 7.105 6.6426.233 5.548 4.997 Period 50 39.196 3142425 730 21.482 18 256 15.762 13.801 12 233 10.962 9.915 8.304 7.133 6661 | 6.246 5.554 4 999 Print Done