Compound interest question

  • Thread starter Thread starter Peter
  • Start date Start date
P

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.
 
Hi Peter,

Look at the RATE() function

See HELP for details
Click to expand...


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.
 

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

Similar Threads

Calculating interest due on late loan payments 1
Mtge calculation (Dly compound interest and multiple interest rate 2
Compound Interest 3
Calculate interest & withdrawals 0
Credit Card time to payoff and defered balance 1
How do I calculate interest? 1
How do I calc interest using 2 interest rates in 1 calendar year 1
Excel compounded interest rate... 1

Back
Top