Project Finance Tool

Project ROI business-case calculator

Core logic: ROI = net benefit / investment

Simple ROI 0.0%

Total net benefit across the horizon divided by upfront investment.

Payback 0 months

Estimated months until cumulative undiscounted cash flow turns positive.

NPV $0

Discounted net cash flow using the selected discount rate.

IRR N/A

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.

Total upfront investment $0
Year 1 gross benefit $0
Year 1 net benefit $0
Benefit-cost ratio 0.00

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.

Tool architecture

Module 1

Project setup

Project name, sponsor, problem statement, baseline period, implementation timing, and decision gate.

Module 2

Investment model

Capital, engineering, labor, training, outside services, startup loss, and recurring operating costs.

Module 3

Benefit model

Labor savings, scrap/rework reduction, downtime reduction, throughput gain, inventory reduction, and avoided cost.

Module 4

Financial results

Simple ROI, payback, NPV, IRR, benefit-cost ratio, annual cash flow, and cumulative cash flow.

Module 5

Scenario and sensitivity

Conservative, expected, and aggressive cases with active key-driver sensitivity checks.

Module 6

Stakeholder report

Copy-ready business-case summary with assumptions, risk notes, recommendation, and review guidance.

Related tools

Project ROI planning notes

Why build a broader ROI calculator when the site already has a Kaizen ROI tool?

The Kaizen tool is useful for improvement-event results. This page is being structured for larger project approval decisions that require investment timing, recurring costs, discounted cash flow, scenarios, and stakeholder reporting.

What should be separated in the final calculator?

Hard savings, soft savings, risk avoidance, and revenue upside should be kept distinct. Combining them into one number without labels weakens decision quality.

What should be reviewed before using the result for approval?

Validate the investment estimate, hard-savings evidence, recurring support cost, discount rate, and whether risk avoidance should be counted as financial value or shown as a separate decision factor.