it's only 1 question

Vw Policies Current Attempt in Progress Doug's Custom Construction Company is considering three non projects.ch requiring an er meinestment of $250 ch project will last for 3 years and produce the following net animal cash flow Year BB 1 MA $8,190 Unresolved 14,040 $32.760 2 $11.700 11.700 11,700 $35.100 $15210 14.010 12870 3 Total 942.120 The equipment's salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period over 2 years. Doug's required rate of return is 12%. Click here to view PV table (a) Compute each project's payback period. (Round answers to 2 decimal places, eg. 15.25.) AA years The equipments valores traight line depreciation. Do wyprowich order years. Det er lidt AI Computer project pack period (Roundermeny o 2 decimal place 15.25) HD Cc Which is the most desirable project The most desirable project based on payback period Which is the most desirable project? The most desirable project based on payback periodis Which is the least desirable project The least desirable project based on payback period is [b] Compute the net present value of each project. (Enter negative amounts using either a negative sin preording the numbers 45 porentheses es (45) Round final answers to the nearest whole doflor, 5.275. For calculation purposes, use Sales In the factor table provided) Compute the ret present value of each project. (Enternetve amounting either active sto preceding the number or parents (45. Round find an ens to the whole dolor. 5.275. Forcalculation purpose 5 decimal place de loyed BE Which as the most desirable project based on net present value? The most desirable project based on nel present value is Which is the least desirable project based on net present value Which is the most desirable project based on net present value? The most desirable project based on net present value is Which is the least desirable project based on net present value? The least desirable project based on net present value is (n) Payments 58 96154 95238 94340 2 1.88609 1.85941 1.8319 3 2.77509 2.72125 2.67301 4 3.62990 3.54595 3.46511 5 4.45182 4.32948 4.21236 6 5.24214 5.07569 4.91732 7 6.00205 5.78637 S.58238 8 6.73274 6.46.21 6.20979 0 7.43533 7.10782 6.80169 10 8.11090 7,72173 7.36009 11 8.76048 8.30641 7.88687 12 938507 8.86325 8.38384 13 098565 9.39357 8.85268 14 10.56312 9.89864 9.29498 15 11.11839 10.37966 0.71225 16 11.65230 10.83777 10.10590 17 12.16567 11.27407 10.47726 18 12.65930 11.68959 10.82760 19 13.13394 12.08532 11.15812 20 13.59033 12.46221 11.46992 93458 92593 1.80802 1.78326 2.62432 2.57710 3.38721 3.31213 4.10020 3.00271 4.76654 4.62288 5. 1929 5.20637 5.97130 5.74664 6.51523 6.24689 702158 671008 7,49867 7.13896 7.94260 7.53608 8.35765 7.90378 8.74547 8.24424 9.10791 8.55948 9.44665 8.85137 9.76322 9,12164 10.05900 9.37189 10.33560 9.60360 10.50401 9.818IS 10 115 I 01741 90909 90090 0286 957 1.75011 1.73554 1.71252 1000 1.62571 2.53130 24S 2 44371 2.4011322323 3.2.1972 3.1696 3.10345 303735 2NSON 3.88965 3.70070 3.69590 3.0047335216 4.48592 415526 421054 4.1111 3.744 5.03205 4.86842 4.71220 4.56376 416042 5.53482 5.33493 5.14612496764448732 5.09525 5.75002 5.53705 532825 4.77138 6.41766614457 5.23023 565022 S 01877 680519 6.49506 6.206525.01770 523171 7.16073 6.81369 6.49236 6.19417 542062 7.48690 7.10116 674087 6.42155 S55315 7.786157.36669 6.98187 662817 5.72 8.06000 7.60608 7.19087 6.810565.84737 8.31256 7.82.171 7.37016697399 5.95424 8.54363 802155 7.54870 7.11963,04716 8.75563 8 20141 7.70162 7 24967 6.12797 8.95012 816492 7.83929 716576 6.19823 0.12855 8,51356 7.96333 746914 6.2593)