Project Charter ROI Calculator
Work out net present value, return on investment, payback period, benefit cost ratio and internal rate of return for your Six Sigma project from raw operational data.
What this calculator does
Most project charters state a benefit figure with no working behind it. Approval committees reject those charters. This calculator builds the number from the ground up, using operational inputs you can defend: team hours, defect volumes, cost per defect, hours saved and overtime removed.
💡 Why raw inputs matter
You do not enter an annual benefit. You enter the volume, the current defect rate, the target defect rate and the cost per defect. The calculator derives the benefit. Every dollar in the result traces back to an assumption a finance business partner can challenge and verify.
The five metrics you get
Net present value
The value of all future cash flows in today's dollars, less the upfront investment. A positive figure means the project creates value after the cost of capital.
- Above zero: the project adds value
- Below zero: the money earns more elsewhere
Return on investment
Total net benefit over the project life divided by total investment. Simple to communicate. It ignores the timing of cash flows, so read it alongside net present value.
- Above 100 percent: you more than double the investment
- Below zero: benefits never cover the cost
Payback period
How long until cumulative benefits cover the investment. Most steering committees want under 18 months for process improvement work.
- Under 1 year: strong
- 1 to 2 years: acceptable
- Over 3 years: hard to defend
Benefit cost ratio
Present value of benefits divided by present value of costs. A ratio of 3.0 means every dollar invested returns three dollars in discounted benefit.
- Below 1.0: costs exceed benefits
- Above 2.0: excellent return
Internal rate of return
The discount rate at which net present value equals zero. Compare it against your organisation's hurdle rate. A rate well above the hurdle means the project survives a rise in the cost of capital.
How to use it
- Open the Calculator tab and load a sample dataset to see the structure.
- Replace the sample values with your own project data. Work through the four sections in order.
- Enter investment inputs first. Team labour usually dominates the cost, so get the hours and the loaded rate right.
- Enter benefit inputs. Only claim benefits you can measure after the project closes.
- Set the financial parameters. Use the discount rate your finance team applies to capital projects.
- Select Calculate ROI. The Results tab opens with the full analysis and a sensitivity table.
- Download the Excel report and attach it to your project charter.
Input definitions
| Input | What to enter | Where to find it |
|---|---|---|
| Loaded hourly rate | Salary plus on costs, divided by annual working hours | Finance or human resources |
| Cost per defect | Rework labour, scrap material, warranty, freight and admin time for one defect | Cost of poor quality records |
| Target defect rate | The rate you commit to hold, not the best day you ever recorded | Benchmark data or pilot results |
| Benefit realisation delay | Months between project start and the first full month of savings | Project timeline |
| Annual sustaining cost | Audits, software licences, extra inspection, control plan upkeep | Control plan and process owner |
✨ Pro tips
- Split hard savings from soft savings. Only hard savings hit the profit and loss statement. Enter cost avoidance and capacity gains under other annual savings and label them clearly in your charter.
- Discount your defect rate improvement by 20 percent before you enter it. Committed benefits should be conservative. Beating a conservative target is a better career outcome than missing an optimistic one.
- Check the break even benefit line in the results. If your project only works at 95 percent of the projected benefit, the business case is fragile.
- Read the sensitivity table before the meeting. Somebody will ask what happens if the benefit lands 30 percent short. Have the number ready.
- Agree the measurement method with finance before you start. A benefit nobody can verify is a benefit nobody will credit.
⚠️ Common mistakes
- Counting the same saving twice, for example claiming both labour hours saved and overtime removed for the same activity.
- Using an unloaded hourly rate for cost and a loaded rate for benefit.
- Assuming benefits start on day one. Set a realistic realisation delay.
- Ignoring the sustaining cost of the control plan.
- Claiming headcount savings without an agreed redeployment or reduction plan.
Enter the resources consumed to deliver the project. Labour is calculated from headcount, hours and duration.
The calculator works out the annual saving from your volume, defect rates and cost per defect.
Capture labour recovered, overtime removed and any remaining measurable savings.
Use the values your finance team applies to capital and improvement projects.
📈 No results yet
Enter your project data in the Calculator tab, then select Calculate ROI. Your full financial analysis appears here.
Six Sigma project ROI calculation explained
A project charter without a financial case rarely gets funded. This free project charter ROI calculator turns your operational data into the five numbers a steering committee asks for: net present value, return on investment, payback period, benefit cost ratio and internal rate of return. It suits DMAIC projects, Kaizen events, lean improvement work and any process improvement business case that needs finance approval.
Who uses this calculator
- Green Belts and Black Belts writing a DMAIC project charter
- Continuous improvement managers prioritising a portfolio of projects
- Quality managers converting cost of poor quality into an annual saving
- Operations leaders preparing a capital request for process improvement
- Consultants building a client business case for lean transformation
How the calculator works out your annual saving
Most ROI tools ask for an annual benefit figure. That figure is the part nobody can verify. This calculator derives it instead. Enter your annual volume, your current defect rate, your committed target defect rate and your cost per defect. The calculator multiplies out the defects removed and values them. It does the same for labour hours recovered and overtime eliminated. Every dollar in the answer traces back to an input your finance business partner can audit.
Metrics this tool calculates
| Metric | Formula applied | Approval threshold |
|---|---|---|
| Net present value | Sum of discounted cash flows less the investment | Above zero |
| Return on investment | Total net benefit less investment, divided by investment | Above 100 percent is common |
| Payback period | Time until cumulative benefit covers the investment | Under 18 months |
| Benefit cost ratio | Present value of benefits divided by present value of costs | Above 1.5 |
| Internal rate of return | Discount rate at which net present value equals zero | Above the hurdle rate |
Frequently asked questions
Subtract the total project investment from the total net benefit over the benefit horizon, divide the result by the investment, then multiply by 100. The investment covers team labour, training, equipment, consulting and trial disruption. The benefit covers defect reduction, labour hours recovered, overtime removed and other measurable savings, less the annual cost of sustaining the control plan. This calculator performs the full calculation from your raw inputs.
Most organisations expect a benefit cost ratio between 3 and 5 for a Black Belt project, and a payback period under 18 months. A benefit cost ratio below 1.5 leaves no margin for a benefit shortfall. Check the break even line in the results. If your project only works at more than 90 percent of the projected benefit, the case is fragile and needs a stronger cost estimate or a pilot to validate the assumptions.
Hard savings reduce a line item on the profit and loss statement. Scrap material removed, overtime eliminated and a cancelled contract are hard savings. Soft savings improve capacity or avoid a future cost without reducing current spend. Labour hours recovered are soft savings unless the process owner agrees a redeployment or headcount plan. Enter soft savings under other annual savings and label them separately in your charter so finance can treat them correctly.
Add the rework labour, scrap material, inspection time, expedited freight, warranty exposure and administration cost caused by one defect. Divide by the number of defects if you only hold a total figure. Your cost of poor quality records usually contain the components. Validate the number with finance before you build the charter around it, because defect reduction often supplies most of the projected benefit.
Use the rate your finance team applies to capital projects, normally the weighted average cost of capital. Rates between 8 and 12 percent are typical for established organisations. Higher risk businesses use 15 percent or more. If you do not know the rate, use 10 percent and state the assumption in the charter so the reviewer can adjust it.
Three years is the standard for process improvement projects. Some organisations only credit 12 months of benefit. Longer horizons of five years suit projects with a capital component such as new equipment or a system replacement. A long horizon inflates the return, so match it to the period the improvement realistically holds.
The simple payback period adds raw cash flows until they cover the investment. The discounted payback reduces each future cash flow by the discount rate first, so it always takes longer. Committees that care about the cost of capital ask for the discounted figure. Report both.
Yes. The calculator runs in your browser with no sign up and no data upload. Your inputs never leave the page. The Excel report generates locally and downloads straight to your device.
Related Lean Six Sigma calculators
🎓 Take it further
Lean 6 Sigma Hub runs Yellow Belt, Green Belt and Black Belt training that covers project selection, benefit validation and charter approval. Visit lean6sigmahub.com to see the current courses.
