[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
PERIODS()
Computes the number of payment periods necessary to repay a loan
------------------------------------------------------------------------------
Syntax
PERIODS(<nCapital>,<nPayment>,<nInterestRate>)
--> nNumberPayments
Arguments
<nCapital> Designates the loan amount.
<nPayment> Designates the amount of the scheduled periodic payment.
<nInterestRate> Designates the periodic interest rate. 1
corresponds to 100%.
Returns
PERIODS() returns the number of payments required to repay the
<nCapital> amount.
Description
PERIODS() computes how often you must make a payment <nPayment> to reach
the <nCapital> amount at the <nInterestRate> interest rate.
Note
. If the installment payment is smaller than the interest
amount, repayment lasts forever. In this case, the function returns
a value
of -1.
Example
How many months do you need to pay back a $4000 loan at an annual
interest rate of 9.5%, if you want the $200 monthly payments?
nRate := 0.095/12 // Monthly rate
? PERIODS(4000, 200, Rate) // Number of periods
See Also:
PAYMENT()
PV()
FV()
RATE()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson