calculate-loan

01 Loan payments

Repayment Schedule in Hindi: Meaning & How It Works

Calculator No. 01-22481 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A repayment schedule, called पुनर्भुगतान अनुसूची (Punarbhugatan Anusuchi) in Hindi, is a table that lists each payment you make on a loan, showing the date, the total amount, and how much goes toward interest versus the principal. This article explains what a repayment schedule is, how to read one, and how to calculate it yourself, with a free calculator below.

Formula

The repayment schedule is built from a single formula that calculates the fixed monthly payment (EMI) for a loan with a fixed interest rate and a fixed term. The formula is:

PMT = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • P = principal loan amount (in your currency)
  • r = monthly interest rate = annual rate ÷ 12 (as a decimal, so 8% per year becomes 0.08/12 = 0.006667)
  • n = total number of monthly payments = loan term in years × 12

For each payment, the interest portion is calculated as: Interest = remaining balance × r. The principal portion is PMT − Interest. After each payment, the remaining balance decreases by the principal portion, and the next payment’s interest is calculated on the new, lower balance.

Worked Example

Using the default values from the calculator: Loan amount = $20,000, APR = 8%, term = 5 years.

  1. Monthly interest rate r = 8 / 1200 = 0.0066667
  2. Total payments n = 5 × 12 = 60
  3. Monthly payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. Calculate (1.0066667)^60 ≈ 1.48985
  5. Payment = 20000 × (0.0066667 × 1.48985) / (1.48985 − 1) = 20000 × 0.0099323 / 0.48985 ≈ 20000 × 0.020276 = 405.52

So the monthly payment is $405.52. Total paid over 60 months = 405.52 × 60 = $24,331.20. Total interest = $24,331.20 − $20,000 = $4,331.20. This matches the calculator output.

Assumptions

  • The interest rate is fixed for the entire loan term.
  • Payments are made at the end of each month (ordinary annuity).
  • Interest compounds monthly at the rate APR/12.
  • This calculation does not include fees, taxes, insurance, or prepayment penalties.

How to Read a Repayment Schedule

A typical repayment schedule has columns for: payment number, payment date, total payment, interest portion, principal portion, and remaining balance. In the early months, most of your payment goes toward interest. As the balance decreases, the interest portion shrinks and the principal portion grows. This is called amortization.

For example, in the first month of the loan above, interest = $20,000 × 0.0066667 = $133.33, so principal repaid = $405.52 − $133.33 = $272.19, leaving a balance of $19,727.81. By the last payment, interest is only about $2.68 and principal is $402.84.

If you see a schedule with a “balloon payment” at the end, that means the monthly payments were lower than a fully amortizing payment, and a large lump sum is due at maturity. Always check whether your loan is fully amortizing or has a balloon.

Why the Repayment Schedule Matters

Knowing your repayment schedule helps you understand the true cost of borrowing. The total interest figure shows how much extra you pay for the convenience of using the lender’s money. It also helps you plan your monthly budget, since you know exactly how much will be due each month.

For example, a $20,000 loan at 8% for 5 years costs $4,331.20 in interest. If you extend the term to 10 years, the monthly payment drops to about $242.66, but total interest rises to $9,119.20. The schedule shows this trade-off clearly.

How to Build Your Own Schedule

You can create a repayment schedule in a spreadsheet or by hand. Here are the steps:

  1. Start with the principal balance.
  2. For each month, calculate interest = balance × monthly rate.
  3. Subtract interest from your fixed monthly payment to get the principal portion.
  4. Subtract the principal portion from the balance to get the new balance.
  5. Repeat for each month until the balance reaches zero.

Alternatively, you can use the calculator above to get the monthly payment and total interest instantly, then use those numbers to fill in the schedule.

Common Mistakes and Misconceptions

  • Using the annual rate as the monthly rate: Always divide by 12. Using 8% instead of 0.6667% per month will massively overstate interest.
  • Forgetting to round the payment: Lenders round to the nearest cent. If you use an unrounded payment, your final balance may be a few cents off.
  • Assuming the interest portion is equal each month: It decreases over time, so a flat interest amount is wrong.
  • Ignoring extra payments: If you make extra payments, the schedule changes; the loan may be paid off early, and total interest will be lower.

Frequently Asked Questions

What is the Hindi word for repayment schedule?

The common Hindi term is “पुनर्भुगतान अनुसूची” (punarbhugatan anusuchi). In banking contexts, you may also hear “ऋण चुकौती तालिका” (rin chukauti talika) meaning loan repayment table.

How do I calculate EMI from a repayment schedule?

EMI is the fixed monthly payment shown in the schedule. You can calculate it using the formula above or use the calculator on this page. Just enter the loan amount, interest rate, and term, and the calculator gives the monthly payment.

Why is my first payment mostly interest?

Because interest is calculated on the full outstanding balance. In the first month, the balance is the highest, so the interest is the highest. As you pay down the principal, the interest portion decreases.

Can I change my repayment schedule?

Some lenders allow you to make extra payments or pay off the loan early, which changes the schedule. You can also refinance to get a different rate or term. Always check with your lender for any prepayment penalties or fees.

What happens if I miss a payment?

Missing a payment usually triggers a late fee and may affect your credit score. The lender may also adjust the schedule or accelerate the loan. Contact your lender immediately if you anticipate a missed payment.

This repayment schedule calculator provides an estimate based on standard loan arithmetic. Your lender’s official disclosure statement will show the exact schedule and terms for your specific loan.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →