HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 - % Alignment Number Conditional Format as...

Transcribed Image Text:

HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 - % Alignment Number Conditional Format as Formatting Table Styles Cell Cells Editing Styles 4 Skipped FILE Paste Clipboard 111 Calibri BIU 4 Font fx A B D E F G H 5 6 A B 7 Year 0 $ (43,500) $ (43,500) 8 Year 1 $ 21,400 $ 6,400 9 Year 2 $ 18,500 $ 14,700 10 Year 3 $ 13,800 $ 22,800 11 Year 4 $ 7,600 $ 25,200 12 13 Required return 11% 14 15 16 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. 17 18 Cash flow A IRR 19 Cash flow B IRR 20 21 Cash flow A NPV 22 Cash flow B NPV 23 24 Difference in cash flows 25 Year 0 26 Year 1 27 Year 2 28 29 Year 3 Year 4 30 31 Crossover rate 32 33 Checkl K L Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 - % Alignment Number Conditional Format as Formatting Table Styles Cell Cells Editing Styles 4 Skipped FILE Paste Clipboard 111 Calibri BIU 4 Font fx A B D E F G H 5 6 A B 7 Year 0 $ (43,500) $ (43,500) 8 Year 1 $ 21,400 $ 6,400 9 Year 2 $ 18,500 $ 14,700 10 Year 3 $ 13,800 $ 22,800 11 Year 4 $ 7,600 $ 25,200 12 13 Required return 11% 14 15 16 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. 17 18 Cash flow A IRR 19 Cash flow B IRR 20 21 Cash flow A NPV 22 Cash flow B NPV 23 24 Difference in cash flows 25 Year 0 26 Year 1 27 Year 2 28 29 Year 3 Year 4 30 31 Crossover rate 32 33 Checkl K L Sign In