RATE()

RATE()

Estimate rate of interest for a loan

Syntax

      RATE( nLoan, nPayment, nPeriods ) --> nRate

Arguments

<nLoan> amount of money you get from the bank <nPayment> amount of money you pay back per period <nPeriods> number of periods you pay the loan back

Returns

<nInterest> estimated rate of interest per period, 1 == 100%

Description

RATE() calculates the rate of interest per period for the given loan, payment per periods and number of periods. This is done with the same equation used in the PAYMENT() or PERIODS() function:

<nPayment> = <nLoan>*(<nInterest>/100)/(1-(1+<nInterest>/100)ˆ(-<nPeriods>))

However, this equation can not be solved for <nInterest> in a “closed” manner, i.e. <nInterest> = …, so that the result can only be estimated.

Examples

      // You get a loan of 5172.56, pay 100 back every month for
      // 5 years (60 months). The effective interest rate per
      // period (=month) is

      ? rate( 5172.56, 100, 60 ) // --> 0.005

Tests

      rate( 5172.56, 100, 60.0 ) == 0.005
      rate( 6000.0, 100, 60.0 ) == 0.0

Compliance

RATE() is compatible with CT3’s RATE().

Platforms

All

Files

Source is finan.c, library is libct.

Seealso

PV(), FV(), PAYMENT(), PERIODS()

Advertisements

2 responses to “RATE()

  1. Pingback: Harbour All Functions – R | Viva Clipper !

  2. Pingback: Harbour Accounting Functions | Viva Clipper !

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s