need help solving payback period, discount payback period,NPV,& IRR for project 1,2 &3. 8% is used tor all 3 projects

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: Payback period method B. Discounted payback period method C. Net present value method IRR method A. D. Project 1 Project 2 Project 3 $120,000 $130.000 $150,000 Initial Investment Cost of Capital Target payback period 081 8AX 4 years 10084 4 years 4 years Year 1 Year 2 Year 3 Year 4 Year 5 $30,000 30,000 30,000 35,000 35,000 Cash flows $33.000 33,000 33,000 30,000 30,000 $35,000 35,000 45,000 45.000 45,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