hi, can you please help me with required 1 through 6B. thanks and have a great day

Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 20% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product $ 250,000 Product B $ 460,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs $ $ $ $ 300,000 135,000 50,000 75,000 $ 400,000 $ 190,000 $ 92,000 $ 55,000 The company's discount rate is 18%. Click here to view Exhibit 128-1 and Exhibit 128-2, to determine the appropriate discount factor using tables. Required: 1. Calculate the payback period for each product 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each product 4. Calculate the project profitability index for each product. 5. Calculate the simple rate of return for each product. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely Complete this question by entering your answers in the tabs below. Reg 2 Reg 1 Req3 Reg 4 Req 6A Reg 5 Req 68 u formach product (Round your answer to 1 decimal place i.e. 0.123 should be considered EXHIBIT 128-1 Present Value of $1: 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 0952 0.943 0935 0.926 0917 0.909 0901 0893 0.885 0877 0.870 0862 0.855 0841 0.840 0.833 0826 0.820 083 0.806 0800 2 0925 0.907 0.890 0873 0857 0842 0826 0.812 0797 0.783 0.769 0756 0743 0731 071 0706 0694 0.683 0672 0.661 0650 0640 3 0889 0864 0840 0816 0.794 0772 0751 0731 0712 0693 0675 0658 0641 0624 0.609 0593 0579 0.564 0551 0537 0.524 0.512 4 0855 0823 0.792 0763 0735 0708 0683 0659 06360613 0592 0572 0552 0534 0516 0.499 482 04670451 0.437 0423 0410 5 0822 0784 077 0713 0681 0650 0.621 0593 0.567 0543 0519 0497 0476 0456 0437 0419 0.402 0.386 0370 0.355 0341 0328 6 0.790 0746 0.705 0666 0630 0596 0.564 0535 0.507 0.480 0.456 0432 0410 0390 0.370 0352 0.335 0319 0303 0289 0275 0.262 7 0.760 0.711 0665 0623 0583 0547 0.513 0482 0.452 0425 0.400 0376 0354 0.333 0.31 0.296 0279 0263 0249 0235 0222 0210 8 0731 0.677 0627 0.582 0.540 0502 04670434 0.404 0376 0351 0327 0.305 0785 0266 0249 0233 0.218 0204 0191 0179 0168 9 0703 06450592 0544 0.500 0460 0424 0.391 0.361 0333 0.308 0284 0263 0243 0225 0209 0194 0180 0167 0155 0144 0134 10 0676 0614 0.558 0.508 0.463 0.422 0386 0352 0.322 0295 0270 0247 0227 0208 0191 0.176 0162 049 01370126 0116 0107 11 0650 0585 0527 0475 0429 0.388 0350 0.317 0287 0261 0237 02150195 0178 0162 0148 0135 0123 012 0103 0.094 0.086 120625 0557 0497 0444 0.397 0356 0.319 0286 0257 0231 0208 0187 0168 0152 037 0124 01120102 0.092 0083 0076 0.069 130601 0530 0469 0.415 0368 0326 0.290 0.258 0229 02040182 0163 0145 0130 0.116 0104 0093 0.084 0075 006 0061 0055 14 0.577 0505 0.442 0388 0340 0.299 0263 0.232 0.205 0181 0160 0141 0125 0111 0099 0088 0078 0.069 0062 0055 0.049 0.044 15 0555 0481 0417 0.362 0.315 0275 0239 0209 0183 0160 0140 0123 0108 0095 0084 0074 0065 0057 0051 0045 0040 0035 16 0534 0458 0.394 0.339 0292 0252 02180188 0163 011 0123 0107 0093 008 007 0062 0054 0047 0012 0036 0032 0028 17 0.513 0.436 0371 0.317 0 270 0231 0198 01700146 0125 0108 0093 000 0069 0060 0.052 0.045 0.039 0034 0030 0026 0023 18 0494 0416 0350 0.296 0.250 0212 0.180 0153013001110095 0081 0.069 0059 0.051 0.044 0038 00320028 0024 0021 0018 190.475 0396 0331 0277 0232 0194 0164 0138 0116 0098 0083 0070 0.060 0051 0043 0037 0.031 0027 0023 0.020 0.01 0.014 200.456 0377 0.312 0.258 0.215 0178 0149 0124 0104 0087 0073 0.061 0.051 0.043 0037 0031 0,026 0022 0019 0016 0.01 0.012 210439 0359 0294 0242 0199 0164 0135 0112 0093 0.077 0064 0.053 0.044 0.037 0.031 0026 0022 0.018 0015 001 0011 0009 22 0.422 0342 0.278 0.226 0184 01500123 0101 0.083 0068 0.056 0046 0.038 0.032 0026 0.022 0.01 0.015 0.013 0.011 0009 0007 230406 0.326 0262 021 0.170 0138 01120091 0074 0.060 0049 0040 0033 0027 0.022 0.018 0.015 0012 0.010 0009 0.007 0006 240390 0.310 0247 0197 0158 0126 0102 0082 0066 0053 0043 0.035 0.028 0023 0.019 0.0150033 000 0008 0.007 0006 0005 25 0.375 0.295 0233 0184 0146 0.116 0092 0074 0.059 0047 0038 0030 0024 0.020 0.016 0013 0010 0.009 0007 0.006 0.005 0.004 26 0361 0281 0220 0172 01350106 0084 0066 0053 0042 0033 0.026 0021 0011 0010011 0009 0007 0006 0005 0004 0001 27 0347 0.268 0 207 0161 0125 0098 0.076 0060 0047 0037 0.029 0.023 0018 001 0011 0009 0.007 0006 0005 0004 0003 0.002 28 0.333 0255 0196 0150 0116 0090 0069 0.054 0.042 0033 0026 0020 0016 0012 0010 0008 0006 0005 0004 0.003 0.002 0.002 0.321 0243 0185 041 0907 0082 0.063 0048 0037 0.029 0022 00170014 0011 0008 0006 0.005 000 0003 0002 0.002 0002 300308 0231 0174 0131 0.099 0075 0057 0044 0033 0026 0020 0.015 0012 0009 0.007 0.005 0.004 0.003 0003 0002 0002 0.001 40 0208 0142 0097 0067 0046 0032 0022 00150011 0008 0005 0004 0.003 0002 0001 0.001 0.001 0.000 0000 0000 0000 0000 EXHIBIT 128-2 Present Value of an Annuity of S1 in Arrears: 1 CD 00 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 1 0962 0952 0.943 0935 0.926 0917 0.909 0901 0893 0885 0877 0.870 0.862 0855 0847 0840 0.833 0826 0820 0.813 0806 0.800 2 1886 1859 1833 1808 1783 1759 1736 1713 1690 1668 1647 1626 1605 1585 1566 1547 1528 1509 1492 1474 1457 1.440 3 2775 2723 2.673 2624 2577 2531 2487 2444 2.402 2361 2322 2283 2246 2210 2.174 210 2106 2074 2.042 2011 1981 1952 4 3630 3.546 3.465 3387 3.312 3240 3170 3.102 3.037 2.974 2914 2855 2798 2743 2690 2 639 2589 2540 2.494 2448 2404 2362 4452 4329 4 212 4.100 39933 890 3.791 3696 3.605 3.517 3.433 3352 3.274 3199 3127 3.058 2991 2926 2864 2803 2.745 2689 5242 5076 4.917 4.767 4623 4486 4.355 4231 4111 3998 3.889 3784 3685 3.589 3.498 3410 3326 3245 3167 3092 3020 2.951 6.002 5786 5582 5.389 5206 5033 4868 4712 4564 4423 4288 4160 4.039 3922 3812 3706 3.605 3.508 3.416 3327 3242 3.161 6733 6.463 6.210 5.971 57475.535 5335 5145 4968 4799 4639 4487 43444207 4078 3.954 3.837 3726 3619 3.518 3.421 3329 7435 7108 6 BOZ 6515 6.247 5995 5759 5537 5328 5132 4 946 4772 4607 4451 4303 4163 4031 3.905 3786 3673 3566 3463 10 8111 7722 7360 7024 6.710 6.418 6145 5.889 5650 5426 5 216 5019 4833 4659 4494 4339 4.192 4.054 3923 3799 3.682 3.571 11 8760 8306 78877499 7139 6.805 6.495 6 207 5938 5.687 5.453 5234 5.029 48364656 4 486 4327 4177 4.035 3.902 3776 3656 9.385 8863 8384 79437.536 7161 6814 6.492 6.194 5.918 5660 5.421 5197 4988 4793 4611 4.439 4278 4127 3.985 3.851 3.725 9.986 9.394 8.853 8358 7904 7.487 7103 6.750 6 424 6122 5842 5583 5.342 5.118 4910 4.715 4533 4362 4203 4053 3.912 3.780 10563 9.899 9.295 8.745 8244 7786 7.367 6982 6 628 6.302 6002 5724 5.468 5.229 5008 4 802 4611 4432 4265 4108 3962 3.824 11.118 10 380 9712 9108 8.559 8061 7606 7191 6.811 6.462 6142 5.847 5575 5 324 5.092 4.876 4675 4 489 4315 4153 4001 3.859 11652 10.838 10.106 9.447 8851 83137824 7379 6.974 6604 6 265 5.954 5.668 5 405 5162 4938 4730 4536 4357 4189 4.033 3887 12.166 11274 10.477 9763 9122 8544 8022 7549 7120 6.729 6.373 6047 5749 5.475 5.222 4990 4775 4576 4.391 4219 4059 3.910 12.659 11.690 10.828 10.0599372 8756 8.201 7702 7250 6840 6.467 6.128 5818 5534 5273 5033 48124608 4419 4243 4.080 3.928 13.134 12.085 11158 10.336 9.604 8950 8365 7839 7366 6.938 6.550 6.198 5877 5.584 5.316 5070 4843 4635 4442 4263 4097 3942 13.590 12.462 11.470 10.594 9818 9129 8.514 7963 7.469 7025 6623 6.259 5.929 5628 5353 51014870 4657 4.460 4.279 4.110 3.954 14 029 12.821 11764 10.836 10.0179292 8649 8.075 7562 7102 6687 6.312 5.973 5665 5384 5127 4.891 4675 4.476 4.292 4121 3963 22 14 451 13.163 12.042 11.061 10 2019.442 8.772 8176 76457170 6743 6.359 6.0115696 5410 5149 4909 4690 4488 4302 4130 3970 23 14.857 13.489 12 303 11272 10.371 9.580 8883 8 266 7718 7230 6.792 6 399 6044 5723 5.432 5.167 4.925 4.703 4.499 4311 4.137 3.976 24 15.247 13799 12 550 11469 10529 9.707 8.985 8348 7784 7283 6.835 6434 6.073 5746 5.451 5.182 4.937 4713 4507 4318 4143 3.981 25 15 622 1094 12783 11654 106759823 9077 8.422 78437330 6873 6.464 6.097 5766 5467 51954948 4721 4514 4.323 4147 3.985 26 15983 14 375 13.003 11.826 10.810 9929 9.161 8.488 7896 7372 6906 6491 6118 5783 5.480 5206 4.956 4728 4520 4.328 4151 3,988 27 16 330 14643 13.211 11987 10.935 10027 9.237 8548 7943 7409 6935 6.514 6136 57985492 5 215 4964 4734 4524 4332 4.154 3.990 28 16.663 14.898 13.406 12137 11051 10116 9307 8602 7984 7441 6961 6.534 6152 5810 5.502 5223 4970 4.739 4528 4.335 4.157 3.992 29 1698415141 13.591 12278 11158 10198 9370 8650 8022 7470 6.983 6551 6166 5820 5.510 5229 4975 4743 4531 4337 4159 3.994 30 17292 15372 13765 12.409 11258 10 274 9.427 8694 8055 7496 7003 6.566 6177 5829 5517 5235 4979 4746 4534 4339 4160 3995 40 19793 1715915046 13 332 11925 10.757 9779 8951 8244 7634 71056642 6233 5.871 5.548 5 258 4.997 4760 4544 4.347 4166 3.999 CUCI Pruuuct. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely: Complete this question by entering your answers in the tabs below. RE Req 2 Req 3 Req 4 Reg 5 Req 6A Req 6B Calculate the payback period for each product. (Round your answers to 2 decimal places.) Product A years Product B years Payback period Req2 > Prev 1 of 2 Next > arch . Curcuuse use project prvuv v uuc. 5. Calculate the simple rate of return for each product. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely: Complete this question by entering your answers in the tabs below. Req 1 Realz Req3 Req 4 Reg 5 Req 6A Reg 6B Calculate the net present value for each product. (Round your final answers to the nearest whole dollar amount.) Product Product B Net present value 7. CUICUIUC MIC PUJEL PULUI HUCA TUI CUCI pivuuci. 5. Calculate the simple rate of return for each product. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 31 Reg 4 Req 5 Req 6A Req 6B Calculate the internal rate of return for each product. (Round your answer to 1 decimal place i.e. 0.123 should be considered as 12.3%.) Product A Product B Internal rate of return % De 9 o 7. LuiLUTULE HIC PUJELE PIHLUMILY UCA TUI CUC pivuucu. 5. Calculate the simple rate of return for each product. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req3 Req 3 Ring 4 Ra Regs Req 5 Req 6A REGGA Req 6B Req GB Calculate the project profitability index for each product. (Round your answers to 2 decimal places.) Product A Product B Project profitability index o E e 9 0 B Calendar pplications i Saved Help Save & Exit Check T. LUILUILLE LIC PUELE PIILUMILY UCA TUI cuci pivuucu. 5. Calculate the simple rate of return for each product. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely: Complete this question by entering your answers in the tabs below. Rega Req 1 Req 3 Req3 Req 4 Rega Reas Reg GA Req 6B Calculate the simple rate of return for each product. (Round your answer to 1 decimal place i.e. 0.123 should be considered as 12.3%.) Product A Product B Simple rate of return To Save & E Che 1. CUICUIOLE LE PUELL PIULUI Ly HUCA IVI CUCI pivuuci. 5. Calculate the simple rate of return for each product. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 5 Req 6A Req 6B For each measure, identify whether Product A or Product B is preferred. Net Present Value Profitability Index Payback Period 1 Internal Rate Simple Rate of of Return Return O e 9 0 0 2 Chi T. CUILUILLE LIC PUJCLE P LUITLY UCA IVI CUCI pivuucu. 5. Calculate the simple rate of return for each product. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, Lou Barlow would likely: Complete this question by entering your answers in the tabs below. Req 1 Req2 Req 2 Req 3 Req3 Req 4 Rega Reqs Reg 5 ReqEA | Beg 68 Req 6A Feq 6B Based on the simple rate of return, Lou Barlow would likely: Accept Product A O Accept Product B Reject both products de 90