I would greatly appreciate it if excel formulas were included! Thank you in advance Part C & D

P27.1 (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. 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 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? (c) and (d)