? pl 5 X 1 Calculating NPV, IRR, and the crossover rate - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign In X Calibri 11 % Paste BIU- Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 fac A B D E F H 1 7 00 Year 0 Year 1 Year 2 Year 3 $ $ $ $ (24,000) 10,620 10,900 10,500 $ $ $ $ (24,000) 12,100 9,360 10,400 9 10 11 12 13 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. 14 15 IRR (X) IRR (Y) 16 17 Difference in cash flows 9 9 SS Year 0 Year 1 Year 2 Year 3 23 24 Crossover rate 25 26 NPV (X) NPV (Y) 27 Required return 0% 5% Sheet1 28 +