1

I'm new to investing and want to know, how to calculate a future value of my investments. Let's see an example:

  • I can buy every year SPY ETFs for 10k for 10 years from now
  • What will be the FV of my investments if the SPY's performance for 10 years will be exactly like it was the last 10 years:

enter image description here * Image source: https://www.etf.com/SPY#overview

What I'm struggling with, is what percent should I add to rate parameter inside FV formula. Is it 7.72% or something else?

Improve this question
3
  • Is your question about the equation and how to use it, or is the question really “I know how to use the function FV, but what return should I use in that field?”
    – JTP - Apologise to Monica ♦
    Oct 27, 2018 at 16:56
  • I don't know if the FV is good for this, since the return can change.
    – Runtime Terror
    Oct 27, 2018 at 20:05
  • Right. It’s tough to get my head around what, exactly, you are asking. You can set up multiple scenarios. Ranging say, from 6% to 12%, and see the different results. But any given equation is going to need one variable to give you the result.
    – JTP - Apologise to Monica ♦
    Oct 27, 2018 at 20:27

1 Answer 1

Reset to default
3

Since the 10 year annualised performance figure is calculated from the largest sample there is some reason to use that as your return. However, that time range includes an unusual market condition, the recovery from the 2008 crash. The three year range would be more reflective of current market conditions and would be a more sensible choice.

=FV(0.1135,10,10000,0,1)

189366.95

d = 10000
n = 10
r = 0.1135

fv = (d (1 + r) ((1 + r)^n - 1))/r = 189366.95

Nevertheless, since you write, "if the SPY's performance for 10 years will be exactly like it was the last 10 years", then you are basically saying you should use the 10 year annualised figure: 14.34%

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .