Diwali Sale: 25% off everythingEnds in03days12hrs16min13sec
Draftstack
Home Loan Prepayment & Balance Transfer Calculator (Excel) – Excel template preview
Excel & SheetsNew

Home Loan Prepayment & Balance Transfer Calculator (Excel)

Find out how much interest you save by prepaying your home loan or paying a little extra every month, and whether moving to a lower-rate bank is worth the charges.

₹84₹399Save ₹315 (79%)
Inclusive of all taxes · One-time payment · Instant download
See a free sample (PDF)
Diwali Sale: 25% off, ends 09 Nov, 12:00 AM
Instant downloadOn screen + email
Secure paymentUPI · Cards · Net Banking
7-day helpFix or refund if faulty
Perfect for
Home loan borrowers with a bonus or savings to useFamilies considering a balance transferAnyone planning to close a loan early
What you get2 × .xlsx (blank + sample)
Works withMicrosoft Excel · Google Sheets · WPS Office
DeliveryInstant download
LicencePersonal & own-business use
Home, Family & Events Mega Bundle: Budgets, Savings, Wedding & Festival Kits – bundle preview Get the whole Mega BundleHome, Family & Events Mega Bundle: Budgets, Savings, Wedding & Festival Kits · ₹2,899 · you save ₹4,986See →

Frequently bought together

Home Loan Prepayment & Balance Transfer Calculator (Excel) – Excel template previewThis item: Home Loan Prepayment & Balance Transfer Calculator (Excel)₹84Loan EMI Calculator & Debt Payoff Planner – Excel template previewLoan EMI Calculator & Debt Payoff Planner₹112Monthly Bills Due Date Calendar & Paid Tracker (Excel) – Excel template previewMonthly Bills Due Date Calendar & Paid Tracker (Excel)₹74
All three: ₹270Sale prices
Made for India
Indian tax rulesCovers old vs new regime.
Amounts in ₹Money columns are already set to rupees.
Priced in rupeesPay in ₹. Download right after payment.

A home loan is the biggest interest bill most families pay, and small changes make a big difference over 15 to 20 years. This calculator puts the three common choices side by side.

What it does

  • Current loan: EMI and the interest still to pay from your outstanding amount, rate and remaining months
  • Prepayment: a lump sum now, and a lump sum plus a fixed extra each month; months left, total interest, interest saved and months saved for each plan
  • Balance transfer: new EMI at the new rate, monthly saving, interest saved over the loan, net saving after charges and months to recover the charges
  • Verdict: worth checking, small saving (ask your bank to match), or not worth it

Before you prepay

Compare the interest you save with what the money would earn elsewhere after tax, and keep an emergency fund. Tax benefits depend on your tax regime.

What's inside

Everything you get

01

Your Loan

Current loan, prepayment and transfer inputs

02

Prepayment table

Interest and months saved for 3 plans

03

Balance transfer

Net saving and break-even months

04

Blank + sample

Sample ₹32 lakh loan

Files in your download

  • XLSXHome_Loan_Prepayment_Balance_Transfer.xlsx11 KB
  • XLSXHome_Loan_Prepayment_Balance_Transfer_SAMPLE.xlsx11 KB
How to use

Start in 5 simple steps

A step-by-step guide is also included inside your download.

  1. 1

    Copy from your statement

    Balance, rate, months

  2. 2

    Try a prepayment

    Lump sum and extra monthly

  3. 3

    Enter the new offer

    Rate and all charges

  4. 4

    Compare savings

    Side by side

  5. 5

    Talk to your bank

    Ask for a rate reset first

FAQ

Questions about this product

Does prepayment reduce my EMI or tenure?

Banks usually keep the EMI and reduce the tenure, which saves more interest. This calculator shows the tenure option. Ask your bank if you want a lower EMI instead.

Is there a penalty for prepaying?

For individual borrowers on floating rate home loans, banks generally cannot charge a prepayment penalty under RBI rules. Fixed rate loans may have charges; check your sanction letter.

Should I transfer for a 0.5% lower rate?

It depends on the balance, remaining months and charges. The sheet shows the net saving and how many months it takes to recover the charges. Often your own bank will reduce the rate if you ask.

Will prepayment affect my tax benefit?

It can reduce the interest you claim, depending on the tax regime. Check with a tax professional.

Does it work on a phone?

Yes, in Google Sheets or the Excel app.

How do I get the files after payment?

A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.

Can I use it on my phone?

Yes. It works with Microsoft Excel, Google Sheets, WPS Office. Free mobile apps are enough.

What if something does not work?

Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.

Our promiseEvery file is tested before launch. If something doesn't work, we fix it or refund you within 7 days. Refund policy
Complete the set

Goes well with this

See all
₹84₹399