How to calculate ROI for a project

Return on Investment is one of the most common indicators used for the cost-benefit analysis. This is probably because of its simplicity and understandability of the information co

How to calculate ROI for a project

Return on Investment is one of the most common indicators used for the cost-benefit analysis. This is probably because of its simplicity and understandability of the information conveyed. In Project Management, it is a success measure suggested by the Project Management Institute (PMI; source: PMBOK®, 6th ed., part 1, ch. 1.2.6.4, p. 34). However, the basic ROI has some limitations, e.g. if you need to compare alternatives with different tenors.

In this article, we will introduce the fundamental concept of return on investment measurement as well as a modification that allows for a multi-year ROI calculation. If you need to calculate the ROI for your project options or investment alternatives, use our free calculator in this article.Contents

  • What Is the Return of Investment (ROI)?
  • What Is Return on Investment for Multiple Years?
  • How Is the Return on Investment Calculated?
  • The Basic ROI Formula
  • How Is the Return on Investment Calculated for Multiple Return Periods?
  • The Multi-Year ROI Formula
  • Calculation in Excel
  • Disadvantages and Modifications of this Method
  • Considerations when Calculating the Return on Investment
  • What Are the Types of Returns Considered for ROI?
  • What Are the Types of Cost and Investment Considered for ROI?
  • The ROI Calculator  Calculate the Return on Investment (Basic Concept)
  • Examples of Basic and Multiple Years ROI
  • Example 1) Investment with a Single Return at Maturity
  • Example 2) Use of Single- and Multi-Period ROI to Compare Project Options
  • Cash Flow Projections
  • ROI Calculation for these Examples
  • Interpretation of Results
  • What Are the Advantages and Disadvantages of the ROI?
  • Pros
  • Cons
  • Alternative Measures
  • Conclusion

What Is the Return of Investment (ROI)?

The return on investment is an indicator of the profitability of an investment or a project. As the ROI is a percentage value, it can be used to compare different projects and investment alternatives with respect to their profitability.

The result is a ratio of benefits and returns in relation to investment and costs. This helps compare alternatives with different investment amounts where absolute returns would not be an appropriate measure for comparison purposes.

What Is Return on Investment for Multiple Years?

Returns may occur at different points in time for different alternatives. It does make a difference whether you are receiving a return at an early or late point in your projection.

Therefore, there is a specific formula for returns that are earned over multiple periods or years. It helps you compare the ROIs of investment alternatives with a different tenor or different cash flow characteristics (source).

How Is the Return on Investment Calculated?

The Basic ROI Formula

In its most simple form, the ROI is calculated by dividing the returns after cost by the investment:

Formula ROI Basic = Return / Investment

This formula may be applied to single-period projects and investments (e.g. a project delivered within one year, a bond with a 1-year maturity). In practice, it is also used for multiple periods which however may not be accurate as the value of time may not be sufficiently considered. If this aspect is not deemed material, investment and project alternatives can be compared using a basic ROI as long as it relates to a small number of periods and the tenors of all alternatives are identical. However, this is not as accurate as the multi-period ROI that is introduced below.

How Is the Return on Investment Calculated for Multiple Return Periods?

If you are comparing project options and investment alternatives with different tenors, you achieve more accurate results when you are using the ROI formula for multiple years instead of the basic ROI concept. You will then be able to compare the annualized ROI of the different alternatives.

The ROI for multiple periods distributes the return earned at the end of the investments tenor across the periods. Thus, an investment with returns over 2 years can be compared with an investment for 4 years, for instance.

The Multi-Year ROI Formula

The Return on Investment formula is as follows:

ROI formula for multiple periods = (1+r)^t - 1

where:
ROI [multiple periods] = cumulative return over all periods
r = return per period [in %] (the equation needs to be solved for r)
t = number of periods

The first component of this formula is similar to the future value formula (FV = (1+r)^t) solved for r as the periodic (e.g. annualized) return. Subsequently, r (in %) is the relevant measure to compare different alternatives.

Calculation in Excel

In Excel, the multi-period ROI can be determined by using the RATE Function. It requires the parameters

  • nper: the number of periods,
  • pmt: payments, this parameter can remain empty for the purpose of this calculation,
  • present value: to be populated with the investment amount (negative figure, representing an initial cash outflow),
  • future value: the total return (incl. amortization of the initial investment) at the end of the time horizon,
  • type (of cash flow): select whether cash flows occur at the end (the typical case) or beginning of a period,
  • guess: an estimation of the rate, if available (can be empty).
Excel RATE function to calculate multi-year ROIROI

Calculating the ROI for multiple periods in Excel using the RATE function.

