This article describes the Flat Interest Rate lending scheme and gives examples on how to calculate payment schedules.
| Table of Contents |
|---|
General
The Flat Interest Rate lending scheme is a fixed payment lending scheme. This scheme has fixed monthly* Principal and fixed monthly Interest. Naturally, the Total monthly amount is fixed too (this is what is similar between the Flat Interest Rate and the Annuity (ENG)).
| Info |
|---|
* Monthly installments are the most common, but other installment periods are also possible. Examples: annually, semi-yearly, quarterly, semi-monthly, bi-weekly, weekly, etc. |
How to calculate fixed monthly payment
Fixed monthly payment is calculated according to the formula:
(1)
where
A is the loan amount,
NP is the number of payments;
IR is the monthly interest rate.
Example 1
In this example, the loan Amount is 1000 USD (A = 1,000), the monthly Interest Rate is 1% (IR = 0.01), and the Number of Payments is 3 (NP = 3).
The total amount of fixed monthly payment is calculated according to Formula 1:
The payment schedule looks as follows:
...
Installment Number
...
Principal
...
Interest
...
Total
...
1
...
2
...
3
...
Total
...
Example 2
In this example, the Loan Amount is 10,000 USD (A = 10,000), the yearly Interest Rate is 36%, which corresponds to a monthly Interest Rate of 3% (IR = 0.03), and the Number of Payments is 12 (NP = 12).
...
The total amount of fixed monthly payment is calculated according to Formula 1:
...
The payment schedule looks as follows:
...
Rounding
When dividing the loan amount by the number of installments (Formula 1), a repeating decimal may occur. This leads to loss of precision. For instance, in Example 2:
This lost precision adds up with every installment and, eventually, effects the total Principal.
...
Principal
(machine precision)
...
Principal
(financial data type precision)
...
To make Total Principal consistent with the Loan Amount, the principal for the last installment is adjusted:
,
where
PNP is the last scheduled principle amount,
A is the loan amount,
Pi is the amount of principal to be repaid in i-th month (financial precision).
For instance, in Example 2 the principal for the 12-th installment is calculated as follows:
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|