Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- CA-Clipper Tools . Books 1-3 - <b>periods()</b> http://www.X-Hacker.org [<<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()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson