Cost Benefit Analysis Example and Steps (CBA Example)

Simple Cost Benefit Analysis Example And Calculation Steps, Net Present Value

In today’s economic environment, it is essential to use financial tools and techniques to support organizational decision-making before starting a new business or making significant changes in existing workstreams. Organizations across various industries—from construction to chemicals—use different decision-making tools to ensure success in their respective fields. One key tool is the Cost-Benefit Analysis (CBA) Methodology, also known as Benefit-Cost Analysis. This is a mathematical approach that allows organizations to compare the costs and expected benefits of two or more projects through a series of systematic steps. In this article, we will explore real-world examples of Cost-Benefit Analysis and provide a step-by-step guide on its calculation, with a focus on how Net Present Value (NPV) is related to this method.

What is Cost Benefit Analysis Methodology?

You’ve probably already used the Cost-Benefit Analysis (CBA) methodology in your own life when purchasing a new car or deciding whether to move to a new apartment. This is because calculating the costs and returns of a decision is an integral part of everyday life.

Every project, of course, involves a list of expenses and potential incomes. To evaluate these, you need to calculate the Net Present Value (NPV) and payback period. Cost-Benefit Analysis is a widely used decision-making tool in finance and economics, applicable to various industries such as IT, software development, construction, education, healthcare, and more.

In general, the primary goal of tracking the steps in a Cost-Benefit Analysis is to calculate the ratio of benefits to costs. Simply put, a Cost-Benefit Analysis helps determine how likely or successful a project will be by assessing whether the benefits outweigh the costs.

What Makes Cost Benefit Analysis Important

A Brief History

The concept of Cost-Benefit Analysis (CBA) was introduced by French economist and engineer Jules Dupuit in 1848, who used this tool in a bridge project. Later, the renowned economist Alfred Marshall structured this approach in his book Principles of Economics in 1890. Since the 1930s, the U.S. Army Corps of Engineers has used Cost-Benefit Analysis for various projects, including federal waterway infrastructure.

What Makes Cost Benefit Analysis Important?

As mentioned earlier, Cost-Benefit Analysis is a systematic approach widely used in economics to evaluate the net present value of costs and expected benefits. It helps minimize risks and maximize returns, benefiting both individual projects and companies as a whole.

For example, you might use CBA when deciding whether to purchase real estate or undertake a new project.

But what is the purpose of conducting a CBA for an investment?

Cost-Benefit Analysis serves two main purposes:

To ensure that an investment (or project) will generate more benefits than costs.
To compare different investments (or projects) by evaluating their benefit-to-cost ratios.
To make a meaningful comparison between the positive and negative aspects of alternatives, a common unit of measurement is necessary. Money is typically the common unit used for comparing alternatives.

In financial analysis, the time value of money is a critical consideration. When performing a CBA, future costs and expected benefits of an investment are converted into present value using a discount rate.

Conducting a Cost-Benefit Analysis provides decision-makers with a structured methodology for evaluating decisions, such as purchasing a new home or expanding sales into a new region.

Both large companies and individuals can use CBA to select the most effective alternative.

Cost Benefit Analysis Steps

Whether you are working in the private or public sector, it is essential to document all relevant parameters when making decisions, such as establishing a new program or expanding an existing system. Below are the key steps to follow when performing a Cost-Benefit Analysis:

  1. Build the Structure: Analyze the current state of the change and clearly define all requirements.
  2. Determine the Stakeholders: Identify who will be impacted by the change, who will bear the costs, and who will benefit from the results.
  3. Categorize the Costs and Benefits: Classify costs and benefits as direct, indirect, tangible, and intangible to better understand their effects.
  4. Project Both Costs and Benefits: Forecast how costs and benefits will evolve over the lifespan of the program or change. Keep in mind that all calculations will be influenced by the duration.
  5. List the Costs as Monetary Values: Quantify the costs in monetary terms.
  6. List the Benefits as Monetary Values: Quantify the benefits in monetary terms.
  7. Use Net Present Value (NPV): Adjust future cash flows and costs to present-day values using NPV.
  8. Calculate the Payback Period: Determine how long it will take to recover the initial investment.
  9. Perform Sensitivity Analysis: Test how sensitive the results are to changes in key assumptions.
  10. Evaluate the Results: Analyze the findings to determine if the benefits outweigh the costs.

Cost Benefit Analysis and Net Present Value (NPV)

Before analyzing a Cost-Benefit Analysis (CBA) example and its calculation steps, let’s first discuss how Net Present Value (NPV) relates to CBA. Whether you are planning to undertake a large project or purchasing a desktop computer for office work, it is crucial to weigh the expected costs against the benefits to make the right decision. To do so, you must compare both costs and benefits on equal terms. This is where NPV calculations come into play.

In finance, the concept of the time value of money states that 1 USD today is worth more than 1 USD in the future. Therefore, when performing a CBA, you need to account for the time value of money. Using a discount rate adjusts future cash flows to present-day values. For simplicity, we will assume a discount rate of “1” in our example.

Example for CBA and NPV

Net Present Value (NPV) relies on the following decision;

  • The value of money today is greater than the value of money later on.

Because money is a tool to make more money! You can buy and sell goods or start a new business, so that earn more money with your current capital.

In our cost benefit analysis example, your company is deciding to undertake a project which longs for three years. The expected total project cost is $ 15,000 today and the expected income after three years will be $25,000. The discount rate is 10%.

Now we will analyze if that is a good investment or not by using Cost Benefit Analysis and Net Present Value.

The Value of Money Today: $ 15,000.

The Present Value (PV) of $ 25,000 is;

PV= $ 25,000 / (1,10 × 1,10 × 1,10) = $ 18,783 now (to nearest cent)

Net Present Value = $ 18,783 – $ 15,000 = $ 3783

So, if the discount rate is %10, that investment is worth $ 3783.  Your company can undertake the project because $ 3783 is a positive value.

A Simple Cost Benefit Analysis Example and Calculation Steps

Let’s assume that a board chairman of a construction company claims his team to make a comparison between two potential real estate development projects. He also reminds them that the company’s financial health is getting poor so he has to select one of them.

The team works and lists below the potential incomes and costs of each project.

Assumptions

Note: In order to simplify the cost benefit analysis example, we will not use a discount rate for each cost and income.

Project 1

– 500 housing units will be constructed.
– 400 of them will be sold and 100 of them will be rented for 20 years.
– Rental Price of each unit is 4,000 USD per year
– Rented 100 units will be sold 70,000 USD after 20 years.
– Construction Cost of each unit is 100,000 USD.
– The sale price of each unit is 120,000 USD.
– The project needs a luxury sales office with a price of 2,000,000 USD.
– The sales personnel cost is 300,000 USD per year.
– The project duration is 3 years.
– Project financing cost is 3,000,000 USD per year

Project 2

– 400 housing units will be constructed.
– 350 of them will be sold and 50 of them will be rented for 15 years.
– Rented 50 units will be sold 80,000 USD after 15 years.
– Rental Price of each unit is 4,500 USD per year
– Construction Cost of each unit is 90,000 USD.
– The sale price of each unit is 135,000 USD.
– The project needs a luxury sales office with a price of 3,000,000 USD.
– The sales personnel cost is 250,000 USD per year.
– The project duration is 2 years.
– Project financing cost is 2,500,000 USD per year

Comparing the Project Parameters

In this cost benefit analysis example, we will calculate the amount of money to be spent and the amount of money to be earned from each project to address economic efficiency.

Below table summarizes all the given project parameters.

Simple Cost Benefit Analysis Example And Steps In Economics

Cost Calculations

Below table summarizes the project costs.

Cost Benefit Analysis Example And Calculation Steps And Net Present Value

Benefit Calculations

Below table summarizes the project benefits.

Calculation Steps Cba And Net Present Value In Economics

Costs and Benefits Comparison

Net Present Value In Economics
Cost Benefit Analysis-Costs And Benefits Comparison

In this simple cost benefit analysis example, there are too many parameters affecting the board’s decision. Financing costs per year, units for sale, units for rent, total units to be constructed are some of them that make decision making difficult.

The above table summarizes the benefits, costs, and profits of each project. Although the income of Project 1 is more than Project 2, the costs of Project 2 are less than the costs of Project 1.

It is obvious that Project 2 is more profitable than Project 1. If the board chairman selects Project 2, the company will earn more profit by spending less money.

