| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate sales run rate | Excel Discussion (Misc queries) | |||
| Calculate Interest Rate when payment changes! | Excel Worksheet Functions | |||
| How to calculate the accumulated payments from an annuity at yr 10 | Excel Worksheet Functions | |||
| How do I calculate the accumulated payments from an annuity at yr | New Users to Excel | |||
| How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
Threaded Mode
