View Single Post
  #1   Report Post  
Dave
 
Posts: n/a
Default What function or formula do I use to calculate ROI with this data?

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