This simple example shows that Cost Benefit Analysis is a useful calculation tool in economics. Decision makers often use it while comparing multiple projects.

Another Real-World Cost Benefit Analysis Example

In the following cost benefit analysis example, three basic steps;

  • Conducting a brainstorming session to determine all the costs and benefits related to the decision.
  • Assigning a monetary value to all the costs.
  • Assigning a monetary value to all the benefits.
  • Comparing costs and benefits to calculate the payback period.

Assume that you have a software company operating for three years and you are planning to speed up the delivery dates in order to meet the market demand. You have five coders working full time but you need three more coders to facilitate the testing process. Hiring three more coders requires additional investments such as buying additional furniture, computers, and leasing additional workspace.

Assumptions

  • Yearly revenue is $100,000 but it will increase by %30 as the capacity increases.
  • Every month you are outsourcing an average of 200 hours of work with a cost of $80 per hour to another software company for testing.
  • The productivity of team members will increase by %5 with a more comfortable office environment.

Costs

Cost Item Details Costs (in First Year)
Rental Cost The additional rental cost of moving to a new office $15.000
Furnishing Costs Painting walls and buying new furniture $10.000
Hiring Costs Cost of hiring three more coders (inc. salaries, benefits, orientation and training, $40,000 for each and the rate of one hired coder is $17,36/hour  (24 Days x 8 hours x 12 Months = 2304 hours)) $120.000
Software Costs Buying three computers and software licenses $10.000
Downtime Costs Approximately $20,000 will be lost due to downtime $20.000
Total Costs $175.000

Benefits

Details Benefits (within 12 Months)
%30 Revenue increase (Yearly revenue is 100,000 USD) $130.000
The rate of three hired coder is $52,08/hour, Cost of outsourcing is $80/hour. The Difference is  (80 – 50,08) x200 hours x 12 months. $67.008
Improved productivity ($40,000x %5 x 8 Coder) $16.000
Expected Benefits $213.008

In this cost benefit analysis example, payback period can be calculated as;

$175,000 / $213,008 = 0.821 of a year, or approximately 10 months.

It is often difficult to estimate the benefits rather than estimating costs. Because benefits are subjective and can be affected by the estimator’s bias. On the other hand, as a decision-making tool in economics, the cost benefit analysis often guides decision-makers to select the most effective alternative.

Cost Benefit Analysis Excel Examples

Example #1

ABC Chemical Ltd. is deciding which investment alternative is feasible considering costs and benefits of each of them.

Alternative 1

  • Total Costs of Alternative  1 = $ 88.000.000.
  • Expected Benefits s of Alternative  1 = $ 108.000.000

Alternative 2

  • Total Costs of Alternative  2 = $ 11.000.000.
  • Expected Benefits s of Alternative  2 = $ 23.000.000

Let’s decide which alternative ABC Chemical Ltd . should choose?

In order to decide which alternative is profitable, we will calculate the benefit-cost ratio for each one through a spreadsheet.

Benefit-Cost Ratio = Expected Benefits / Total Costs

Excel Calculation for Alternative 1

Simple Benefit-Cost Ratio Excel Calculation Example Steps

= $ 108.000.000 / $ 88.000.000

Benefit-Cost Ratio = 1,23

Excel Calculation for Alternative 2

Simple Benefit-Cost Ratio Excel Calculation Steps

= $ 23.000.000 / $ 11.000.000

Benefit-Cost Ratio = 2,09

According to Benefit-Cost Ratio calculations of Alternative 1 and Alternative 2, both investment opportunities have positive outcomes. In other words, both alternatives are beneficial for ABC Chemical Ltd. So the company will be in a good position it selects any of the alternatives. However, in that example, benefit-cost ratio of Alternative 2 is higher than benefit-cost ratio of Alternative 1. So, according to the Cost Benefit Analysis, ABC Chemical Ltd. should select Alternative 2, in the light of the information given above.

Example #2

