View Single Post
  #1   Report Post  
 
Posts: n/a
Default How to calculate the RATE in annuity?

Hi there,

Need your help.

On 1 Nov 2005, I bought a unit trust, with initial payment US$5000.
Subsequently, each month-end (starting 31 Nov 05), I put in US$200 for
a period of two years in a row.

On 1 Dec 2007, I will get back US$ 11,000 (including the initial
payment)

Question:
1) What is the interest rate throughout annuity period?

2) How to use the Microsoft Excel to calculate?

Thanks. Please e-mail me directly!

cheers
dstdst