Cost Benefit Analysis Calculator
Use our free Cost benefit analysis Calculator to plan your projects & roi strategy. Get detailed breakdowns, charts, and actionable insights.
Formula
NPV = Sum of [Benefits_t / (1+r)^t] - Sum of [Costs_t / (1+r)^t]
Where Benefits_t and Costs_t are the benefits and costs in year t, r is the discount rate, and the summation runs from year 0 to the project duration. BCR equals PV of benefits divided by PV of costs. Payback period is the time required to recover the initial investment.
Worked Examples
Example 1: Software Implementation Project
Problem: A company considers investing $50,000 in new software with $10,000 annual costs and $25,000 annual benefits over 5 years at an 8% discount rate.
Solution: Net annual cash flow = $25,000 - $10,000 = $15,000\nSimple payback = $50,000 / $15,000 = 3.3 years\nPV of benefits = $25,000/(1.08) + $25,000/(1.08)^2 + ... + $25,000/(1.08)^5 = $99,818\nPV of costs = $50,000 + $10,000/(1.08) + ... + $10,000/(1.08)^5 = $89,927\nNPV = $99,818 - $89,927 = $9,891\nBCR = $99,818 / $89,927 = 1.11
Result: NPV: $9,891 (positive = viable) | BCR: 1.11 | Payback: 3.3 years
Example 2: Marketing Campaign Analysis
Problem: A $20,000 marketing campaign with $5,000 annual costs is expected to generate $18,000 in annual benefits for 3 years at 10% discount rate.
Solution: Net annual cash flow = $18,000 - $5,000 = $13,000\nSimple payback = $20,000 / $13,000 = 1.5 years\nPV of benefits = $18,000/1.1 + $18,000/1.21 + $18,000/1.331 = $44,763\nPV of costs = $20,000 + $5,000/1.1 + $5,000/1.21 + $5,000/1.331 = $32,434\nNPV = $44,763 - $32,434 = $12,329\nBCR = $44,763 / $32,434 = 1.38
Result: NPV: $12,329 (positive = viable) | BCR: 1.38 | Payback: 1.5 years
Frequently Asked Questions
What is cost-benefit analysis and why is it important?
Cost-benefit analysis (CBA) is a systematic approach to evaluating the strengths and weaknesses of a project or decision by comparing total expected costs against total expected benefits. It is one of the most widely used decision-making tools in business, government, and public policy. The process involves identifying all relevant costs and benefits, quantifying them in monetary terms, discounting future values to present value, and comparing the totals. CBA helps organizations allocate resources efficiently by providing an objective framework for comparing alternatives. It is particularly valuable when multiple stakeholders are involved because it translates diverse impacts into a common monetary metric that everyone can evaluate consistently.
What discount rate should I use for cost-benefit analysis?
The appropriate discount rate depends on the context and type of analysis being performed. For private sector projects, the discount rate typically reflects the company's weighted average cost of capital (WACC), which often ranges from 8% to 15% depending on the industry and risk profile. For public sector projects, the US Office of Management and Budget recommends a 7% discount rate for regulatory analysis, representing the average pre-tax rate of return on private capital. The Federal Reserve often uses 3% for long-term social projects. Higher discount rates favor projects with near-term benefits, while lower rates favor projects with long-term benefits. Sensitivity analysis should always be performed using multiple discount rates to understand how the conclusion changes under different assumptions about the cost of capital.
What is the benefit-cost ratio (BCR) and what is a good ratio?
The benefit-cost ratio (BCR) is calculated by dividing the present value of total benefits by the present value of total costs. A BCR greater than 1.0 indicates that benefits exceed costs, meaning the project adds value. A BCR less than 1.0 means costs exceed benefits, suggesting the project should be reconsidered. Generally, a BCR of 1.5 or higher is considered a strong project, while a BCR between 1.0 and 1.5 may be acceptable depending on strategic importance and non-quantifiable benefits. Government agencies typically require a BCR of at least 1.0 for project approval. The BCR is useful for comparing projects of different sizes because it provides a ratio rather than an absolute number, making it easier to rank alternatives when capital is limited.
What are common mistakes in cost-benefit analysis?
Several common mistakes can significantly undermine the accuracy and usefulness of a cost-benefit analysis. Omitting relevant costs or benefits, especially indirect and intangible ones like employee morale, brand impact, or environmental externalities, leads to biased results. Using an inappropriate discount rate can dramatically change the conclusion, making sensitivity analysis essential. Double counting occurs when the same benefit or cost is included under multiple categories. Ignoring opportunity costs, which represent the value of the next best alternative foregone, distorts the true cost picture. Optimism bias causes analysts to overestimate benefits and underestimate costs, which is why independent review is recommended. Failing to account for risk and uncertainty by presenting only a single-point estimate rather than a range of scenarios gives a false sense of precision.
How do I calculate customer acquisition cost (CAC)?
CAC = Total Sales and Marketing Expenses / Number of New Customers Acquired in that period. Include all related costs: advertising, salaries, tools, commissions, and overhead. CAC payback period = CAC / Monthly Gross Margin per Customer. A payback period under 12 months is generally healthy for SaaS businesses.
How do I interpret the result?
Results are displayed with a label and unit to help you understand the output. Many calculators include a short explanation or classification below the result (for example, a BMI category or risk level). Refer to the worked examples section on this page for real-world context.