arithmetic and geometric sequences calculator

#Arithmetic and geometric sequences calculator how to#

Let’s look a the S&P 500 actual returns (including dividends):Īrithmetic Average S&P 500 Total Returns (2000 thru 2015) The correct calculation, or your actual return, would be 1.98%. An investment manager or mutual fund will probably quote the 5.0% return. The average investor is often misled by the media and institutions which incorrectly use the arithmetic average return. This is an easy way to get a your result. If you don’t have a finance calculator you can use a Geometric Mean Calculator and just plug in the numbers. Raise the answer to the power of one divided by the count of the numbers in the sequence.Įxample: -1 =. This is to avoid problems with negative numbers.ģ. First add 1 to each number in the sequence.

#Arithmetic and geometric sequences calculator how to#

This is how to figure geometric average with a finance calculator:ġ. The geometric average of the same numbers is quite different. Lets say we have 6 year sequence of investment returns as follows: +30%, -20%, +30%, -20%, +30%, and -20%.Īn arithmetic average is simply the sum of all the terms (numbers) divided by the count of that sequence.Įxample: (0.30 + (-.20) + 0.30 + (-.20) + 0.30 + (-.20) / 6 =. The arithmetic average is not reality! The geometric average (I will show you how to do this shortly) will provide the actual results: The 50% decline will then bring their capital down to $75. A 50% increase on $100 brings them to $150. If the order of the returns are reversed the results are the same. A 50% increase only brings them back t0 $75. In reality they have lost 25% of their capital! If an investor starts with $100 and losses 50% they now have $50. Many people mistakenly believe they are at break even. It does not matter the order, the results are the same.Īrithmetic Average = (. Here is a simple example to illustrate how volatility lowers your investment returns.Įxample: A 50% gain and a 50% loss. When calculating investment returns the only time an arithmetic average will be accurate is when there is no volatility (i.e.

This is because through compounding each successive term is dependent on the previous outcome.

Investment average returns must be figured as a geometric average in order to be accurate. In other words the ratio between each chronological term in the sequence is the same.Įxample: 50, 100, 200, 400, 800 (common ratio is 2)

Or 25, 20, 15, 10, 5 (common difference is -5) Geometric Sequences In other words the same value is added or subtracted from term to term.Įxample: 1, 3, 5, 7, 9, 11 (common difference is +2) Arithmetic SequencesĪrithmetic sequences have a common difference. What are Arithmetic and Geometric Sequences?Ī sequence is a group of numbers, called terms, arranged in a specific order.