The result is the annualized return in percent which however is not as accurate as the internal rate of return method if cash flows occur between the first and last periods.

Disadvantages and Modifications of this Method

This approach assumes that all returns occur in the form of a single cumulative inflow in the last period of the investments tenor. This is appropriate for compounded investments, e.g. a bond that accumulates yields over time which are paid at maturity.

However, other investments and types of projects may produce returns before the end of the projection. These returns would have to be accumulated to apply the above formula. This is often done in a rough way by using the sum of these returns as a total return in the last period. This approach does not take the value of time into account  note that a return in an earlier period is usually more valuable than one in a later period  and is therefore not recommended.

Calculating and considering the sum of the future values of each and every return at the end of the investment tenor is the more accurate alternative method. However, this requires further assumptions (i.e. the interest rate) and additional calculation efforts. Another more accurate technique is the internal rate of return (IRR) method.

Considerations when Calculating the Return on Investment

What Are the Types of Returns Considered for ROI?

All kinds of returns in the form of yields, benefits and inflows are basically taken into account when calculating the ROI.

For financial investments, this may include for instance:

  • interests,
  • dividend payments,
  • capital gains,
  • other positive financial inflows or gains.

The definition of returns in project management is not that straightforward though. The benefits of projects are often more complex than those of plain-vanilla financial instruments. They may consist of both qualitative and monetary benefits  examples are:

  • increased or newly produced earnings or revenue,
  • cash inflows,
  • cost savings due to efficiency gains implemented by a project,
  • appreciations of assets,
  • qualitative benefits converted into monetary equivalents.

If you are performing a cost-benefit analysis in the context of a project, you will want to be transparent (and seek stakeholders approval, if necessary) on the scope of benefits considered for your ROI assessment. You might also check existing requirements for profitability analyses and business case evaluations within the organization you are working for.

The same recommendation holds true for the question of whether taxes are to be taken into account. While some organizations and investors prefer including tax effects into an ROI calculation, others may separate those aspects to reduce complexity or allow for a more holistic assessment of tax effects.

Whichever scope of returns you are defining and using, make sure you are applying these criteria to all options you are comparing. This is to ensure a level playing field among the alternatives and ensure the comparability of your results.

What Are the Types of Cost and Investment Considered for ROI?

Similar to the considerations for the scope of returns, you will have to define the investment and cost that you include in your evaluation. For financial investments, you are probably able to determine the costs of incurring and managing an investment, besides the initial investment amount.

In projects, there is usually a distinction in different types of costs. Most fundamental is the decision on how direct and indirect costs are treated. Certain costs may be part of the investment  e.g. cost of resources used in a project  while other types such as operating cost of an asset might not be defined as part of the investment.

While this does not necessarily change the return amount which is a net return anyway, it will affect the denominator. The more cost types you include in your total investment amount, the lower the ROI value. When you compare different alternatives, you should therefore allocate cost types in a consistent manner and be aware of the effects it may have depending on the characteristics of the alternatives.

The ROI Calculator  Calculate the Return on Investment (Basic Concept)

Fill in the expected returns and the calculated investment. For the assumptions and components that need to be considered, refer to the previous section. The calculator will determine the basic ROI which can be used for single-period tenors or investment alternatives with an identical timeline.Payment options

Examples of Basic and Multiple Years ROI

Example 1) Investment with a Single Return at Maturity

In this example, a company is comparing 3 investment alternatives with different characteristics and returns. All three alternatives require an initial investment in year 0 (negative cash flow) and come with a single payment at maturity that consists of the repayment and the return.

The expected investments and repayments are as follows:Investment and Return ProjectionnowYear 1Year 2Year 3Alternative 1-1000013000Alternative 2-1200011000Alternative 3-1500017000

A calculation of the basic Return on Investment and the multi-year ROI leads to the following results:Calculation & ResultsAlternative 1Alternative 2Alternative 3Investment-10000-12000-15000Net returns3000-10002000Basic ROIROI = 3000 / 10000 = 30.00%ROI = -1000 / 12000 = -8.33%ROI = 2000 / 15000 = 13.33%Annualized return rr = 9.14%r = -2.86%r = 13.33%
(identical to basic ROI as tenor = 1 year)Calculation of annualized returnROI(3y) = (1 + 9.14%) ^ 3  1) = 30.00%ROI(3y) = (1 + -2.86%) ^ 3  1) = -8.33%ROI(1y) = (1 + 13.33%) ^ 1  1) = 13.33%

The alternatives 1 and 2 are both repaid in period 3. Thus, the basic ROI would be sufficient to compare these two alternatives. Alternative 1 with a total return of 30% is more beneficial (without prejudice to other decision criteria) than alternative 2 that produces a negative return (i.e. a loss) of 8.33%.

If alternative 3 is included in the comparison, the multiple-period ROI needs to be used to consider the different tenors. Using the annualized return as the only criterion, alternative 3 would be the most profitable investment (with 13.33% annualized return compared to 9.14% and -2.86% for alternatives 1 and 2, respectively).

Example 2) Use of Single- and Multi-Period ROI to Compare Project Options

In this example, three project options are compared with each other. These numbers have been used for other investment evaluation approaches as well  refer to our cost-benefit analysis overview to learn more details as well as the results of other methods.

Cash Flow Projections

The cash flow projections and classification of investment and operational cost is as follows:Option 1NowYear 1Year 2Year 3Year 4Year 5Year 6Investment and Cost (outflows)-5000-5000-1000-500-500-1000-1000of which: investment-5000-4000of which: cost0-1000-1000-500-500-1000-1000Benefits and Earnings (inflows)0030005000500040004000Net Cash Flow-5000-500020004500450030003000Option 2NowYear 1Year 2Year 3Year 4Year 5Year 6Investment and Cost (outflows)-15000-1000-1000-1000-500-500-1000of which: investment-15000of which: cost0-1000-1000-1000-500-500-1000Benefits and Earnings (inflows)0250050005000500050005000Net Cash Flow-15000150040004000450045004000Option 3NowYear 1Year 2Year 3Year 4Year 5Year 6Investment and Cost (outflows)-3000-3000-2500-1000-500-500-500of which: investment-3000-2500-2000-500of which: cost0-500-500-500-500-500-500Benefits and Earnings (inflows)0030004000400030003000Net Cash Flow-3000-30005003000350025002500

ROI Calculation for these Examples

The ROI calculation and the resulting ROIs for these examples are summarized in the following table:Calculation and ResultsOption 1Option 2Option 3Total Investment-9000-15000-8000Total net returns700075006000Basic ROIROI = 7000 / 9000 = 77.78%ROI = 7500 / 15000 = 50.00%ROI = 6000 / 8000 = 75.00%Annualized return ROI (r)r = 10.06%r = 6.99%r = 9.78%Calculation of annualized ROI(1 + r) ^ 6  1 = 77.78%(1 + r) ^ 6  1 = 50.00%(1 + r) ^ 6  1 = 75.00%CheckROI(6y) = (1 + 10.06%) ^ 6  1) = 77.78%ROI(6y) = (1 + 6.99%) ^ 6  1) = 50.00%ROI(6y) = (1 + 9.78%) ^ 6  1) = 75.00%

Interpretation of Results

Comparing the ROIs of the 3 project options reveals a minor advantage of option 1 over option 3 while option 2 looks much less appealing. As the projections of all options have a time horizon of 6 years, a ranking based on the annualized return would lead to the same result (unless returns were compounded).

Considering the characteristics of the 3 cash flow projections, the use of the ROI methods for this example is not ideal. Inflows and outflows differ significantly among the options and periods. Thus, an assessment based on a more accurate method (see alternative methods section below) is more appropriate.

What Are the Advantages and Disadvantages of the ROI?

While the return on investment is a popular and widespread measure, it comes with a number of pros and cons described below. As important as the fundamental advantages and disadvantages of this technique is the way the ROI is used in your analysis. MIT Sloan Review points out that the biggest challenge with ROI isnt a technical deficiency but confusion over how it is used (source).

Pros

  • Ideal for investments with a single return,
  • common easy to understand success measure,
  • makes options with different investment amounts comparable,
  • the modified formula can be used for multi-year returns.

Cons

  • ROI calculation may require several assumptions and definitions, e.g. scope of returns, cost, and investment,
  • these assumptions may have a strong impact on the results,
  • inaccurate results if returns occur at different periods,
  • basic approach not suitable for multi-year investments and endeavors,
  • qualitative returns need to be converted into monetary values (which requires further assumptions).

Alternative Measures

For use in project management, there are various alternatives to an ROI. These include payback period, benefit-cost ratio, net present value and internal rate of return. Each of these success measures comes with its respective advantages and disadvantages.

Read our overview of cost-benefit analysis methods to get a full comparison of these approaches:

Cost-Benefit Analysis for Business Cases (Definition, Steps, Example)

Conclusion

Return on Investment is a common indicator to measure the profitability of investments and projects, While it can help achieve comparability of different alternatives, it requires some assumptions that may impact the results significantly. Being transparent and applying them in a consistent manner is key to ensure the comparability of the results across different options.

If you are working on a cost-benefit analysis, you should try not to rely on the results of only one success measure. Read more about the various methods to evaluate different project options and use a set of measures that fits best for your assessment.

Video liên quan