Please answer this using excel. Thank you

Capital Budgeting Exercises: on for capital budgeting purposes. Their ash flows are provided below. Use the te all three projects and indicate which Three independent projects are under consideration respective initial investment, cost of following capital budgeting techniques to evaluate all three pro och should be undertaken, assuming there is no budget constraint: A. Payback period method Discounted payback period method Net present value method TRR method C. Project 1 Project 2 Project 3 $125,000 $200,000 $160,000 Initial Investment Cost of Capital Target payback period 8% 4 years 10% 4 years 12% 4 years Year 1 Year 2 Ycar 3 Year 4 Year 5 $30,000 30,000 30,000 30.000 40,000 Cash flows $45,000 45,000 60,000 60,000 60,000 $35,000 40,000 45,000 50,000 60,000 Capital Budgeting Spreadsheet Example ASSIGNMENT # NAME: LAB TIME: Answer Sheet for Capital Budgeting Exercises From Previous Page Project 1 Project 2 Project 3 Which project(s) should be accepted? Payback period Discounted payback period NPV IRR