InterestPayment

Syntax

InterestPayment(Rate, Period, NPeriods, Payment, PresentValue, FutureValue, PaymentTime)

Summary

Calculates the interest portion of a loan payment.

Parameters

• Rate: The percentage interest rate.

• Period is the number of periods into the loan for which the principal value is desired.

• NPeriods is the number of periods of the loan.

• PresentValue is the initial investment.

• FutureValue is the value the investment will reach after N payments.

• PaymentTime is zero or one. It indicates whether the cash flows occurs at the beginning (0) or at the end of the period (1).

Credit

This function is based on the same named function in the Delphi programming language.