| Financial Analysis for Project Name |
| Created by: | | Date: |
| Note: Change the inputs, shown in green below (i.e. interest rate, number of years, costs, and benefits). Be sure to double-check the formulas based on the inputs. |
| Discount rate | 8.00% |
| Assume the project is completed in Year 0 | | | Year |
| | 0 | 1 | 2 | 3 | Total |
| Costs | 140,000 | 40,000 | 40,000 | 40,000 |
| Discount factor | 1.00 | 0.93 | 0.86 | 0.79 |
| Discounted costs | 140,000 | 37,200 | 34,400 | 31,600 | 243,200 |
| Benefits | 0 | 200,000 | 200,000 | 200,000 |
| Discount factor | 1.00 | 0.93 | 0.86 | 0.79 |
| Discounted benefits | 0 | 186,000 | 172,000 | 158,000 | 516,000 |
| Discounted benefits - costs | (140,000) | 148,800 | 137,600 | 126,400 | 272,800 | NPV |
| Cumulative benefits - costs | (140,000) | 8,800 | 146,400 | 272,800 |
| ROI | 112% |
| | Payback in Year 1 |
| Assumptions |
| Enter assumptions here |
joshna
business_case_financials.xlsx
