The basic idea behind investing is finding ways for your money to earn you even more money. Getting your money to do work for you? Yes, please.
But how do you figure out how much your investment is going to make you?
The money that you earn on an investment is known as your return. The rate of return is the pace at which money is earned or lost on an investment.
If you’re going to invest, you may want to consider how much money that investment is likely to earn you. Though it’s not possible to predict the future, having some idea of what to expect can be critical in setting expectations on what’s a good return on investment.
How to Calculate Rate of Return on Stocks
Here’s the rate of return (ROR) formula:
Rate of return = [(Current value − Initial value) ÷ Initial Value ] × 100
Let’s say you own a share that started at $100 in value and rose to $110 in value. Now, you want to find its rate of return.
In our example, the calculation would be [($110 – $100) ÷ $100] x 100 = 10
A rate of return is typically expressed as a percentage of the investment’s initial cost. So, if you were to sell your share, this investment would have a 10% rate of return.
How To Calculate Expected Return
Expected return (also referred to as “expected rate of return”) is the profit or loss one may expect to see from an investment.
To calculate the expected rate of return on a stock, you need to think about the different scenarios in which the stock could see a gain or loss. For each scenario, multiple that amount of gain or loss (return) by the probability of it happening. Finally, add up the numbers you get from each scenario after multiplying the returns by the probabilities.
The formula for expected rate of return looks like this:
Expected Return = (Return A X Probability A) + (Return B X Probability B)
(Where A and B indicate a different scenario of return and probability of that return.)
For example, you might say that there is a 50% chance the investment will return 20% and a 50% chance that an investment will return 10%. (Note: All the probabilities must add up to 100%.)
Next, multiply each scenario’s probability percentage by the investment’s expected return for that period.
Expected Return = (50% X 20%) + (50% X 10%)
Then, add those numbers together.
Expected Return = 10% + 5% = 15%
The expected rate of return is the return an investor expects from an investment, given either historical rates of return or probable rates of return under different scenarios. The expected return formula projects potential future returns.
To determine the expected rate of return based on historical data, it can be helpful by starting with calculating the average of the historical return for that investment. More on this calculation below.
This strategy may be useful when there is a robust pool of historical data on the returns of that particular asset type, but remember that past performance is far from a guarantee of future performance.
Calculate Expected Rate of Return on a Stock in Excel
Follow these steps to calculate a stock’s expected rate of return in Excel:
1. In the first row, enter column labels:
• A1: Investment
• B1:Gain A
• C1: Probability of Gain A
• D1: Gain B
• E1:Probability of Gain B
• F1: Expected Rate of Return
2. In the second row, enter your investment name in B2, followed by its potential gains and probability of each gain in columns C2 – E2*
• Note that the probabilities in C2 and E2 must add up to 100%
3. In F2, enter the formula =B2*C2+D2*E2
4. Press enter, and your expected rate of return should now be in F2
If you’re working with more than two probabilities, simply extend your columns to include Gain C, Probability of Gain C, Gain D, Probability of Gain D, etc.
If there’s a possibility for loss, that would be negative gain, represented as a negative number in cells B2 and/or D2.
How to Calculate Expected Return Using Historical Data
To calculate the expected return using historical data, you’ll want to take an average of each outcome. Here’s an example of what that would look like.
In this example, the average rate of return is 9%. When using historical data, you may want to consider your pool of data. Are you using all of the data available? Or only data from a select period? If you are only using some data and not others, why?
How to Calculate Expected Return Based on Probable Returns
When using probable rates of return, you’ll need the additional data point of the expected probability of each outcome. Remember, the probability column must add up to 100%. Multiply the return by the probability and add the outcomes together to get the expected rate of return. Here’s an example of how this would look.
Using the formula above, in this hypothetical example, the expected rate of return is 9.7%.
Limitations of the Expected Returns Formula
Having historical data can be a good place to start in your journey of understanding how an investment behaves. That said, investors may want to be leery of extrapolating past returns for the future. Historical data is a guide, it’s not necessarily predictive.
Another limitation to the expected returns formula is that it does not take into account the risk involved by investing in a particular asset class. After all, investing can be inherently risky.
And risk and return are often two sides of the same coin. In order to achieve a higher rate of return, you’ll most likely have to take more risk. The risk involved in an investment is not represented by its expected rate of return.
Look at the first example. In this example, which uses historical returns, 9% is the expected rate of return. What that number doesn’t reveal is the risk taken in order to achieve that rate of return. The investment experienced negative returns in the years 2005, 2006, 2012, and 2014. The variability of returns is often called volatility.
Sometimes, investment risks and managing them come with the possibility of losing money. Knowing this, it might be misguided to assume that 9% annual returns were going to show up as positive 9% returns each and every year. To achieve 9% average returns, there must be some risk involved.
Systematic and Unsystematic Risk
All investments are subject to pressures in the market. These pressures, or sources of risk, can come in the form of systematic and unsystematic risk. Systematic risk affects an entire investment type. Within that investment category, it probably can’t be “diversified” away.
Because of systematic risk, you may want to consider building an investment strategy that includes different asset types. For example, a sweeping stock market crash could affect all or most stocks and is, therefore, a systematic risk.
In the stock market, unsystematic risk is risk that’s specific to one company, country, or industry. For example, technology companies will face different risks than healthcare companies and energy companies. This type of risk can be mitigated with portfolio diversification, the process of purchasing different types of investments.
To be a savvy investor, it’s helpful to understand the risks involved with each asset class you’re looking to invest in. One way is to consider the standard deviation of an investment. Standard deviation measures volatility by calculating the dispersion (values’ range) of a dataset relative to its mean. The larger the standard deviation, the larger the range of returns.
Consider two different investments. Investment A has an annual return of 9%, and Investment B has an annual return of 6%. But when you look at the year by year performance, you’ll notice that Investment A experienced significantly more volatility. There are years where returns are much higher and lower than with Investment B.
|Year||Investment A||Investment B|
On Investment A, the standard deviation is 16%. On Investment B, the standard deviation is 6%. Although Investment A has a higher rate of return, there is more risk. Investment B has a lower rate of return, but there is less risk. Investment B is not nearly as volatile as Investment A.
Expected Rate of Return vs Required Rate of Return
The required rate of return is a concept in corporate finance. It’s the amount of money, or the proportion of money received back from the money invested, that a project needs to generate in order to be worth it for the investor or company doing it.
This matters for investors because it’s a way of thinking about the relationship between the risk of an investment and the potential profitability or return that can be garnered from it. For the investor, the required rate of return can be applied to stocks.
What is the Dividend-Discount Model?
There are different ways of calculating the required rate of return for stocks.
One is the “dividend-discount model,” which can be used for stocks that pay out high dividends and have steady growth. In this model you get the stock’s value by dividing annual expected dividends by the required rate of return minus the dividend growth rate. By moving around the terms, you can find the required rate of return by dividing the dividend payments by the stock price and adding the growth of dividends.
So, if you have a stock paying $2 in dividends per year and is worth $30 and the dividends are growing at 2% a year, you have a required rate of return of:
$2/30 + .05,
.066 + .05
For a required rate of return of 11.67%
What is the Capital Asset Pricing Model?
The other way of calculating the required rate of return is using a more complex model known as the “capital asset pricing model.”
In this model, the required rate of return is equal to the “risk free rate” plus what’s known as “beta” (the stock’s volatility, or its change in price, compared to the market) which is then multiplied by the market rate of return minus the risk free rate.
For the risk free rate, we can take the yield on 10-year Treasuries, which is about 1% or .01, a beta of 1.5, and the market rate of return of 5% or .05.
So using the formula, the required rate of return would be:
RRR = .01 + 1.5 x (.05 – .01)
RRR = .01 + 1.5 x (.04)
RRR = .01 + .06
RRR = .07, or 7%
What is the Real Rate of Return (RoR)?
Another important formula to know is the “real rate of return.” What makes the real rate of return distinct from other formulas is how it takes into account inflation. This matters because the reason to invest in assets like stocks, bonds, property and so on is to generate money to buy things — and if the cost of things is going up faster than the rate of return on your investment, then the “real” rate of return is actually negative.
This is especially important for low risk investments in things like money market mutual funds or bonds, which are supposed to pay out steadily and provide cash flow, as opposed to stocks which typically are valuable for how the stocks themselves go up in price.
The rate of return is the conversion between the present value of something from its original value converted into a percentage. The formula is simple: It’s the current or present value minus the original value divided by the initial value, times 100. This expresses the rate of return as a percentage.
To understand the real rate of return, we must first understand what the simple or nominal rate of return is. You have to first be able calculate this before moving on to the real rate of return.
Real Rate of Return (RoR) vs Nominal Rate of Return (RoR)
What we calculated above was the “simple” or “nominal rate of return,” a measure of how much the value of something has grown over time compared to when it was purchased.
Another way of thinking of rates of return is on assets that generate interest or yield. A certificate of deposit that pays 3% has a 3% simple or nominal rate of return. But then there’s inflation.
This formula is (1 + the nominal rate)/(1 + inflation rate) -1
So in our example of a 3% yielding CD and a 2% inflation rate, the real rate of return would be
(1+.03)/(1+.02) – 1
.98% = real rate of return
Real Rate of Return (RoR) vs. Compound Annual Growth Rate (CAGR)
If the real rate of return is a way to compare the value of an investment from when purchased to a given point of time, the compound annual growth rate is a way of measuring how much the investment has grown on average per year.
This can be useful because it’s a way of comparing investments over annual timespans. This is useful because typically investments are thought of as being held over a given time period and you want to compare which investment is most appropriate or will generate the biggest gains.
The compound annual growth rate does not tell you how much an investment’s value has grown in a given year, but it does give you a basis of comparison. Another assumption of the compound annual growth rate is that any profits from the investment are re-invested.
The formula for the compound annual growth rate is:
CAGR = (present or final value/starting or initial value)^1/n – 1, where n is the number of years.
So let’s look at a stock which you purchased for $50 in 2008 and has now grown to $200 in 2020. The simple rate of return for this stock would be 300%, which sounds impressive. But let’s look at its compound annual rate of return.
CAGR = (200/50)^1/12 – 1
CAGR = 4^.0833 – 1
This 12.25% seems more modest than the 300% rate of return, but it’s useful to compare to other annual rates of returns, like from the market as a whole, from treasury bonds, dividend-stocks and more.
Consider a Diversified Investment Portfolio
Once you’ve done your research on the risk and return characteristics of the different asset classes, you may feel ready to start investing.
If your goal is to build an investment portfolio, you may want to consider diversifying. Diversification is the process of buying assets that are hopefully non-correlated; the performance of one is not necessarily related to the performance of the other. For example, you could build a portfolio of stocks and bonds, two non-correlated asset classes.
To do this, you can buy stocks and bonds directly, or you can buy them within funds. Funds can provide a way to achieve a diversified portfolio because they bundle many different investments together.
One fund could hold hundreds or even thousands of stocks, bonds, or other investments. For example, an S&P 500 index fund invests in the 500 leading companies in the United States. But the variety of funds doesn’t stop there. There are funds that invest in countries and industries all over the globe.
With SoFi Invest®, you can keep costs such as transaction costs and account fees low in order to build out your portfolio—whether you want to buy stocks or exchange-traded funds (ETFs). If you would like help creating an investment portfolio, SoFi Automated Investing uses a portfolio of ETFs based on your goals, risk tolerance, and projected timeline.
The information provided is not meant to provide investment or financial advice. Investment decisions should be based on an individual’s specific financial needs, goals and risk profile. SoFi can’t guarantee future financial performance. Advisory services offered through SoFi Wealth, LLC. SoFi Securities, LLC, member FINRA / SIPC . SoFi Invest refers to the three investment and trading platforms operated by Social Finance, Inc. and its affiliates (described below). Individual customer accounts may be subject to the terms applicable to one or more of the platforms below.
1) Automated Investing—The Automated Investing platform is owned by SoFi Wealth LLC, an SEC Registered Investment Advisor (“Sofi Wealth“). Brokerage services are provided to SoFi Wealth LLC by SoFi Securities LLC, an affiliated SEC registered broker dealer and member FINRA/SIPC, (“Sofi Securities).
2) Active Investing—The Active Investing platform is owned by SoFi Securities LLC. Clearing and custody of all securities are provided by APEX Clearing Corporation.
3) Cryptocurrency is offered by SoFi Digital Assets, LLC, a FinCEN registered Money Service Business.
For additional disclosures related to the SoFi Invest platforms described above, including state licensure of Sofi Digital Assets, LLC, please visit www.sofi.com/legal. Neither the Investment Advisor Representatives of SoFi Wealth, nor the Registered Representatives of SoFi Securities are compensated for the sale of any product or service sold through any SoFi Invest platform. Information related to lending products contained herein should not be construed as an offer or pre-qualification for any loan product offered by SoFi Lending Corp and/or its affiliates.
Investment Risk: Diversification can help reduce some investment risk. It cannot guarantee profit, or fully protect in a down market.
Disclaimer: The projections or other information regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect actual investment results, and are not guarantees of future results.