Present Value - NCFX DE 1 2 Year (n) Cash Inflow () Cash Outflow (E) Net Cash Flow (NCF) Discount factor (DF) 3 0 0 11500 4 1 8000 2500 5 2 8000 1300 6 3 9000 1800 7 4 6500 3100 5 5500 3600 9 6 7000 3500 10 7 7500 3000 11 8 7000 2500 12 9 7750 2000 13 10 8000 3000 14 11 8500 3500 15 12 9000 3000 16 Total 17 19 NPV = 20 21 22 Open the NPV Worksheet in the Test 3 Data fie in Excel Suppose we have the cash flow given in the NPV worksheet with an associated project and that the discount rate is 8.5% Find the Discount Factor for Year 10 Gve your answer to 6 decimal places A Open the Present Value Worsheet in the Test Suppose we are the cash flow gent work with an associated project and that the contrate is 8.8% Find the present Value for Year 2 Give your ato 2 decimal places Open the Net Present Value Worksheet in the Test 3 Data fe in Excel. Suppose we have the cash flow given in the NPV worksheet with an associated project and that the discount rate is 8.5% Find the Present Value for Year 2 Give your answer to 2 decimal places Arswer Open the Net Present Value Worksheet the Test wall have the cash flow given in the NPV Worksheet with an associate project and that the discount rate 85 Find the Net Present Value Give your worto ecimal places A