Calculating Initial Payment - Excell

pietm3

New Member

Join Date: Jun 2010

Posts: 1

27th Jun 2010

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

« Excel sort dialog box: Display of column header instead of columnname | Re: IF, dates and values »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Calculating Annual Return From One Time Payment	Fred Smith	Microsoft Excel Misc	0	25th Jan 2009 12:47 AM
Calculating the payment for a loan	=?Utf-8?B?UmFnaHU=?=	Microsoft Excel Worksheet Functions	0	19th Feb 2007 06:17 AM
Invoiceing / Invoice Payment Add Initial Payment Record?	=?Utf-8?B?QnJvb2s=?=	Microsoft Access Form Coding	27	9th Mar 2006 10:33 PM
Calculating a mortgage payment	Erin Jenkins	Microsoft Excel Misc	5	17th Dec 2003 05:42 PM
calculating Principle and Interest Payment	mrcoop	Microsoft Access Forms	0	16th Sep 2003 11:55 PM