Fox Car Maintenance Company is thinking to expand its current repair shop, and for that purpose, it will require additional vehicle mechanics and equipment. The owner of the company decides to make a cost benefit analysis to understand if that investment is beneficial or not. Here below you can find all the parameters related to costs and benefits.

  • Hiring 5 more vehicle mechanics will provide a revenue increase by 45 % within one year. This expansion is planning to bring a revenue of $ 220.000.000.
  • This expansion will increase the brand awareness of Fox Car Maintenance Company. Thus, this will bring additional revenue of $ 40.000.000.
  • The salary of the new vehicle mechanics is around  $ 110,000.
  • The purchase cost of new equipment is $ 20,000.
  • The cost of additional electrical and mechanical infrastructure will be around $ 15,000

Let’s perform a Cost Benefit Analysis for the given example.

Total Benefits (TB)

  • Total benefits of the expansion: Increase in revenue of hiring 5 more vehicle mechanics + Increase in revenue of brand awareness
  • TB: $ 220.000.000 + $ 40.000.000 = $ 260.000.00

Total Costs (TC)

  • Total costs of the expansion: Salary of additional employees + purchase cost of new equipment + cost of additional electrical and mechanical infrastructure.
  • TC: $ 110,000 + $ 20,000 + $ 15,000
  • TC: $ 145,000

Now we will make the calculations by using Excel.

Cba Calculations Excel Net Present Value

According to the Benefit-Cost Ratio calculations, the expansion of the current repair shop has positive outcomes. The Fox Car Maintenance Company should expand its business and employ new vehicle mechanics as well as purchasing new equipment and build new infrastructures.

Where to Use Cost Benefit Analysis? Example Scenarios

As discussed above, cost benefit analysis facilitates the course of the decision-making process across a wide variety of areas. It is applied to many disciplines from business to finance. You can take advantage of using cost benefit analysis when;

  • Comparing two or more projects
  • Deciding whether to start a new business
  • Making the right hiring decisions
  • Comparing investment opportunities
  • Evaluating social benefits
  • Evaluating policies
  • Making decisions regarding changes

Summary

These simple, real-world Cost-Benefit Analysis examples demonstrate how to conduct a CBA in different situations. It’s important to consider intangible benefits—such as customer satisfaction, environmental impact, employee well-being, and health and safety—when conducting a Cost-Benefit or Benefit-Cost Analysis in economics.

Benefits don’t only consist of the revenues generated from business activities; they also include intangible factors. To conduct an accurate Cost-Benefit Analysis, you need to calculate the present value of future earnings using financial techniques such as Net Present Value (NPV).

At times, it may be difficult to compare options with very similar values. In such cases, intangible factors can influence the final decision.

Typically, these analyses are reviewed by high-level stakeholders, top management, and board members. Once a project is selected, the process of developing the project charter begins.

See Also

Request For Information

Expected Monetary Value Calculation

Further Reading

[1] The social CBA

Related posts


