Please solve it in excel and show the formulas.

Thanks

The following data is given for 2 projects that Dog Voices is considering. Project A B Initial Investment ($11,000) ($17,000) Duration of Project 6 years 6 years Cash flow per year $4,000 $6,000 Required Rate of Return 15% 15% NPV $4,138 $5,707 IRR 28.16% 26.80% Terminal value $35,014.95 $39,391.82 MIRR 17.77% 17.18% Discounted Payback 3.82 3.96 a) If these projects are mutually exclusive, explain which one would you pick. First you must explain the method you would use. b) Discuss the relative Advantages and disadvantages of all the methods. c) What can you deduce about the reinvestment rate vs. the finance rate from the MIRR? Is the reinvest rate higher or lower than the finance rate? Explain. d) If these projects are independent, explain which one(s) would you pick (you could pick both)