Question Help Consider how Cole Valley Brook Park Lodge could use capital budgeting to decide whether the $13.500.000 Brook Park Lodge expansion would be a good investment. Assume Cole Valley's managers developed the following estimates concerning the expansion ( che con to view the times) (Click the icon to view addisional Wormation) Click the coon to view Present Value of $1 table) Click the icon to view Presentace of Ordinary Annuity of $1 table) What is the projects NPVround to nearest or is the investmenttractive? Why or why not? Calculate the net present value of the expansion (Enter any factor amounts to the decimal places, XXXX Round to the rear whole dolar Not Cash Annuity PV Factor PV Factor Present Years Inflow 10%. 10 10% 10 Value 1.10 Present of annuity 10 Present value of residual value Total PV of cash infos 0 Initial investment Net present value of expansion Data Table More info Number of anal seper day Average number of days per year weather conditions allow skiing at Cole Wiley Use of expansion in years) Average cash per by each sker per day Average variatie cost of serving each skler per day Cost of expansion Discount 10 years $ 237 77 13.500,000 10% Assume that Cole Valleyes the right ne depreciation method and expects the lodge expansion to have a residual value of $500.000 at the end of to ten year We. They have already calculated the average wnual net cashindowper you to be $2,865,280 Print Done Print Done Isaac Maldonad work CH26 H 7 of 11 (2 complete) Reference Practive? Why ansio 05 we 0.162 sion Present Value of 1 Periods 1% 3% 4% 5% 6% 05 94 10% 12% 14% 15% 16% 20% 0.580 0.71 0.962 0.9520913 093 0.926 0.9170.900 0993 016770 370 0362 0847 0.833 2 0.980 0.31 0.943 0.05 0.9OT0.890 0.750.857 0.842 0.025 0.797 0.789 0.750 0.743 0.7180.594 3 0.971 0.92 0.915 0.889 0.8640340 03 0.7940.772 0.751 07120.675 0.868 0.541 0.609 0.579 4 0.961 0.9 0.88 0.855 0.23 0.792 0.763 0.735 0.708 0.683 0.535 0.582 0.572 0.552 0.516 0.42 5 0.961 0.05 0.863 0822 0.784 0747 0.7130601 0.567 0.519 0437 0.478 0.437 0.402 0.942.BBB 0837 0.790 074 0.705 0.6 0.630 0.500.554 0.5070456 042 0410 0.370 0.335 7 0.933 0371 0.813 0.7600.711 0.665 0.623 0.59 0.513 0.4520.400 0.375 0.354 0.314 0.279 8 0923 0.853 0.789 0.73 0677 0527 0.582 0.540 0.502 0.417 0.4040.351 0327 0.305 0.206 0.230 9 0.914 0.837 079 0.703 0.545 0.592.40.500 0.480 0.424 0.361 0.308 0.24 0.263 0.225 0.194 40 0.50 0820 0.744 0.676 0644 0.55 0.508 0.463 0.422.36 0.1220270 0.267 0.227 0.191 11 0.99 0.304 0.7220.650 0.50 0.527 04750429 0.388 0.50 0.287 0237 0215 0.195 0.162 0.135 07 TRB 0701 0.625 0557 0497 040.397 0.319 0.2570 201 0.187 0.158 0.137 0.112 13 0.879 0.773 0.681 001 0500 0.415 0.0.326 0.200 0.229 0.1820.160 0.145 0.110 0.090 14 0870 0.758 0.661 0577 0505 0442 0.340 0.20 0.250 0.206 0.160 0.41 0.125 0.09 0.078 15 0.10743 0.542 0.555 0.481 0417 0.2 0.315 0.275 0.250 0.133 0.100.123 0.108 0.04 0.065 0.053 0.720 0623 0.534 0.458 0.394 0.330 0.250 0.252 0.218 0.1630123 0.1070.0000071 0.054 17 0.714 0.50 0.513 0456 0371 0.317 0270 0231 0.19 0.1460108 0093 0.0800060 0045 19 0336 0.700 0.581 0.494 0.416 0.296 0250 0212 0.160 0.130 0.0950081 0.000 0.051 0.038 19 0.570 0.475 03 0331 0277 0232 0.14 0.1640.116 0.083 000 0.00 0.043 0.031 20 0.820 0.6730.5540.456 0.37703120.258 0215 0.1780 149 0.14 0.073 0.0610051 0.037 0.0 21 0.660 053804300.350234 0242 0.19 0.140.135 0.093 0.064 0.06 0.04 0.031 0.022 0.800 000 0.522 0.422 0.342 0.278 0226 0.14 0.15 0.123 0.08 0.056 0.046 0.000 0.025 0.018 22 ONS 0.534 0.50 0.45 0.326020202110.170 0.13 0.112 0.04 0.049 0.040 0.035 0.002 0.015 24 0.788 0.522 0492 0.300.30 0.27 0.1970.150 0.125 0.1020.066 0.043 0.035 0.0280019 0.013 25 0.70 0.010 0.478 0.375 0.29 0233 0.184 0.146 0.19 0.000 0.00 0.00 0.00 0.00 0.016 0.010 26 07720.454 0.351 0281 02200.172 0.135 0.106 0.034 0.0530030 0.025 0.021 0.014 0.000 27 0.764 0.5M 0.450 0.349 0.250 0.20 0.16 0.125 0.0980.078 0.047 0.000 0.023 0.018 0.011 0.007 29 0.757 0574 0437 0333 0.256 0.16 0.150 0.19 0.000 0.00000 0.00 0.00 0.05 0.010 000 0749 0.500 0.424 0321 0243 0.185 0.141 0.107 0082 0.083 GOST 0.022 0.017 00140.000 30 0.005 0.742 053 0412 0.231 0.174 0.131 0.009 OPS 0.057 0.00 0.020 0015 0012 ODOT 0.004 40 0.453 0.307 0.208 0.142.097 0.067 0046 0.032 0.022 0.01 0.005 0.004 0.003 0.001 0.001 0332 0.141 0.07 0.054 0.004 0021 2013 0.009 0.003 0.001 0.001 0.001 0144 per day year that ch sker per ving each 0.30 Print Print Done MacBook Pro C Search or type URL @ % & 2 3 4 5 6 7 8 9 History Bookmarks People Tab Window Help Do Homework - Isaac Maldonado ork.aspathomeworkid-565746977&questionid=18flushed=false&cid=60158248centerwin-yes Isaac Maldonado work CH26 HW 7 of 11 (2 complete Reference vestre tractive? Why ansio Periods 1 2 3 4 5 6 4355 10 BOS an 11 12 13 14 15 Present Value of Ordinary Annuity of S1 1% 23 3% 4 5% 7% 8% 94 10% 124 10% 15% 18% 10% 20% 0.910 1900 0.971 0.92 0.952 MB 0915 0.926 0917 6.900 0.80 0.877 0.870 0.882 0.347 033 1990 1912 1913 184 1859 1.833 1 500 1.783 1.750 1738 1000 1547 1.605 1566 1528 2NI 2014 2.8292775 2.723 2673 2.624 2577 2531 2487 2402 23222283 2246 2174 2.106 3.902 3.500 3.717 3630 3.546 3.405 3.387 33123240 3.10 3.037 2.914 2.856 279 2.690 2.580 4713 45804452 4329 4212 4 100 3.993 3.800 3.791 3608 3433 3.352 32143127 2991 5.7955601 5.417 52425.07 49174767 4699 4486 4.111 3.8893794 3.685 3498 3.326 67286.4726230 6.000 5.786 552 5.389 5.206 5.033 4.868 4.554 4288 4.160 4030 3.812 3.505 76527325 7020 6733 6210 5.971 5.747 5.535 53154 4344 4.078 3.837 8.566 816277867435 7.100 6.802 6.5156247 5.966 5.750 5.3284.946 4.772 4.507 4300 4.001 9.4718980 8530 8111 7.722 7.360 70246710 6.418 6.545 5.6505216 5.619 4.833 4494 4.192 1039.787 9253 8.700 8300 7.887 7499 7.139 6.4865,938 5.453 5234 5029 4656 11255 105759.9549.35 8863 8584 7.943 75 6.814 6.1 5650 5.421 5.1974.793 4439 12.15411.345 10 605 9.99 8.8538.358790474B7 7.103 8.45.842 5.589 5.3424.910 4.530 13.004 12.106112 10.569.99 9.296 8145 8.2447.786 737 6.628 6.000 5.724 5.4685.000 4611 13.80512849 1195 11.11810.3808.712 0.1088.550 8061760668116.142 5.547 5.575 5.092 4.675 54.71813 578 12.561 11652 10.83 10.106 8.851 8.3137824 8974 6.265 5.954 566951024.730 15.562 14292 13.166 12.156 11 274 10.4779753 9.122854480227.120 6373 6047 5749 5222 4.775 16300 14.992 13.754 12.650 11600 10828 10.0509.372 8.756 8.2017.250 6.467 6.128 5.818 5.2734.812 17 226 15.678 1432413.1341204511 1581039695048950 8.365 6.550 5.877 5316 4.844 18.046 16.35 14.877 13.590 1246211470 10.5049.818 9.129 8.514 7.480 6.623 6.2595.220 5.350 4.870 18.85T17011 15.415 14.029 12.821117541083 100179.282 8849 7.562 6.687 6.312 5.973 5.354 4891 1966017658 1593714451 13.16 12.042 11061102019.4428.772 7.645 6.743 6350 8.011 4900 20.45 18.282 16.464 14.857 13.430 12.30311272 10.371 9.580 8.883 7.718 6.792 6.399 6.044 4.925 2124318.914 1695 15247 13.700 12.550 11400 10 5299707 8.98577346 RIS 6.434 8013 5.451 4,937 22.023 195231741315.622 14.094 12.783 11.654 106759823 9.077 7.8436.873 6097 5.467 4.948 22.795 2012117 KT1598314375 13.003 11.2010.8109.9299161 7.896 6.900 6.491 6.118 5.480 4956 23.560 20 TOT 18 327 433014643 13.211 11.587 10.905100279237 7.943 6.995 8.130 5.492 4964 2431621.28 18.754166631489 13.406 12137 11.061 10.1969.307 7984 6.961 6.534 6.152 5.5024970 25066 2184419.686 1684 15.541 13.501 12278 11.150 10.10 9.3708022 6.983 6.551 6.166 5.510 4975 25 808 223 19.500 1723215.372 13.765 12.400 11.250 102740.4278.055 7.000 6.566 6.177 5.517 4919 3283527385 23.115 19.733 17.159 15.046 13.38211825 10.7579.778.244 7.105 6.542 6233 5.548 4.997 39 190 3142425.730 214821825615.782 13.801 12233 10.9629.915 8304 7.130 6.661 6.24855544.999 940 16 17 13 18 20 rday 5.410 21 22 23 arthal 25 6514 kier per ng each 25 27 20 23 30 40 50 Print Print Done MacBook Pro