The interest rate per period.
The period for which a payment is to be computed.
The total number of payment periods.
The present value of a series of future payments.
The future value or cash balance after the final payment. If omitted, the default value is 0.
A value indicating when payments are due.
DueDate.EndOfPeriod (or 0) indicates that payments
are due at the end of the payment period;
BegOfPeriod (or 1) indicates that payments are due
at the beginning of the period. If omitted, the default value is
A Double representing the interest payment
Computes the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. An annuity is a series of fixed cash payments made over a period of time. It can be either a loan payment or an investment.
The value of
per can range from 1 to
represent liabilities, their value is negative; if they represent
assets, their value is positive.
The ComputeSchedule function accepts a loan amount, an annual percentage rate, and a number of payment periods. It uses the Pmt function to calculate the payment per period, then returns a two-dimensional array in which each ...