I need to calculate the total tuition to estimate the needed savings. That is, the tuition -now- is 10.000€, the estimated inflation is 2%. How much tuition is going to be paid in 10 years during four years?
Using the trick described here, I can obtain the correct amount... in Excel.
{=SUM(Tuition*(1+Inflation)^ROW(OFFSET(A1;YearsToTuition;0):OFFSET(A1;YearsToTuition+YearsofTuition;0)))}
Now, the thing is, this has to work in Apple Numbers and I don't know if that'll work.
So, the question is whether there's another form to implement this in Excel.
Edit: I use Excel, my client uses Numbers.
Edit: I ended up using the FV function as proposed by thecraw.
=FV(Inflation;YearsofTuition;-Tuition*(1+Inflation)^YearsToTuition)
Not sure but is the question you are asking the following.
I want to calculate a total amount of savings that I need today that will be pay for 4 years of tuition which I will start in 10 years. The cost today is 10,000 a year inflation is 2% per year.
If this is the question you could do it with 4 cells in numbers or excel by using the formulae =(10000×(1.02^10))for the first year change the 10 to 11 for the second year etc. This will give you 12189 for first year 12433 for second 12682 3 year and 12936 for the last year as the tuitions starting 10 years down the road. So if I have understood what you are trying to do, today you would 50242 to pay for this but that is assuming you are getting 0 return on this money for the 10 years and you just have it sitting there making nothing to pay for this. Anyway my best guess as to what you were asking.