Calculating Initial Payment - Excell

Joined
Jun 27, 2010
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top