Please use excel to solve this problem, and please state the formulas clearly so I can learn and submit as well. Thank you.

7. The payback period Aa Aa The payback method helps firms establish and identify a maximum acceptable payback period that helps in their capital budgeting decisions Consider the case of Blue Hamster Manufacturing Inc. Blue Hamster Manufacturing Inc. is a small firm, and several of its managers are worried about how soon the firm will be able to recover its initial investment from Project Delta's expected future cash flows. To answer this question, Blue Hamster's CFO has asked that you compute the project's payback period using the following expected net cash flows and assuming that the cash flows are received evenly throughout each year Complete the following table and compute the project's conventional payback period. For full credit, complete the entire table Year O Year 1 Year 2 Year 3 Expected cash flow Cumulative cash flow -4,500,000 $1,800,000 $3,825,000 $1,575,000 Conventional payback period: The conventional payback period ignores the time value of money, and this concerns Blue Hamster's CFO. He has now asked you to compute Delta's discounted payback period, assuming the company has a 7% cost of capital Complete the following table and perform any necessary calculations. Round the discounted cash flow values to the nearest whole dollar, and the discounted payback period to the nearest two decimal places. For full credit, complete the entire table Year O Year 1 Year 2 Year 3 Cash floww Discounted cash flow Cumulative discounted cash flow -4,500,000 $1,800,000 $3,825,000 $1,575,000