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
|