View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pasko1
 
Posts: n/a
Default Effective interest paid - need formula/function

I would like to calculate the effective interest paid on a lease. If the
asset value is $55k, and the lease payments are $2,519 for 2 years with a
residual asset value of $1 at the end of the lease, what is the effective
interest rate? Note that the first payment is double ($5,038), with 22
monthly payments thereafter.