please provide me excel formulas please

help me

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 Capital Budgeting Spreadsheet Example ASSIGNMENT \# NAME: LAB TIME: Answer Sheet for Capital Budgeting Exercises From Previous Page