Please provide formulas with answers!

1 2 Created by: 3 4 5 Discount rate 6 7 8 9 Costs 10 Discount factor 11 Discounted costs 12 13 Benefits 14 Discount factor 15 Discounted benefits 16 17 Discounted benefits costs 18 Cumulative Discounted benefits - costs 19 20 ROI 21 PAYBACK 22 23 Assumptions 24 Enter assumptions here 25 26 Financial Analysis for Project Name Date: 10.00% Year 1 2 3 4 Total 200,000 30,000 30,000 30,000 0 100,000 100,000 100,000 27 28 NPV