A cost-benefit analysis can make a decision look beautifully precise. That is both its strength and its danger.
When the assumptions are transparent, it helps a team compare options, notice hidden costs, test whether benefits justify an investment, and explain a recommendation. When uncertain numbers are presented as facts, the same analysis can create false confidence. This free cost-benefit analysis template for Microsoft Word provides a structured place to document the decision, alternatives, assumptions, costs, benefits, timing, risks, and conclusion.
Use it for a new system, equipment purchase, hiring decision, process improvement, program, policy, marketing initiative, expansion, training project, or other investment. For significant financial, public, legal, tax, safety, or regulatory decisions, involve appropriately qualified professionals and use the methods required by your organization or jurisdiction.
Frame the Decision Before Collecting Numbers
Begin with a decision question that can actually be answered. “Is automation good?” is too broad. A better question is:
Over a five-year period, should the service team keep the current manual intake process, buy System A, or develop a limited internal solution?
Record the objective, sponsor, decision date, evaluation period, affected groups, constraints, and alternatives. Always include the realistic “do nothing” or “continue current approach” baseline when appropriate. Without a baseline, benefits can be overstated because normal improvement or unavoidable costs may be credited to the proposal.
Set the Boundary
Define what the analysis includes and excludes. Are you examining one department or the whole organization? Direct cash flow only, or also staff time and customer impact? Implementation alone, or the full operating life?
A clear boundary prevents selective counting. If savings are measured across the business but costs are counted only for one team, the comparison is distorted.
List the Alternatives Fairly
Do not build a detailed case for a preferred option and compare it with a weak caricature of the alternatives. Apply a consistent level of evidence, time horizon, and valuation method.
Possible alternatives might include:
- Continue the current process
- Improve the current process without replacing it
- Purchase a commercial product
- Build internally
- Outsource the service
- Run a limited pilot before full commitment
- Delay the decision pending necessary information
Some options may be eliminated for legitimate reasons such as compliance, capacity, or technical feasibility. Document the reason rather than silently removing them.
Identify the Full Cost Lifecycle
The purchase price is rarely the whole cost. Consider costs before, during, and after implementation.
Upfront Costs
- Equipment, software, licenses, property, or materials
- Design, configuration, development, and integration
- Professional services and legal review
- Procurement and contracting effort
- Recruitment, onboarding, and training
- Data migration, testing, and launch support
- Permits, inspections, and initial compliance work
Recurring Costs
- Subscriptions, hosting, maintenance, and support
- Staff time and administration
- Utilities, insurance, storage, and facilities
- Monitoring, audits, security, and compliance
- Consumables, replacements, and ongoing training
Transition and Indirect Costs
- Temporary productivity loss
- Parallel operation of old and new systems
- Change management and communications
- Customer or employee disruption
- Opportunity cost of people and capital
- Contingency for credible uncertainty
End-of-Life Costs
- Contract termination
- Data export and migration
- Decommissioning and disposal
- Environmental handling
- Restoration, retention, or archival obligations
A number belongs in the analysis only once. Watch for double counting, especially when labor is included both as a direct project cost and inside a vendor estimate.
Identify Benefits in the Same Disciplined Way
Benefits may be financial or nonfinancial, direct or indirect. Typical categories include:
- Additional revenue or service capacity
- Reduced labor or contractor expense
- Lower error, rework, waste, or downtime
- Avoided penalties, losses, or replacement costs
- Faster delivery or shorter customer wait times
- Improved safety, compliance, accessibility, or reliability
- Better employee or customer experience
- Improved data, reporting, or decision speed
- Environmental or community outcomes
Not every important benefit can be converted responsibly into money. Describe non-monetized effects separately and show how they influence the recommendation. Do not assign a convenient dollar amount merely to force every value into one calculation.
Financial Benefits Versus Capacity Benefits
Saving time does not automatically save cash. If a tool saves each employee two hours per week but staffing and output remain unchanged, the organization has gained capacity, not necessarily reduced expenditure.
That capacity may still be valuable. It could support more cases, better quality, quicker response, training, or reduced overtime. State the expected use. Avoid claiming a labor saving as both a cost reduction and increased output unless the model supports both without double counting.
Use Evidence and Label Assumptions
For every major input, record the source and confidence level. Sources may include invoices, payroll data, time studies, historical performance, vendor quotes, benchmark research, pilot results, or expert estimates.
Separate:
- Known values: supported by current records or binding terms
- Estimates: based on evidence but not certain
- Assumptions: conditions used to construct the model
- Excluded values: relevant items that cannot be measured reliably
Add an owner and date to key assumptions. Costs and market conditions change; an estimate without a date quickly loses context.
Make All Values Comparable
Use a consistent currency, price basis, and time period. State whether amounts include tax, inflation, financing, overhead, and contingency.
When costs and benefits occur over several years, future amounts may need to be converted to present value using an approved discount rate. In simplified form:
Present value = Future value ÷ (1 + discount rate)number of periods
The appropriate rate and method depend on the organization, decision, market, and sometimes regulation. Do not select a rate simply because it produces a desirable result.
Core Measures and What They Mean
Net Benefit
Net benefit = Total benefits − Total costs
A positive result suggests benefits exceed costs under the stated assumptions. It does not prove that the project is affordable, ethical, compliant, strategically appropriate, or less risky than alternatives.
Benefit-Cost Ratio
Benefit-cost ratio = Total benefits ÷ Total costs
A result above 1 means measured benefits exceed measured costs. Ratios can be misleading when projects differ greatly in size or when important effects are not monetized.
Return on Investment
ROI = (Net benefit ÷ Total costs) × 100
State exactly which costs, benefits, and period are included. “ROI” can mean different things in different organizations.
Payback Period
The payback period estimates how long cumulative benefits take to recover the initial investment. It is easy to understand but may ignore benefits and costs after payback and may not account for the time value of money.
Net Present Value
NPV totals discounted benefits and costs across the chosen time horizon. It is useful for multi-year comparisons but depends heavily on forecasts, timing, and the discount rate.
A Worked Illustration
Suppose a team is considering a document-processing system.
- Implementation: $45,000
- Training and migration: $10,000
- Annual subscription: $12,000
- Evaluation period: three years
- Estimated annual labor capacity value: $28,000
- Estimated annual reduction in rework: $7,000
Ignoring discounting for this simple illustration, total cost would be $91,000: $55,000 upfront plus $36,000 in subscriptions. Measured benefits would total $105,000. Net benefit would be $14,000, and the benefit-cost ratio would be approximately 1.15.
That result is not the end of the decision. The team should ask whether capacity becomes real savings or useful output, whether migration costs are complete, whether benefits ramp up gradually, how reliable the estimates are, and what happens if subscription prices rise.
Test Uncertainty With Scenarios
A single forecast hides uncertainty. Create at least three cases when material assumptions vary:
- Base case: the most supportable expected assumptions
- Downside case: higher costs, slower adoption, or lower benefits
- Upside case: favorable but credible results
Then perform sensitivity analysis. Change one important variable at a time—adoption, labor value, sales volume, implementation delay, exchange rate, useful life, or discount rate—to see what drives the result.
Calculate the break-even point when useful. How many units must be sold? How many hours must be saved and redeployed? How much can implementation cost increase before net benefit becomes negative?
Account for Risk Without Hiding It in One Percentage
Contingency can help, but a blanket percentage is not a substitute for understanding risks. Identify material uncertainties, their effect, available controls, and responsibility.
Examples include vendor failure, schedule delay, data quality, adoption, regulation, integration, inflation, cybersecurity, safety, demand, and maintenance. Some risks can be modeled as scenarios; others require qualitative judgment or specialist assessment.
Distribution Matters
An option may produce an overall net benefit while imposing costs on one group and benefits on another. Identify who pays, who benefits, who carries risk, and when effects occur.
This is especially important for public policy, workforce changes, healthcare, accessibility, community projects, and environmental decisions. A positive total does not automatically make the distribution fair or acceptable.
Write the Recommendation as a Decision Record
Summarize:
- The decision and alternatives
- Evaluation boundary and period
- Major costs and benefits
- Core financial measures
- Non-monetized effects
- Critical assumptions and evidence
- Sensitivity and downside findings
- Risks and constraints
- Recommended option and conditions
- Approvals and next review date
A recommendation can be conditional: proceed with a pilot, negotiate a price ceiling, require security review, validate demand, or stop if a threshold is exceeded.
Common Cost-Benefit Analysis Errors
- Leaving out the current-state baseline
- Counting sunk costs that do not change between options
- Ignoring opportunity cost
- Claiming time savings as immediate cash savings
- Using inconsistent time horizons
- Mixing values with and without tax or inflation
- Double counting connected benefits
- Using unsupported precision
- Ignoring ramp-up time and implementation disruption
- Reporting only the favorable scenario
- Hiding nonfinancial harm because it is difficult to monetize
Customize the Word Template
Save an untouched original, then tailor the working copy to the decision. Add a cover summary, alternative table, assumptions log, cost schedule, benefit schedule, calculation notes, sensitivity table, risk section, and approval record. Link or cite supporting evidence so another reviewer can reproduce the reasoning.
This template helps organize analysis but does not replace a verified financial model. Check formulas independently and obtain financial, tax, accounting, legal, technical, or regulatory review where the stakes require it.
Download Your Cost-Benefit Analysis Template
Preview the document below, then download the editable Word file. Replace every example with evidence relevant to your decision and state uncertainty plainly.
Cost-Benefit Analysis FAQs
What is a cost-benefit analysis?
It is a structured comparison of an option’s expected costs and benefits over a defined period, using financial measures and relevant nonfinancial considerations.
Should the current process be included?
Usually yes. A realistic baseline shows what happens without the proposed investment and prevents normal or unavoidable effects from being misattributed.
Are time savings financial benefits?
Not automatically. They create capacity; cash savings occur only when spending is reduced. Explain how released capacity will be used and valued.
What time horizon should I use?
Use a period long enough to capture major lifecycle costs and benefits, while recognizing that longer forecasts carry greater uncertainty.
What is a benefit-cost ratio?
It is total measured benefits divided by total measured costs. Above 1 indicates benefits exceed costs under the model’s assumptions.
Why discount future amounts?
Money received or spent at different times is not directly comparable. Discounting converts future amounts to a present-value basis using an appropriate rate.
What is sensitivity analysis?
It tests how the result changes when a key assumption changes, revealing which variables have the greatest influence.
Should nonfinancial benefits be included?
Yes. Describe and assess important effects even when monetization would be unreliable or inappropriate.
Does a positive net benefit mean we should proceed?
Not by itself. Decision-makers should also consider affordability, risk, strategy, law, ethics, safety, distribution, and non-monetized effects.
Is the template financial advice?
No. It is a general planning tool. Significant decisions should use verified data and qualified financial, accounting, tax, legal, or technical advice as appropriate.