Please show all your work and identify formulas used.

P12.1A (LO 1, 2,5), AN U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Compute annual rate of return, cash payback, and net present value C Excel Project Bono $160,000 Project Edge $175,000 Project Clayton $200,000 Capital investment Annual net income: Year 1 14,000 14,000 14,000 14,000 14,000 $ 70,000 18,000 17,000 16,000 12,000 9,000 $ 72,000 27,000 23,000 21,000 13,000 12,000 $ 96,000 Total Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.) Instructions a. Compute the cash payback period for each project. (Round to two decimals.) b. Compute the net present value for each project. (Round to nearest dollar.) E $(7,312); C $2,163 c. Compute the annual rate of return for each project. (Round to two decimals.) (Hint: Use average annual net income in your computation.) d. Rank the projects on each of the foregoing bases. Which project do you recommend