please answer all requirements (7) tables are included for calculations thank you!!

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 22% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cont 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 $ 88,000 $68,000 Home The company's discount rate is 20% Click here to view Exhibit 148.1 and Exhibit 143-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 retum for each product Ga For each measure, identify whether Product A or Product B is preferred 6b. Based on the simple rate of return, which of the two products should Lou's division accept 100000000000000 0010701 000200172 00 34 0 100 WO 0000000000000000000000 FOOD WOOD OSC0000000000000 000000000000000000000 LE 0000000000000000000000000000000 WE 00000000000000000000000 DOCO 00000 CODEC ODO0000000000000000000000 00 TO O OSO Donoso 0020000 200 00 00 00 00 00 00 00 DO DE 0000000000000000D POD WOOD OD IND DODO no 000000000000000000100 0 00000000000000000000000000000 SIDO 000 000 000 HOD 10000000 100 000 OOOO COD 00000000000000000000000000 BOLO BIO 9050 1600 Oto O 000 000 0000 90000 10000 20000 HO 20 20 2620 SED TO GO TO 00000 100 200 00 00 00 000 CORO BOOOOOO SD 200 0990 - 1000000000000000000 OSLO l 10 LO SOCO. O CAO 6600 VEDBO SOSO 50 0003 00 00 00 POLO RO 000 SOBOTO SOOOOOOOOOOO 1090 Wooo COLO GEO 1000 MO DO ESZO OS COSTO 2000 000 600 COLO 210 20 23.00 SOLO UZO OO O O O OSO MO SVO SO 00 D D OLD CRO WED 100 to 220 DO DEDO E ESCO 3000 1900 10 IND OOOO ZOO 0000 2000 BEO00000000 0600 160 POSTO CEGO CO DO SO SOCO LEO SEO BEO 100 100 COD 000 EO LOCO ICO LCO TOZO SECO O O SEO O NO DISCO DONOSO 900 000 EZO LOOD SZZO SO OCOCO SOCO SCOOLCO 0000 0 YDSYO O 200 SESO: 190905000990 SOUND 0020 ESCO. OD TO D. COROND 0302 OTTO 00 00 00 00 019 0904 050 0.250 0.750 022 0100 0.0040 600.650 OLD 12 11 ORD ON 5 co 0650 010501 SET 050 059 0.43 0.05 0.456 417 0.003 0.750 0370 0.95802 059205205520051002007051 20792070135 0700 000 000 000 000 092 0009 0564 0.0006 0704 om 07510072 065 065 0.058 064 06 0600 059 0579 034 04 05 098 0907OOTS 017 02 0.025 070 076 075 070 071 0707060054 053 6672 000 0000610 0560992060035 092 091 09090901 0.00 0.00 0.00 0.002 058 01 050 023 010 0100 0.00 0.00 0.00 20 14 9 1 SOL IL SEYE 69 0129 2004 SW Po 103 10 15 20% 0000552 000 09150926 0,912 0.909 0901 2093 07 0570 0362 0.55 0.047 0.540 033 0.5240120 0003060.000 2 1 1956 1133 100 1 20 1736 160 1666 167 1626100550 560 141 1520 150043457 TA 27 2024 2577 2531 201 244 2402201 222 223 2246 2210 21142140 200 201 2002 2001 1981 19 26001546 1455 222 2240 31701022037 294 291 21552790210 2090 2039 2549 250 241 242601 2262 5 4452 129 4212 1900 29933190 3,791 10763505 356 3433 1382 3214 2199 227 3050 2.991 2926 2854 21000 2105 2009 30 SON 4957 4 44 4.35542314 1999 1704 16051509 349 3326 324537 1092 3020 2951 7 0574 5.205 5.000 40 72464 2427 42880 400029221121906 1905 350 300 2.327124215 620 59 52 5505 5335 556 56 99 450 44574314 4 207 407 354 38717263619 15111329 30255 5995 5759 552 5.370 532 49464772 2007 2451 4.3004 4031 1905 37 1073 2360 6.4 65 59 5650 5426 5206 5019 4833 4659 14 0042 4054 1923 199 1602 1571 11 10000 2179 6305 6.95 6.207 5938 567 5450 5234 5029 406 4056415022241 400 300 301058 30 36 34 790 2535 1901 606692 694 59185660 54215197 40 402 403 25 1525 2358 2904 7487 703 6.750 644 8122580 5583 5342 51 4910 45043024204029 270 09.099295 24472 7.3626902 628 202 6.002 572455220 5000 002 422 42300 1038097 100 8.5 3001 7191 8.640262 5.87 5575524509875335 4001150 1852 700 940 1551 1934 7370 69146016205 55545668 5.405 5562 7304357 40310 112144700 0022 154 10227549710067296 579 5.0 5222 499044570312104053 1950 21000 21005372 1.756 0201 7700 725004067012555594 5.27330 4812 4000 4001 1013090950 1367070665506199 SH7555000 35000 150 42 1430 52 TAG 70258.625.20 5929 0172 01 LES 100 420 305 100172 07027026 0259009347 62 SU 120001020112 2017 2018 2020 305096 500 0000010 495 120 11210171530 7209210045525 LO) 19 20 1300 1129 70472040 5700 2 16522 50703304 SSS 2000 201503053045 100715070706516 73544543 100 TO 9:30) TMA4125555233 09 650 02 03 04 2 31 6 HYDG DO