Hi
I have a target FV and want to calculate the initial payment when the payment increases by inflation rate. What formula can I use (I currently do a goal seek). I use Excel 2000 and 2002.
Example:
I need 2 million in 10 years time and the inflation rate is 6% and investment growth rate is 10%.
What amount do I need to invest in year 1 to have 2000 000 after 10 years? (That is what I want to calculate).
Thanks!
Piet
I have a target FV and want to calculate the initial payment when the payment increases by inflation rate. What formula can I use (I currently do a goal seek). I use Excel 2000 and 2002.
Example:
I need 2 million in 10 years time and the inflation rate is 6% and investment growth rate is 10%.
What amount do I need to invest in year 1 to have 2000 000 after 10 years? (That is what I want to calculate).
Thanks!
Piet