10 thoughts on “Cost Benefit Analysis Example and Steps (CBA Example)”

  1. ensoft, a software house, is considering developing a payroll application for use in academicinstitutions and is currently engaged in a cost-benefit analysis. Study of the market has shownthat, if they target it efficiently and no competing products become available, they will obtain ahigh level of sales generating an annual income of £800,000. They estimated that there is a 1 in10 chance of this happening. However, a competitor might launch a competing applicationbefore their own laun

    Reply
  2. NEED SOLUTION

    The Board of Quest plc is due to meet to consider investing in a new project which will allow the company to diversify its existing product range. Before the meeting the Finance Director, has asked you, to evaluate the project using the following information.

    Market research has been undertaken at a cost of HK$500,000 which shows that the project will result in the following cash flows:

    Year 1

    Year 2

    Year 3

    Year 4

    Sales volume (units)

    100,000

    130,000

    130,000

    90,000

    Selling price (HK$/unit)

    472

    523

    551

    660

    Variable cost (HK$/unit)

    275

    315

    351

    403

    Fixed costs (HK$)

    8,760,000

    9,030,000

    9,320,000

    9,610,000

    These forecasts are after taking account of selling price inflation of 3·0% per year, variable cost inflation of 6·0% per year and fixed cost inflation of 3·5% per year.

    In addition included in the fixed costs is a figure of HK$1,000,000 which represents an apportionment of general overheads. The balance of the fixed costs are incremental fixed costs which are associated with the new project.

    The total machinery costs of the project in year 0 are estimated to be HK$40,000,000 and the machinery from the project will be sold for scrap with a value of HK$4,000,000 at the end of year 4.The company will also have to spend HK$ 3,000,000 refurbishing the building before the new machinery can be installed.

    Quest plc pays corporation tax of 25% per year. This is paid in the following year (i.e. one year in arrears) Capital allowances on an 18% reducing balance basis are available on the machinery only. A balancing charge or allowance is available at the end of the fourth year of operation.

    Quest plc has a real cost of capital of 9% and the general rate of inflation is 3.7%

    Required:

    Recommend to the Board whether the project should be undertaken by:
    Calculating the nominal after-tax Net Present Value of the new project using the money cost of capital.(Round to the nearest whole number)

    Calculating the Internal Rate of Return of the new project.

    After the Board meeting, you were asked to consider the risk of the project and you have reported back to the board that the Expected Net Present Value and the Standard Deviation of the project are HK$1,290,000 and HK$1,640,000 respectively.

    Required:

    Calculate the percentage probability that the project will be value destroying (you can assume a normal distribution of outcomes.) and briefly discuss the difficulties of using probability analysis in incorporating risk into investment appraisal.

    One of the directors thinks that incorporating inflation into the calculation in the way outlined above is too time consuming and just adds more costs to the business without giving a significant benefit.

    Required:

    Explain one other way that inflation can be incorporated in the NPV calculation and discuss which method you think the company should adopt.(use the figures above to support your answer)

    Reply
  3. Very helpful. Thank you very much. May I have a a social cost benefit analysis = one that does not have financial or tangible benefits. For example, introducing social workers in schools to eliminate cases of child suicides.

    Reply
  4. 1. A government is considering building a tunnel across a sea channel which can currently only be crossed by ship. The following Information is available.
    (i) The tunnel will consist of a tow- truck railway and cars and passengers will be carried by train. It will cut crossing time by two hours for car and passengers.
    (ii) The relevant categories of traffic are:
    (a) Cars (and their passengers)
    (b) Passengers not in cars
    (c) Freight
    (iii) The authorities who would operate the tunnel have decided to charge a toll which would maximize revenue. The toll that they have decided to charge is 160 per car which compares favorably with the charge by ship which is 200.
    (iv) Because of the quicker and chipper journeys available, it is forecast that the following traffic per year for the foreseeable future will be diverted from the existing method of travel:
    75,000 cars (with the average of two passengers)
    50,000 passengers not in cars
    350,000 tonnes of fright
    In addition 50,000 extra car journeys (with two passengers each) will be made.
    (v) The average value of passenger’s time is 6 per hours.
    (vi) The diverted traffic will reduce the cost of operation of the existing ship by 40 million a year, while at the forecast levels of traffic, the maintenance and operating cost of the tunnel will be 3 million. Its capital cost will be 400 million. The life of the tunnel will be 50 years.
    (vii) Assuming that the monetary figures given the above reflect social value, calculate the IRR of the streams of social costs and benefits.
    2. A government is considering whether it should close down the branch line passengers services from station A to station B. no good are currently carried by rail. The chief accountant of the government estimate the annual cost of the train movement, track maintenance, signaling, and other expense to be 1, 520,000, including 120,000 toward depreciation and interest charges. If the line were closed at any time, the diesel train operating on it could be sold to another country for 240,000. Noting else has any re-sale value the line is used for 1000 single Journeys each day (250 days per year). The single fare is 4.00. So the line is losing money, a deficit met by taxation. If the line is closed, It is estimated that of the former journeys 800 will be made by bus (at the same fare) and 200 will not be made. The bus fare is the same as the rail fare and the extra bus fares exactly offset the bus operations extra cost. Bus journey takes an average of 40 minute longer than the rail journey. The average value of passenger’s time is 2 per hour. Enumerate the social costs and benefits associated with the proposal.

    Reply
  5. This post on cost-benefit analysis is incredibly helpful! The step-by-step approach makes it easy to understand, and the example you provided really clarified how to apply the concepts in real situations. I appreciate the emphasis on both tangible and intangible benefits. Thank you for sharing such valuable insights!

    Reply
  6. This blog post really breaks down the cost-benefit analysis process clearly! The example provided helped me understand how to apply the steps in real-life scenarios. I appreciate the practical tips and the straightforward language. Looking forward to more posts like this!

    Reply

Leave a Comment