I need help solving requirement two located on the first picture. The question is asking to calculate the additional NPV provided from the refurbishment. The other photos are additional information used to solve the problem. Please help

%E12-29A (similar to) Question Help and will cost $925,000 Projected net Alderman Industries is deciding whether to automate one phase of its production process. The manufacturing equipment has a six year cash flows are as follows EIB (Click the icon to view the projected net cash inflows) (Click the icon to view the present value table) (Click the icon to view the present value annuly table) (Click the icon to view the future value table) (Click the icon to view the future value annuity table) Read the requirements Requirement 1. Compute this project's NPV using Alderman Industries 14% hurdle rate. Should Alderman Industries invest in the equipment? Why or why not? Begin by computing the project's NPV (not present Value). (Round your answer to the nearest whole dollar. Use parentheses or a minus sign for negative net present values) Net present value (40,143) Alderman Industries should not invest in the equipment because its NPV is negative Requirement 2. Alderman Industries could returbish the equipment at the end of six years for $102,000. The refurbished equipment could be used one more year, providing 577,000 of net cash inflows in Your In addition, the refurbished equipment would have a $55,000 residual value at the end of Year 7. Should Alderman Industries invest in the equipment and refurbish it for you? Why of wlwy not? In addition to your answer to Requirement discount the additional cash outflow and inflows back to the present value) Calculate the additional NPV provided from the refurbishment (Round your answer to the nearest whole dolar Use parentheses or a minussion for negative nel present values) Additional NPV provided tromflurbishment Enter any number in the editfelds and then click 1 Temanning 1 part Check Answer Data Table Year 1. Year 2. Year 3. Year 4. $265,000 $252,000 $224,000 $210,000 $200,000 $174,000 Year 5 Year 6. Print Print Done Done Reference Present Value of $1 Periods 1% 2% 3% 4% 5% 6% 8% 10% 12% 14% 16% 18% 20% 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 0.980 0.961 0.943 0.925 0.907 0.890 0.857 0.8260.797 0.7690.743 0.7180.694 0.971 0.942 0.915 0.889 0.864 0.840 0.794 0.751 0.712 0.675 0.641 0.6090.579 0.961 0.924 0.888 0.855 0.823 0.792 0.735 0.683 0.636 0.592 0552 0.516 0.482 5 0.951 0.906 0.863 0.822 0.784 0.747 0.681 0.621 0.587 0.519 0.476 0.437 0.402 6 0.942 0888 0.837 0.790 0.746 0.705 0.630 0.564 0.507 0.456 0.410 0.370 0.335 0.933 0.8710 .813 0.7600.711 0.665 0.583 0.513 0.4520.400 0.354 0.3140.279 0.923 0.853 0.789 0.731 0.677 0.627 0.540 0.467 0.4040.351 0.305 0.266 0.233 0.914 0.837 0.766 0.703 0.645 0.592 0.500 0.424 0.361 0.308 0.263 0.225 0.194 0.905 0.820 0.744 0.676 0.614 0.558 0.463 0.386 0.322 0.270 0.227 0.1910.162 0.8960.804 0.722 0.650 0.585 0.527 0.429 0.350 0.287 0.237 0.195 0.162 0.135 0.8870.788 0.701 0.625 0.557 0.497 0.397 0.319 0 2570 2080.168 0.137 0.112 0 879 0.773 0.681 0.601 0.530 0.469 0.368 0.290 0.229 0.182 0.145 0.116 0.093 0.870 0758 0.661 0.577 0.505 0.442 0 205 0.160 0.125 0.099 0.078 0.861 0.743 0.642 0.556 0.481 0.417 0.315 0.315 0.239 0.183 0.140 0.108 0.084 0.065 0.820 0.673 0 554 0.456 0.377 0.312 0.215 0.149 0.104 0.073 0.051 0.037 0.026 0.780 0 810 0.478 0.375 0.295 0.233 0.146 0.092 0.059 0.038 0.024 0.0160.010 0.742 0.552 0.412 0.308 0231 0.174 0.099 0.057 0.033 0.0200.0120.007 0.004 400.6720463 0.30702080 .142|0.097 0.0460022 0.011 0.005 0.003 0.001 0.001 ooooo 0.263 Done i Reference Future Value of $1 Periods 26 125 1030 1.040 1050 10% 1 100 1.210 1082 S) 1061 1093 1.126 1.159 1.103 16% 1.180 1.346 1.561 1.125 1.080 1 166 1.260 1360 1 158 1.120 1.254 1.406 1574 1.752 1 331 1080 1.124 1.191 1 262 1338 1.419 2015 1.200 1440 1.228 2074 24 1.170 1217 1216 1276 1.392 1.643 1939 2288 1 454 1140 1.300 1482 1689 1.925 2.195 2502 2853 1611 2100 1587 1772 1316 1020 1.040 1.051 1.082 1.104 1.126 1.149 1.172 1.195 1.219 1.243 1258 1.294 1.319 1714 1.359 1504 1594 15 1.010 1.020 1030 1041 1051 1.062 1,072 1083 1.094 1.105 1 116 1.127 1.138 1.149 1 161 1220 1 282 138 2144 1194 1 230 1267 1305 1344 1384 1551 2.586 3.583 4.300 5.180 8192 1.851 1999 2.150 1.423 1480 1.974 2211 2476 2773 3.106 3.479 3252 in the prese 8 3707 2.436 2.826 3.278 3.803 4411 5.117 59 6.885 7988 9268 2700 3.185 3759 4435 5.234 6178 7.288 8599 10 147 11974 = 1539 1.601 2332 2518 1 665 2720 1.469 1513 4226 4818 5.492 6.261 1732 1 346 1001 1710 1796 1886 1.980 2079 2653 3.388 4322 7040 2937 3.172 1558 1808 7 138 1370 2.10 7430 8.916 10.699 12839 15.407 38 338 95 206 237375 1.469772 2.133 2 261 2397 3 207 4292 5703 10286 S88 1.486 1541 4.363 4 887 5.474 9.646 17 000 29.900 93.051 4.561 6.848 10063 21725 2094 2427 3282 6727 10 835 17.449 45259 2.000 3.243 4.801 1.811 19.461 40 874 85 850 378 721 50 950 188 884 27 393 62689 143371 750 378 2208 Print Done e projected net cash inflows.) 2X 1 Reference Periods 1 2 3 0. 0 = Present Value of Annuity of $1 1% 2% 3% 4% 5% 6% 8% 10% 12% 14% 16% 18% 20% 0.990 0.980 0.9710.9620.952 0.943 0.926 0.909 0.8930.877 0.862 0.847 0.833 1.9701.942 1.913 1.886 1.859 1.833 1.783 1736 1.6901.647 1.605 1.566 1.528 2.9412.8842829 2.775 2.723 2.673 2.577 2.487 2.402 2.3222.246 2.174 | 2. 106 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 4.8534.713 4.580 4.452 4.329 4.212 3.993 3.791 3.605 3.433 3.2743.127 2.991 5.795 5,601 5.417 5.2425.0764.917 4.623 4.355 4.1113.8893.685 3.498 3.326 6.728 6.4726.230 6.002 5.786 5.5825.206 4.8684.564 4.288 4.039 3.812 3.605 7.652 7.325 70206.733 6.463 6210 5.747 5.335 4.9684.6394.344 4.078 3.837 8.566 8 1627.786 7.435 7.108 6.802 6.247 5.759 5.328 4.9464.607 4.303 4.031 9.471 8.9838530 8.1117.722 7360 6.7106.145 5.650 5 216 4.833 4.494 4.192 10.368 9.7879.253 8.760 8.306 7887 7.139 6.495 5.938 5.453 5.0294.656 4.327 11.255 10.575 9.954 9.385 8.8638.384 7.536 6814 6. 194 5.660 5.197 4.793 4.439 12.134 11 348 10.6359.986 9.394 8.853 7.904 7 103 6.424 5 842 5.3424.910 4.533 13.004 12 106 11 296 10.563 9 899 9.295 8.244 7.387 6.628 6.0025.468 5.008 4.611 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 18.046 16.351 14.877 13.590 12.462 11.470 9.818 8.5147.4696.623 5.929 5.353 4.870 22.023 19.523 17.41315.622 14.094 12.783 10.875 9.07778436 .8736 0975 .467 4.948 25.80822.395 19.600 17.292 15 372 13.765 11.258 9.4278055 7003 6.1775.517 4.979 32 835 27.356 23.115 19.793 17.159. 15.046 11.925 9.779 8.244 1056,233 5.648 4.997 099 Print Done icon to view the projected net cash inflows.) Reference Future Value of Annuity of $1 Periods 24 5% 165 20% 10% 1000 1000 2040 1.000 2020 3060 4.122 5.204 1.000 2030 3091 4.184 3122 4 245 1.000 2050 3.153 4310 5528 1000 2080 3246 4.506 5.867 7338 1000 2010 3.030 4.000 5.101 6.152 7214 820 9.309 10482 11.567 12.083 13.809 14 16.087 22.019 28 243 4715 6.30 468 6.633 7434 2002 8583 802 5214 0.755 10.150 10583 10.950 11-14 12005 12.100 12 308 136 13 412 14 192 15028 14680 15518 16.527 15 974 1708 18 242 17200 18.5 20024 24 297 25 870 29.778 32.030 35 459 4158 4058 47575 56085 60.10275 60195 025 B. 102 9.549 11027 12578 14207 15 917 17 713 19 599 21579 10% 12% 14% 1.000 1.000 1.000 1.000 1.000 2.100 2120 2.140 2160 2180 2200 3310 3.374 3.400 3.500 3.572 3.640 4.641 4.779 4.921 5.005 5215 5368 6. 105 6353 8.510 6.877 7.154 7.442 7710 8115 8.630 8 977 9.442 9.930 9482 10 000 10730 11.414 12.142 12918 11,436 12.300 13.233 14.240 15327 18.499 13.578 14778 18.085 17519 19.036 20.799 15.37 12549 19337 21321 23.521 25 950 18531 20 856 23.045 25.730 28.755 32.150 21384 24.133 27.271 30.850 34.931 39.581 2453 28.029 32009 36.786 42219 48 497 27.975 32393 37 501 43.672 50 818 59. 196 37 280 33 342 51.660 60.965 72035 57 275 72052 91025 115 380 145.628 188.688 33 347 133 334 181 371 249 214342603471981 154494 2 155 787 510 312 701181882 412.509767.0911 342 02523007574163 213 7343 858 Fall 2015 SKB 317 33.000 47.727 66.430 120 300 154.782 Print Done