Please show your work/ formulas

B D E 3 6 Project Project Life I(0) CF(1) CF(annual growth) WACC Reinvestment Rate A 3 800 400 4.0% 7.0% 5.0% 4 1100 400 3.5% 6.5% 5.0% 1600 400 3.0% 6.0% 5.0% 8 1900 400 1.0% 5.5% 5.0% 10 2700 450 0.0% 5.0% 5.0% 1. Calculate the NPV, EAA, IRR, MIRR, and Payback Period for each project, A-E a. Please show your work (answers w/o Excel work will not be counted) b. Do NOT use the Replacement Chain Method to calculate NPV B D E 3 6 Project Project Life I(0) CF(1) CF(annual growth) WACC Reinvestment Rate A 3 800 400 4.0% 7.0% 5.0% 4 1100 400 3.5% 6.5% 5.0% 1600 400 3.0% 6.0% 5.0% 8 1900 400 1.0% 5.5% 5.0% 10 2700 450 0.0% 5.0% 5.0% 1. Calculate the NPV, EAA, IRR, MIRR, and Payback Period for each project, A-E a. Please show your work (answers w/o Excel work will not be counted) b. Do NOT use the Replacement Chain Method to calculate NPV