Function help needed

[Nigel Heald]

Hi

I am trying in vain to find a function within Excel 2003 that will enable us
to calculate the monthly investment required to achieve a given amount after
X number of months at a known rate of return. i.e

"How much does one need to invest monthly @ 6% per annum interest in order
to have a fund of £20,000 after 120 months"

If anybody can point me in the right direction I would be very grateful

Thanks in advance

Nige

--
#############################################################
Nigel Heald
Maurice Ricketts Associates - Independent Financial Advisors
Branch office:- 16, Hunters Close, Ivybridge, Devon PL21 9JD
01752 896097. Fax 01752 897028. Mobile 07770 590788
www.mrauk.co.uk
Regulated by the Financial Services Authority
Member of the General Insurance Standards Council


This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed. They may contain legally privileged information,
and may not be disclosed to anyone else. If you have received
this email in error please notify (e-mail address removed) and delete all
copies from your system
#############################################################

 

[JE McGimpsey]

See the reply at microsoft.public.newusers.


Please don't post the same message to multiple newsgroups - it just
tends to fragment any answers you get, and potentially wastes the time
of those answering a question that has already been answered.

See

http://cpearson.com/excel/newposte.htm

for tips on using these newsgroups effectively.