Cost Benefit Analysis Calculator
Use our free Cost benefit analysis Calculator to plan your projects & roi strategy. Get detailed breakdowns, charts, and actionable insights.
Reviewed for accuracy by Sahil, Senior Finance & Tax Editor
Cost Benefit Analysis Calculator
Calculator
Adjust values & calculateEnter your values below. Every result is computed in your browser โ no data is sent to any server.
Formula: NPV = Sum of [Benefits_t / (1+r)^t] - Sum of [Costs_t / (1+r)^t]
Worked example โ NPV: $9,891 (positive = viable) | BCR: 1.11 | Payback: 3.3 years
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 Simple payback = $50,000 / $15,000 = 3.3 years PV of benefits = $25,000/(1.08) + $25,000/(1.08)^2 + ... + $25,000/(1.08)^5 = $99,818 PV of costs = $50,000 + $10,000/(1.08) + ... + $10,000/(1.08)^5 = $89,927 NPV = $99,818 - $89,927 = $9,891 BCR = $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 Simple payback = $20,000 / $13,000 = 1.5 years PV of benefits = $18,000/1.1 + $18,000/1.21 + $18,000/1.331 = $44,763 PV of costs = $20,000 + $5,000/1.1 + $5,000/1.21 + $5,000/1.331 = $32,434 NPV = $44,763 - $32,434 = $12,329 BCR = $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 is Net Present Value (NPV) and how do I interpret it?
Net Present Value (NPV) is the difference between the present value of all benefits and the present value of all costs over the life of a project. It accounts for the time value of money by discounting future cash flows back to their present-day equivalent using a chosen discount rate. A positive NPV indicates that the project is expected to generate more value than it costs, making it a worthwhile investment. A negative NPV suggests the project will destroy value and should typically be rejected. The higher the NPV, the more attractive the project. When comparing multiple projects, the one with the highest NPV generally provides the greatest return, assuming similar risk levels. NPV is considered the gold standard of investment analysis because it accounts for both timing and magnitude of cash flows.
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.
References
Background & Theory
History
Reviewed for accuracy by Sahil, Senior Finance & Tax Editor ยท Editorial policy
Related Calculators
๐งฎCustomer Acquisition Cost (CAC) Calculator
Calculate customer acquisition cost caccalculator with inputs, formulas, and instant results.
๐งฎInflation Cpiadjustment Calculator
Calculate inflation cpiadjustment with inputs, formulas, and instant results.
๐งฎPurchasing Power Parity (PPP) Converter
Calculate pppconverter with inputs, formulas, and instant results.
๐งฎPrice Elasticity Calculator
Calculate price elasticity with inputs, formulas, and instant results.
๐งฎEOQ Calculator
Calculate eoqcalculator with inputs, formulas, and instant results.
๐งฎQueueing M/M/s Calculator
Calculate queueing mmscalculator with inputs, formulas, and instant results.