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