Please show work so I can learn what I am doing wrong and could you use excel if possible. Thank you!

Complete the following table and compute the project's conventional payback period. For full credit, complete the entire table. (Note: Round the conventional payback period to two decimal places. If your answer is negative, be sure to use a minus sign in your answer.) Beta's discounted payback period, assuming the company has a 7% cost of capital. Complete the forming and a necessary credit, complete the entire table. (Note: If your answer is negative, be sure to use a minus sign in your answer.) Which version of a project's payback period should the CFO use when evaluating Project Beta, given its theoretical superiority? The discounted payback period The regular payback period One theoretical disadvantage of both payback methods-compared to the net present value method-is that they fail to consider the value of the cash flows beyond the point in time equal to the payback period. How much value in this example does the discounted payback period method fail to recognize due to this theoretical deficiency? $2,638,144$4,112,509$1,142,817$1,607,836