# How to Use Cost Benefit Analysis Calculator in Excel

## What is Cost Benefit Analysis

A cost-benefit analysis is the process 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:

Benefit-Cost Ratio = âˆ‘PV of all the Expected Benefits / âˆ‘PV of all the Associated Costs

The another one is Net Present Value(NPV):

Â Net Present Value = âˆ‘PV of all the Expected Benefits â€“ âˆ‘PV of all the Associated Costs

### Method 1 – Applying Benefit-Cost Ratio to Perform Cost Benefit Analysis

Steps:

• Find the sum of total costs using the SUM function. Enter the following formula in cell C11.
`=SUM(C5:C10)`

• Press ENTER to get the Total Costs.

• Apply the same steps to find Total Benefit as well.
• Apply the Division operation to the We will divide the F10(Total benefit) by C11(Total costs) and get the Benefit-Cost Ratio for the project.

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

Read More: Opportunity Cost Calculator in Excel

### Method 2 – Using Net Present Value for Cost Benefit Analysis

Steps:

• Find Total Costs and Benefits of the project.
• Subtract F10(Total costs) from C11(Total Benefits).

• Press ENTER to get the result.
• The project will make a benefit of \$4000.

Read More: Truck Operating Cost Calculator in Excel

## Related Articles

<< Go Back to Cost Calculator |Â Finance Template |Â Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Junaed-Ar-Rahman

Md Junaed-Ar-Rahman, a Biomedical Engineering graduate from Bangladesh University of Engineering and Technology, has contributed to the ExcelDemy project for one year. As a technical content developer, he has authored 15+ unique articles and actively addressed user problems. He participated in 2 specialized training programs on VBA and Chart & Dashboard design in Excel. His passion lies in solving problems uniquely and exploring new functions and formulas. Eager for future exploration, he aims to gain proficiency in applications... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF