PMT.RdPMT 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)specifies the interest rate.
specifies the period of the payment to be applied to interest or to principal.
specifies the number of payment periods.
specifies the present value or the lump-sum amount that a series of future payments is worth currently. pv can be 0 if a positive fv argument is included.
specifies the future value or a cash balance that you want to attain after the last payment is made. Default is 0.
specifies the number 0 or 1 and indicates when payments are due. Default is 0.
a numeric value
# 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
# 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