Related Information Examples & Tutorials

Amortized Loan - Normal

The most common method of repaying an interest-bearing loan is by amortization. In this method, a series of periodic payments is made. The indebtedness at any time is called the outstanding balance or outstanding principal. It is just the discounted value of all unmade payments.

Each sequential payment pays the interest on the unpaid balance and also repays a part of the outstanding principal. Over the term of the loan, as the outstanding principal decreases, the interest portion of each payment decreases and the principal portion increases. This shifting distribution is shown in an amortization schedule. Amortized loan is calculated according to this schedule. Payments are set up using the formula given below.

RULE OF 78's

The difference between the above method and Rule of 78's is that, in the Rule of 78's, the interest portion of each payment is not determined by the unpaid balance, but rather by a calculation which is called Rule of 78's. This may result in a different distribution shift than described above. As well, if a loan is paid off early, with Rule of 78's computing, a borrower does not receive as much of an interest refund as in other forms of borrowing.

Please see Rule of 78's for details and formulas used in this type of calculation.

Amortized Loan Information

In the Interest Detail form, the Operator enters:

Annual Interest Rate - as a percent, e.g. 15. This is the Annual rate of interest. When Period is more frequent than Annual, Interest rates are calculated for the Period using the formula -- R/n

Period - pick a Period from the list. This is a frequency of interest conversion (compounding) and a frequency of payment. Collect! uses this information to determine how often to compound Interest. It also states how often a debtor is scheduled to make a payment.

Rate Basis - 360, 364 or 365 days, or Ordinary - 12 months. This is the length of the year.

Calculate Interest From Date - the date you want calculation to begin.

Term - this is the Total Number of Payments. It is NOT in the formula below. If the debtor is paying monthly for four years, that means 12 payments for 4 years so Term = 48.

First Payment Date - the date you want the first payment to be due.

tip.gif These are the basic values that Collect! needs to set up the preamortization schedule and display results of calculations. There are additional options you can choose. Press F1 in the Interest Detail form for information on the field you are wondering about.

Top of page.

Payment Amount

Collect! uses the following formula to calculate Payment amount. The Operator enters the information listed above and Collect! performs the necessary calculations.

Payment Amount

P = Payment

A = Amount borrowed

R = Annual Interest Rate

n = number of compound payments per year. This is how often the interest is compounded, (the Period.) (e.g. Quarterly period: n = 4, Bimonthly period: n = 6)

R/n = the Interest Rate of a Compounding Period. This divides the Annual rate by the number of times a year the interest is compounded (the number of periods.)

T = time in years. This is the number of years allowed to pay off the loan. This calculation takes into consideration the Rate Basis set in the Interest Detail.

nT = Term, the total number of payments in the loan schedule. This is the number of periods per year multiplied by the number of years. This is the exponent. In the formula, 1 + the Interest Rate(R/n) is multiplied by itself as many times as the value of the Term(nT).

Example:

$2000 borrowed at 5% for 2 years with Monthly payments.

Plugged into the formula:

((2000 x .05) / 12) x (1 + .05 / 12) (multiplied by itself 24 times) Divided by (1 + .05 / 12)(multiplied by itself 24 times) minus 1

Approximately, this results in 8.3333 x 1.10494 divided by .10494 which gives a monthly payment of $87.74.

Top of page.

Total Plan Payments

Total Plan Payments amount is calculated as follows:

TP = P x T

TP = Total Plan Payments
P = Payment Amount
T = number of Payments (Term)

In our example, this is 87.74 x 24 = $2105.76

tip.gif If the Set Terms Manually switch is ON, the Payment Amount is supplied and Payment Amount formula is not used.

Top of page.

Total Interest

To calculate the Total Interest, the following is used:

TI = TP - A

TI = Total Interest
TP = Total Plan Payments
A = Amount Borrowed

In our example, this is 2105.76 - 2000 = $105.76

Top of page.

Time In Years

Calculations take into consideration the Rate Basis set in the Interest Detail. This Rate Basis is used in every single interest calculation. It can be set to Ordinary, 360, 364 or 365 days.

Top of page.

See Also

- Rule of 78's
- Interest Detail
- How To Make An Interest Adjustment
- How To Setup Amortized Interest
- How To Use The Amortization Schedule

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org