Table A A B D G F Net Present Value 2 Net Flow Inflow B E Discount Factor 1/(1 + k + p) 1.00 0.87 4 5 6 0.76 0.66 7 8 Year A 2013* 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2022 Outflow $125,000.00 100,000.00 90,000.00 0.00 15,000.00 0.00 15,000.00 0.00 15,000.00 0.00 0.00 $0.00 0.00 0.00 50,000.00 120,000.00 115,000.00 105,000.00 97,000.00 90,000.00 82,000.00 65,000.00 35,000.00 9 10 11 12 13 (B-C) -$125,000.00 -100,000.00 -90,000.00 50,000.00 105,000.00 115,000.00 90,000.00 97,000.00 75,000.00 82,000.00 65,000.00 35,000.00 0.57 0.50 0.43 0.38 0.33 0.28 0.25 0.25 DXE -$125,000.00 -86,957.00 -68,053.00 32,876.00 60,034.00 57,175.00 38,909.00 36,466.00 24,518.00 23,310.00 16,067.00 8,651.00 14 15 16 Total $750,000.00 $360,000.00 $399,000.00 $17,997.00 17 18 19 *1 = 0 at the beginning of 2013 20 21 22 23 24 25 26 27 28 Formulae Cell D4 Cell E4 Cell E5 Cell E6 Cell F4 Cell B17 = (B4-C4) copy to D5:D15 1/(1 + 0.13 + 0.02)^0 1/(1 + 0.13 + 0.0241 1/(1 + 0.13 + 0.02)^(A6-2012) copy to E7:E15 D4*E4 copy to F5:F15 Sum(B4:B15) copy to C17, D17, F17 2 - Using the problem on page 15-17, PsychoCeramic Sciences, Inc. Create the spreadsheet to do the Discounted Cash Flow using the NPV formula. Use separate columns to show: Year, Inflow, OutFlow, Net Flow, Discount Factor and NPV. DO NOT TYPE IN 13 and 0.02 in the equations: instead have the hurdle rate and the inflation rate as variable cells using referencing to the specific cell Give the calculated value of the Net Present Value (NPV)