expected return calculator, formula

Expected return calculator and formula

When evaluating an asset’s past performance, we can make use of the historical (or realized) average return. In that sense, the historical average return is a backward-looking measure. But, in order to forecast an asset’s future performance, we need a forward-looking measure. This measure is called the expected return. In this post, we offer an easy-to-use expected return calculator and explain the formula as well.

Expected return calculator

expected return calculator

When using our expected return calculator below, please pay attention to the following points:

  • Please ensure the probabilities add up to 100% (the sum of the probabilities is given in the final row).
  • If your calculation requires, say, 3 states only, simply leave 0s in the fields involving the states 4, 5, and 6.
  • Returns can be positive, negative, or zero.

You may also find the following calculators useful:

Expected return formula

Formally, the expected return formula can be written as follows:

expected return formula

This means that E[R] is a probability-weighted average of all possible return outcomes where pi is the probability of the ith state and Ri is the risky asset’s return under state i.

Let us illustrate the use of this formula with an example (see also the video above). Hillary has savings worth $5,000 and is considering investing in the U.S. stock market. She believes that the probabilities that the market will be in a “good state” and “bad state” next year are 60% and 40%, respectively.

Hillary is interested in a specific stock that is expected to go up by 10% when the market is in the good state and down by −5% when the market is in the bad state. Using the expected return formula, Hillary finds that:

E[R] = 60% * (+10%) + 40% * (−5%) = 4%

This means that if Hillary invests $5,000 in the stock today, the expected value of her investment in one year’s time is:

$5,000 * (1 + 4%) = $5,200

What if there were three possible states instead of two as follows?

StateProbabilityReturn
150%+10%
230%−5%
320%2%

Then, we would have:

E[R] = 50% * (+10%) + 30% * (−5%) + 20% * (2%) = 3.9%

And, we would expect the value of the $5,000 investment to become $5,000 * (1 + 3.9%) = $5,195 after a year.

Of course, these are stylized examples. In reality, there are not just two or three possible outcomes but many of them, and it is difficult to know the probability associated with each outcome. And, because of that, we normally rely on asset pricing models such as CAPM and APT to estimate expected returns. We will be covering these models in the final part of this course.

Video Summary

Summary

In this lesson, we have shown that the expected return formula is based on (i) the asset’s returns under different states of the market, and (ii) the probabilities of those states occurring and that it is a forward-looking measure. We have also offered a handy expected return calculator, which can accommodate up to six different states.

Further reading on the expected return calculator and formula

Black (1993), ‘Estimating expected return‘, Financial Analysts Journal, Vol. 49(5), pp. 36-38.

What is next?

This lesson is part of our free course on investments.

We hope you find our expected return calculator useful. If that is the case, feel free to share this post with others on social media or other platforms.

If you have got any questions or comments, you can reach us here.