please use excel to answer this question, please provide excel equations/functions.

thank you

Capital Budgeting Exercises: Three independent projects are under consideration for capital budgeting purposes. Their respective initial investment, cost of capital, and cash flows are provided below. Use the following capital budgeting techniques to evaluate all three projects and indicate which project should be undertaken, assuming there is no budget constraint: A. Payback period method B. Discounted payback period method C. Net present value method D IRR method