CT_PERIODS

 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()



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.