[<<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