Thread: to compute interest rate from principal and interest amount
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default to compute interest rate from principal and interest amount
=RATE(24,102/24,-100,102)

--
Kind regards,

Niek Otten

"PVJ" wrote in message
...
Principal amount $100
interest amount $2
i need to repay $102 in 24 instalments
i want the function in excel to compute the interest rate for the
computing
the interest rate one month so that the principal plus the interest for 24
months cumulates to $102


Reply With QuoteReply With Quote