URGENT please aswer all seven parts feel free to show work but i only need final answers. thank you so much!! tables are included for calculations

4 Check my work 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 22each of the last three years. He has computed the cost and revenue estimates for each product as follows Product Product Initial investment Cost of equipment (zero salvage value $ 370,000 $570,000 Annual revenues and costs: Sales revenues $400,000 $ 480,000 Variable expenses $ 180,000 $ 214,000 Depreciation expense $ 74,000 $ 114,000 Fixed out-of-pocket operating costs $68,000 $ 68,eee H The company's discount rate is 20% Click here to view Exhibit 148.1 and Exhibit.148.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 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 is preferred 6 And on the simple ratenfeturn which of the hun dahulu divain arrat 1 30 2 0975012109170900 0.01 0.005 7070 01 0055 070040000000 09750.007 0.100 OD 0157000126 000 0000 0.756 MB 0.0005 004 000 002 0.00 0.00 0.74 0720751 0.0723 0575 064 063 000 0057 0940105380 Gotovo 2900 COWO TOSO 2550 USD 0601090 10 ROCO DOO 2 074 074 07 0056 0.591 057 056 050 0497 0.000 0.0001000000000035 034 033 CE UZO DODGEDSED SO OD 0 DOPO OD 90000 OSO GD 950 000 000 000 HOOD OOOOOOOOO SOMEO COVO SVO STO ODIO DOS OS POZOO O OOO SOLO COCO BED SONEO TOO OOO OO 0000 90 100 100 0000 DO O 150 SOOOO COCO POCO 0000OOOOO 0000 0000 SOLD 160 BODO O O OO SO ZED CHOICO 90 OSODOOD Coco 330 LD DO O ZO ZO 100 GOOSEO VOLVO 22000990 MO DOO 100000 DOO 000000000000000000 WOOD SHO in ODLO SOLO COCO 60OCOCO MOSOS ONDOKO DO BOLO CEO SCOO OO 0 0 0 0 0 0 0000 DOOD 00 14 15 15 1 on o to o o o o osto go osco 10 1 OT 008 062505570.407 0.41 0.297 356 020 026 025 0.21 0.200 057 0001 0530 0.400 0.41 0.125 0 2500 250 2290 201 202 010400100400750000100 0125 m 0090 0.00 0.00 0.00 0.003 0055 000 000 OS 0123 000 0095 0004 0.00 0.00 0.00 0.00 0.00 0.00 0.035 O 04 03 0202 0252 02000019 0.50 000 02 03 0270 0221 0100 0110000125 0000 0000 0000 0000 0.000 0.00 0.00 0.000 0.000000 00% co 0000 0000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0475 096 0210277 02 04 04 0050116 0000 0000 0000 0000 0000 0023 020 000 0156 037 03 02 010501210194 000 con 00 00 00 00 00 00 0022 0.00 0.00 0.00 0.00 0.250 0.294 0242 0700 0164 0935010 0.093 000 0004 0.091 6044 GOW GO 0026 0032 000 000 0000 0000 0422 0542 0.278 0220 0154 01500123001 0.00 0.00 0.00 0.00 0.00 0.035 0.022 000 000 000 con 0000 000 0170301 0.001 000 0000 0000 0000 000027 0022 000 000 0000 0000 000 000 0.1580320 175 028 029 01 00011 0.092 001 0058 007 000 0.000 0034 0000 0000 0000 0000 000 000 000 000 0 02002200172 005 000 000 000 000 0062 con 0026 0021 007 00 oon 0.000 0.00 0.00 0.00 0.00% com 035 0.000 0.00060 00 0.00 0.009 0023 0.00 0.00 on 0.000 0.00 0.00 0.00 0.004 om 0.00 0118 0090 00 0.05 0.0006 0.020 00 00 00 0.00 0.00 0.00 0.00 0.000000 0107 008 Com 004 0037 0.029 0022 0.0 0.0 0.0 0000 0000 000 000 000 000 000 000 03010231 074 01 0000000057 004 OCT 0.025 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.003 com 0002 000 000 20001000070067 004 00120022005 000 0000 0.00 0.00 0.00 0.00 0.00 0.00 0.000000000000000000000 22 HO 22000 900 50 ROOD OD 10000 1000 000 000 00 00 00 00 00 00 00 00 9000 2000 COLO SE M 22 2 190 OZDOHCO OSLO DO ED 52 SO COD VO 0 07 Periods 1 2 3 5 ONE EESNS 12 3 14 15 16 45 5% 09 7 99 10 109 15 155 17 20% 21 09620952 0943 0985 0920 0.917 0.909090108930.885 0.877 0.870 03620055 0.347 0940 033 03260820 000 0005 0.000 1300 1850 1833 1800 1750 1736 1700 1690 1668 1647 1626 1505 1505 1566 1547 1528 1509 492 140 157 1 2779 2.723 2673 2024 2577 2531 2487 2484 2402 2361 2322 2283 2245 2.200 2174 2.540 2.106 2.074 2042 2011 195 3030 3550 3.465 3.387 3312 3.240 3.10 3.102 3.037 2.994 2014 2055 2798 2743 2690 2639 2509 2.540 2494 243 244 2.362 4052 4320 4212 4,100 2.9933.890 3.791 3.696 3.605 3.517 3.433 33523274 31992127 3058 2.991 2.926 2.364 2802 2745 2689 5.242 5070 4907 4757 463 4.486 4355 42314 3.9983.8893.784368525893498 3.450 228 22453167 3092 3020 2051 6002 5768 5582 5399 5.200 5033 468 4712 4.564 4423 4288 4160 4.0393.922 3.812 37063005350834153327 3242_1161 6.733 6.400 6.210 5.971 5747 5535 53355546496847994639 4487 43444207 4078395636373326 3619353421 3329 7405 2108 6802 6.515 6.247 5995 5.759 5537 5328 5132 4.94647724607 4451 43034563 40313 905 706 3673 356 3083 8. 7722 2360 2024 6.710 6.418 6145 5.809 5.6505.426 5.216 5.099 4833 4659 4494 43394192 4054 1923 1799 30023571 8.750 8.3052887 7499 7139 6.805 6.495 6.207 5901 56875453 5234 502948364656 4406 43274177 40953902 3.776 3656 9.385 8.860 2384 7943 7536 7561 6.814 6.492 6194 59185680 5421 5197 49884.7934611 4439 4270 4127 3.985251375 99869394 8853 8358 7904 7487 7300 6750 6624 6122 5.342 5583 5.342 5.158 4.910 4715 45334362 203 40533912 3.700 10.563 9.999 9.295 3.745 8.244 2780 7367 6982 6 628 6.302 6002 5724 5.458 5229 5.008430246114.432 4265 406 3962 150 11113 103809712 9109 3.559 8.000 7,806 2191 6811 6.4626142 5.347 5.575 5324 5.092 4.676 46754409 4315 4.001 2050 11652 10.838 10.00 9.447 8.851 8.30 7824 73796.9746004 6.265 5 954 5.660 5.405 5.162 49384730 4.536 4357 4189 4033387 1296 11 274 10.4779.763 9.122 8.544 8022 7549 2020 67296.373 60475749 5.475 5222 4.990 4775 4576 4 3914219 40591910 12.659 116909.828 10.059 9.372 8.758 9.20127027250 6.840 6.457 6128 5.818 5.534 5.273 5.033 4812 4600 4419 42434.000 3.928 15134 1208511158 10.336 9.604 8950 365 78297366 6.938 6.550 6.198 5.877 5584 5.316 5070 433 4635 442 4263 4097 3902 13.590 12.462 1470 10.594 9.818 9.129 8.554 7963 7469 7025 6.623 6.259 5929 5.628 5.353 5101 4370 4657 44604279 40 3.954 14.029 128211754 10.836 9001 9.292 3649 8.075 75627102 6,687 63125.973 5665 5384 5127 4891 4.675 4476 4.292421 3.00 14.451 13:33 120421001 10.2019.442 8728.176 7665 2170 674363596.011 5696 5.410 5149 49094090 4.438 4300 400 3970 14857 13.491230311272 10.371 9580 8.883 32667718 7230 6792 6.399 6.044 57235432_5167 4925 4703 4498 431 437 35 15.247 3.799 12.550 11469 90.529 9.707 3985 8.343 7784 2283 6.835 5.434 607357465451 5.182 4.937 4713 4.5074310 432901 15.622 14,094 12783 11654 10.675 9.823 9077 8.422 7343 7330 6.873 6.464 6:097 5766 5467 51954948 4721 4.5144323 4547 2955 15.9534375 300311826 10 910 9929 9.161 8.48 799673726906 64916118 578354805 206 495647284520 438 4351 2988 16330 4.643 3211 1987 10.935900279.237 8.548790 7409 6.9056.514 6136 5.798 5.492 5.215 49644734 4524 432 415 1990 56.663 11 406 12137 11051 90.116 9307 8.6027984 7441 69616534 6152 5.810 5.502 52234970 473945284335 4157 1992 10.04 15:54 13591 12.278 11158 10.198 9370 3.650 8.022 7470 6983 6551 6166 5.820 5510 5.2294975 4743 4531 43374159 1994 172929537275512800 11.258 10274 94278.604 8055 7490 2003 6565 6777 5.829 5.5175235 4979 716 4534 4329 4100 3199 1979377159 15.046 3.332 11.925 9075797798951 8.244 7634 2105 6.642 6233 5.8715.543 5253 4992 4760 455 4347 3166 22 22 24 25 26 23 29 30 40 4 Check my work 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 22each of the last three years. He has computed the cost and revenue estimates for each product as follows Product Product Initial investment Cost of equipment (zero salvage value $ 370,000 $570,000 Annual revenues and costs: Sales revenues $400,000 $ 480,000 Variable expenses $ 180,000 $ 214,000 Depreciation expense $ 74,000 $ 114,000 Fixed out-of-pocket operating costs $68,000 $ 68,eee H The company's discount rate is 20% Click here to view Exhibit 148.1 and Exhibit.148.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 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 is preferred 6 And on the simple ratenfeturn which of the hun dahulu divain arrat 1 30 2 0975012109170900 0.01 0.005 7070 01 0055 070040000000 09750.007 0.100 OD 0157000126 000 0000 0.756 MB 0.0005 004 000 002 0.00 0.00 0.74 0720751 0.0723 0575 064 063 000 0057 0940105380 Gotovo 2900 COWO TOSO 2550 USD 0601090 10 ROCO DOO 2 074 074 07 0056 0.591 057 056 050 0497 0.000 0.0001000000000035 034 033 CE UZO DODGEDSED SO OD 0 DOPO OD 90000 OSO GD 950 000 000 000 HOOD OOOOOOOOO SOMEO COVO SVO STO ODIO DOS OS POZOO O OOO SOLO COCO BED SONEO TOO OOO OO 0000 90 100 100 0000 DO O 150 SOOOO COCO POCO 0000OOOOO 0000 0000 SOLD 160 BODO O O OO SO ZED CHOICO 90 OSODOOD Coco 330 LD DO O ZO ZO 100 GOOSEO VOLVO 22000990 MO DOO 100000 DOO 000000000000000000 WOOD SHO in ODLO SOLO COCO 60OCOCO MOSOS ONDOKO DO BOLO CEO SCOO OO 0 0 0 0 0 0 0000 DOOD 00 14 15 15 1 on o to o o o o osto go osco 10 1 OT 008 062505570.407 0.41 0.297 356 020 026 025 0.21 0.200 057 0001 0530 0.400 0.41 0.125 0 2500 250 2290 201 202 010400100400750000100 0125 m 0090 0.00 0.00 0.00 0.003 0055 000 000 OS 0123 000 0095 0004 0.00 0.00 0.00 0.00 0.00 0.00 0.035 O 04 03 0202 0252 02000019 0.50 000 02 03 0270 0221 0100 0110000125 0000 0000 0000 0000 0.000 0.00 0.00 0.000 0.000000 00% co 0000 0000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0475 096 0210277 02 04 04 0050116 0000 0000 0000 0000 0000 0023 020 000 0156 037 03 02 010501210194 000 con 00 00 00 00 00 00 0022 0.00 0.00 0.00 0.00 0.250 0.294 0242 0700 0164 0935010 0.093 000 0004 0.091 6044 GOW GO 0026 0032 000 000 0000 0000 0422 0542 0.278 0220 0154 01500123001 0.00 0.00 0.00 0.00 0.00 0.035 0.022 000 000 000 con 0000 000 0170301 0.001 000 0000 0000 0000 000027 0022 000 000 0000 0000 000 000 0.1580320 175 028 029 01 00011 0.092 001 0058 007 000 0.000 0034 0000 0000 0000 0000 000 000 000 000 0 02002200172 005 000 000 000 000 0062 con 0026 0021 007 00 oon 0.000 0.00 0.00 0.00 0.00% com 035 0.000 0.00060 00 0.00 0.009 0023 0.00 0.00 on 0.000 0.00 0.00 0.00 0.004 om 0.00 0118 0090 00 0.05 0.0006 0.020 00 00 00 0.00 0.00 0.00 0.00 0.000000 0107 008 Com 004 0037 0.029 0022 0.0 0.0 0.0 0000 0000 000 000 000 000 000 000 03010231 074 01 0000000057 004 OCT 0.025 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.003 com 0002 000 000 20001000070067 004 00120022005 000 0000 0.00 0.00 0.00 0.00 0.00 0.00 0.000000000000000000000 22 HO 22000 900 50 ROOD OD 10000 1000 000 000 00 00 00 00 00 00 00 00 9000 2000 COLO SE M 22 2 190 OZDOHCO OSLO DO ED 52 SO COD VO 0 07 Periods 1 2 3 5 ONE EESNS 12 3 14 15 16 45 5% 09 7 99 10 109 15 155 17 20% 21 09620952 0943 0985 0920 0.917 0.909090108930.885 0.877 0.870 03620055 0.347 0940 033 03260820 000 0005 0.000 1300 1850 1833 1800 1750 1736 1700 1690 1668 1647 1626 1505 1505 1566 1547 1528 1509 492 140 157 1 2779 2.723 2673 2024 2577 2531 2487 2484 2402 2361 2322 2283 2245 2.200 2174 2.540 2.106 2.074 2042 2011 195 3030 3550 3.465 3.387 3312 3.240 3.10 3.102 3.037 2.994 2014 2055 2798 2743 2690 2639 2509 2.540 2494 243 244 2.362 4052 4320 4212 4,100 2.9933.890 3.791 3.696 3.605 3.517 3.433 33523274 31992127 3058 2.991 2.926 2.364 2802 2745 2689 5.242 5070 4907 4757 463 4.486 4355 42314 3.9983.8893.784368525893498 3.450 228 22453167 3092 3020 2051 6002 5768 5582 5399 5.200 5033 468 4712 4.564 4423 4288 4160 4.0393.922 3.812 37063005350834153327 3242_1161 6.733 6.400 6.210 5.971 5747 5535 53355546496847994639 4487 43444207 4078395636373326 3619353421 3329 7405 2108 6802 6.515 6.247 5995 5.759 5537 5328 5132 4.94647724607 4451 43034563 40313 905 706 3673 356 3083 8. 7722 2360 2024 6.710 6.418 6145 5.809 5.6505.426 5.216 5.099 4833 4659 4494 43394192 4054 1923 1799 30023571 8.750 8.3052887 7499 7139 6.805 6.495 6.207 5901 56875453 5234 502948364656 4406 43274177 40953902 3.776 3656 9.385 8.860 2384 7943 7536 7561 6.814 6.492 6194 59185680 5421 5197 49884.7934611 4439 4270 4127 3.985251375 99869394 8853 8358 7904 7487 7300 6750 6624 6122 5.342 5583 5.342 5.158 4.910 4715 45334362 203 40533912 3.700 10.563 9.999 9.295 3.745 8.244 2780 7367 6982 6 628 6.302 6002 5724 5.458 5229 5.008430246114.432 4265 406 3962 150 11113 103809712 9109 3.559 8.000 7,806 2191 6811 6.4626142 5.347 5.575 5324 5.092 4.676 46754409 4315 4.001 2050 11652 10.838 10.00 9.447 8.851 8.30 7824 73796.9746004 6.265 5 954 5.660 5.405 5.162 49384730 4.536 4357 4189 4033387 1296 11 274 10.4779.763 9.122 8.544 8022 7549 2020 67296.373 60475749 5.475 5222 4.990 4775 4576 4 3914219 40591910 12.659 116909.828 10.059 9.372 8.758 9.20127027250 6.840 6.457 6128 5.818 5.534 5.273 5.033 4812 4600 4419 42434.000 3.928 15134 1208511158 10.336 9.604 8950 365 78297366 6.938 6.550 6.198 5.877 5584 5.316 5070 433 4635 442 4263 4097 3902 13.590 12.462 1470 10.594 9.818 9.129 8.554 7963 7469 7025 6.623 6.259 5929 5.628 5.353 5101 4370 4657 44604279 40 3.954 14.029 128211754 10.836 9001 9.292 3649 8.075 75627102 6,687 63125.973 5665 5384 5127 4891 4.675 4476 4.292421 3.00 14.451 13:33 120421001 10.2019.442 8728.176 7665 2170 674363596.011 5696 5.410 5149 49094090 4.438 4300 400 3970 14857 13.491230311272 10.371 9580 8.883 32667718 7230 6792 6.399 6.044 57235432_5167 4925 4703 4498 431 437 35 15.247 3.799 12.550 11469 90.529 9.707 3985 8.343 7784 2283 6.835 5.434 607357465451 5.182 4.937 4713 4.5074310 432901 15.622 14,094 12783 11654 10.675 9.823 9077 8.422 7343 7330 6.873 6.464 6:097 5766 5467 51954948 4721 4.5144323 4547 2955 15.9534375 300311826 10 910 9929 9.161 8.48 799673726906 64916118 578354805 206 495647284520 438 4351 2988 16330 4.643 3211 1987 10.935900279.237 8.548790 7409 6.9056.514 6136 5.798 5.492 5.215 49644734 4524 432 415 1990 56.663 11 406 12137 11051 90.116 9307 8.6027984 7441 69616534 6152 5.810 5.502 52234970 473945284335 4157 1992 10.04 15:54 13591 12.278 11158 10.198 9370 3.650 8.022 7470 6983 6551 6166 5.820 5510 5.2294975 4743 4531 43374159 1994 172929537275512800 11.258 10274 94278.604 8055 7490 2003 6565 6777 5.829 5.5175235 4979 716 4534 4329 4100 3199 1979377159 15.046 3.332 11.925 9075797798951 8.244 7634 2105 6.642 6233 5.8715.543 5253 4992 4760 455 4347 3166 22 22 24 25 26 23 29 30 40