View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GeorgeA GeorgeA is offline
external usenet poster
 
Posts: 29
Default Solving for Amortization with PMT function

Hello,
I need to solve for Amortization and think I should be using the PMT
function €œPMT(rate,nper,pv,fv,type)€
My data gives me the desired payment, rate, pv, fv and type.
I dont know what formula to use to return the amortization (in years). Can
anyone help?

Much appreciated!
George