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

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

Bad example on my part;

Assume $10,000 to start, $12,000 in $1,000 payment each month, final number
$30,000

Dave

"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

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

=RATE(12,-1000,-12000,30000)

"Dave" wrote in message
...
Bad example on my part;

Assume $10,000 to start, $12,000 in $1,000 payment each month, final
number
$30,000

Dave

"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

On Thu, 4 Nov 2004 05:22:02 -0800, "Dave"
wrote:

Bad example on my part;

Assume $10,000 to start, $12,000 in $1,000 payment each month, final number
$30,000

Use the RATE function. But be aware the result is the interest rate per
period. Since you want the interest rate per year, and the periods are
monthly, you should multiply the result by 12.


--ron

Thanks for the responses.

Dave

"Dave" wrote in message
...
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

I am sorry I am still struggling with this. If I enter no minus, I get an
error

My Scenario

Beginning amount = $10,000
12 monthly payments of $1,000
Ending value of $30,000

So where does the information get plugged in and which has to be negative

Here is what was sent =RATE(12,-1000,-12000,30000)

Where does the beginning value of $10,000 go and is it expressed as a
positive or negative number?
Is the monthly contribution expressed as a negative number and where does
that go?

Sorry if I appear slow.

Thanks






"N Harkawat" wrote in message
...
=RATE(12,-1000,-12000,30000)

"Dave" wrote in message
...
Bad example on my part;

Assume $10,000 to start, $12,000 in $1,000 payment each month, final
number
$30,000

Dave

"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

The example you were given has a typo. Replace the -12000 with -10000.

In general, you can consider money that leaves your pocket (even to deposit in
a bank savings account) is negative. Money that goes back into your pocket
(when you withdraw something from that savings account) is positive.

Or you can look at it from the bank's perspective, in which case just reverse
the signs.


On Thu, 4 Nov 2004 18:05:41 -0600, "Dave" wrote:

I am sorry I am still struggling with this. If I enter no minus, I get an
error

My Scenario

Beginning amount = $10,000
12 monthly payments of $1,000
Ending value of $30,000

So where does the information get plugged in and which has to be negative

Here is what was sent =RATE(12,-1000,-12000,30000)

Where does the beginning value of $10,000 go and is it expressed as a
positive or negative number?
Is the monthly contribution expressed as a negative number and where does
that go?

Sorry if I appear slow.

Thanks






"N Harkawat" wrote in message
...
=RATE(12,-1000,-12000,30000)

"Dave" wrote in message
...
Bad example on my part;

Assume $10,000 to start, $12,000 in $1,000 payment each month, final
number
$30,000

Dave

"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

Thanks that helps!!


"Myrna Larson" wrote in message
...
The example you were given has a typo. Replace the -12000 with -10000.

In general, you can consider money that leaves your pocket (even to
deposit in
a bank savings account) is negative. Money that goes back into your pocket
(when you withdraw something from that savings account) is positive.

Or you can look at it from the bank's perspective, in which case just
reverse
the signs.


On Thu, 4 Nov 2004 18:05:41 -0600, "Dave" wrote:

I am sorry I am still struggling with this. If I enter no minus, I get an
error

My Scenario

Beginning amount = $10,000
12 monthly payments of $1,000
Ending value of $30,000

So where does the information get plugged in and which has to be negative

Here is what was sent =RATE(12,-1000,-12000,30000)

Where does the beginning value of $10,000 go and is it expressed as a
positive or negative number?
Is the monthly contribution expressed as a negative number and where does
that go?

Sorry if I appear slow.

Thanks






"N Harkawat" wrote in message
.. .
=RATE(12,-1000,-12000,30000)

"Dave" wrote in message
...
Bad example on my part;

Assume $10,000 to start, $12,000 in $1,000 payment each month, final
number
$30,000

Dave

"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