[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
RATE()
Computes the interest rate for a loan
------------------------------------------------------------------------------
Syntax
RATE(<nCapital>,<nPayment>,<nNumberPayments>)
--> nInterestRate
Arguments
<nCapital> Designates the amount of the loan.
<nPayment> Designates the payment per installment.
<NumberPayments> Designates the number of the planned payment
periods.
Returns
RATE() returns the loan interest rate.
Description
RATE() determines the annual interest rate for a loan <nCapital> in the
<nNumberPayments> period at the specified <nPayment> installment. The
calculated interest rate is based on a Newtonian iterative solution
procedure:
lk+1=ik - f(ik)/f(ik)
where:
f(i)=(1-(l + i)^-n)/i - PV/PMT
The initial value for i is selected as follows:
-io = PMT/PV - PV/n^2PMT
Note
. This function allows a maximum value for the payment period of
1020.
Example
For a $2500 loan, you pay $86.67 per month for 3 years. What is the
effective annual interest rate?
nLoan := 2500
nPayment := 86.67
nPeriod := 36
? RATE(nLoan, nPayment, nPeriod) * 12 // 0.1501 (15.01%)
See Also:
PAYMENT()
PV()
FV()
PERIODS()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson