Return on investment (ROI) is the key measure of the profit derived from any investment. It is a ratio that compares the gain or loss from an investment relative to its cost. It is useful in evaluating the current or potential return on investment, whether you are evaluating your stock portfolio's performance, considering a business investment, or deciding whether to undertake a new project.
In business analysis, ROI and other cash flow measures—such as internal rate of return (IRR) and net present value (NPV)—are key metrics that are used to evaluate and rank the attractiveness of a number of different investment alternatives.
Although ROI is a ratio, it is typically expressed as a percentage rather than as a ratio.
- Return on investment (ROI) is an approximate measure of an investment's profitability.
- ROI is calculated by subtracting the initial cost of the investment from its final value, then dividing this new number by the cost of the investment, and finally, multiplying it by 100.
- ROI has a wide range of uses. It can be used to measure the profitability of stock shares, to decide whether to purchase a business, or to evaluate the success of a real estate transaction.
- One disadvantage of ROI is that it doesn't account for how long an investment is held.
How to Calculate ROI in Excel
How to Calculate Return on Investment (ROI)
ROI can be calculated using either of two methods.
ROI= Cost of InvestmentNet Return on Investment×100%
ROI=Cost of InvestmentFVI−IVI×100%where:FVI=Final value of investmentIVI=Initial value of investment
When interpreting ROI calculations, it's important to keep a few things in mind. First, ROI is typically expressed as a percentage because it is intuitively easier to understand than a ratio. Second, the ROI calculation includes the net return in the numerator because returns from an investment can be either positive or negative.
When ROI calculations yield a positive figure, it means that net returns are in the black (because total returns exceed total costs). But when ROI calculations yield a negative figure, it means that the net return is in the red because total costs exceed total returns.
Finally, to calculate ROI with the highest degree of accuracy, total returns and total costs should be considered. For an apples-to-apples comparison between competing investments, annualized ROI should be considered.
The ROI formula can be deceptively simple. It depends on an accurate accounting of costs. That's easy in the case of stock shares, for example. But it is more complicated in other cases, such as calculating the ROI of a business project that is under consideration.
Assume an investor bought 1,000 shares of the hypothetical company Worldwide Wickets Co. at $10 per share. One year later, the investor sold the shares for $12.50. The investor earned dividends of $500 over the one-year holding period. The investor spent a total of $125 on trading commissions in order to buy and sell the shares.
The ROI for this investor can be calculated as follows:
Here is a step-by-step analysis of the calculation:
- To calculate net returns, total returns and total costs must be considered. Total returns for a stock result from capital gains and dividends. Total costs include the initial purchase price and any trading commissions paid.
- In the above calculation, the gross capital gain (before commissions) from this trade is ($12.50 - $10.00) x 1,000. The $500 amount refers to the dividends received by holding the stock, while $125 is the total commissions paid.
If you further dissect the ROI into its component parts, it is revealed that 23.75% came from capital gains and 5% came from dividends. This distinction is important because capital gains and dividends are taxed at different rates.
ROI=Capital Gains%−Commission%+Dividend Yield
Capital Gains=($2500÷$10,000)×100=25.00%Commissions=($125÷$10,000)×100=1.25%Dividend Yield=($500÷$10,000)×100=5.00%ROI=25.00%−1.25%+5.00%=28.75%
A positive ROI means that net returns are positive because total returns are greater than any associated costs. A negative ROI indicates that the total costs are greater than the returns.
An Alternative ROI Calculation
If, for example, commissions were split, there is an alternative method of calculating this hypothetical investor's ROI for the Worldwide Wickets Co. investment. Assume the following split in the total commissions: $50 when buying the shares and $75 when selling the shares.
IVI=$10,000+$50=$10,050FVI=$12,500+$500−$75FVI=$12,925ROI=$10,050$12,925−$10,050×100ROI=28.75%where:IVI=Initial value (cost) of investmentFVI=Final value of investment
Annualized ROI helps account for a key omission in standard ROI—namely, how long an investment was held.
The annualized ROI calculation provides a solution for one of the key limitations of the basic ROI calculation. The basic ROI calculation does not take into account the length of time that an investment is held, also referred to as the holding period. The formula for calculating annualized ROI is as follows:
Annualized ROI=[(1+ROI)1/n−1]×100%where:n=Number of years investment is held
Assume a hypothetical investment that generated an ROI of 50% over five years. The simple annual average ROI of 10%–which was obtained by dividing ROI by the holding period of five years–is only a rough approximation of annualized ROI. This is because it ignores the effects of compounding, which can make a significant difference over time. The longer the time period, the bigger the difference between the approximate annual average ROI, which is calculated by dividing the ROI by the holding period in this scenario, and annualized ROI.
From the formula above,
This calculation can also be used for holding periods of less than a year by converting the holding period to a fraction of a year.
Assume an investment that generated an ROI of 10% over six months.
In the equation above, the numeral 0.5 years is equivalent to six months.
Comparing Investments and Annualized ROI
Annualized ROI is especially useful when comparing returns between various investments or evaluating different investments.
Assume that an investment in stock X generated an ROI of 50% over five years, while an investment in stock Y returned 30% over three years. You can determine what the better investment was in terms of ROI by using this equation:
AROIx=[(1+0.50)1/5−1]×100=8.45%AROIy=[(1+0.30)1/3−1]×100=9.14%where:AROIx=Annualized ROI for stock XAROIy=Annualized ROI for stock Y
According to this calculation, stock Y had a superior ROI compared to stock X.
Combining Leverage With ROI
Leverage can magnify ROI if the investment generates gains. By the same token, leverage can amplify losses if the investment proves to be a losing investment.
Assume that an investor bought 1,000 shares of the hypothetical company Worldwide Wickets Co. at $10 per share. Assume also that the investor bought these shares on a 50% margin (meaning they invested $5,000 of their own capital and borrowed $5,000 from their brokerage firm as a margin loan).
Exactly one year later, this investor sold the shares for $12.50. The shares had earned dividends of $500 over the one-year holding period. The investor also spent a total of $125 on trading commissions when buying and selling the shares.
The calculation must also account for the cost of buying on margin. In this example, the margin loan carried an interest rate of 9%.
When calculating the ROI on this example, there are a few important things to keep in mind. First, the interest on the margin loan ($450) should be considered in total costs. Second, the initial investment is now $5,000 because of the leverage employed by taking the margin loan of $5,000.
Thus, even though the net dollar return was reduced by $450 on account of the margin interest, ROI is still substantially higher at 48.50% (compared with 28.75% if no leverage was employed).
As another example, consider if the share price fell to $8.00 instead of rising to $12.50. In this situation, the investor decides to take the loss and sell the full position.
Here is the calculation for ROI in this scenario:
In this case, the ROI of -41.50% is much worse than an ROI of -16.25%, which would have occurred if no leverage had been employed.
The Problem of Unequal Cash Flows
When evaluating a business proposal, it's possible that you will be contending with unequal cash flows. In this scenario, ROI may fluctuate from one year to the next.
This type of ROI calculation is more complicated because it involves using the internal rate of return (IRR) function in a spreadsheet or calculator.
Assume you are evaluating a business proposal that involves an initial investment of $100,000. (This figure is shown under the "Year 0" column in the Cash Outflow row in the following table.)
The investment will generate cash flows over the next five years; this is shown in the Cash Inflow row. The row called Net Cash Flow sums up the cash outflow and cash inflow for each year.
Using the IRR function, the calculated ROI is 8.64%.
The final column shows the total cash flows over the five-year period. Net cash flow over this five-year period is $25,000 on an initial investment of $100,000. If this $25,000 was spread out equally over five years, the cash flow table would then look like this:
In this case, the IRR is now only 5.00%.
The substantial difference in the IRR between these two scenarios—despite the initial investment and total net cash flows being the same in both cases—has to do with the timing of the cash inflows. In the first case, substantially larger cash inflows are received in the first four years. Considering the time value of money, these larger inflows in the earlier years have a positive impact on IRR.
Advantages of ROI
The biggest benefit of ROI is that it is a relatively uncomplicated metric. It is easy to calculate and intuitively easy to understand.
Due to its simplicity, ROI has become a standard, universal measure of profitability. As a measurement, it is not likely to be misunderstood or misinterpreted because it has the same connotations in every context.
Disadvantages of ROI
There are some disadvantages to the ROI measurement. First, it does not take into account the holding period of an investment, which can be an issue when comparing investment alternatives.
For example, assume investment X generates an ROI of 25%, while investment Y produces an ROI of 15%. One cannot assume that X is the superior investment unless the time frame of each investment is also known. It's possible that the 25% ROI from investment X was generated over a period of five years, while the 15% ROI from investment Y was generated in only one year.
Calculating annualized ROI can overcome this hurdle when comparing investment choices.
No Risk Adjustment
A second disadvantage of ROI is that it does not adjust for risk.
Investment returns have a direct correlation with risk: the higher the potential returns, the greater the possible risk. This can be observed firsthand in the stock market, where small-cap stocks are likely to have higher returns than large-cap stocks but also are likely to have significantly greater risks.
An investor who is targeting a portfolio return of 12%, for example, would have to assume a substantially higher degree of risk than an investor whose goal is a return of 4%. If that investor hones in on the ROI number without also evaluating the associated risk, the eventual outcome may be very different from the expected result.
Some Costs May Be Omitted
ROI figures can be inflated if all possible costs are not included in the calculation. This can happen deliberately or inadvertently.
For example, in evaluating the ROI on a piece of real estate, all associated expenses should be considered. These include mortgage interest, property taxes, and insurance. They also include maintenance costs, which can be unpredictable.
These expenses can subtract from the expected ROI. Without including all of them in the calculation, the ROI figure may be grossly overstated.
Some Issues May Be Ignored
Finally, like many profitability metrics, ROI considers only financial gains when evaluating the returns on an investment. It does not consider ancillary benefits, such as social or environmental costs.
A relatively new ROI metric, known as social return on investment (SROI), helps to quantify some of these benefits for investors.
Frequently Asked Questions
What Is ROI?
Return on investment, or ROI, is a straightforward measurement of the bottom line. How much profit (or loss) did an investment make after considering its costs?
ROI is used for a wide range of business and investing decisions. It can be used to calculate the actual returns on an investment, to project the potential return on a new investment, or to compare the potential returns on a number of investment alternatives.
For example, if a business owner is considering expanding into a new product line, the ROI formula can be used to chart out its costs and estimate its potential returns. If an entrepreneur is evaluating a new project, an ROI calculation can help determine if the likely return is worth the expense. If an investor is evaluating past or future stock purchases, the ROI formula is a quick indicator of real or potential stock performance.
How Is Return on Investment (ROI) Used?
ROI is a straightforward method of calculating the return on an investment. It can be used to measure profit or loss on a current investment or to evaluate the potential profit or loss of an investment that you are considering making.
Keep in mind that ROI omits a key factor: the length of time that it took to earn that profit (or make that loss). Obviously, a stock that makes a 10% return in one year is preferable to a stock that makes a 10% return in four years.
For this reason, the formula for annualized return on investment may be a better choice than the basic formula for return on investment. (Both are shown above.)
How Do You Calculate ROI for Real Estate?
The return on investment (ROI) formula remains the same whether you're evaluating the performance of a single stock or considering the potential profit of a real estate investment. (See formula above.)
Some investments are more complicated to evaluate than others, though, particularly when it comes to costs. A ROI on a real estate investment must include all of the potential costs that may be involved, including such matters as maintenance, repairs, insurance, and lost rental income.
The Bottom Line
Return on investment (ROI) is a simple and intuitive metric of the profitability of an investment. There are some limitations to this metric, including the facts that it does not consider the holding period of an investment and is not adjusted for risk. Despite these limitations, ROI is a key metric used by business analysts to evaluate and rank investment alternatives.