Thread: PMT Function
View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

Say you take a loan of 1000 and at end of 12 months want to leave a loan
balance of say $400.
How much would you pay in equal instalements in 12 months in order to pay
off 600 of loan and leave 400 ?
FV is that $400
therefore
=PMT(rate/12,12,-1000,400)


"Annie" wrote in message
...
What does the 'fv' do in the PMT Function?

Thank you in advance,
Annie