EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Cost-Benefit Analysis Formula
 

Cost-Benefit Analysis Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 25, 2023

Cost-Benefit Analysis Formula

 

 

Cost-Benefit Analysis Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is the Cost-Benefit Analysis Formula?

The term “cost-benefit analysis” refers to the analytical technique that compares the benefits of a project with its associated costs. In other words, all the expected benefits out a project are placed on one side of the balance and the costs that have to be incurred are placed on the other side.

The cost-benefit analysis can be executed either using “benefit-cost ratio” or “net present value”. The formula for a benefit-cost ratio can be derived by dividing the aggregate of the present value of all the expected benefits by an aggregate of the present value of all the associated costs, which is represented as,

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Cost-Benefit Analysis Formula,

Benefit-Cost Ratio = ∑PV of all the Expected Benefits / ∑PV of all the Associated Costs

The formula for net present value can be derived by deducting the sum of the present value of all the associated costs from the sum of the present value of all the expected benefits, which is represented as,

Net Present Value = ∑PV of all the Expected Benefits – ∑PV of all the Associated Costs

Example of Cost-Benefit Analysis Formula (With Excel Template)

Let’s take an example to understand the calculation of Cost-Benefit Analysis in a better manner.

You can download this Cost-Benefit Analysis Excel Template here – Cost-Benefit Analysis Excel Template

Cost-Benefit Analysis Formula – Example #1

Let us take the example of a financial technology start-up which is contemplating on hiring two new programmers. The promoter expects the programmers to increase the revenue by 25% while incurring an additional cost of $45,000 in the next one year. The help promoter decides whether to go ahead with the recruitment based on cost-benefit analysis if the revenue of the company in the current year is $220,000 and the relevant discount rate is 5%.

 Example of A Financial Technology-1.1

Solution:

PV of Benefit is Calculated as:

Cost-Benefit Analysis Formula-1.2

  • PV of Benefit= $55,000 / (1 + 5%)
  • PV of Benefit = $52,380.95

PV of Cost is Calculated as:

Cost-Benefit Analysis Formula-1.3

  • PV of Cost = $35,000 / (1 + 5%)
  • PV of Cost = $33,333.33

Benefit-Cost Ratio is calculated using the formula given below

Benefit-Cost Ratio = ∑PV of all the Expected Benefits / ∑PV of all the Associated Costs

Cost Benefit Analysis Formula 1-4

  • Benefit-Cost Ratio = $52,380.95 / $33,333.33
  • Benefit-Cost Ratio = 1.57x

Net Present Value is calculated using the formula given below

Net Present Value = ∑PV of all the Expected Benefits – ∑PV of all the Associated Costs

Cost-Benefit Analysis Formula -1.5

  • Net Present Value = $52,380.95 – $33,333.33
  • Net Present Value = $19,047.62

Therefore, both the method of cost-benefit analysis suggests that the promoter should go ahead with the recruitment.

Cost-Benefit Analysis Formula – Example #2

Let us take the example of two projects to illustrate the use of cost-benefit analysis. The sum of the present value of expected benefits from Project 1 is $50 million with the sum of the present value of associated costs of $30 million. On the other hand, the sum of the present value of expected benefits from Project 2 is $10 million with the sum of the present value of associated costs of $5 million. Discuss which project is better based on cost-benefit analysis.

example of 2 project

Solution:

Benefit-Cost Ratio is calculated using the formula given below

Benefit-Cost Ratio = ∑PV of all the Expected Benefits / ∑PV of all the Associated Costs

cost benefit7

For Project 1

  • Benefit-Cost Ratio = $50,000,000 / $30,000,000
  • Benefit-Cost Ratio = 1.67x

For Project 2

  • Benefit-Cost Ratio = $10,000,000 / $5,000,000
  • Benefit-Cost Ratio = 2.00x

Net Present Value is calculated using the formula given below

Net Present Value = ∑PV of all the Expected Benefits – ∑PV of all the Associated Costs

net present value (Cost-Benefit Analysis Formula)

For Project 1

  • Net Present Value = $50,000,000 – $30,000,000
  • Net Present Value = $20,000,000

For Project 2

  • Net Present Value = $10,000,000 – $5,000,000
  • Net Present Value = $5,000,000

Therefore, as per the benefit-cost ratio, project 2 is better, while the net present value suggests project 1 is better. Although this is a stalemate mind of the situation, the inherently net present value gets the preference. Therefore, project 1 will be considered better.

Explanation

The formula for cost-benefit analysis can be calculated by using the following steps:

Step 1: Firstly, Calculate all the cash inflow from the subject project, which is either revenue generation or savings due to operational efficiency.

Step 2: Next, Calculate all the cash outflow into the project, which are the costs incurred in order to maintain and keep the project up and running.

Step 3: Next, Calculate the discounting factor based on the current pricing of assets with a similar risk profile.

Step 4: Next, based on the discounting factor, calculate the present value of all the cash inflow and outflow. Then, add up the present value of all the cash inflow as ∑PV of all the expected benefits and outflow as ∑PV of all the associated costs.

Step 5: Now, the formula for a benefit-cost ratio can be derived by dividing aggregate of the present value of all the expected benefits (step 4) by aggregate of the present value of all the associated costs (step 4) as shown below.

Benefit-Cost Ratio = ∑PV of all the Expected Benefits / ∑PV of all the Associated Costs

Step 6: Now, the formula for net present value can be derived by deducting the sum of the present value of all the associated costs (step 4) from the sum of the present value of all the expected benefits (step 4) as shown below.

Net Present Value = ∑PV of all the Expected Benefits – ∑PV of all the Associated Costs

Relevance and Use of Cost-Benefit Analysis Formula

The importance of cost-benefit analysis lies in the fact that it is used for assessing the feasibility of an opportunity, comparing projects, appraising opportunity cost and building real-life scenario-based sensitivity testing. In this way, this technique helps in ascertaining the accuracy of an investment decision and provides a platform for its comparison with similar proposals.

Cost-Benefit Analysis Formula Calculator

You can use the following Cost-Benefit Analysis Formula Calculator

∑PV of all the Expected Benefits
∑PV of all the Associated Costs
Benefit-Cost Ratio
 

Benefit-Cost Ratio =
∑PV of all the Expected Benefits =
∑PV of all the Associated Costs
0 = 0
0

Recommended Articles

This is a guide to Cost-Benefit Analysis Formula. Here we discuss how to calculate the Cost-Benefit Analysis Formula along with practical examples. We also provide a Cost-Benefit Analysis calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. Formula of Moving Average
  2. Example of Financial Analysis
  3. Calculation of Convexity
  4. How to Calculate Time Value of Money

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Cost-Benefit Analysis Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Cost-Benefit Analysis Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW