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?

  • 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?” – JoeTaxpayer Oct 27 '18 at 16:56
  • I don't know if the FV is good for this, since the return can change. – Gabriel Oct 27 '18 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. – JoeTaxpayer Oct 27 '18 at 20:27
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%

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.