Bad example on my part.

Assume the data is $10,000, $12,000, $32,000


"Ron Rosenfeld" wrote:

On Thu, 4 Nov 2004 05:37:30 -0600, "Dave" wrote:

I have the following data and I want to calculate my investment Rate of
Return or lack thereof.

I have three pieces on data:

1. the beginning amount of money $10,000
2. the total of the equal monthly contributions $12,000
- (each month I contributed $1,000)
3. the ending value of $22,000.

So the data is $10,000, $12,000, $22,000

So I want to figure out the compounded percentage rate.

Does Excel have a function for that?

Thanks
Dave


You don't need Excel for this.

Assuming you start with $10K, add $12K and wind up with $22K, your roi is zero
(0%).


--ron