Project Finance Tool
Project ROI business-case calculator
Core logic: ROI = net benefit / investment
Total net benefit across the horizon divided by upfront investment.
Estimated months until cumulative undiscounted cash flow turns positive.
Discounted net cash flow using the selected discount rate.
Estimated internal rate of return for the project cash-flow stream.
Project setup and investment
Annual benefit model
Financial assumptions
Scenario assumptions
Use scenarios to keep the business case honest. Hard savings should be treated differently from throughput, risk avoidance, and other upside because they usually carry different confidence levels.
| Scenario | Investment change | Hard savings realization | Throughput / upside realization | Risk / other realization | Recurring-cost change |
|---|---|---|---|---|---|
| Conservative | |||||
| Expected | |||||
| Aggressive |
Recommendation pending
Enter project assumptions to calculate the business case.
Annual cash-flow view
| Year | Gross benefit | Recurring cost | Net cash flow | Discounted net | Cumulative cash flow |
|---|
Scenario comparison
| Scenario | Year 1 gross benefit | Year 1 net benefit | ROI | Payback | NPV | IRR | B:C ratio |
|---|
Sensitivity analysis
Sensitivity shows which assumptions create the largest movement from the expected case. Adjust the swing percentage to test how stable the business case is when the estimate changes.
| Rank | Assumption tested | NPV range | ROI range | Payback range | Primary impact |
|---|
Stakeholder business-case report
Use this generated summary as a starting point for leadership review, project charter approval, or finance discussion. It keeps the recommendation, assumptions, expected-case results, scenario spread, and key sensitivity risks in one place.