Loan: payment schedule, overpayment and the effective rate
Builds an annuity or declining-balance payment schedule with a principal grace period, calculates the overpayment, compares it with the other payment type and finds the effective rate with fees.
At a glance
- What question does it answer?
- What payments and how much interest the loan gives under an annuity and under a declining-balance schedule and what the rate is with fees.
- What data is needed?
- The amount, rate, term and grace period.
- How to read the result?
- Example on the default values (RUB 10 million, 21% a year, 24 months, a 1% fee): payment RUB 513,856.51, interest over the term RUB 2.33 million, total paid RUB 12.4 million, effective rate 24.43% a year; with declining-balance payments interest is RUB 2.19 million. Example on the default values: First payment: RUB 513,856.51; Last payment: RUB 513,856.51; Interest over the whole term: RUB 2.33 million; Fees over the whole term: RUB 100,000. The figures are illustrative: enter your own to see your result.
Why and how to reason
The terms of a loan can only be compared by the full price: the rate in the contract does not include fees and insurance. The calculation builds a payment schedule and counts the effective rate from the cash flow: you receive the sum less the fee and pay payments plus monthly charges. An annuity makes the payment the same: A = S × i ÷ (1 − (1 + i)^−m), where i is the monthly rate. For 10 million at 21% for 24 months the payment is 513,857, interest 2.33 million, a 1% fee of 100 thousand. The effective rate with the fee is 24.4% against a nominal 21%. A differentiated payment declines: principal equals S ÷ m, interest on the balance. Its interest is lower (2.19 million, less by 145 thousand), but the first payments are higher. A grace period on principal pushes payments back and increases interest.
When to use it
It fits when choosing a loan, comparing bank offers and planning cash flow. Do not use it for floating-rate loans or early repayments that change the schedule. Assumptions: the rate is constant, payments are made on time, fees are known, calculation is monthly. Check the contract terms in the text, this is only a model. It also suits assessing a restructuring: insert the new terms and see how much is really saved.
How to read the result
Compare the effective rate (24.4%) with the nominal (21%): the 3.4-point difference has two parts. About 2.1 points come from compounding itself (21% with monthly payments equals about 23.1% a year), about 1.3 points from the 1% fee; the full-cost rate among the indicators (22.05%) shows the same fee cost in nominal annual terms. It matters for short terms and is smoothed on long ones. Look at the difference in interest with the other payment type: it shows how much saving a differentiated schedule gives, but at the expense of a higher first payment. If cash flow is weak, take an annuity, if strong, differentiated. The overpayment against the loan amount (24.3%) is a convenient guide when comparing offers for one term. For assessment, recalculate separately with your early repayment plan. Decide what matters more to you: a low payment now or lower interest overall. The answer determines the payment type.
Common mistakes
Typical trap: comparing nominal rates without fees and insurance, ignoring the grace period, mixing terms in months and years, not checking the monthly payment against the bank’s real schedule. Ask the bank for a payment schedule and compare with the calculation: differences point to hidden charges.
What data is needed?
- The amount, rate, term and grace period.
- The issue fee and monthly fees.
- The contract’s payment type.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Loan amount | ₽ | 10,000,000 | The amount you receive. The example value is illustrative. |
| Nominal rate | % per year | 21 | The contract rate. Take the key rate at the calculation date, it changes; calculate a floating rate by scenarios. The example value is illustrative. |
| Term | months | 24 | The whole term, including the grace period. |
| Payment type | Annuity: equal payments | An annuity is easier to plan, declining balance is cheaper in interest. | |
| Principal grace period | months | 0 | Only interest is paid in these months. Must be shorter than the term. |
| Issue fee | % of amount | 1 | Withheld at issue. Take the terms from the contract. |
| Monthly fee or insurance | ₽ | 0 | Paid every month on top of the schedule if the contract has it. |
How it is calculated
| Step | Formula |
|---|---|
| Annuity | A = S × i ÷ (1 − (1 + i)^−m), i = rate ÷ 12, m = term − grace |
| Declining balance | principal S ÷ m; interest = balance × i |
| Effective rate | IRR of the flows: +S − fee; −payment − monthly fee; year: (1 + IRR)^12 − 1 |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- First payment
- 513,856.51 ₽
- Last payment
- 513,856.51 ₽
- Interest over the whole term
- 2.33 m ₽
- Fees over the whole term
- 100,000 ₽
- Total paid (principal, interest, fees)
- 12.4 m ₽
- Overpayment to the loan amount
- 24.3 %
- Effective rate per year
- 24.4 %The annual yield with compounding, with fees. The procedure of the full cost of credit is set by the contract and the law: check with the bank.
- Nominal rate on the full cost
- 22.1 %Monthly IRR × 12.
- Interest with the other payment type (declining balance)
- 2.19 m ₽
- Interest difference with the other type
- +145,056 ₽
- Annuity
- Declining balance
Data as a table
| Month | Annuity | Declining balance |
|---|---|---|
| 0 | 10m | 10m |
| 1 | 9.66m | 9.58m |
| 2 | 9.32m | 9.17m |
| 3 | 8.97m | 8.75m |
| 4 | 8.61m | 8.33m |
| 5 | 8.25m | 7.92m |
| 6 | 7.88m | 7.5m |
| 7 | 7.5m | 7.08m |
| 8 | 7.12m | 6.67m |
| 9 | 6.73m | 6.25m |
| 10 | 6.33m | 5.83m |
| 11 | 5.93m | 5.42m |
| 12 | 5.52m | 5m |
| 13 | 5.1m | 4.58m |
| 14 | 4.68m | 4.17m |
| 15 | 4.24m | 3.75m |
| 16 | 3.81m | 3.33m |
| 17 | 3.36m | 2.92m |
| 18 | 2.9m | 2.5m |
| 19 | 2.44m | 2.08m |
| 20 | 1.97m | 1.67m |
| 21 | 1.49m | 1.25m |
| 22 | 1m | 833k |
| 23 | 505k | 417k |
| 24 | 0 | 0 |
- Principal
- Interest
Data as a table
| Measure | Principal | Interest |
|---|---|---|
| 1 | 339k | 175k |
| 2 | 345k | 169k |
| 3 | 351k | 163k |
| 4 | 357k | 157k |
| 5 | 363k | 151k |
| 6 | 370k | 144k |
| 7 | 376k | 138k |
| 8 | 383k | 131k |
| 9 | 389k | 125k |
| 10 | 396k | 118k |
| 11 | 403k | 111k |
| 12 | 410k | 104k |
| 13 | 417k | 96.6k |
| 14 | 425k | 89.3k |
| 15 | 432k | 81.8k |
| 16 | 440k | 74.3k |
| 17 | 447k | 66.6k |
| 18 | 455k | 58.8k |
| 19 | 463k | 50.8k |
| 20 | 471k | 42.7k |
| 21 | 479k | 34.4k |
| 22 | 488k | 26.1k |
| 23 | 496k | 17.5k |
| 24 | 505k | 8,838 |
Payment schedule by month
| Month | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | 513,856.51 ₽ | 338,856.51 ₽ | 175,000 ₽ | 9.66 m ₽ |
| 2 | 513,856.51 ₽ | 344,786.5 ₽ | 169,070.01 ₽ | 9.32 m ₽ |
| 3 | 513,856.51 ₽ | 350,820.26 ₽ | 163,036.25 ₽ | 8.97 m ₽ |
| 4 | 513,856.51 ₽ | 356,959.62 ₽ | 156,896.89 ₽ | 8.61 m ₽ |
| 5 | 513,856.51 ₽ | 363,206.41 ₽ | 150,650.1 ₽ | 8.25 m ₽ |
| 6 | 513,856.51 ₽ | 369,562.52 ₽ | 144,293.99 ₽ | 7.88 m ₽ |
| 7 | 513,856.51 ₽ | 376,029.87 ₽ | 137,826.64 ₽ | 7.5 m ₽ |
| 8 | 513,856.51 ₽ | 382,610.39 ₽ | 131,246.12 ₽ | 7.12 m ₽ |
| 9 | 513,856.51 ₽ | 389,306.07 ₽ | 124,550.44 ₽ | 6.73 m ₽ |
| 10 | 513,856.51 ₽ | 396,118.93 ₽ | 117,737.58 ₽ | 6.33 m ₽ |
| 11 | 513,856.51 ₽ | 403,051.01 ₽ | 110,805.5 ₽ | 5.93 m ₽ |
| 12 | 513,856.51 ₽ | 410,104.4 ₽ | 103,752.11 ₽ | 5.52 m ₽ |
| 13 | 513,856.51 ₽ | 417,281.23 ₽ | 96,575.28 ₽ | 5.1 m ₽ |
| 14 | 513,856.51 ₽ | 424,583.65 ₽ | 89,272.86 ₽ | 4.68 m ₽ |
| 15 | 513,856.51 ₽ | 432,013.86 ₽ | 81,842.65 ₽ | 4.24 m ₽ |
| 16 | 513,856.51 ₽ | 439,574.11 ₽ | 74,282.4 ₽ | 3.81 m ₽ |
| 17 | 513,856.51 ₽ | 447,266.65 ₽ | 66,589.86 ₽ | 3.36 m ₽ |
| 18 | 513,856.51 ₽ | 455,093.82 ₽ | 58,762.69 ₽ | 2.9 m ₽ |
| 19 | 513,856.51 ₽ | 463,057.96 ₽ | 50,798.55 ₽ | 2.44 m ₽ |
| 20 | 513,856.51 ₽ | 471,161.48 ₽ | 42,695.03 ₽ | 1.97 m ₽ |
| 21 | 513,856.51 ₽ | 479,406.8 ₽ | 34,449.71 ₽ | 1.49 m ₽ |
| 22 | 513,856.51 ₽ | 487,796.42 ₽ | 26,060.09 ₽ | 1 m ₽ |
| 23 | 513,856.51 ₽ | 496,332.86 ₽ | 17,523.65 ₽ | 505,019 ₽ |
| 24 | 513,856.51 ₽ | 505,018.68 ₽ | 8,837.83 ₽ | 0 ₽ |
Interest is counted on the monthly balance at the rate ÷ 12. The bank’s actual schedule may count by days and dates: check with the contract. Rate changes, early repayment and penalties are not modelled. Check the terms, the tax treatment of interest and insurance with an accountant and the bank.
Nuances and limits
- Comparing loans by the nominal rate without fees.
- Choosing declining balance without checking the payment peak at the start.
- Treating the bank schedule as exact: days and dates change the figures.