Hi, please help with question #3, I can't figure out how to calculate the internal rate of return. please show in detail how to get the answer, 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 payrolses are determined by his division's return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Products Initial investment Cont of equipment (zero salvage value) $ 290,000 $ 490,000 Annual revenues and costs: Sales revenues $ 340,000 $ 440,000 Variable expenses $ 154,000 $ 206,000 Depreciation expense $ 58,000 $ 98,000 Fixed out-of-pocket operating costs $ 79,000 $ 59,000 The company's discount rate is 15% Click here to view Exhibit 148-1 and Exhibit 14B-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 6. For each measure, identify whether Product A or Product B is preferred. 66. Based on the simple rate of return, which of the two products should Lou's division Soccept? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4 Reg 5 Req 6A Req GB Calculate the internal rate of return for each nraduct. (Round vour nercentaon answer to 1 decimal nacele 0.123 should hel BIBIT - Pratent Valuerst 201 Parol 45 50 94 09 145 15 193 21 22 23 257 1 0.92 0.952 009350920091 0.909 0.901 0893 OBBS 030870 0362 0555 0347 0.840 0823 0.3260320 080 0.806 0.000 2 0925 0902 0.000373 0857 0342 0320 08120797 0783 0769 07560743 0731 071007050094 0683 0.672 0661 0650 0640 0054 05400316 074 0720751073 072 093 06750658 0641 06240609 0.53 0579 0554 0551 0.587 0.5240512 4 055 03230792 073 0735 0700 0603 0659 0056 0600 0592 0.572 0552 0534 05160499 0.482 0.467 0.451 0.07 0.4230410 5 0022 0.784 0707070 0681 0650 0.621 058 0567 050 059 0.497 0.476 0456 047 049 0402 0.336 0370 0.355 0.3410320 0.750 0.746 0705 0.656 0030 0.506 0564 055 0.507 0.480 0456 002 0.410 0.90 0.370 0352 0.335 0.319 0300 0209 0275 0282 7 0300070 0665 0020583 050 0.50 0.832 0452 0425 0.400 0.376 0354 0.333 0.21 0.296 0279 0.26 0249 0235 0222 0.210 07H06770622 052 0540 0.502 0467 0.04 0.804 0.376 0351 0.327 0.305 0295 0206 0249 022 021 02040191 01290960 9 070006450592 054 0500 0.400 0.424 0.391 0.361 0333 0.308 0.24 0.250 0.24 0.225 0.209 0.194 0190 0167 0155 014 0.04 0570000550 0.500 0.463 0.422 0.385 0352 0.322 0295 0270 0247 0227 0200 0.191 01760162 034909370126 0.116 0.307 11 0.650 0505052 0.05 0.429 0.388 0350 0.31 0.287 0.261 0237 0.21501950179016205400005 01230112 0903 0.094 0.085 12 062505570.4970444 0.397 0356 0.319 0200 0257 0231 0.208 0187 05600152 0037 0.024 0.12 0.1020092 0.003 0075 0.069 . 0.601 0530 0469 0.45 0.368 0.326 0.290 0.258 0229 0204 0182 0163 05450130 0110 0104 0090 0.084 0.0750068 0001 0055 SE 0.5770505 0.412 033 0340 0299 0.263 0232 0205 0.181 0.160 0141 0125 0.111 0.099 0000 0078 0.009 0.062 0.055 0049 0.044 15 0.5550401 049 0.362 0.15 0.275 0239 0.209 0183 0.3600500123 0100 0098 0.004 0.074 0065 0057 0051 0.045 0.040 0.035 10 0.534 045 0.394 0.309 0292 0252 021 058 01630541 012301070093 0.001 007 0.002 0.054 0047 0002 003 0002 0028 050 0.00 0.371 0312 0.270 0231 0199 0.170 0546 012501000090 0.000 0.000 0.0000052 0045 0.039 0.004 0030 0.026 0.023 0.69 0.450.500290 0.250 0212 0.1500153 0130 0:1 0.095 00010069 0050 2051 0.04 0.008 0.032 0.028 0.024 0021001 19 0.475 0.39603010277 0232 0194 0164 0.38 0.116 0090 0.00 0.00 0.0000051 000 0.037 0.031 0.027 0023 0.020 001 20 0.014 0.4560277 0.12 0258 0.23 0.178 0349 01240104 0.007 0.073 0001 0.051 0.063 0037 0.031 0.025 0.022 0.019 0.0% 0.00.012 21 0090359 0294 022 0199 0.564 0.05 01120093 007 0064 0.053 004 0.037 0.001 0.025 0.022 0.018 005 000 001 0.009 22 0020362 02780226 015401500123 0301 0.00 0.008 0.05 0.06 0.030 0.032 0.026 2022 0.01 0.01 000 0.on 0.009 0.007 0.4060320 0262 02110170 003 0.112 0.091 0.074 0.000 0.049 0040 0.033 0.027 0022 0.0180.015 0.002 0.000 0.000 0.00 0.006 24 0.00310 0.2470197 01560126 002 0.002 0.006 0.053 000 0.035 0.025 0.023 0.019 0.015 0.00 0.01000000007 0.006 0.005 25 0.375 0295 02330354000100092 001 0.059 0047 0.033 0030 0.024 0.020 0.016 000 0000 0000 0000 0000 0.005 0004 20 0.31 020 0220 0172 0050100 0.004 0006 0053 0.012 0033 0026 0021 000 001 0011 0009 0.007 0.005 0.005 0004 0.000 22 03070203 0.2070301 0.125 0090 0.0250060 000 0.037 0.029 0023 0.013 001 0.00 0.00 0.007 0.005 0.0050001 0.003 0.002 20 0113 0255 00150010 0000 0.009 0054 00420033 0026 0020 0.096 0012 0.010 0000 0.000 0.005 0.004 0.00 0.002 0.002 29 021 020 01050 0107 000 000 004 00370029 0,022 00170010011 0000 0.000 0.005 0.00 0.003 0.002 0.0000002 30 300200 0010099 007 0.057 004 003 0.026 0020 0.015 0012 0.003 0.007 0.005 0.00 0.003 0.003 0.002 0.002 0.000 0200000007 0.067 004 0032 0.022001500110008 0.005 0.004 0003 0002 000100010001 0.000 0.000 0000 0000 0000 DOCBT8-2 Patent Value of an Annuity of 5 in Art 24 739 Parloos 2 53 9 100 th 12% OS 10% 15% 10% TO 19% 205 21 22 23 25 0.0020952090 09350926 0907 0909 0.901 0.093 0.55 0.77 0.870 0.362 0.855 0.347 0.840 0333 0.326 0020 030 0.006 0.800 2 1500 150 1533 1108 1780 1750 1730 170 1690 1668 1667 1626 1005 1585 1565 1547 1520 15091492 1474 1457 1460 2 2.773 2673 2021 2572 201 2:07 2444 2402 2361 2222 223 2246 2210 2114 2500 2006 2074 2012 2011 1901 1952 1600 1516665 2307 30 3200 1070 3.102 2032 2.974 294 2955 2790 270 2690 2679 2599 2.540 2494 2448 2.1042362 5 452 42 4212 2100 2993 1890 3791 7696 3.605 3.50 3.42 3.352 1274 3199 31273058 2991 2926 2364 2.300 2.745 2609 5 522 5.075 4977 4767 4627 4436 41554231 3.998 209 3.784 36853589 3498 3410 3326 3245 3557 3.092 3020 2951 7 0.002 5700 552 5.2095 205 5033 43004712 4564 4423 4208 4.500 400929222812 3706 1605 3500 3.416 3.327 32422161 670 6.40 6.210 5.971 5747 5515 5.255.5454968 479946394487 4344 4207 40703954 3.807 3726 36153512421 3.329 2300 6.002 6.515 6247 5.995 5.7595537 5328 50249464772 4.607 4451 4303416340313.905 376 3673 3.566 3.463 10 7722 7300 7024 6710 5. 6545 5889 5650 5.426 5216 5.0994.833 4659 4494 4309 4192 40543923 3799 3682 3.571 11 3.750 3306 2007 7,499 700 6 305 6.4956207 5938 5.687 5.453 5234 5.029 4.6364656 4400 4327 417 4005 3.902 37763656 315 7903 7535 2151 6.814 6.492 6194 59185680 5.421 5197 4988 47934611 9900 994 4409 4278 4.127 3.905 3851 3725 3507904 7487 7.103 6750 6.424 61225.042 5.583 5342 518 4910 4715 105609.099 9.295.745 4533 4.362 4203 405329123780 5244 2786 7367 6.902 6628 6.302 8002 57245.460 5.2295000 48024611 4.432 4265 4108 3962 3.824 15 10.3809712 9100 8559 0001 7606 7191 6.811 6462 6542 5.347 5.575 5324 5092 48754675 4.499 4.3154153 400 2.50 18 1652 103 10106 9407 3851 78242379 6974 6504 6265 5.954 5.660 5.4055102 4933 473045364.357 418940333587 12.36 TL27690077 9783 9.222 354 3.022 7549 2120 67296.373 6047 5.749 5.4755222 4990 4775 4576 4591421940592910 22.69911000 10028100599372 0756 201 270272506540 6.457 612850105.534. 5.2735033 4.2 4.608 4.419 42434000 3920 004 2005 1115 103069604950 8.365 782923666.938 6.550 6198 5.877 5.584 5.30 5.070484346151442 42634097 3942 20 50024621.00 905949.00 9129 8.517963 7469 7025 6.623 5.259 5.9295628 5.353 5101 4.870 4657 446042794110 21 02922111754 100069017 9.292 06498.07575627102 6687 631259735.665 5394 5127 49914675 476 4292 4121 22 1445150200211001102019.442 2903 1.7728.176 2545 2170 67436.359 3.011 5 696 5410 5549 49094090 4430 4302 400 3.970 20 SL574912300 1272 0.3719.500 8.00 8.266 2718 7.230 679263996044 5723 5.02 5167 24 15273790 2.550 11.46905299707 4925 4703 1499311 432 905 341 2.784 2283 66566346.073 5746 5451 5102 3970 25 15.622 4094 270311654906750823 4937 470 45074318413 2981 9.077 422 78402330 6.073 6.454 6.0975766 5467519549404721 45144323 4547 20 150.000 120 108109929 3.905 29614307896 2372 906 6.491 6118 570 5.400 5206 4956472815204328415 10146021 11.92 10.905100279217 8.5079074098.905 654 6136 579854925215496447344524 432 4154 1988 15031606207 MOS 10116 9307 1.602 7984 7441 69616534 5152 5810 5502 5223 4990 4739452843354152 25 5 501278111581000370 850 3022 7470 903 655161065120 5510 5229 975 40 451 412 41502994 3992 30 112925070520091123010214942716948055 74967000 6566 6177582955075.235 4979 474645340300003995 40 19771500103211925075797799513241 7634 7105 6612 0.223571 5585258499747505043024906 1999 3990