Compound interest question

[Peter]

an anyone please advise how I may do the following?

A sum of money is invested for 5 years - at the end of that 5 years
interest is paid ( a known amount)

How can I work out what rate of interest has been paid if no
withdrawals have been made i.e the rate of compound interest paid.
--
Cheers

Peter

[Niek Otten]

Hi Peter,

Look at the RATE() function

See HELP for details

--
Kind regards,

Niek Otten

"Peter" <peter.thomasINVALID@nidum.plus.com> wrote in message
news:d4uop1hvesnv3ilm6olovsou69tsrrglel@4ax.com...
> an anyone please advise how I may do the following?
>
> A sum of money is invested for 5 years - at the end of that 5 years
> interest is paid ( a known amount)
>
> How can I work out what rate of interest has been paid if no
> withdrawals have been made i.e the rate of compound interest paid.
> --
> Cheers
>
> Peter

[Peter]

On Sun, 11 Dec 2005 20:22:57 +0100, "Niek Otten" <nicolaus@xs4all.nl>
wrote:

>Hi Peter,
>
>Look at the RATE() function
>
>See HELP for details


Hi Nic,

Thanks very much for your suggestion - I've tried it, but can't get it
to work. The help example seems to refer to a loan that is being paid
back on a monthly basis.

I have a sum of money, invested on a date, say 1 April and want to
know what the rate of growth on that sum has been over 5 yrs.

[Niek Otten]

=RATE(5,0,-1000,1500)

gives 8.45%


--
Kind regards,

Niek Otten

"Peter" <peter.thomasINVALID@nidum.plus.com> wrote in message
news:30cpp1dec37hssmqapjhkteg5rhl0oeam4@4ax.com...
> On Sun, 11 Dec 2005 20:22:57 +0100, "Niek Otten" <nicolaus@xs4all.nl>
> wrote:
>
>>Hi Peter,
>>
>>Look at the RATE() function
>>
>>See HELP for details
>
>
> Hi Nic,
>
> Thanks very much for your suggestion - I've tried it, but can't get it
> to work. The help example seems to refer to a loan that is being paid
> back on a monthly basis.
>
> I have a sum of money, invested on a date, say 1 April and want to
> know what the rate of growth on that sum has been over 5 yrs.
>