please show cell reference number in formula to arrive at each answer

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? $ 15,311.79 $ 16,636.51 18.94% 21.40% Hint: Use a formula here! Pear