- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 1 (48.82 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 2 (29.5 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 3 (59.17 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 4 (49.67 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 5 (83.48 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 6 (83.48 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 7 (93.11 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 8 (57.18 KiB) Viewed 31 times
- 2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet 9 (65.09 KiB) Viewed 31 times
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) fie prent value c. The internal rate of return is between what two whole discount rates jeg, between 10% and 1%, between 15 and 12%, between 12% and 13%, between 13% and 14%, etc. dReset the discount rate to 17%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value?
IT Pret Value of St C 12 11 14 15 M 12 0925 0907 08350 asn 0857 0342 026 020 037 0383 079 076 0703 678 67 0889 0364 0540 025 0794 0772 071 071 072 0993 065 00586604 6509 0543 0579 0564 055 0537 0534 050 0706 0054 0683 0672 061 650 0440 4 5 6 0822 0784 0747 073 001 0650 0621 6580 0567 0543 059 0457 046 0456 0437 04190002 0.30 0.370 0355 0341 0328 065 0622 0.583 0547 050 0482 0462 6425 0400 636 0354 030 934 6 22 12 R 25 39 M NO VA Not NOC OCD CD CD OD 90 S80 2900 OCE O SED 1550 1060 6060 69 250 960 60 2560 2960 MAN SP NO ARG zato size co toco aco SEED D co oce 200 000 2050 SESD 950 9650 90 9990 SOCO CD 060 WO OKO to facO GLED 96ED OLED ZZZO SEZO 1 soco Coco MEO HD 100 200 2050 050 2050 290 2290 sto CO CO 00050 w 250 w care TATO CO CO CO CO F 76 IN T XP% are 9 O CORO 950 VESO 2950 2259 260 000 90 6630 RVO BOCO SEED COCO OND CZEO S680 0577 0506 0442 6555 040 040 6302 YPN 06% 6 0.556 0.508 0463 0422 036 0352 0322 0295 020 0247 0227 0206 091 6075 026540 0337 0650 055 0527 045 0429 038 0350 0317 0.287 0201 0237 626 016 0170 0362 0148 0126 016 0307 US 023 02 0303 600 000 0102 0062 000 000 0009 0504 0000 0004 005 000 000055 0125 am 0000 000 000 0000 0062 005 004 0044 900 OBOCO SECO 520 962O SED SCO LECO WO 2000 2550 SCD 40 000 SO MO 20 voco sro 020 0620 seco DAD VEVD 2010 240 1090 00 00 sro saco 038 0340 0299 0263 0232 0205 000 OM SEO HD 60 cose soro 0 000 MED MED SO LD 19500 REED SAD ure acto MAR HOED M 0341 028 01255 03 150 20240 0140 DOP 0200 004200 0000 000022 NO 4 COCO CO e cocos 1600 OD OD 00 1500 250D SOD NOD 30000 940 COD ONO OKO CO soro ZO SIZO OND O Bro esto caco CCD CD D C200 200 000 000 000 200 200 000 1900 0000 0000 5000 000 000 acto c HTD KYD OSD 1950 00 200 000 000 200 000 1900 6600 0000 000 000 000 40 000 20 oso seto ouco SED MED 9000 AND 210 5400 22% seco so DE ACC NOT SIC 0000 9000 GEO 0000 0043 00 00 0475 0300 033 0277 0232 0456 0377 032 031 020 034 0304 01780549 0124 0304 6087 076 000 0043 6037 00 00 0022 00 0OM CON 000 000 000 000 0627 0022 0000 000 0OM 012 603 007 0064 003 0044 7 0 de 0022 00 com comm0009 01010 0000 00 00 00 00 00 0022 00 00 00 00 000 000 COM UN 0000 0000 0000 0000 0027 0022 600 000 000 000 000 000 000 020 630 0:24 GMT on 926 002 0.02 0.006 003 004 003 00286022 600 000 000 000 000 0000 0005 0000 00 00 6047 000 000 000 000 000 000 000 000 000 000 000 043 032 0202 0211 61001300112 4220 02 030306 0004 600 900 000 0000 0000 WE 0 000 000 0040 0047 003 002 00 OON ON 01025 00000000000000000000005 000 000 0000 0005 0004 0000 004 0000 0000 0002 00 000 000 000 0004 0000 0000 9 400 000 000 0000 0000 0000 0000 000 0004 0000 000 0000 0002 000 00000000 0000 0000 0000 0000 0000 day 06 0020 000 4005 2004 6 M MacBook Air U 500 webe On D 10 OCO 2o 920 240 000 40 400 0.129 ONE 1940 0123 0307 00 cer com 0062 0054 0047 0042 0006 0032 6025 BELO
EXHIBIT 48-3 Pecent Value of an A ON 153## BSUNUN DES NO V M SK. NA SH M NA MENCE 460 OED SED D60 2960 2960 MOD DE CES CON CS SACES DE 180 1060 6060 091 190 000 2961 401 Oz not wist waz az az azz wez tace ZEE VICE CON 12 DE out at met wEZ HEZ HOZOTT GE OCT Z S KE WE WE ut act E EZ EZ WZ wot cat SST MEE HET TOEST SOVE OVE MACE sit ve otace MEE OP MET SHE MALE SOFT MO THE OCE LICE NE BOSE SOT NICE DE ZET SY ONE BY COT PAY 1806 1856 1833 2775 2.723 2673 3630 3546 Clark BOOK WON 7% IN SICE 1.000 1.780 LIST SOFT ACE OKE SOWE 4212 4x00 520 4907 4767 4523 6.002 506 5.502 6733 £404 5.97 5347 5.305 7435 2900 6.302 6.585 4.247 5.995 7722 6.70 6.40 11.306 7807 1343 8.304 2943 7536 PIEK con DOCE 600 60FL 1759 2531 ONGE ENGE CLOS DOS GIS 6032 GON'D IKE 996 1043 $0 $296 845 8.244 11700 $300 4.40 4355 421 4 4.98 472 5.335 554 49 470 409 4487 4364 4.303 1554 387 3776 36 15 14 109 5.750 5.537 5328 512 4546 4772 4607 40 430 44 1905 196 1975 1904 140 6345 5309 5450 545 526 500 423 489 4330 4.50 48 645 6207 5530 507 5453 5234 5029 430 456 4.406 4.327 42 6.3 6.42 64 59 5000 5421 1397 498 4750 44 40S 428 407 35 183725 7900 6.750 644 6122 4525 4362 4200 4052 192 370 7367 662 6628 6300 6002 5724 54 5229 500 4902 A 4412 430 4300 12 104 7606 716 642 6542 5847 5.55 5.324 1002 4.070 4675 4.40 4.35 48 5.342 5.503 5342 50 49 476 7924 7379 654 6604 6265 1954 5600 5405 5362 438 470 456 457 4 8544 420 419 1205 1000 10829 10.059 $372 8756 8201 7700 7250 6340 667 40 50 554 5273 5003 40 40 12:005 1.158 0336 9604 8950 8345 783 7300 6.938 4550 48 5877 5504 536 500 430 4435 440 42 100 12.40 140 10504 $310 854 1963 1409 7025 6623 6.259 5829 5628 5383 550 40 405 400 425 4 2004 14.029 122211064 0 000 9292 1542 702 6807 6.30 552 55 5304527 849 son M3 12042 11001 10201 9442 1149 12:30 11272 1337 9500 530 079 22550 8772 2.0 2645 750 6.700 6.250 65000 505 490 400 LS 432 400 3309 3 8.206 27 89059348 774 1283 4825 6.434 5073 5740 540 552 437 4.70 4.507 4300019 9077 8422 1941 1330 4473 454 4007 576 547 55 456 4720 434 433 457 2005 15.822 14.054 127 15943135 3000 200 1460 1329 11400 10.529 9307 654 0675 9.823 8200 $329 073350027 13.406 12:37 11.01 40 7206 7372 630 644 173 1.400 5200 498 4778 458 438 439 927 8548 7543 2409 6.905 654 656 128 542 520 464 474 4324422245 100 9307 1.602 7904 1461 404542 520 532 522) 437 438 4305 48 487 282 10:30 9370 650 6022 7470 490 45 466 5320 530 5229 45000 45 4337104 1024 $47 104 8.000 26 7003 6566 6377 5229 5507 525 435 436 4554 4456 2 325 0752 9779 435 8.244 7034 2505 6642 62 547 554 5.258 497 AND 4544 434 4300 100 1694 M 2.522 1 1722 15.372 5075 12.40 11.258 197933715045 32 MacBook Air TACK ONE ON DE SO Y NEW D 8358 2904 7407 77 1903 9659 are cas tas TE 6018 th 9 1426 1505 1505 150 2176 276 1507 158 1509 142 144 1457 1400 22% ESET PROT ONE HACE NET THE SY LIVE WAT 1009 FAST ARE CRY DETAY MY NIT S S sss 2 0 SE C20 THE AZEW THEY SOY LOY WAY NOTACY CYSYNS CCCS HOCHZEL DEZE
ezto. on: Capital Budgeting Decisions Assignment Saved Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14-8 in the text. 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.) A C 1 Chapter 14: Applying Excel 2 3 Data 4 Example E S Cost of equipment needed $ 6 Working capital needed 7 Overhaul of equipment in four years 8Salvage value of the equipment in five years Annual revenues and costs: 9 Sales revenues 10 Cost of goods sold $ 11 Out-of-pocket operating costs $ 12 55,000 17% Discount rate 13 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 Prev 1 of 1 Nex $ $ S $ 110,000 30,000 10,000 30,000 360,000 275,000
tion: Capital Budgeting Decisions Assignment i Saved Required information Annual revenues and costs: Sales revenues 10 Cost of goods sold $ 11 Out-of-pocket operating costs S 12 55,000 17% Discount rate 13 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 17%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minimum salvage valus required to generate a positive present value Next S 360,000 275,000
ezto-cf-media.mheducation.com Media/Corner EXHIBIT 18-1Pcent Value of $1 * 0% 115. 125 12N 146 15% 175 Jes 22% 23% Periods 1 75% 0962 0713 0790 0346 T 0300 071 9 760% 4% 7% BIN 19% 20% 2 0.952 0943 0935 092 0917 0.909 0.901 0993 0805 0.877 0170 0862 0.855 0807 0840 083 0826 0320 083 6306 000 2 0925 0907 0290 0.873 0857 0542 0325 0312 0797 0783 0309 07560743 0731 0718 0X060004 063 0672 058 0050 0640 3 0889 0064 0340 0216 0.794 0772 0.751 0731 0712 0.693 6675 058 0641 0624 0606 0583 0579 0564 0551 0537 6524 8512 4 0855 0823 0.792 0763 0735 0308 0603 0659 0636 0613 0502 0572 0552 0534 056 0499 0452 0467 0451 0437 0423 040 5 0822 0.24 0347 061 0650 0621 0590 0567 0543 0519 0497 0.476 0456 0417 0419 0402 0.30 0.370 0355 0.341 630 0305 0606 0.630 0506 0564 0535 0507 0.400 0.456 0432 0410 0290 0.370 0352 0315 0319 0303 0209 0275 0262 0605 0623 0.503 0542 0513 0.412 0.452 0425 0.400 0.376 0354 0313 0314 0295 0279 0263 0289 0235 0222 0290 01790103 0.7 0671 0627 0582 0540 0.502 0467 0434 0404 0376 0351 0.327 0.305 0285 0200 0249 0233 028 0204 0191 0167 0155 0144 0138 07030645 0592 0544 0.500 0460 0424 0391 0361 0333 0300 0294 0263 0243 0225 0209 0194 050 0:16 0162 0149 0630 0.014 0.558 0500 0.463 0422 0.396 0.352 0322 0295 0270 0247 0.227 02081 0137 0125 016 00 0148 015 0123 0117 0103 01/02 0850 0.585 0.527 0475 0.429 0380 0350 0.30 0257 0261 0237 025 0905 0102 0012 003 0076 0:00 0124 012 12 0625 0557 0.497 0464 0.397 0356 0319 0286 0257 0231 0208 0387 068 0152 0157 0963 0545 000 0:16 0104 000 0004 005 006 001 0055 13 0.601 0530 0469 0415 0368 0.326 0290 0258 0229 0304 0182 0160 0541 0125 0m 0.000 0.00 0.00 0.00 0062 0055 009 0044 0.577 0.505 0442 0388 0340 0299 0263 0232 0205 01 01600140 0417 0362 0315 0275 0239 0209 0163 0123 0108 0095 0.064 0004 0005 0057 0.051 004500400035 15 05550401 0062 0054 0047 0042 0036 0002002 0123 0307 0.093 0.001 0.071 0534 0458 0354 0339 0252 0252 02 0188 0163 0541 0.5 0.4 0.371 0317 0270 0231 0198 0170 0146 0125 000 0093 0.000 0.000 0.000 6052 0045 000 000 00300025 0.023 044 0416 0350 0296 0.250 0252 0100 0153 0130 0.005 0.001 0000 0055 0.051 0044 0038 0032 0028 0024 002 00 0164 0138 0068 0083 0030 0.000 0.00 0.043 0.037 0.031 CT 0023 0020 007 COM 0.475 036 0311 0.277 0222 0194 0456 0377 0332 0258 026 018 019 0124 0104 0087 0073 0.001 0.051 0043 00700 0026 6022 009 00 00 000 005 003 001 0.009 M 17 10 U 20 21 22 0439 0359 0422 0342 0125 0123 0406 0326 0117 23 24 0340 0310 0294 0242 0199 0354 0275 0226 014 0150 0262 021 020 01 0247 0197 0150 0126 25 0375 0295 0223 0184 0146 0196 26 0301 0291 0220 0172 0106 0004 0125 000 0076 0000 000 015 014 0107 0.002 0.003 0176 0.001 0.007 0.007 0112 0093 0077 0004 0.053 0044 000 000 0026 0.002 001 0013 001 0000 000 000 0000 0056 0046 0038 0032 0.025 0.022 00 0.00 0101 0031 004 0000 0049 000 0033 0.027 0.022 00 00 0012 0.00 0.000 0.007 0006 0102 0082 0006 0053 0043 0.005 0.029 0022 0015 00 0.00 0.00 000 000 000 000 0092 0074 0059 0047 0038 0000 0024 0020 00 000 000 000 000 0000 0005 0.004 0.009 600 0.00 Dom 0000 000 000 000 0.00 0.00 0.000 0000 0053 0042 0023 0026 0021 0.060 0047 0037 0029 0023 00 0054 0042 0033 0006 0020 00 004 0037 0029 0022 600 00 007 00 00 00 002 000 0343 020 0.20 0 0333 (1255 056 050 4321 0243 0004 3001 0002 000 0005 0.005 0.00 0.003 0002 0.002 0000 0000 0004 0.000000200020002 0.005 0.004 0003 0001 0002 0.00000 0.00 0.00 0.000 0.000 0.000 0.000 0.000 0308 0221 00 00 0000 0.00 0.00 0.00 0099 0.075 0057 0.044 0.003 0026 0020 0015 0012 0.00 0.00 0.00 0201 0542 0.05 0032 0.022 0015 0.00 0.00 9 106 14 # ZAERAARS 21 30 40 NE 500 GLED NO 9440 BIO 0000 600
ezto-cf-media.mheducation.com/Media/Connect Production/tine/accounting garison 170/ExhibitExhibit 148 2.jpg 0 C EXHIBIT 148-2 Present Value of an Annuity of $1 in Arreart; [1] Periods 46 5% 6% 7% 15 9% 1 0962 0.952 0943 0935 0.926 0.917 2 1806 1309 1833 1808 1783 1759 3 2.775 2.723 2673 2624 2.577 2.531 3630 3546 3,465 3.367 332 3,240 4.452 4329 4.212 4100 2.990 3000 4.423 4.406 5206 5.033 5.971 5347 5.535 4 5 6 5242 SON 4017 4767 6.002 5706 5502 5309 7 11 6733 6.40 15. 10% TTK 12% 17% 34% 1525 His 17% 11% 10% 20% 21 22% 225 241 25% 0.909 0.901 0893 0835 0.877 0.870 0.862 0855 0347 0.840 0533 0826 0820 081 0306 0800 1736 1713 1690 1668 164 1626 1605 1585 156 1547 1528 1509 1472 1474 1457 1440 2.487 2444 2.402 2.301 2322 2283 2246 2210 2124 2100 2106 2074 2042 200 1901 1952 3170 3102 3037 2974 2.914 2855 2798 2743 2690 2639 2.589 2540 2494 2448 2404 2362) 3791 3.890 3005 3517 3423 3352 1274 3799 3127 2050 291 2926 2004 2003 2745 2005 4356 4231 4.111 3.990 3.09 3784 1685 3509 3.030 2410 3326 3245 3357 3092 3020 2.951 4968 4712 4564 4423 4288 4160 4.039 1922 182 1706 1505 150 146 3327 3242 3161 5.335 1540 4.900 4799 4639 4407 4344 4207 40 3954 1837 1776 169 1510 1421 332 2435 7308 6.102 6515 5.247 5.995 5799 5.537 5.328 5132 4946 4772 4.007 4451 4303 4163 400 3905 306 3672 2506 143 8.311 7722 7:360 2024 6.790 6.40 6145 5.000 5.650 5426 52% 50% 483 4659 4494 4330 4392 4054 3.923 37063482357 8700 8306 2007 2400 7039 6.005 6.495 6.207 5.900 5.607 5453 5.234 5009 4006 4004 4406 4327 4177 4005 3902 3776 3656 9305 8.863 8384 2943 7.536 2161 6.814 6.492 6194 5.9 5.000 5.421 5192 493 473 4.0 4.439 4270 427 3.905 3851 3725 $906 $294 8053587904 7407 7102 6.750 6.424 6122 5847 5503 5.342 518 490 4.75 4533 4302 4200 4053 292 3.700 6563 900 9205 8.745 1244 7206 2367 6082 6.620 6302 6.002 5224 54 5229 500 4002 441 442 4265 4300 3.923824 10 10300 9712 9:300 8.559 8001 2600 2191 611 6462 6542 5847 5575 5324 5012 4006 4075 4400 4215 4153 40013159 11.052 103 10100 9447 1951 1.30 7824 7379 6.974 6.604 0.265 5954 5668 5405 532 4935 4730 4536 4.357 4.999 4023 30007 12166 11274 10477 9763 9122 8.544 8022 7549 7120 6729 6.373 6047 5749 5.475 5222 4900 4775 4570 4.291 4299 40500 12.659 11600 10.828 30059 9372 11756 8201 2202 2250 6840 6.467 6128 588 5534 5273 5033 4812 4608 409 424 400 392 12134 12.005 1115 20.336 9.604 11.950 8365 7839 2.360 6.500 6.550 €108 5877 5504 536 5070 434 4635 4.442 4253 4097 1942 13.500 12:462 11470 10.594 9310 9:129 854 7963 2469 7025 6623 6259 5929 5.628 5353 5101 4870 4657 4,460 4279 40 3.954 14.029 12.021 11764 10.836 100179292 9:545 8075 2562 7102 6.657 6312 5903 5665 5.354 5127 4391 4675 4.476 4252 421 3963 14451 300 12.042 11001 10201 9442 8.772 176 7645 7370 6.743 6.259 60 5.60 5.40 $140 4.500 4600 4400 4300 400 1970 14.057 13.489 12.303 1272 10.371 9500 8.883 8266 7710 7230 6.792 6.309 6044 5223 5.432 5167 4925 4703 4/409 431 407 3076 15.247 1270 12.550 11409 10529 9707 8.905 8348 7784 7283 6835 6444 60 540 5.45 5182 4937 473 4.507 438 4343 3301 15622 14004 1273 11054 30.675 9.823 9077 8422 2841 7330 6.873 6464 6097 5766 5467 5195 494 4721 4514 432 4347 3.905 15983 14.325 13003 11826 108903929 9101 8,488 7895 7372 6.906 6.491 63 27 M330 14643 m 9212 8548 7943 7409 6935 654 6136 20 3663 1499 9307 8.602 7904 741 6941 6534 6152 964 15141 9370 8650 8.022 7470 6933 6551 6366 17292 15302 9427 2004 2055 7496 7003 6.566 6377 9779 0951 8244 7634 7105 6.642 6233 1987 10935 10.027 13406 12137 11051 10116 13.591 12.278 158 10196 13265 12.40 11.250 10274 25.048 1.332 11.825 30357 5783 5.430 5206 4956 4728 4520 4320 451 1568 5798 542 5215 4.964 47344 4.524 4312 4354 3.990 5010 5.502 5223 4570 4738 4528 4335 4557 2.992 5820 5510 5229 4925 4743 453 4337 4199 1994 51129 5512 $235 495 4746 4554 422 450 2905 581 5548 5258 4997 4790 4544 4347 4356 1998 13793 1258 OF FORNASAERAARNA NARAR S 10 16 18 10 20 25 125