B D E F 1 Project Metrics 2 3 Calculate the NPV, ROI, and Payback for the following project. The discount rate is 5%. 4 Complete all areas in green. 5% 6 Discount rate 7 1 Year 2 3 $85,000 $85,000 0.90 0.85 $85,000 0.95 4 $85,000 0.80 $200,000 0.95 $40,000 0.90 $40,000 0.85 $40,000 0.80 8 9 Benefits 10 Discount factor 11 Discounted benefits 12 Cumulative benefits 13 14 Costs 15 Discount factor 16 Discounted costs 17 Cumulative costs 18 19 Benefits - costs 20 Discounted benefits - costs 21 Discounted cum benefits - costs 22 23 NPV 24 25 ROI 26 27 PB 28