View Single Post
  #6   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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