◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
PPmt# (rate#, per#, nper#, pv#, fv#, type%, status%)
 
    ■ rate#      The interest rate per period (for example, .12).
    ■ per#       The payment period: must be in the range from 1 to nper#.
    ■ nper#      The number of payment periods in the annuity.
    ■ pv#        The present value.
    ■ fv#        The future value.
    ■ type%      An integer expression: 0 = end-of-period payment;
                                        1 = beginning-of-period payment.
    ■ status%    A variable that returns a value indicating calculation
                 failure or success: 0 = success; 1 = failure.
 
Returns
    Payment on the principal for a given period of an annuity based
    on periodic, constant payments and a constant interest rate.
 
See Also    ◄FV#►    ◄IPmt#►    ◄NPer#►    ◄Pmt#►    ◄PV#►    ◄Rate#►