Syntha Lab RU

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.

Cash and working capital For whom: Chief financial officers and owners choosing a loan repayment scheme.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Loan amount₽10,000,000The amount you receive. The example value is illustrative.
Nominal rate% per year21The contract rate. Take the key rate at the calculation date, it changes; calculate a floating rate by scenarios. The example value is illustrative.
Termmonths24The whole term, including the grace period.
Payment typeAnnuity: equal paymentsAn annuity is easier to plan, declining balance is cheaper in interest.
Principal grace periodmonths0Only interest is paid in these months. Must be shorter than the term.
Issue fee% of amount1Withheld at issue. Take the terms from the contract.
Monthly fee or insurance₽0Paid every month on top of the schedule if the contract has it.

How it is calculated

StepFormula
AnnuityA = S × i ÷ (1 − (1 + i)^−m), i = rate ÷ 12, m = term − grace
Declining balanceprincipal S ÷ m; interest = balance × i
Effective rateIRR 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 ₽
Loan balance
Line chart: Annuity: 10m → 0; Declining balance: 10m → 002m4m6m8m10m05101520Annuity, 0: 10mAnnuity, 24: 0Declining balance, 0: 10mDeclining balance, 24: 0₽Month
  • Annuity
  • Declining balance
Data as a table
MonthAnnuityDeclining balance
010m10m
19.66m9.58m
29.32m9.17m
38.97m8.75m
48.61m8.33m
58.25m7.92m
67.88m7.5m
77.5m7.08m
87.12m6.67m
96.73m6.25m
106.33m5.83m
115.93m5.42m
125.52m5m
135.1m4.58m
144.68m4.17m
154.24m3.75m
163.81m3.33m
173.36m2.92m
182.9m2.5m
192.44m2.08m
201.97m1.67m
211.49m1.25m
221m833k
23505k417k
2400
Payments by month: principal and interest
Bar chart: 1 339k, 2 345k, 3 351k, 4 357k, 5 363k, 6 370k0100k200k300k400k500k600k11Principal: 339kInterest: 175k514k22Principal: 345kInterest: 169k514k33Principal: 351kInterest: 163k514k44Principal: 357kInterest: 157k514k55Principal: 363kInterest: 151k514k66Principal: 370kInterest: 144k514k77Principal: 376kInterest: 138k514k88Principal: 383kInterest: 131k514k99Principal: 389kInterest: 125k514k1010Principal: 396kInterest: 118k514k1111Principal: 403kInterest: 111k514k1212Principal: 410kInterest: 104k514k1313Principal: 417kInterest: 96.6k514k1414Principal: 425kInterest: 89.3k514k1515Principal: 432kInterest: 81.8k514k1616Principal: 440kInterest: 74.3k514k1717Principal: 447kInterest: 66.6k514k1818Principal: 455kInterest: 58.8k514k1919Principal: 463kInterest: 50.8k514k2020Principal: 471kInterest: 42.7k514k2121Principal: 479kInterest: 34.4k514k2222Principal: 488kInterest: 26.1k514k2323Principal: 496kInterest: 17.5k514k2424Principal: 505kInterest: 8,838514k₽
  • Principal
  • Interest
Data as a table
MeasurePrincipalInterest
1339k175k
2345k169k
3351k163k
4357k157k
5363k151k
6370k144k
7376k138k
8383k131k
9389k125k
10396k118k
11403k111k
12410k104k
13417k96.6k
14425k89.3k
15432k81.8k
16440k74.3k
17447k66.6k
18455k58.8k
19463k50.8k
20471k42.7k
21479k34.4k
22488k26.1k
23496k17.5k
24505k8,838

Payment schedule by month

MonthPaymentPrincipalInterestBalance
1513,856.51 ₽338,856.51 ₽175,000 ₽9.66 m ₽
2513,856.51 ₽344,786.5 ₽169,070.01 ₽9.32 m ₽
3513,856.51 ₽350,820.26 ₽163,036.25 ₽8.97 m ₽
4513,856.51 ₽356,959.62 ₽156,896.89 ₽8.61 m ₽
5513,856.51 ₽363,206.41 ₽150,650.1 ₽8.25 m ₽
6513,856.51 ₽369,562.52 ₽144,293.99 ₽7.88 m ₽
7513,856.51 ₽376,029.87 ₽137,826.64 ₽7.5 m ₽
8513,856.51 ₽382,610.39 ₽131,246.12 ₽7.12 m ₽
9513,856.51 ₽389,306.07 ₽124,550.44 ₽6.73 m ₽
10513,856.51 ₽396,118.93 ₽117,737.58 ₽6.33 m ₽
11513,856.51 ₽403,051.01 ₽110,805.5 ₽5.93 m ₽
12513,856.51 ₽410,104.4 ₽103,752.11 ₽5.52 m ₽
13513,856.51 ₽417,281.23 ₽96,575.28 ₽5.1 m ₽
14513,856.51 ₽424,583.65 ₽89,272.86 ₽4.68 m ₽
15513,856.51 ₽432,013.86 ₽81,842.65 ₽4.24 m ₽
16513,856.51 ₽439,574.11 ₽74,282.4 ₽3.81 m ₽
17513,856.51 ₽447,266.65 ₽66,589.86 ₽3.36 m ₽
18513,856.51 ₽455,093.82 ₽58,762.69 ₽2.9 m ₽
19513,856.51 ₽463,057.96 ₽50,798.55 ₽2.44 m ₽
20513,856.51 ₽471,161.48 ₽42,695.03 ₽1.97 m ₽
21513,856.51 ₽479,406.8 ₽34,449.71 ₽1.49 m ₽
22513,856.51 ₽487,796.42 ₽26,060.09 ₽1 m ₽
23513,856.51 ₽496,332.86 ₽17,523.65 ₽505,019 ₽
24513,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.

Terms used

Calculate on your data →