i just need the NPV I know the rest
Check my work Derrick Iverson is a divisional manager for Holston Company. His annual pay raises are largely determined by his division's return on investment (ROI), which has been above 20% each of the last three years. Derrick is considering a capital budgeting project that would require a $3,700,000 investment in equipment with a useful life of five years and no salvage value. Holston Company's discount rate is 16%. The project would provide net operating income each year for five years as follows: $3,100,000 1,300,000 1,800,000 Sales Variable expenses Contribution margin Pixed expenses: Advertising, salaries, and other fixed out-of-pocket costs Depreciation Total fixed expenses $ 660,000 740,000 1,400,000 $ 400,000 Net operating income Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables. Required: 1. Compute the project's net present value. 2. Compute the project's simple rate of return. 3a. Would the company want Derrick to pursue this investment opportunity? 3b. Would Derrick be inclined to pursue this investment opportunity? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3A Reg 38 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 1 0.962 0.952 0.943 0.935 0.926 0,917 0.909 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0.840 0.833 0.826 0.820 0.813 0.806 0.800 2 0.925 0.907 0.890 0.873 0.857 0.842 0.826 0.812 0.797 0.783 0.769 0.756 0.743 0.731 0.718 0.706 0.694 0.683 0672 0.661 0.650 0640 3 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.731 0.712 0.693 0.675 0658 0.641 0.624 0.609 0.593 0.579 0.564 0551 0.537 0.524 0.512 4 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0.659 0.636 0.613 0.592 0.572 0.552 0.534 0.516 0.499 0.482 0.467 0.451 0.437 0.423 0.410 5 0.822 0.784 0.747 0.713 0.681 0.650 0.621 0.593 0.567 0.543 0.519 0.497 0.476 0.456 0.437 0.419 0.402 0.386 0.370 0.355 0.341 0.328 6 7 0.790 0.746 0.705 0.666 0.630 0.596 0.564 0.535 0.507 0.480 0.456 0.432 0.410 0.390 0.370 0.352 0335 0.319 0.303 0.289 0275 0262 0.750 0.711 0.665 0.623 0.583 0 547 0 513 0.492 0.452 0425 0.400 0.376 0354 0.333 0314 0296 0 279 0.263 0.249 0.235 0.222 0.210 0.731 0.677 0627 0.582 0.540 0.502 0.467 0434 0404 0.376 0 351 0.327 0305 0.285 0.266 0249 0 233 0218 0.204 0.191 0.179 0.168 .703 0.645 0.592 0.544 0.500 0.460 0.424 0.391 0361 0333 0 308 0284 0263 0.243 0.225 0.209 0.194 0 180 0.167 0.155 0.144 0.134 0.676 0.614 0.558 0.508 0.463 0.422 0.386 0.352 0.322 0.295 0.270 0.247 0.227 0.208 0.191 0.176 0.162 0.149 0.137 0.126 0.116 0.107 9 0 10 11 13 0.650 0.585 0.527 0.475 0.429 0.388 0.350 0.317 0.287 0.261 0.237 0.215 0.195 0.178 0.162 0.148 0.135 0.123 0.112 0.103 0.094 0.086 0625 0.557 0.497 0.444 0.397 0.356 0.319 0.286 0.257 0231 0208 0.187 0.16 0.152 0.137 0.124 0 112 0.102 0.092 0083 0076 0.069 0.601 0.530 0.469 0.415 0.368 0 326 0.290 0.250 0.229 0204 0.182 0.163 0.145 0.130 0.116 0.104 0.003 0.084 0.075 0.068 0061 0.055 0.577 0.505 0.442 0.388 0 340 0.299 0.263 0.232 0.205 0.181 0.160 0.141 0.125 0.111 0.099 0.0 0.078 0.069 0.062 0.055 0.049 0044 0.555 0.481 0.417 0.362 0.315 0.275 0 239 0.209 0.183 0.160 0.140 0.123 0.108 0.095 0.084 0074 0.065 0.057 0.051 0.045 0.040 0.035 15 16 17 18 19 20 21 24 25 26 27 28 29 30 40 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0.163 0.141 0.123 0.107 0.093 0.081 0.071 0.062 0054 0.047 0.042 0.036 0.032 0.028 0.513 0.436 0371 0317 0.270 0231 0198 0.170 0.146 0.125 0 108 0093 0080 0 059 0 060 0052 0045 0099 0.034 0.030 0026 0.023 0.494 0.416 0.350 0.296 0.250 0.212 0.180 0.153 0.130 0.111 0.005 0.081 0.069 0.059 0.051 0.044 0.038 0.032 0.028 0.024 0.021 0.018 0.475 0.396 0.331 0.277 0.232 0.194 0 164 0.138 0.116 0.098 0083 0070 0 060 0 051 0.043 0.037 0.031 0027 0023 0020 0017 0014 0.456 0.377 0 312 0.250 0.215 0.178 0.149 0.124 0.104 0.087 0.073 0061 0.051 0.043 0.037 0.031 0.026 0022 0019 0016 0.014 0012 0.439 0.359 0.294 0242 0.199 0 164 0 135 0 112 0093 0077 0064 0.05) 0044 0037 0031 0.026 0022 0.018 0015 0013 0011 0009 0.422 0342 0278 0.226 0.184 0.150 0.123 0.101 0.083 0.068 0.056 0.046 0038 0032 0.026 0.022 0.018 0015 0.013 0011 0009 0007 0.406 0.326 0.262 0.211 0.170 0.13 0.112 0.091 0.074 0.00 0.049 0.040 0033 0027 0.022 0.018 0015 0.012 0010 0000 000 0006 0 390 0310 0247 0197 0.158 0.126 0.102 0082 0.066 0.053 0.043 0.035 0.028 0023 0.019 0,015 0,013 0010 0.008 0.007 0006 0.005 0.375 0.295 0.233 0.184 0.146 0.116 0.092 0.074 0.059 0.047 0.038 0.030 0.024 0.020 0016 0013 0010 0.009 0.007 0.006 0.005 0.004 0.361 0281 0220 0.172 0.135 0.106 0084 0066 0.053 0.042 0.033 0.026 0.021 0.017 0014 0011 0009 0.007 0.006 0.005 0.004 0.003 0347 026 0207 0.161 0.125 0.098 0.076 0060 0.047 0.037 0.029 0023 0.018 0014 0011 0009 0007 0006 0005 0004 0001 0002 0333 0255 0.16 0.150 0.116 0.090 0 069 0054 0.042 0.033 0.026 0.020 0,016 0012 0010 0000 000 0005 0.004 0.003 0.002 0.002 0.321 0741 0.15 0.141 0.107 0.002 0.063 0.048 0.037 0.029 0.022 0.017 0.014 0.011 0.008 0.006 0.005 0004 0003 0.002 0.002 0.002 0.308 0.231 0.174 0.131 0.009 0.075 0.057 0044 0033 0.025 0.020 0,015 0,012 0.000 0.007 0.005 0.004 000 000 000 0002 0001 0.208 0.142 0.097 0.067 0.046 0.032 0.022 0015 0011 0.008 0.005 0.004 0.003 0.002 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 Periods485 687%8 9% 10811812813314515% 16517818319%20%21%22%23624%25% 1 0.962 0952 0943 0935 0926 0.017 0.009 0.001 0.8930 0977 0.870 0.862085 00470840 0833 0.826 0820 08130806 0800 21 19 13 18 T100 10:17:30 36 66 , 4 4: 9 : 30 :17: 106 2014:04:2011 1981957 4 3.630 3546 3465 3367 3312 3240 3.170 3102 3.037 2.974 2.914295% 2.70H 2743 2.690 2639 2.599 2540 2494 2.448 2.40 2362 5 4452329 212 4100 1993 1990 31 3696 1 4335,3774911230529129.62 ,600 27 289 13 5 5.242 5076 4.917 767 4.623 4.46355 4.231 111 3.998 39 3784 3.6% 3.59 3.498 3410 3.326 3245 3167 3092 3020 2951 7 5.002 1.76 5,582 139 5.206 5.033 .868 4712,564 4423 4.28 1110 4039 3922 3812 3706 3605 3606 1416 19273742316 B T36) 11 01 : 00 3 4081311118.1.9 197 36710 02 5.55 5,247 5,995 5759 5.57 5.32% 5122 1946 772 4,607514303 4163 4001 1.00 3. 75 3673 3 5466 3.463 109111 1/22 1060702 6710 6.41 6.1155890 650 1,4266216 5.00 4,893 E59 4,494 4339 1024.05 3923 3799 36823571 118.760 8.306 7 8877499 7.139 6.86 6.495 6207558 5.687 5.453 5234 5.029 85 4.65 4.46 4327 4.177 4.035 3.902 3776 3656 19563I 4 2013 15 16111649261945918 5C60 5.15101 10 2014 11 41 4270 1121 19536137 1996 194 1104 14:1101 GTAO424122,42, 1,1, 1 910 11: 36: 01 16:1912. 0 1 10 562 9999 9295 87512 1761,942 3 02 02/24 ) 20 1,000 4802611 42 4265 10B 3962382 15 11.118 10.380 9712 9.108 8.559 80617.005 7.191 6.11 5.462 6.142 5.847 5,575 5.324 5.002 4,876 4.675 4.489 4315 4193 4.001 3859 16 11.652 10438 10 106 9447 8451 8313742473796974 604 6265 5954 5.668 5.405 5.162 938 730 4.536 4357 4.19 a033 3887 12.16 11.27 10.477 9.763 9.122 8.54 80227.549 7.120 0.729 6373 6.047 5.749 5.475 5.222 4.990 4.775 .576 4.391 4219 4.059 3910 16 12.659 11.690 10 828 10.069 9372 4756 82017.7027250 6.40 6.4167 6121 5.81 5534 5273 5.033 4812 4.608 4.419 4.243 400 3928 119 13 134 12 085 11.158 10 336 9604 8980 8365 7.89 7366938 6.50 6.196 587735845316 5070 4843 4635 442 4263 4.0973942 2013.590 12.462 11.470 10.594 9618 9.129 8514 7.96 27 469 7025 6623 6.259 5.929 5.628 5.353 5.101 4.870 4657 4.460 4.279 4110 3954 21 14.029 12.421 11764 10 136 10017 12/128649 8071 7.562 7102 6.07 6.1125973 5665 5 314 12) 4 1 46 447 4202 4.121 3963 14.451 1313 12 042 11 06 10 2010442 4772 .76 7645 7.170 67436359 6011 5 66 5.410 5.10 800 460 148 4302 130 3970 14 857 13 9 12303 11272 10 11 1500 ARM38266 7716 7230 0.792 6390 6.041 1773 5432 5 167 19215 1703) 1.190 4.0|| 4137 397 2415,24713799.12.550 11,469.10.5299.7078,9858,3487,7847.28368356.4346,0735.7465,4515.1824.9374,7134.5074.3184.1433,981 25 15622 14 004 12 163 11.654 10 675 98239077 842276437110 6173 6464 60975 76 5467 5.195 4948 47215144323 4.1473985 26 15.163 14.375 13.003 11.026 10.810 9.920 9.161 1.460 75 7372 6.906 6191 611 173 5480 5. 26 1956 4728 15.20 4328 4151 3988 16.330 14 143 13211 11.087 10935 100279237 1548 7943 7409 6935 65146 36 1798 54925215 964734 45244312 4154 3990 28 16 663 14 198 13406 12.137 11.05] 10 1169307 B E02 1984 7.44] 6.96] 6534 6.152 5810 5102 5.223 1970 4730 158 33 1117 3992 2016 1994 11 1 13591 1227 1116 10 191 9370 0.60 802271 700 0 1101 0561 6164 15 0.0 15 15 10 15 19 1975 4.7] 31 1107 4.1513994 30 17202 15.172 13765 12 400 11.26 10 274 94278694 1055 1406 7003 6566 6177 5829 5.51 5235 1979 4.746 4 534 4319 4.160 3995 40 19793 17 159 15.046 13332 11.925 10.7579770 1951 8247634 7106 66426233 5 671 5.54 5.250 997 a760 4544 4347 4.166 3999