Posted part "a" in another question

Will thumbs up for correct answers, Thank you!

Doug's Custom Construction 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 net annual cash flows. Year S7,000 9,000 12,000 $28,000 $10,000 10,000 10,000 S30,000 S13,000 12,000 11,000 S36,000 Total 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%. Instructions (a) Compute each project's payback period, indicating the most desirable project and the least desirable project using this method. (Round to two decimals and assume in your computations that cash flows occur evenly throughout the year.) (b) Compute the net present value of each project. Does your evaluation change? (Round to nearest dollar.) NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "7