How ₹10,000 Extra EMI Saves You ₹30+ Lakh|Home Loan Amortization Excel Template Explained!- Housing

Welcome back to the channel! In this video, we dive deep into a powerful, automated loan amortization Excel template that helps you clearly understand your EMI payments and how extra payments can significantly reduce your total interest and loan tenure.

📊 What’s Inside:

Full breakdown of EMI without extra payments (30-year loan)

Smart amortization logic using Excel PMT function

Step-by-step demo with interest, principal, and closing balances

Comparison with extra monthly payments (₹10,000 extra from 2nd year)

How loan tenure drops from 30 years to just 13 years and interest drops by over ₹30 Lakh

💡 Whether you're planning a home loan or just want to understand how EMI works — this tool is for you!

🔧 Excel Loan Template Includes:

2 tabs: Without Extra Payment & With Extra Payment

Full amortization schedule (2025 to 2054)

Extra payments starting after 1-year lock-in

Calculated savings on interest and total payments

💰 Quick Comparison:

Without Extra Payment: ₹79,24,657.40 total paid | ₹49,24,657.40 interest

With Extra ₹10,000/month: ₹38,74,276.95 total paid | ₹18,95,659.48 interest | Loan paid off in 13 years

🎁 Download link in the comments (if applicable)

🔔 Don’t forget to:
👍 Like this video
📢 Share it with friends/family planning a loan
📌 Subscribe for more Excel finance tools and tutorials
📝 Comment if you want the template or have questions

Видео How ₹10,000 Extra EMI Saves You ₹30+ Lakh|Home Loan Amortization Excel Template Explained!- Housing канала Tutorials