C D E F G 1 How to Use the NPV and IRR Functions in Excel Student Instructions: 1. Watch the accompanying Excel Function Video below. (Link to Video 3 button) 2. Enter the correct formula in the formula bar above to solve the corresponding Multiple Choice questions. Use the NPV and IRR functions in cells B15 and B16, respectively to assess the capital budgeting investment. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 8 Initial cost (37,200) 2,400 9 Salvage value 10 Annual cash flows 8,400 8,400 8400 8,400 8,400 (37.200) 8,400 8,400 8.400 S 8,400 S 10,800 11 12 13 Required rate of return 6.55% 14 15 NPV 16 IRR 17