Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cepeda Manufacturing Company is considering three new projects, each requiring an equipment investment of $22,000. Each project will last for 3 years and produce the

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Cepeda Manufacturing Company is considering three new projects, each requiring an equipment investment of $22,000. Each project will last for 3 years and produce the following cash inflows. Year AA BB CC 1 $7.000 $9.500 $11,000 2 9.000 9.500 10.000 3 15.000 9.500 9,000 Total $31.000 $28,500 $30,000 The equipment's salvage value is zero Cepeda uses straight-line depreciation. Cepeda will not accept any project with a payback period over 2 years. Cepeda's minimum required rate of return is 12%. Click here to view PV table (a) Vorancarkas hoonsaved sonernro detalle trottharduodane TABLE 1 Future Value of 1 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 15% 0 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1 1.04000 1.05000 1.06000 1.07000 1.08000 109000 1.10000 1.11000 1. 12000 1.15000 2 1.08160 1.10250 112360 1 14490 1.16640 118810 1.21000 1.23210 1.25440 1 32250 3 1.12486 1.15763 1.19102 1.22504 1.25971 1.29503 1.33100 1 36763 1.40493 1 52088 4 1.16986 1.21551 1.26248 1.31080 1.36049 1.41158 1.46410 1 51807 157352 1.74901 5 1.21665 1.27628 1 33823 140255 1.46933 1.53862 1.61051 1.68506 1.76234 201136 6 1.26532 1.34010 1.41852 1 50073 1.58687 1.67710 1.77156 1.87041 197382 2 31 306 7 1 31593 1.40710 1 50363 1.60578 1.71382 182804 1 94872 207616 2.21068 2.66002 8 1.36857 1.47746 1.59385 171819 1.85093 1 99256 2.14359 2.30454 2.47596 3.05902 9 1.42331 1.55133 1.68948 183846 1.99900 2.17189 235795 2.55803 2.77308 3.51788 10 1.48024 162889 1.79085 1.96715 2.15892 2.36736 2.59374 2.83942 3.10585 40-4556 11 1.53945 171034 L89830 210485 2.33164 2 58043 2.85312 3.15176 3.47855 4.65239 12 1.60103 1 79586 2.01220 2.25219 2.51817 281267 3.138.43 3.49845 3.89598 5.35025 13 1.66507 1.88565 2.13293 2.40985 2.71962 3.06581 3.45227 3.88328 436349 6.15279 1.73168 1.97993 2.26090 2.57853 2.93719 334173 3.79750 131014 4.88711 7.07571 15 1.80094 2.07893 239656 2.75903 3.17217 364248 4.17725 4.78459 5.17357 11706 16 187293 2.15287 2.51035 299216 197031 4.59497 5.310N9 935762 6.11039 17 194790 2.29202 2007 3.1582 370002 5.9509 10.76126 50517 202582 2.85434 210662 18 3.37903 65355 1.71712 5.55992 12.37545 7.68997 302560 31570 3.61653 2 70685 5.11166 14 23177 6901 726334 X 61276 19 219112 20714 5601 16 1654 3696 672750 TABLE 2 Future Value of an Annuity of 1 (n) Payments 4% 5% 6% 7% 8% 9% 10% 1 11% 1.00000 12% 1.00000 15% 1.00000 1.0000 1.00000 1.00000 2 1.00000 204000 100000 2.05000 1.00000 2.06000 1.00000 2.0700 2.08000 209000 2.10000 3 3.12160 2.11000 2.12000 3.15250 215000 3.18360 3.2149 3.246-40 3.27810 3.31000 4 4.24646 3.34210 3.37440 4.31013 437462 3.47250 4 4399 4 50611 4.57313 4.64100 4.70973 5 5.41632 4.77933 5.52563 4.99338 5.63709 5.7507 5.86660 5.98471 6.10510 6.22780 6.35285 6.74238 6 6.63298 6.80191 6.97532 7.1533 7.33592 7.52334 7.71561 7.91286 7 7.89829 8.11519 8.75374 8.14201 8.39384 8.65.10 8.92280 9.20044 9.48717 9.78327 10.08901 8 11.06680 9.21423 9.54911 9.89747 10.2598 10.63663 1102847 11.43589 11.85943 12.29969 9 10.58280 13.72682 11.02656 11.49132 11.9780 12.48756 13.02104 13.57948 14.16397 14.77566 10 16.78584 12.00611 12 57789 13.18079 13.8164 14 48656 15.19293 15.93743 16.72201 17.54874 20.30372 11 13.48635 14.20679 14.97164 15.7836 16.6-4549 17 56029 18.53117 19.56143 20.65458 24.34928 12 15.02581 15 91713 16.86994 17.8885 18 97713 20.14072 21 38428 22.71319 24.13313 2900167 13 16.62684 1771298 18.88214 20.1406 21.49530 22.95339 24.52271 26.21164 28.02911 34 35192 18 29191 19.59863 21.01507 22 5505 24 21492 26.01919 27.97498 30.09492 32 39260 10.50471 15 20.02359 21.57856 23.27597 25.1290 27 15211 29.36092 31.77248 34 40536 37 27972 47.58041 16 21.82453 23 65749 25.67253 27 8881 30.32428 33.00340 35.94973 39.18995 42.75328 55.71747 17 23.69751 25 4037 28 21258 30 8402 33.75023 36.97351 10.54470 44 50084 48 88367 6507509 IX 256454) 28.13223 30.90565 33.9990 3745024 41 30134 15 59917 50.39593 55.74972 75.83636 19 2767123 30 53900 3375999 37.3790 41.4-1626 16.01.16 S115909 56.93949 6143965 XX 21181 29 770 370695 36.559 10.995 15.26196 51 16012 57.27500 64 2023 72.05244 10244358 TABLE 3 Present Value of 1 (n) Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 15% 1 96154 95238 94340 93458 92593 91743 90909 90090 .89286 86957 2 92456 90703 .89000 .87344 .85734 84168 .82645 .81162 79719 75614 3 88900 .86384 83962 .81630 79383 .77218 .75132 73119 71178 .65752 4 85480 .82270 79209 76290 73503 70843 .68301 .65873 63552 57175 5 .82193 78353 -74726 .71299 68058 64993 .62092 59345 56743 49718 6 79031 .74622 70496 66634 63017 59627 56447 53464 50663 43233 7 75992 .71068 66506 .62275 58349 54703 51316 48166 45235 37594 8 73069 .67684 62741 58201 54027 50187 46651 43393 40388 32690 9 70259 64461 59190 54393 50025 46043 42410 39092 36061 28426 10 67556 .61391 55839 50835 46319 42241 38554 35218 32197 24719 11 64958 58468 52679 47509 42888 38753 35049 31728 28748 21494 12 62460 55684 .49697 11101 39711 35554 31863 28584 25668 18691 13 60057 53032 16884 41496 36770 32618 28966 25751 22917 16253 14 57748 S0507 14230 38782 34046 29925 26333 23199 20462 14133 15 55526 18102 41727 36245 31524 27454 23939 20900 18270 12289 16 53391 45811 3936 33873 29189 25187 21763 18829 10687 16312 S1337 13630 17 37136 31657 27027 23107 19785 16963 14564 09293 35034 11552 20586 19367 18 25025 21199 17986 15282 11004 08081 33051 19573 27615 16251 19 17464 20171 19449 13768 11611 07027 180 15639 37689 2542 20 21455 12403 1743 14861 10367 06110 TABLE 4 Present Value of an Annuity of 1 Payments 5% 6% 7% 8% 9% 10% 11% 12% 15% 1 96154 95238 94340 93458 92593 91743 90909 90090 .89286 86957 2 188609 1.85941 1.83339 1.80802 1.78326 1.75911 173554 1.71252 1.69005 1.62571 3 2.77509 2.72325 2.67301 2.62432 2.57710 2.53130 2.48685 2.44371 2.40183 2 28323 3.62990 3.54595 346511 3.38721 3.31213 3.23972 3.16986 3.10245 3.03735 285498 5 4.45182 4.32948 4.21236 4.10020 3.99271 3.88965 3.79079 3.69590 3.60478 3.35216 6 5.24214 5.07569 4 91732 4.76654 4.62288 4.48592 4.35526 4 23054 4.11141 3.78448 7 6.00205 5.78637 5.58238 5.38929 5.20637 5.03295 4.86842 4.71220 456376 4.16042 8 6.73274 6.46321 6.20979 5.97130 5.74664 5.53482 5.33493 5.14612 4.96764 4.48732 9 7.43533 7.10782 6.80169 6.51523 6.24689 5.99525 5.75902 5.53705 5.32825 4.77158 10 8.11090 7.72173 7 36009 7 02358 671005 6.41766 6.14457 5 88923 5.65022 5.01877 11 76048 8.30641 788687 7.49867 713896 6.80519 6.49506 6,20652 593770 5.23371 12 9.38507 3.86325 838384 794269 753608 7.16073 681369 6.492.36 6.19437 5.42062 9.98565 13 9:39357 8.35268 8.35765 7.90378 748690 7.10336 6.74987 6.42355 558315 9.89864 10 56312 9.29498 874517 8.24424 7.78615 698187 7 36669 5.724-48 6.62817 1037966 9.71225 IS 9 10791 11.118.39 55948 0600 7.19087 7600 TONG 5.84737 5137 11256 7 17916 782371 6.97399 5.95424 1081777 16 10 10590 116520 97164 02155 2546 7x79 6,04716 17 1127407 10.57726 12.16.567 8.75561 100000 20141 7.70162 6.12797 12690 #1612 8.9501 71929 6. 1923 9.6360 73657 1 2012 19 13:04 XX 10:01 51156 7691 11401 (a) Your answer has been saved. See score details after the due date Compute each project's payback period. (Round answers to 2 decimal places, e.g. 52.75.) AA BB CC Payback period 24 years 2.32 years 2 11 years Indicate the most desirable project and the least desirable project using this method Most desirable Project CC Lest desirable Project AA V (b) Compute the net present value of each project. (For calculation purposes, use 5 decimal places as displayed in the factor table provided and final answers to 0 decimal places, e.g. 5,275.) AA BB CC Net present value $ $ $ Indicate the most desirable project and the least desirable project using this method. Most desirable Least desirable Save for Later Attempts: 0 of 1 used Submit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance Building Your Future

Authors: Robert B. Walker, Kristy P. Walker

1st edition

9780077861728, 978-0073530659

Students also viewed these Accounting questions