thats all i was given for this accounting problem

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 $ 350,000 $ 550,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 $ 390,000 $ 178,000 $ 70,000 $ 87,000 $470,000 $ 210,000 $110,000 $ 67.009 The company's discount rate is 20% 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. Reg1 Reg 2 Reg 3 Reg 4 Regs Req6A Req6B Calculate the payback period for each product. (Round your answers to 2 decimal places.) Product Product B Payback period years Ivars 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 $ 350,eee $ 550,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 $ 390,000 $ 178,000 $ 70,000 87,000 $ 470,000 $ 210,000 $ 110,000 $ 67,000 The company's discount rate is 20% Click here to view Exhibit 12B-1 and Exhibit 12B-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. 6. Based on the simple rate of return, Lou Barlow would likely Complete this question by entering your answers in the tabs below. Reg1 Reg 2 Reg 3 Reg4 Regs Reg A PANOR Calculate the net present value for each product. (Round your final answers to the nearest whole dollar amount.) Product Product B Net present value Reg1 Reg 3 > 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 A Product B $ 350,000 $ 550,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 $ 390,000 $ 178,000 $ 70,000 5 87,000 $470,000 $ 210,000 $110,000 $ 67,000 The company's discount rate is 20% Click here to view Exhibit 12B-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. 65. Based on the simple rate of return, Lou Barlow would likely Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Heg 3 Reg 4 Reg 5 Reg 6A Reg 6B Calculate the internal rate of return for each product. (Round your answer to 1 decimal place le. 0.123 should be considered as 12.36) Product Product B Internal rate of return 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 A Product 8 $ 350,000 $ 550,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 $ 390,000 $ 178,000 $ 70,000 $ 87,000 $470,000 $ 210,000 $ 110,000 $ 67,000 The company's discount rate is 20% Click here to view Exhibit 128-1 and Exhibit 12B-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 1 Req3 Red 4 Reg 5 Req6A Req 6B Calculate the project profitability index for each product. (Round your answers to 2 decimal places.) Product Product B Project profitability index (Reg 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 A Product B $ 350,000 $ 550,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 $ 390,000 $ 178,000 $ 70,000 $ 87,000 $470,000 $ 210.000 $110.000 $ 67.000 The company's discount rate is 20% Click here to view Exhibit 12B-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 1 Reg 2 Reg 3 Reg 4 legs Reg 6A Reg 6B Calculate the simple rate of return for each product. (Round your answer to 1 decimal place le. 0.123 should be considered as 12.3 .) Product Product B Simple rate of return 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 $ 350,000 $ 550,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 $ 390,000 $ 178.000 $ 70,000 $ 87,000 $470,000 $ 210.000 $110,000 $ 67,000 The company's discount rate is 20% 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. Reg1 Reg 2 Reg 3 4 Reg 5 Reg 6A Reg 68 For each measure, identify whether Product A or Product B is preferred. Net Present Value Profitability Index I Payback Perlod Internal Rate S of Rotum ple Rate of Return 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 $ 350,000 $ 550,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 $ 390,000 $ 178, $ 70,000 $ 87,000 $470,000 $ 210,000 $ 110,000 $ 67,000 The company's discount rate is 20% Click here to view Exhibit 12B-1 and Exhibit 12B-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 retur, Lou Barlow would likely Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg3 Rega Reas Req5A RegGA REGGE Based on the simple rate of return, Lou Barlow would likely: Accept Product Accept Product Reject both products EXHIBIT 120-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 0962 0952 0.943 0935 0926 0917 0909 0901 0893 0885 0877 08700862 0855 08470840 0833 0826 0820 0813 0806 0800 2 0925 0907 0890 0873 0857 0812 0826 0812 0797 0783 0769 07560743 0731 07180706 0694 0683 0672 0661 0650 0640 3 0889 0864 0840 0816 0.794 0720751 0731 07120693 06750658 0641 0624 0609 0593 0579 0564 0551 0537 0524 0512 4 0855 0823 0792 0763 0735 0708 0683 0659 0636 0613059205720552 0534 05160499 0482 0.467 0451 0437 0423 0410 5 0822 0784 0747 0713 0681 0650 0621 0593 0567 0543 0519 0497 0476 0456 0437 0419 0402 0386 0.370 0.355 0.341 0.328 6 07900746 0705 0666 0630 0596 0564 0535 0507 0480 0456 0432 04100390 0370 0352 0335 0319 0303 0289 0275 0262 0760 07 0665 0623 0583 0547 0513 0482 0452 0425 0100 0.376 0354 0333 03140296 0279 0.263 0249 0235 0222 0210 0731 0677 0627 0582 0540 0502 04670434 0404 0376 0351 0327 0305 0285 0 266 0249 0233 0218 0204 0.191 01790168 0703 0645 0592 0544 05000460 0424 0391 0361 0333 03080284 0 263 0243 0225 0209 0194 0180 0167 0155 0144 0134 10 0676 0614 0558 0508 0463 0422 0386 0352 0322 0295 0270 0247 0227 0208 0191 0176 01620149 01370126 0116 0107 11 0650 0585 0527 0475 0429 0388 0350 03170287 0 261 0237 021501950178 0162 0118 013501230112 0103 0.094 0086 120625 0557 04970444 0.397 0356 0319 0286 0257 0231 0208 0187 0168 0152 0137 0124 01120102 0092 0083 0.076 0.069 130601 0.530 0469 04150368 0326 0290 0258 0229 0204 0182 01630145 0130 01160104 0093 0084 0075 0.068 0061 0055 14 0577 0505 0.442 0388 0340 0299 0263 0232 0205 0181 01600141 02250111 0099 0088 0078 0069 0.062 0.055 0049 0044 15 0555 0.481 0417 0362 0315 0275 0239 0209 0183 016001400123 0108 00950084 0074 0065 0057 0051 0045 0040 0035 16 0534 0458 0394 0339 0292 0252 021801880163 01410123 01070093 0081 0071 0062 0054 0047 0042 0036 0032 0028 051 0436 0371 0317 02700231 0198 01700146 0125 0108 009300800069 00600052 0045 0039 0034 0030 0026 0023 18 0494 0416 0350 0296 0.250 0212 01800153 0130 0111 0095 0081 0069 0059 0051 0044 0938 0032 0028 0024 0.021 0018 19 0475 0396 0331 0277 0232 0194 0164 0138 0116 0098 0083 0070 0060 0051 0043 0037 0031 0027 0023 0020 0.01 0.014 200456 037 0312 0258 0215 0178 0149 0124 0104 0087 0073 0061 0051 0043 0037 0031 0026_0022 0019 0016 004 0012 21 0439 0359 0294 0 242 0199 0164 0135 01120093 0077 0064 0053 004 0037 0031 0026 0022 001800150013 001 0009 22 0422 0342 0278 0226 0184 0150 0123 010100830068 0056 0046 0038 0032 0026 00220018 0015 0013 001 0009 0007 23 0406 0326 0262 0211 01700138 01120091 0074 0060 0049 0040 0033 0027 00220018 00150012 0010 0009 0007 0.006 24 0390 0310 0247 0197 0158 0126 0102 0082 0066 0053 0043 0.035 0028 0023 001900150013 0010 0008 0007 0006 0005 25 0375 0295 0233 01840146 01160092 0074 0059 0047 0038 0030 0024 0020 0016 0013 0010 0009 0.007 0006 00050004 26 0361 0281 0220 0172 01350106 0084 0066 0053 0042 0033 0.026 0021 0017 004 001 0009 0.007 0006 0.005 0.004 0003 27 0347 0268 0207 0161 0125 0098 0076 0060 0047 0037 0029 0023 0018 00M 0011 0009 0.007 0.006 0005 0004 0003 0.002 28 0333 0255 0196 0150 01160090 00690054 0042 0033 0026 0020 006 0012 0010 0008 0006 0005 0004 0003 0002 0.002 029 0022 0.01 0.014 0011 0008 0006 0005 0004 0.003 0002 0002 0.002 300308 0231 0174 0131 0.099 0075 0057 0.044 0033 0026 0020 0015 0012 0009 0007 0005 0004 0.003 0.003 0002 0002 0001 400208 0M2 0097 0067 0045 0032 0022 0015 000 0008 0005 0.004 0.003 0.002 0.001 0001 0.001 0.000 0.000 0000 0000 0000 Now EXHIBIT 120-2 Present Value of an Annuity of St in Arrears: 11 - Periods 5 6 7 8 9 10 11 12% 0% 0% 5% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 1 09020952090309350926 0917 0909 0 901 0893 0885 0877 0870 0862 0855 0841 08400833 0826 0820 OR OBOS 0800 2 1886 1859 1833 1808 1783 1759 1736 1713 1690 1668 1647 1626 160515851566 1547 1528 1509 1492141414571440 3 2775 2723 2673 2624 257 2531 2487 244 2402 2361 2322 2283 2246 2210 2174 210 2106 2074 2012 2011 1981 1952 4 3630 354634653387 3312 32403170302 3037 29742914 2855 2798 2143 2690 2639 2589 2540 2494 2448 2404 2362 5 4452 4329 42124100 39933890 391 3696 3605 3517 3433 3352 3274 3199 3127 3058 2991 2926 2864 2803 2745 2689 5242 5076 49174767 4623 4486 4355 4231 4111 3998 3889 3784 36853589 3.498 3410 3326 3245 31673092 3020 2951 60025786 558253895206 5033 4868 4712 4564 4423 4288 4160 4039 3922 3.812 370636053508 34163327 3242 3161 6733 64636210 5971 5747 5535 5335 5146 4968 4799 4639 4487 4344 4207 4078 3954 3837 3726 3619 3518 3421 3329 9 7435 7108 6802 6515 6247 5.995 5759 5537 5328 5132 4946 472 4607 4451 4303 416340313905 3786 3673 3566 3463 10 811 77227360 7024 6710 6.418 6145 5889 5650 5426 5216 5019 4833 4659 4494 43394192 40543923 3799 3682 3571 11 8760 8.30678877499 71396805 6495 6207 5938 5687 5.453 5 234 5029 48364656 4 486 4327 417 40353 902 3776 3656 129 385 8863 8384 7943 7536 2161 681 6492 6194 59185660 5421 5197 4988 4793 4611 4439 4278 4127 3985 3851 3725 13 99869394 8853 8.358 7904 7487 7103 6750 6.424 6122 58425583 5342 5118 4910 4715 4533 4362 4203 4053 3912 3780 14 10.563989992958745 8244 7786 7367 69826628 6 302 6.002 57245.468 5229 5008 4 802 4611 4432 4265 4108 3962 3824 1511118 103809712 9108 8559 8061 7606 7191 6811 6462 612 5847 5575 5 324 5092 4876 4675 4489 431541534001 3859 16 11652 10 83810106 9.447 8851 83137824 7379 6974 6604 6265 5954 5668 5405 5162 4938 4730 4536 4357 41894033 3887 17 12 166 1127410.477 9763 9122 8544 8022 7549 7120 6729 6.373 6047 5749 5475 5222 4990 4775 4576 4391 4219 4059 3910 18 2659 11690 1082810059 9.372 8756 8201 7702 7.250 6 840 6.467 6128 5818 5534 5273 5.033 48124608 4 419 424340803928 19 13134 2085 11158 10.336 9.604 8950 8365 7839 7366 6938 6550 6198 5877 5584 5316 5070 4843 4635 4442 4263 4097 3942 2013 590 12.462 11.470105949.818 912985147963 7469 7025 6623 6259 5.929 5628 5353 51014870 4657 4460427941103954 21 029 12821 11764 10836 10.017 9292 8649 8075 7562 71026687 6.312 5973 5665 5384 51274891 4675 4476 4 292 4121 3963 224451 3163 12.042 11061 10 201 942 872 8176 76457170 6743 6359 601 5696 5.410 51494909 4690 4488 4302 4030 3970 234857 13.489 12.303 11272 10371 9580 8883 8266 7718 7230 6792 6 399 6044 57235432 5167 4925 4703 4499 4311 4573976 24 15 247 13 799 12.550 1146910529 970789858348 7784 7283 6835 6.434 60735746 5451 5182 4937 47134507 438 433981 25 5622 094 22.78311654 10675 9823 907784227843 73306873 6.464 6097 5766 5467 51954948 47214544323 47 3985 26 5983 1375 13003 1182610810 9929 91618488 7896 73726.906 6.491 6118 5783 5 480 5206 4956 478 4520 432841513988 27 16330 643 12111987 10935 10027 9237 8548 7943 7409 6.935 6.54 61365798 5 492 5 215 4964 4734 4524 433241543990 28 15663 1898 13406 1237 1105110116 9307 8602 7984 7441 6961 6534 61525810 5502 5223 4970 47394528 4335 41573992 29 1698415141 591 2.278 11158 0198 9370 8650 8022 7470 6983 6.551 6166 5820 5510 5229 4975 470 4531 433741593994 30 17292 15372 13765 12.409 1125810274 9.427 8694 8055 7496 7003 6566 617 5829 5517 5235 49794746 4534 4339 450 3995 40 19793 1715915046 3332 11925075797798951 8244763471056642 6233 5875548 5258 4997 4750 4544 4347 46 3999