Consider how Kyler Valloy Waterfall Park Lodge could use capital budgeting to decide whether the 511,000,000 Waterfall Park Lodge expansion would be a good investment. Assume Kyler Valley's managers developed the following estimates concerning the expansion Click the icon to view the estimates.) (Click the icon to view additional information) LED (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of 51 table.) What is the project's NPV (round to nearest dollar)? Is the investment attractivo? Why or why not? Calculato the net present value of the expansion (Enter any factor amounts to three decimal places, XXXX Round to the nearest whole dollar) Net Cash Annuity PV Factor PV Factor (1-14% Year's Inflow (i-14%, n-10) n-10) Present Value Years 1-10 Present value of annuity Year 10 Present value of residual value Total PV of cash inflows Year 0 Initial investment Net present value of expansion Data table Kyler Valley Wald er the $11,000,000 ment. Assume Kyler cerning the expan icon to view the icon to view adda - Xable.) inary Annuity of 51 table.) :)? Is the investment 116 skiers 143 days 10 years net present value Number of additional skiers per day Average number of days per year that weather conditions allow skiing at Kyler 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 pole dollar) 242 Present valued 85 11,000,000 14% Present valued Total PV of cas tea ate the net present valud Assume that Kyler Valley uses the straight-line depreciation method and expects the lodge expansion to have a residual value of $500,000 at the end of its ten-year life. They have already calculated the average annual net cash inflow per year to be $2,604, 316 ble dollar) pors 1-10 Present value od ir timal (CI cull 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) 0.971 0.962 0.952 0.943 09350 926 0.917 0.909 0 893 0.877 0.870 0.862 0.847 0833 Period 20.980 0.961 0.943 0.925 0.9070 890 0.873 0.857 0.8420 826 0.797 0.769 0.756 0.743 0.7180.694 Period 30.971 0.942 0.915 0 889 0.864 0.840 0.816 0.794 0.772 0.751 0.712 0675 0.658 0.641 0609 0579 Period 40.961 0.9240.888 0 855 0.823 0 792 0.763 0.735 0.708 0.683 0.636 0.592 0.572 0552 0.516 0 482 Period 5 0.951 0.906 0.863 0.822 0.784 0.747 0713 0.681 0 650 0.621 05670519 0.497 0.476 0.437 0.402 Period 60.942 0.888 0.837 0.790 0.746 0.705 0 666 0.6300 596 0.564 0.507 0.456 0432 0.410 0.370 0.335 Period 70.933 0.871 0.813 0.760 0.711 0.665 0623 0.5830547 0.513 0.452 0.400 0.376 0.354 0314 0.279 Period 80.923 0.853 0.789 0.731 0.677 0.627 0.582 0.540 0.502 0 467 0.404 0.351 0.327 0.305 0 266 0233 Period 90.914 0 837 0.766 0.703 0.645 0.592 0544 0.500 0.4600 424 0.361 0.308 0.284 0.263 0225 0 194 Period 0.905 0.820 0 744 06760 614 0.558 0.500 0.463 0.422 0.386 0.322 0.270 0247 0.227 0.191 0.162 10 Period 110.896 0.804 0.722 0.650 0 585 0.5270475 0.429 0.388 0.350 0.287 0.237 0.215 0.1950 162 0 135 Dead In noclenchace Lowozlacenilcolato la colAZA Yd fear Yed Yel Present Value of Ordinary innuity of $1 Periods 1% 2% 3% 4% 5% 6% 7% B% 9% 10% 12% 14% 15% 16% 18% 20% Period 1 0990 0.980 0.971 0.962 0.952 0943 0.935 0.926 0.917 0.909 0.893 0.877 0.870 0.862 0.847 0833 Period 2 1970 1.942 1913 1886 1859 1833 1808 1783 1759 1736 1.690 1647 1626 16051566 1528 Period 3 2941 2884 2.829 2775 27232 673 2 624 2577 2.531 2487 2402 23222283 2246 2174 2. 106 Period 4 3.902 3.808 3.717 3630 3.546 3.465 3.387 3312 3.240 3.170 3.037 2.914 2855 2.798 2690 2589 Period 5 4853 4 713 4580 4452 4329 4 212 4.100 3.993 3.890 3.791 3.605 3433 3352 3274 3.127 2991 Period 6 5.795 5601 5 417 5242 5.076 4.917 4 767 4 623 4.486 4355 4 111 3.889 3.784 3.685 3.498 3326 Period 7 6 728 6 472 62306 002 5.786 5582 5.389 5.206 5.033 4.8684564 4288 4160 4 039 3 812 3.605 Period 8 7 652 7.325 7020 6.733 6.463 6.210 5.971 5747 5.535 5335 4.968 4 6394.487 43444078 3 837 Period 98.566 8. 162 7 786 7435 7 108 6 802 6515 6 247 5.995 5.759 5328 4 946 4772 4607 4.303 4031 Period 10 9.471 8983 8,530 8.111 7722 7360 7.0246 710 6.418 61455650 5216 5019 4833 44944 192 Period 11 10.368 9.787 9253 8760 8 3067 887 7 499 7 1396.805 6.495 5938 5 453 5234 5029 4656 4 327 Period 12 11 25510,575 9.95493858 863 8 384 7943 7536 7 161 6814 6 1945 660 5421 5197 4.793 4 439 Indonesconoclono le colon.1971 013 COLLA