do this on excel and show formulas please

X M N O L K F G H E D Pandora Lands is considering two mutually exclusive projects, Project X and Project Y. Both projects are repeatable. Both require an initial investment of $10,000 at t=0. Project X has an expected life of 3 years with after-tax cash inflows of $5,000 at the end of Years 1, 2, and 3 respectively. Project Y has an expected life of 5 years with after-tax cash inflows of $4,000 at the end of each of the next 5 years. Each project has a WACC of 11%. Using EAA analysis determine which project Pandora should choose (cell Which project will Wilson choose? ly 16) Project X Cost of Capital 11% 3 0 1 Year Cash flow 2. 5000 NPV EAA $5,000.00 #NAME? -10000 5000 5000 Project Y 4 EAA 5 NPV 1 Year Cash flow 0 -10000 2 4000 4000 4000 4000 4000