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 12B-1 and Exhibit 12B-2. (Use appropriate factor(s) from the tables provided.) A Chapter 12: Applying Excel B $ $ 3 Data 4 Example E 5 Cost of equipment needed 6 Working capital needed 7 Overhaul of equipment in four years B 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 480,000 35,000 55,000 30,000 $ $ $ $ $ 425,000 230.000 60,000 11 % 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 present value c. The internal rate of return is between what two whole discount rates (e.g. 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 11%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive not present value? Minimum age volue required to generate a positive represent value DORIT 1294Pwofst M Pela 10% ITS 11% 1155 BY 1 TH 19 20 21 22 23 24 25 1 0.902 095 0005 056 0917 0908 09 0893 ORS OR OWO 08620S ORAZ DO 0833 060320 081 080 0800 0325 0907 COM OS ORZ0826 0812 0797 0783 0756.0071 071 070 069 068 0672 0661 06500540 ORE 0864 0800 08 079 0m 071 070720693065 OUR 0541 0674 0609 0590 057 0564 0551 0537 0524 0512 4 0855 0823 072 073 0735 078 0683060636 0613 0542 0572 0552 0534 05 0499 042 046704510437 0423 0.410 5 0872 0784 0741 070 0681 060 0621 00567 053 0519 0497 04760456 047 0419 0.4020385 030 0.255 OM 0378 F 0790 0.746 0705 066 0630 0506 0564 055 0507 480 0456 0432 0.40 0.390 030 0352 0335 0.319 0300 0289 0275 0262 1 0760 071 065 0623 058 057 01 02 042 0425 0400 0326 0.754 0333 0.31 026 027 0263 0249 0235 0222 0210 0731 06770627 05820540 050 047 0434 0404 0376 0351 0127 0.305 0285 02060249 023) 021 0204 01 019 0168 9 07030645 05 0544 0500 0.860 0.4 0.361 0333 000 0284 0263 020 0225 0209 0.194 01800167 0155 00134 10 067 066 055 050 04670422 036 0352 0 0295 0270 0247 0227 0208 0194 01701620149 01370126 016 0907 11 0650 054 0527 0475 0429 038 0350 0.31 026 0201 02 015 01450178 0162 014 01350123 0112 003 009 D06 Os 055 0497 444 0297 0.256 029 028 0257 08 070R 07 08 09 om 0124 01208020092 0082 00760064 0101 050 049 045 036 0326 0230 028 0279 0204 0182 091 015 0130 0736 0704 003 G08 0075 006 0061 0055 16 0577 0506 002 03 030 029 02 021 0205 0781056004 015 011 0099 008 007 0060 0067 0055 019 0044 15 0555 00417 0362 0.315 0.275 029 0209053 01600140 02 08 0,095 006 007 0065 0057 0051 0045 00400035 15 0534 0458 0.94 0339 0292 0252 021 012 053 014101220132 003 001 007 0062 0054 007 0042 0036 0032 0.028 17 050 0436 01 2317 0270 0231 0198 0170 036 0125 0108 0093 000 000 006 005 0005 0039 0934 0030 0026 0,023 18 064 0446 0.50 026 025 0212 010 0157 010 00055 0081 006 005 005 004 003 000 000 0024 0021 00 15 0.415 0396 6331 0272 0232 014 0164 013 06 009 0083 007000600051 000 00 00 00 0023 0020 001 00 20 0655 07072 0254 015 017059 012 CON 007 0061 001 000 BOX 003 0026 00 00 00 00 0010 040393 0296 0242 099 095401 010 0093 0077 0064 005 004 001) Don 0006 002 004 003 oo 0009 22 0312 278 0226 04 050 0123 010100R3 0068 0056 0046 018 0012 002 0022 00 0015 000 000 0000 0007 23 0006 034 0262 021 020 018 019 004 0014 006 0040 0010 0003 0027 002 001 00150012 BOX 0009 0.007 000 0.250 0.310 27 0797 0158 0126 0102 0012 0006 005 0043 0035 0.028 0023 00 0015 000 0000 000 000 0006 0005 75 0.375 0295 023 04 OM 009 004 008 007 0038 0030 0.024 000 0000 0000 0000 000 000 000 000 0 021 0220 02 005 006 005 006 0053 002 0033 0026 0.021 000 0000 000 0007 0006 0005 0004 0001 0.37 0268 0.707 2761 0125 000 0076 0060 0047 007 0029 023 00 OM OO 0.008 0007 0005 0005 0004 0003 0002 om 028 050 016 00 0054 000 000 0026 0020 004 0000000000000050004 0.00 0.002 0.002 20 0321 0787 018 01 07 007 0057 000 000 0029 0022 001 00 01 000 000 000 000 0000 000 0002 0002 0.308 0210114 001 009 0075 0057 004 003 0026 0020 0015 000 000 0007 005 0000 0000 0000 0002 0002 0001 00 0204 OM 00910067 000 00120022001500 000 000 000 000 000 000 000 000 000 0000 0000 0000 0000 NAGR$ MIT 131: Present Value of any of in Area Periods 5% -- 102 ||? 12 139 49 15 16 17% 1, 19 20 21 22.2345% 1 0962 0552 0043 095 936 09170909 001 0493 0 08 070 06:085 0847 0.840 0830826 0820 0813 kg05 0800 1885 18SS 1,833 1869 1733 1759 1.136 1/13 190 1.6 1647 165 1605 155 156 15471.528 1509 1.92 1.47 1.457 1440 2.278 2727 263 2624 2577 353 2.487246 2402 23612322 2263 2244 22 10 2.174 2.140 2106 2074 3042 2017 1981 1952 1630 3546 346 1387 112 1240 3170 3102 2017 2.97 2934 21955 2/pr 2742 2690 2.639 26.39 2540 2495 244 3404 2362 5 452 439 4292 100 3933390 3791 36 3006 1517 3433 3352 3274 3190 3127 3.056 1991 2925 2.864 2 BTS 2745 2689 24, 507977 77 623 BB 4395 1231 1111 1999 7 3 ER; 3.59 3.99 3416 1726 1245 3 16: : WWW.3620 2951 6062 575582 5399 500 5033 4684712 4264 1423 24 4160 6029 3.922312 376 3605 3508 345 37 3242 363 11 E463 6210 5971 1747 5555335 56 1.96% 4799 40 4497424? 4.00 3.954 1937 3.75 3635 34213329 7436 10 162 6515 2675999 57156 5.537 3.320 41.2 96 4772 437 44514.03.4.163 4.031 3905 37 3673 16 1403 10 BT17 7722 7307024 16 15418 5.145 56 5650 5425 5216 5019433 a659 4496 4139 4192 a054 3933 3799 3682 37 1] RT60 +1 ? 79 7130 65 5.495 4.207 5.91 57 145) 1234 20 44 45 4,04,327 4.177 403902 373 365 86 3847943 7.536 7.161 68146.4924.194 91 560 194251974 4.7934511 439 4278 4127 3985 33725 1 986 9.194 ] 1.80 7101 740771016, TO 12: J2 4815142 110 910 4.71% 533 4,362 4.203 053 3912 1796 10591 9999 25 745 1.24 776 7.347 4.02 6,624 f30dop: 572 54 5229 5.00 4802 1511.42 4265 12 12 1924 11111 10.30 1712 9 10 1.58 E6176 7.101 81].62 14:57 5575 13124 5.92 4976 175 489 4115 a151 adol 319 1. 10 10 10 10 914) 11 11197124779 6.974 CC 2014 MAY 102491) PA6 4.3 17 10 002 117 12.166 11276 16 47 4763 9.122 ff44 R0227540 7.120 6729 17 047 5740 1.47% 5.222 1990 4.75 4.576 499! A.219 4059 1010 12 591190 10, 10 26 192 1756 2017027,25, 42 41 11 15346_739 5013 42 460 44 4249 10MG 1924 10 1331 12 0 11.15% 10,000 1.9650 5139,8,9,10 41 4.4Y) 15.313070 43 635422017 104 1391 12 16:1470 10 91 91 9129 17:40 10: 1020 30 15 191 70 -1.40 479 a110 114 A.C29 121 11.74 10 110 16017 ) 2012 9 dys1627122611: 507355 519 12791 675 476 pic a121 1963 ,5 11 13 12042 1,061 16 20104277 17 14: T1 PM 17410769 5011 14:15.416 140 4900 400 44 4162 1130 1976 3 1457 1349 12 10 11.272 10.71 958 3983 6 7711 72 1792 99 6044 5722 5.32 5.167 4025 470 a49 391 4 37 397 24 11.247799 20 11.69 10.5% 9.307 347714 ) 2011 10414673 746 5.45] 112 2017 15 ICP140 4143 348T 166 091 12.0) GPA 106292] 9.67] 104) 11 1060975746 5.4),19541 4721 15 14 13 14,915 15.94 14 75 12009 19,6108 9929 12.11.440 T9 T172 640 6491 6.118 1111 1480 626 1956 47 45.0 43364 151 3968 27 16 130 14 4] 11 21 11.097 10995 10.0279237 11 71.1941 40 19 1914136 1790 15 4025218 1964 41 424 . 4 151990 30 16.63 14 190 11 426 12.137 14.51 10.1169 17 14092 1964 7.44] 6.96165144112.10 55025221 1970 4110 570 415152 2012 16 14 15 11 30 19 298 11.158 jd-198770 9654) 1022740 69026561156 50 5,610 ) 20 1975 43 21 197 159 1999 17 02 15 12 13 10 17 11-258 10.274 1427 94 199 7.4M 7001 6566 177 50 5617 23 1979 746 45.34 19 160 1995 1993 17.139 4046 13 332 11.925 10797791% 4.244 7639 7105 56421211 5715540 525B 4.997 4.740 4 544347 1399 678ew 5