Please help! Thanks

2. The company is considering a project involving the purchase of new equipment Change the data area of your worksheet to match the following: Use Exhibit 148-1 and Exhibit 148-2 (Use appropriate factor(s) from the tables provided.) B 1 Chapter 14: Applying Excel 2 3 Data 4 Example E 5 Cost of equipment needed 6 Working capital needed 7 Overhaul of equipment in four years 8 Salvage value of the equipment in five years 9 Annual revenues and costs 10 Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 13 Discount rate $ S $ $ 270,000 35,000 20,000 30,000 $ S 435,000 270.000 90.000 12 % S a What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) Net procent value DOHIBIT 118-2 Present Value of an Annuity of S1 in Arreart: 1 10 11 12 0 1 5 5 1 13% 90 20 21 22 24 25 0.002 0.952090 093509200917 0.0090.901 0.93 0.885 0.977 0.20 0.362 055 0547 OBD E0826 08200008060300 1956 1959 1805 178 1759 1735 176 1690 1668 1647 18201605156515661547 1520 1500 1692 147 1457 100 2775 272 2.624 207 2531 247 2444 2802 2361 2122 223 2246 2210 21782302106 2074 2012 2011 1981 1952 3630158 32653387 1200 300 3102 10372974 2942055 2.79822090 2009 2.589 2.540 2494 2443 2004 2.362 4212 400 199 2000 3.791 1696 30052517 34313523274 21993127 3055 299129202864 2.903 2745 2.699 52425079497 4767 4400 4755 42314 3998 319 3784 365 359 3490 3410 3326 3245 3567 31092 2020 2951 8002 5705 5582 52393 200 5033 4.500 472 45644423 428041604039 29223.812 370636053508141533271242151 6710 6653 6200 595743 5535 5335 546 908 99 10094344207 20783951 23726101935903421 3329 2005 7100 50 624 5995 5.7995501 5328 502 4946477246074451 4.300 415340313905 37063677156634653 22 7360 7024 6710 6.545 5.309 5650 5.00 5215019 4833 4659 4494 433941940543923 3.7991682 3571 3750 306 1987 2499 7139 630509562075.83356675453 5234 50294006 40584343274177 4005 1902 17763656 9305363 32704 7903 7530 21 601464926.194 591856005621 5197 4998 479 4011 44394271417 3905 3.3513725 906 9394 7904 7437 23036750642461225542 550 5342 5118 4910 475 4520430220040533912700 105 295 745 24 2700 7.3676.9026626 6.902 8002 572454085229 50084302 4011 4.1324205400 2952 2324 10300970 9300 35598051 7600 7291 6511 0:452 6142594755755324 5.092 475 467544094315 00125 T052 08300900947 3.95130 2014 2379 974 0.000 0.2655954 5668 540551074978 4730 456 457 4189 4.6333 128 127210479703 902 544 20227549720 67296.373 6047 5749 5.4755 222 4.99047754576 43914219 40591910 1269811.000 1082110050 9.372 74 8 201 202 7250 6.3406467612855.534 5.2735033 48124608 419 42033000 3.920 131341005158 10:338960490 83657839 2.300 938 650 61905.877 554 5310 5070 443 40354412426340973942 1512462470 10.594 0.81 9129 35790 TO 7025 6.6225259 5.929 562 5:1515101 4.570 4657460 279 2110 1058 1802912921 11704 10136100179292 86498.075750270266767125.07 5665 5.384 5127 9914675 4704292421 2983 1245151 2042 101 102019.422 3.772170 7615 7170 67436259 601 5.098 5410 5149 4908 409 410 4730 270 145739 12.3032210371 9580 5.80 1.206 7710 72307926299 3044 57235432 3.567 492547034499 1970 15247 07977255011409105299707 395 274 720 6.835 6.434 5073 5.786 551 51824937473 450744381 1362254010700510610023 0.07184227843733068736.484 0975700407519549414721 516 4324147 2005 15903141900020103100929 951 BE789073726900 64016110 5703 5430 5,200 4950 428 4520 4151 1950 130433 0211 11907 1905 90027 021314370137408956514 600 5.799 5.92 5.215 496 734152443324354 2990 6663153601 105110115 9.307 10077954 7441 653451525.0 5502 52234970 473952354157392 16.154 15541 13591 12:27010158101989.370 1.65000227703 6551 516050205105229 4975474315314 2004 17292 15172276534001125102740271605574957003066177 522955175275 476 4534 43394500 7995 175060102505795102 7034705254052949914700 4541 47662099 22 38EUNE 25 30 he 2. Required information What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) Net present value c. The internal rate of return is between what two whole discount rates (eg, between 10% and 11%, between 11% and 12%, between 12% and 13%, between 13% and 14%, etc.)? The internal rate of return is between % and d. Reset the discount rate to 12% Suppose the salvage value is uncertain How large would the salvage value have to be to result in a positive net present value? Minimum salvo value tequired to generato a positive present value