Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel - PMT function - Chapter 10 - Coggle Diagram
Excel - PMT function - Chapter 10
PMT function
To calculate the monthly repayments on a capital amount (loan / annuity) when:
interest rate
number of payments
present value
future value
are given
=PMT(rate,nper,pv,fv,type)
Rate
This is the periodic interest rate applicable to each payment
Nper
This is the number of payments
Pv
This is the present value of the capital amount
Fv
This is the residual value / end value of the capital amount - Usually 0 if the loan is completely redeemed
Type
This indicates whether the payments are made at the beginning or at the end of the period.
0 => end
1 => beginning
PV function
Calculates the current value of a set of equal installments when:
interest rate
number of installments
payment
future value
are given
=PV(rate,nper,pmt,fv,type)
FV function
Calculates the future value of a set of equal installments when:
interest rate
number of installments
payment
present value
are given
=FV(rate,nper,pmt,pv,type)