Please help!
[The following Information applies to the questions displayed below] Beacon Company is considering automating its production facility. The initial Investment in automation would be $15 million, and the equipment has a useful life of 10 years with a residual value of $500,000. The company will use straight- line depreciation. Beacon could expect a production Increase of 40,000 units per year and a reduction of 20 percent in the labor cost per unit. Answer is complete and correct. Production and Sales Volume Current (no automation Proposed automation) 80.000 units 120.000 units Per Unit Total Per Unit Total $ 90 3 7.200,000 $ 90 10.800.000 Sales revenue Is 18 IS 18 20 25 10 10 Variable costs Direct materials Direct labor Variable manufacturing overhead Total variable manufacturing costs Contribution margin Fored manufacturing costs Niet operating income 53 37 IS 42 2.900,000 $ $ 1.250,000 5 1,710,000 5,040.000 $ 2,350,000 5 2.000.000 2 Determine the project's accounting rate of retur. (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. Accounting rate of return 17.03% 3. Determine the project's payback period. (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. Payback 3.623 years period 4. Using a discount rate of 15 percent calculate the net present value (NPV) of the proposed Investment Future Value of $1. Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1) (Use appropriate factor(s) from the tables provided. Negative amount should be indicated by a minus sign. Enter the answer in whole dollars.) Answer is complete but not entirely correct. Net present value 5,901,432 TABLE 11.1A Future Value of $1 Periods 2% 3% 3.75% 4% 4.25% 5% 6% 7% 8% O 1.0000 10000 10000 10000 10000 10000 10000 10000 1.0000 1 10200 10300 1.0375 10400 1.0425 10500 10600 10700 10800 2 1.0404 10609 10764 10816 10868 11025 11236 11449 11664 3 1.0612 1.0927 1.1168 1.1249 11330 11576 11910 12250 12597 4 10824 11255 1.1587 11699 11811 12155 12625 13108 13605 5 1.1041 11593 1.2021 12167 12313 12763 13382 14026 1.4693 6 11262 1.1941 12472 1.2653 12837 13401 14185 15007 15869 7 11487 12299 12939 13159 13382 1.4071 15036 16058 17138 8 11717 12668 13425 13686 13951 14775 15938 17182 18509 9 1.1951 13048 13928 14233 14544 1.5513 16895 18385 19990 10 12190 1.3439 1.4450 14802 15162 16289 17906 19672 21589 20 14859 18061 20882 2.1911 2 2989 26533 32071 3.8697 46610 Periods 10% 11% 12% 13% 14% 15% 20% 25% 0 10000 10000 10000 10000 10000 10000 10000 10000 10000 1 10900 11000 11100 11200 11300 11400 11500 12000 12500 2 11881 12100 12321 12544 12769 12996 13225 1 4400 15625 3 12950 13310 13676 1404914429 14815 15209 17280 19531 14116 4 1.4641 1.5181 15735 16305 16890 17490 2.0736 2.4414 15386 16105 16851 17523 1 8424 19254 un 2 0114 24883 30518 16771 6 17716 23131 18704 19738 20820 21950 2.9860 3.8147 7 1.8280 19487 2.0762 2.2107 2.3526 2.5023 26600 3.5832 4.7684 1.9926 8 2 1436 59605 2 3045 24750 26584 28525 30590 42998 9 2 1719 23579 25580 27731 30040 3.2519 35179 51598 74506 23674 2.5937 28394 31058 3.3946 3.7072 40456 6.1917 10 93132 20 5 6044 6.7275 80623 9.6453 115231 13.7435 15 3665 38 3376 86 7362 TABLE 11.2A Present Value of $1 Periods 2% 3% 3.75% 4% 4.25% 5% 6% 7% 8% 1 0.9804 0.9709 0.9639 0.9615 0.9592 0.9524 0.9434 0.9346 0.9259 2 0.9612 0.9426 0.9290 0.9246 0.9201 0.9070 0.8900 0.8734 0.8573 3 0.9423 0.9151 0.8954 0.8890 0.8826 0,8638 0.8396 0.8163 0.7938 4 0.9238 0.8885 0.8631 0.8548 0.8466 0.8227 0.7921 0.7629 0.7350 5 0.9057 0.8626 0.8319 0.8219 0.8121 0.7835 0.7473 0.7130 0.6806 6 0.8880 0.8375 0.8018 0.7903 0.7790 0.7462 07050 0.6663 0.6302 7 0.8706 0.8131 0.7728 0.7599 0.7473 0.7107 0.6651 06227 0.5835 8 0.8535 0.7894 07449 0.7307 07168 0.6768 0.6274 0.5820 0.5403 9 0.8368 0.7664 0.7180 0.7026 0.6876 0.6446 0.5919 0.5439 0.5002 10 0.8203 0.7441 0.6920 0.6756 0.6595 0.6139 0.5584 0.5083 0.4632 20 0.6730 0.5537 0.4789 0.4564 0.4350 0.3769 0.3118 02584 0.2145 Periods 9% 10% 11% 12% 13% 14% 15% 20% 25% 0.9174 0.9091 0.9009 0.8929 0.8850 0.8772 0.8696 0.8333 0.8000 2 0.8417 0.8264 0.8116 0.7972 0.7831 0.7695 07561 0.6944 0.6400 3 0.7722 0.7513 0.7312 0.7118 0.6931 0.6750 0.6575 0.5787 0.5120 4 0.7084 06830 0.6587 0.6355 0.6133 05921 0.5718 0.4823 0.4096 5 0.6499 0.6209 0.5935 0.5674 0.5428 0.5194 0.4972 0.4019 0.3277 6 0.5963 0.5645 0.5346 0.5066 0.4803 0.4556 0.4323 0.3349 0.2621 7 0.5470 0.5132 0.4817 04523 0.4251 0.3996 0.3759 0 2791 0.2097 8 0.5019 0.4665 04339 0.4039 03762 03506 0.3269 0.2326 0.1678 9 0.4604 0.4241 0.3909 0.3606 0.3329 0.3075 0.2843 0.1938 0.1342 0.1074 10 0.4224 0.3855 0.3522 0.3220 0.2946 0.2697 0.2472 0.1615 20 01784 01486 0.124001037 00868 00728 00611 0.0261 00115 TABLE 11.3A Future Value of an Annuity of $1 Periods 2% 3% 3.75% 4.25% 5% 6% 7% 8% 1 1.0000 10000 1.0000 1.0000 10000 1.0000 1.0000 10000 1.0000 2 20200 20300 20375 20400 2.0425 20500 20600 2.0700 20800 3 3.0604 3.0909 3.1139 31216 3.1293 31525 3.1836 3.2149 3.2464 4 4.1216 4.1836 42307 4.2465 4.2623 4.3101 43746 4.4399 4.5061 5 5.2040 5.3091 5.3893 5.4163 5.4434 5.5256 5.6371 5.7507 5.8666 6 6.3061 6.4684 6.5914 6.6330 6.6748 6.8019 6.9753 71533 73359 7 7.4343 7.6625 78386 7.8983 7.9585 8.1420 8.3938 8.6540 8.9228 8 8.5830 8.8923 9.1326 92142 9.2967 9.5491 9.8975 10 2598 10.6366 9 9.7546 10.1591 10.4750 10.5828 10.6918 11.0266 11.4913 11.9780 12.4876 10 10.9497 11.4639 11.8678 12.0061 12.1462 12.5779 13.1808 13.8164 14.4866 20 45.7620 24 2974 26.8704 29.0174 29.7781 30.5625 33 0660 36 7856 40.9955 Periods 9% 10% 11% 12% 13% 14% 15% 25% 20% 1.0000 1.0000 1 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 2.0900 2 2.1000 2.1100 2.1200 21300 2.1400 21500 22000 2.2500 3 32781 3 3100 3 3421 3 3744 3.4069 3.4396 3.8125 34725 36400 4.5731 4.6410 4 47097 47793 4.8498 49211 4.9934 5.3680 5.7656 6.1051 6.2278 6.3528 6 6101 5 5.9847 6.4803 6.7424 7.4416 8.2070 77156 79129 8.1152 75233 8 3227 8 5355 87537 99299 6 112588 9.2004 7 9.4872 97833 100890 12.9159 10.4047 10.7305 110668 15.0735 11.0285 11.4359 118594 12 2997 127573 13.2328 8 13.7266 16.4991 19.8419 13 5975 14 1640 13 0210 14 7757 15 4157 9 16.0853 167856 207989 25.8023 10 15 1929 15.9374 16.7220 17.5487 18.4197 19.3373 20.3037 25.9587 33 2529 20 51.1601 572750 64 2028 720524 80.9468 910249 102.4436 186 6880 342 9447 TABLE 11AA Present Value of Annuity of $1 Periods 2% 3% 3.75% 4% 4.25% 5% 6% 7% 8% 1 09804 0.9709 0.9639 0.9615 0.9592 0.9524 0.9434 0.9346 0.9259 2 1.9416 1.9135 1.8929 1.8861 1.8794 1.8594 18334 18080 17833 3 2 8839 28286 2.7883 27751 2.7620 27232 26730 26243 2.5771 4 3.8077 3.7171 3.6514 3.6299 36086 35460 3.4651 3 3872 3.3121 5 4.7135 4.5797 4.4833 4.4518 4.4207 43295 4.2124 4.1002 3.9927 6 5.6014 5.4172 5.2851 5.2421 5.1997 5.0757 4.9173 4.7665 4.6229 7 6.4720 62303 6.0579 6.0021 5.9470 5.7864 5.5824 5.3893 5.2064 8 73255 70197 6.8028 6.7327 6.6638 6.4632 62098 5.9713 5.7466 9 8.1622 77861 7.5208 7.4353 73513 71078 6 8017 6.5152 6.2469 10 8.9826 8.5302 8.2128 8.1109 8.0109 77217 73601 70236 6.7101 20 16 3514 14.8775 13.8962 13.5903 13.2944 12.4622 11.4699 10.5940 9.8181 Periods 9% 10% 11% 12% 13% 14% 15% 20% 25% 1 0.9174 0.9091 0.90090.8929 0.8550 0.8772 0.8696 0.8333 0.8000 2 17591 17355 17125 16901 16681 16467 16257 1.5278 14400 3 2.5313 2.4869 24437 2.4018 23612 23216 22832 21065 1.9520 4 3.2397 3.1699 3.1024 30373 2.9745 2.9137 2.8550 2.5887 2.3616 5 3.8897 3.7908 3.6959 3.6048 3.5172 3.4331 3.3522 2.9906 26893 6 4.4859 4.3553 42305 4 1114 3.9975 3.8887 3.7845 3.3255 2.9514 50330 7 4.8684 4.7122 4.2883 3.1611 4.5638 4.4226 4.1604 3.6046 5.5348 5.3349 5.1461 4.9676 47988 46389 4.4873 00 3.8372 3.3289 5.7590 5.5370 5.3282 5.9952 51317 49464 4.7716 9 4.0310 3.4631 10 6.4177 6.1446 5.8892 5.0188 41925 3.5705 56502 5.4262 5 2161 91285 8.5136 79633 74694 20 70248 6.6231 62593 4.8696 3.9539 5. Recalculate the NPV using a 10 percent discount rate. (Future Value of $1. Present Volue of $1. Future Value Annuity of $1. Present Value Annuity of $1.) (Use appropriate factor(s) from the tables provided. Enter the answer in whole dollars.) Answer is complete but not entirely correct. Net present value $ 10,832,804