i need help with the questions i got wrong please. thank you
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 22% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product Product B $ 380,000 $575,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 $ 410,000 $ 186,000 $ 76,000 $ 89,000 $ 490,000 $ 218,000 $ 115,000 $ 70,000 The company's discount rate is 20%. Click here to view Exhibit 13B-1 and Exhibit 13B-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. 66. Based on the simple rate of return, Lou Barlow would likely Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Answer is complete but not entirely correct. 1 Complete this question by entering your answers in the tabs below. e Req1 Req2 Regs Reg 3 Reg 4 Reg 5 Req 6A Req 6A Req 6B Reg 68 Calculate the payback period for each product. (Round your answers to 2 decimal places.) Product A 2.81 years Product B 2.84 years Payback period Reg 2 > Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req 3 Reg 4 Reg 5 Req 6A Req 6B Calculate the net present value for each product. (Round your final answers to the nearest whole dollar amount.) Product A $ 23,731 Product B $ 19,101 Net present value Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Req1 Req 2 Req3 Reg 4 Reg 5 Req 6A Req 6B Calculate the internal rate of return for each product. (Round your answers to 1 decimal place le 0.123 should be considered as 12.3%) Product Product A 23.2 Internal rate of return % 21.7 % Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req3 Reg 4 Req5 Req 6A Reg 68 Calculate the project prontability Index for each product. (Round your answers to 2 decimal places.) Product Product A 1.063 1.053 Project profitability index EXHIBIT 138-1 Present Value of the Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 0.962 0.952 0943 0935 0926 0917 0 909 0901 0893 O 885 0877 0370 0862 0855 0 847 0 340 0833 0826 0820 0.813 0 806 0.800 0.925 0.907 0.890 0873 0857 0342 0826 0812 0797 0783 0769 0 756 0743 0731 0.718 0706 0.694 0.683 0672 0861 0 650 0 540 0.889 0.864 O 840 0.816 0794 0772 0.751 0731 0712 069) 0675 068 0641 0624 0600 053 0579 0564 0551 0537 0.524 0512 0855 0.823 0.792 0.763 0735 0708 0683 0659 0636 0613 0 592 0572 0552 0534 0516 0.400 0.482 0.467 0.451 0.437 0.423 0.410 5 0.822 0.784 0.747 0.713 0.681 0.60 0.621 0.593 0 567 0543 0519 0497 0.476 0.456 0.437 0.419 0.402 0.386 0 370 0.355 0.341 0.328 7 8 9 10 0.790 0.746 0.705 0.666 0.630 0.595 0564 0.535 0 507 0.400 0.456 0432 0410 0 390 0.370 0352 0.335 0.319 0.303 0.289 0.275 0.262 0.760 0.711 0.665 0.623 0583 0 547 0513 0 4820452 0425 0400 0376 0354 0333 0314 0.296 0.279 0.263 0.249 0.235 0.222 0.210 0.731 0.677 0.627 0.582 0 540 0.502 0.467 0.434 0.404 0376 0351 0327 0305 0285 0 266 0.249 0.233 0.218 0.204 0.191 0.179 0.168 0.703 0.645 0.592 0.544 0.500 0.460 0.424 0.391 0 361 0333 0.308 0284 0 263 0243 0225 0 209 0.194 0.180 0.167 0.155 0.144 0.134 0.676 0.614 0558 0.508 0.463 0.422 0.386 0352 0322 0295 0270 0247 0227 0 208 0191 0.176 0.162 0.149 0.137 0.126 0.116 0.107 11 13 0650 0 585 0527 0 475 0429 028 0.250 0317 027 0261 0237 0215 0.195 0.178 0 162 0 14 0 135 0.123 0.112 0.103 0.094 0086 0.625 0.557 0.497 0.444 0.397 0 356 0.319 0286 0257 0231 0208 0.187 0.16 0.152 0.137 0124 0112 0.102 0.092 0 0B3 0.076 0069 0.601 0.530 0.400 0.415 0.368 0.326 0.290 0258 0229 0204 0.182 0.163 0.145 0.10 0.116 0104 0.003 0084 0.075 0.068 0.061 0.055 0.577 0.505 0.442 0.38 0 340 0.200 0 263 0232 0205 0.11 0.160 0.141 0.125 0.11 0.099 0.08 0.078 0.069 0.062 0.055 0.049 0.044 0.555 0.481 0.417 0.362 0.315 0.275 0239 0209 0.13 0 160 0 140 0 123 0108 0.095 0084 0074 0.065 0.057 0.051 0.045 0.040 0.035 15 20 1 0.534 0.458 0.394 0.339 0.292 0.252 0218 0.18 0.163 0.141 0.123 0.107 0.093 0.061 0.071 0.062 0.054 0.047 0.042 0036 0.032 0.028 17 0.513 0.436 0.371 0.317 0.270 0231 0.19 0.170 0 146 0.125 0.108 0093 000 0069 0.060 0 052 0045 0.039 0094 0030 0.025 0.023 18 0.494 0416 030 0296 020 0212 0 10 0 151 100111 0.095 001 0000 0 059 0 051 0044 001 0012 003 0024 0021 0018 19 0475 0.396 0331 0237 022 0194 0164 013 116 000 0003 0070 0000 0.051 0001 017 003 0027 003 0020 0017 0014 0.456 0.377 0312 0.258 0.215 0.178 0.149 0.124 0.104 0087 0073 0061 0.051 0043 0.037 0.031 0.026 0.022 0019 0016 0014 0.012 21 0.439 0.350 0.204 0.24 0.199 0.164 0.15 0.112 0.003 0077 0.064 0.053 0.044 0.037 0.031 0.026 0022 0.010 0015 0013 0011 0.009 22 0.422 0342 0.278 0.226 0.184 0.50 0.123 0.101 000 0068 0.056 0046 0038 001 0026 0022 0018 0015 001) 0011 0009 0.007 23 0.406 0.326 0 262 0211 0.170 0.18 0.112 0.091 0074 0060 0.049 0.040 0033 C 0 022 0.018 0015 0012 0010 0000 0007 0006 24 0.390 0.310 0247 0.197 158 0126 0102 0.002 0066 0053 0.043 003 002 003 0019 0015 001) 0010 000 000 0005 0005 25 0.375 0.295 0.233 0.184 0.145 0.116 0092 0.074 005 0047 0018 0.030 0024 0.020 0.016 0013 0010 0000 000 0006 0.005 0.004 26 0361 021 020 0172 0115 0.106 04 05 005 0042 003 0026 0021 0.017 0014 0011 0000 OOOT 0000 000 0004 0.003 27 0347 026 0207 0.161 0.125 000 006 0060 0047 0037 0 029 0023 018 0014 0011 0000 000 0000 000 0004 000 000 28 0.333 0.265 196 0150 0.116 0.000 0.00 0.054 0042 0033 0026 0.020 0.016 0012 0.010 ODOS O ODOS 0004 0.003 0.002 0.002 20 0321 0243 0.18 0.141 0.10 0. 02 0063 0.048 003 0029 0022 0.017 0.014 0011 0000 0000 000 0004 0.003 0.002 0.002 0.002 30 0.308 0231 0,174 0.131 0.000 0.025 0057 0044 0033 0026 0.020 0,015 0,012 0.000 0.007 0.005 0.004 0003 0003 0.002 0.002 0.001 4 00 208 0.142 0097 0067 0046 0032 0022 0015 0011 000 000 0004 0.003 0.002 0.001 0.00 0.00 0.000 0.000 0.000 0.000 0.000 1 EXHIBIT 130-2 Present Value of an Annuity of $1 in Amers: ||- Periods 4% 5 6 7 8 9 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 0.962 0.952 0943 0.935 0.926 0.917 0.909 0.901 0.893 0.885 0.877 0.870 0.362 0.855 0.847 0.840 0.833 0.826 0.820 0.813 0.806 0.800 2 1886 1.859 1833 1808 1.783 1.759 1736 1.713 1690 1668 1647 1626 1605 1.585 1 566 1547 1528 1509 1492 1474 1457 1.440 3 2775 2723 2673 2624 2577 2531 2.487 2444 2402 2361 2322 2283 2246 2210 2.174 2140 2106 2074 2042 2011 1981 1952 4 3.630 3.546 34653387 3312 3.240 3.170 2.102 3.037 2.974 2914 2.855 2.798 2.743 2690 2699 2.509 2540 2494 2448 2404 2362 5 4452 4.329 4212 4.100 3993 3.890 3 791 3696 3605 3517 3433 3.352 3274 21993.127 3058 2991 2926 2 864 2 803 2745 2689 9 5.242 5076 4917 4.767 4623 4.486 4 355 4231 4.111 3998 3889 3.784 365 3589 1498 3410 3326 3245 3.167 3.092 3020 2951 7 6002 5.786 552 5389 5206 5033 468 4712 4564 4423 4288 4.160 4030 3922 3812 3706 605 508 3416 3327 3242 3.161 8 6.733 6.463 6210 5.971 5.747 5535 5 335 5 146 496 4.799 4 639 4.487 4.344 4 207 4078 954 3.837 3.726 3619 3.518 3.421 3329 7 .435 7.108 6.802 6515 6 247 5995 5.759 5 537 5328 5.132 4946 4.772 4.607 4.451 4.303 4.163 4031 3.905 3.786 3.673 3.566 3.463 8.111 7.722 7.360 7024 6710 6.418 6.145 5 889 5650 5.426 5 216 5 019 4833 4.659 4 494 4339 4.192 4.054 3.923 3.799 3.682 3571 11 8.760 8.306 7.887 7499 7.139 6.805 6.495 6 207 5938 5687 5.453 5.234 5029 48364,656 4486 4.327 4.177 4.035 3.902 3.776 3.656 93858.863 8.384 7.943 7.536 7.161 6.814 6.492 6.194 5.918 5.660 5.421 5.197 4.988 4.793 4.611 4.439 4.278 4.127 3.985 3.851 3.725 9.986 9.394 8.853 8.358 7.904 7407 7.103 6.750 6.424 6.122 5.842 5.583 5 342 5.118 4.910 4.715 453 4362 4.203 4.053 3.912 3.780 10.563 9.8999295 .745 R2447.786 7367 6982 6.628 6.302 6.002 5 724 546B 5 229 5.000 4 002 4611 4.432 4.265 4.108 3.962 3.824 15 11.118 10.380 9.712 9.108 8559 8,061 7.606 7.191 6.811 6.462 6.142 5.847 5575 5 324 5092 14.876 4,675 4.489 4.315 4.153 4001 3.859 11.652 10.838 10.106 94478.851 8.313 7.824 7.379 6.974 6,604 6.265 5.954 5.668 5.405 5.1624910 4.730 4.536 4357 4.189 4.033 3.887 12.166 11.274 10.477 9.763 9.122 8.544 8.022 7.549 7.120 6.729 6.373 6,047 5749 5.475 5.222 4 990 4.775 4576 4.391 4.219 4.059 3.910 12659 11.690 10 828 10 059 93728.756 8. 201 7.702 7.250 6 840 6.467 6.128 5818 5534 5.2735033 4812460B 4.419 4243 4.090 3.928 19 13.134 12.085 11.158 10,336 9.604 8.950 8.365 7.839 7.366 6.938 6.550 6.198 5877 5584 5.316 5070 4843 4635 4 442 4.263 4.097 3.942 2013 590 12 462 11.47010504 9818 9.120 514 7943 749 7 025 6.6236259 56696205 4 870 4657 4450 4279 4.110 3954 21 22 24 25 14029 12821 11 764 10836 10 017 9.292 8.649 3 075 7.562 7.102 6 687 6312 595.645 14127 4014675 4.476 4 292 4 121 3963 14.451 13.163 12042 11 061 10 201 9.442 8.7728.176 7.645 7.170 6.743 63506.01 5.0 5.410149 4300 690 4438 4302 4130 3970 14857 1489 12 103 11 22 10 371 9.580 88266 7.718 7230 6792 630 50447235425104025 701 4.499 4311 4137 1976 15.247 13 799 12.550 11.469 10.529 9.707 8.985 8 348 7784 2283 6835 64346.073 6746 451 5.182 4937 47134 507 4318 4.143 3981 15 622 14 004 12.781 11654 1067508239077 8.422 7543 7330 6873 6.454 8 097576656750 8 414514 423 4147 3085 26 27 28 15 14 13 1100 1126 108 109 929 9161 848 796 7372 6.906 6.491 6118570) 500 504324151 103 16.330 14.543 13 211 11987 10 935 10 027 9.237 8548 7.94) 7409 6.935 65146.136 5.790 5492 215 466 47344524 432 41543990 15 663 14 398 11406 12 37 11051 1011692307 8602 7984 7.441 5.961 6 534 6 1525 810 502 223 4070 423 4528 4 335 4157 3992 16954 15 141 11 591 12 270 11.158 10 18 9 370 650 022 7.470 600 651 6166 5820 S1029 405 441 453143341593994 17.292 15 372 13.765 12.409 128 10 274 9.4278694 055 7.406700365666177 5.820 5 2 4070446 4534 439 4.160 2995 19.793 17.159 15 046 13.31211925 10.7579.779 3951 3.2447654 7 100 642 6233 5.8715.54 5.258490747604544 4347 4.166 3.999 30 40