PMT {DescTools} | R Documentation |
PMT
computes the periodic payment of an annuity.
IPMT
calculates what portion of a period payment is going towards interest in a particular period and
PPMT
what portion of a period payment is going towards principal in a particular period. RBAL
yields the remaining balance in a particular period.
PMT(rate, nper, pv, fv = 0, type = 0)
IPMT(rate, per, nper, pv, fv = 0, type = 0)
PPMT(rate, per, nper, pv, fv = 0, type = 0)
RBAL(rate, per, nper, pv, fv = 0, type = 0)
rate |
specifies the interest rate. |
per |
specifies the period of the payment to be applied to interest or to principal. |
nper |
specifies the number of payment periods. |
pv |
specifies the present value or the lump-sum amount that a series of future payments is worth currently. |
fv |
specifies the future value or a cash balance that you want to attain after the last payment is made. Default is 0. |
type |
specifies the number 0 or 1 and indicates when payments are due. Default is 0. |
a numeric value
Andri Signorell <andri@signorell.net>
# original principal: 20'000
# loan term (years): 5
# annual interest rate: 8%
# annual payment: -4'156.847
# simple amortization schedule
cbind(
year = 1:5,
payment = PMT(rate=0.08, nper=5, pv=20000, fv=-5000, type=0),
interest = IPMT(rate=0.08, per=1:5, nper=5, pv=20000, fv=-5000, type=0),
principal = PPMT(rate=0.08, per=1:5, nper=5, pv=20000, fv=-5000, type=0),
balance = RBAL(rate=0.08, per=1:5, nper=5, pv=20000, fv=-5000, type=0)
)
# year payment interest principal balance
# [1,] 1 -4156.847 -1600.0000 -2556.847 17443.153
# [2,] 2 -4156.847 -1395.4523 -2761.395 14681.759
# [3,] 3 -4156.847 -1174.5407 -2982.306 11699.452
# [4,] 4 -4156.847 -935.9562 -3220.891 8478.562
# [5,] 5 -4156.847 -678.2849 -3478.562 5000.000