How to Use Cost Benefit Analysis Calculator in Excel

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will demonstrate how to use the cost-benefit analysis calculator in Excel. Cost-benefit analysis is a very important term in the business analysis perspective. It assists us in selecting a single option among many others. We will use Microsoft 365 to do all these.


What is Cost Benefit Analysis

A cost-benefit analysis is the process we use to measure the benefits of a decision or taking action minus the costs associated with taking that action. The outcome of the analysis will determine whether the project is financially feasible or if the company should pursue another project. There are two basic formulas for Cost Benefit Analysis. The first one is Benefit-Cost Ratio which looks like below:

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

The another one is Net Present Value(NPV) and is formulated like below:

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

How to Use Cost Benefit Analysis Calculator in Excel: 2 Suitable Methods

In order to illustrate, we will use a sample dataset. For instance, the following dataset represents the costs of the project of a company. The company will check whether the project is feasible. The company will perform Cost Benefit Analysis and only then take the final decision.Dataset

Method 1: Applying Benefit-Cost Ratio to Perform Cost Benefit Analysis

We can use Benefit-Cost Ratio to do cost benefit analysis of a single or multiple projects. The higher the ratio, the higher the possibility that the company will accept that project. We will perform this on the above dataset. You can follow the steps below to do it yourself.


  • At first, we will find the sum of total costs by the SUM function. We write the following formula at

Cost Benefit Analysis by Benefit-Cost Ratio

  • Next, we hit ENTER and get the Total Costs.

Finding Total Costs

  • After that,we perform the same thing to find Total Benefit as well.
  • Finally, we apply the Division operation to the C13 We will divide the F10(Total benefit) by C11(Total costs) and get the Benefit-Cost Ratio for the project.

Applying Benefit-Cost Ratio Formula

  • The Benefit-Cost Ratio for this project is 1.13 which implies the project is feasible.

Benefit-Cost Ratio Result

Read More: Opportunity Cost Calculator in Excel

Method 2:Using Net Present Value for Cost Benefit Analysis

Another way to perform Cost Benefit analysis is evaluating Net Present Value(NPV) of that project. In the following section we will evaluate NPV for the dataset.


  • Initially,we will find Total Costs and Benefits of the project as before.
  • After that, we Subtract F10(Total costs) from C11(Total Benefits).

NPV evaluation Cost Benefit Analysis

  • Lastly, we hit ENTER and get the result.
  • The project will make a benefit of $4000.

NPV result for Cost Benefit Analysis in Excel

Read More: Truck Operating Cost Calculator in Excel

Download Practice Workbook

You may download the following workbook to practice yourself.


We have discussed the ways to calculate Cost Benefit Analysis calculator in Excel in the above sections. Hope this will be very helpful for you. Let us know your views and recommendations in the comment section. Have a good day.

Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel projects.

Md Junaed-Ar-Rahman, BSc, Biomedical Engineering, Bnagladesh University of Engineering and Technology, Bangladesh, has been working with the ExcelDemy project for 11 months. He has written over 15+ articles for ExcelDemy. Currently, he is working as Technical Content Developer in ExcelDemy project; writes unique articles as well as solves user problems. He participated in 2 specialized training programmes on VBA and Chart and Dashboard designing in Excel. He loves to solve any problem in unique way and explore new functions and fomulas of Excel. In future, he wants to explore more applications like Excel and gaining proficiency in those applications.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF