Please show excel formula for each calculation

You are considering two crowd-funding opportunities. Both are for prospective new personal computer manufacturers, Banana and Pear. Each requires that you to pay an initial cost of $75,000, and your projected cash flows are listed below. Year 0 1 2 3 4 5 $ $ $ $ $ $ Banana (75,000.00 $ 33,183.42 $ 20,000.00 $ 25,184.56 $ 15,000.00 $ 25,000.00 $ Pear (75,000.00 43,000.00 29,500.00 5,000.00 30,000.00 7,800.00 A. Assuming the weighted average cost of capital (WACC) is 10.5%, calculate the payback period, discounted payback period, NPV, and IRR. If the projects are mutually exclusive, which should be selected using the NPV criterion? WACC 10.5% Banana Pear Payback Period Discounted Payback Period NPV IRR Best Project? Hint: Use a formula here