Home Loan Repayment Tips with Calculation | Prepayment Calculator in Excel

Home Loan Repayment Tips with Calculation | Prepayment Calculator in Excel
In this video by FinCalC TV we will see Home Loan Repayment Tips with Calculation in hindi. We will see 5 tips to save home loan interest amount in long term.
Also we will check home loan EMI calculator to know the EMI and total interest amount to be paid.

Home Loan Calculator Online:

Website Blog:

DOWNLOAD Home Loan Calculator in Excel:

Home Loan Prepayment Reduce EMI or Tenure:

Mutual Fund Returns Calculation Video:

JOIN Telegram Group:

CHAPTERS:
00:00 Home Loan Repayment Tips Intro
01:12 #1 Make Home Loan Prepayments
01:58 Prepayment Examples using Excel
08:41 #2 Keep Loan Tenure Low
09:07 FinCalC Blog Home Loan Calculator
13:24 #3 Keep Loan Interest Rate LOW
13:48 #4 Never miss Loan EMI Payments
14:05 #5 Tax Benefits on Home Loan

WHAT IS HOME LOAN EMI CALCULATOR
Home Loan EMI Calculator helps you to calculate home loan EMI (Equated Monthly Installment). This calculation helps you in planning for loan to buy or construct new house so that you get the idea of monthly loan EMI you will be paying.

Loan EMI Calculator also helps you to know the Total Interest you will be paying throughout your loan tenure. The Total Amount you pay to close your loan is Loan Amount + Total Interest

HOME LOAN EMI CALCULATION METHOD
- Home loan EMI can be easily calculated in excel using PMT function
- PMT function takes 3 parameters: Interest Rate, Remaining months and Principal value remaining
- Interest rate provided should be the monthly home loan interest rate divided by 100
- Remaining months is the number of months remaining for which EMIs are yet to be paid
- Principal value is the outstanding principal amount remaining in your loan account
- Remember, your EMI consists of 2 things: Principal Amount and Interest Amount
- Interest Amount is high initially, and decreases with time
- Principal Amount is low initially, and increases with time

COMPONENTS OF LOAN EMI
- Basically there are 2 components of loan EMI – Principal Amount and Interest Amount
- Principal amount is low initially and increases with time
- Interest amount is high initially and decreases with time
- Majority of Interest amount is paid by you during the first half of your loan tenure
- As you move towards your loan closure by paying all EMIs on time, very less interest if left to be made making it difficult to save loan interest using loan prepayment option
- Thus, it is recommended that if you are making loan prepayments to save interest, make the payments during initial half of the loan so that you can save maximum interest on your loan
- Car Loan EMI is also calculated in same way as above

FACTORS AFFECTING LOAN EMI
2 factors affect Loan EMI – Interest Rate and Tenure
- Higher the interest rate, more interest amount you will be paying
- Longer the tenure, more interest amount you will be paying
You should try to take loan with minimum interest rate and tenure to save maximum interest amount

#HomeLoan #Repayment #Calculator #FinCalC

============================
LIKE | SHARE | COMMENT | SUBSCRIBE

Mujhe Social Media par FOLLOW kare:

============================
MORE VIDEOS:

============================
DISCLAIMER:
Examples and demo used are for Illustration purpose only and might not cover every detail of examples shown.

[fincalc]

Home Loan Repayment Tips Video Kaisa laga? COMMENT KARO 👇👇
Home Loan EMI Calculator:
JOIN Telegram Group:

[damodarvaishnav]

अच्छे से बताया, धन्यवाद
On line process hona चाहिए

[jaihind]

Very nice information and guidance. Nice video brother. Keep going😊. God bless you.

[sankarkumarmukherjee]

Very happy with your expert Nicely explained

[sameer.]

Sir jaise agar mai home loan leta hu aur 12 emi ke jagah 13 emi krta hu toh woh ek extra emi kaise jama kr skta hu taaki loan ka tenure jaldi khtm ho ske jaise 20k ki emi hai 30 saalo tk toh mai ek extra emi dekr isko kam saal mei like jo bhi ho 24, 25 saal mei kaise khtam kr skta hu? Kyaa procedure hai iska aur ispe kyaa charges bhi lagenge principal amount mei ek extra emi dene pr ?

[lamtureshivbhakt]

Do you have any calculator which can give input if we increase EMI % every year ?

[MPrabhu-gz]

Namasthe sir 25 year home loan pe every year 4 extra emi pay kiya toh kitne saal me home loan clear hoga.tenure kitna ghatega.

[ashishpolinati]

Can you help to clarify at what time of a month it is better to prepay the amount? I was told that some simple interest is calculated, so better to pay the amount on 1st of every month rather than end of month

[ameenrulz]

Can you please share the excel sheet. Thanks 😊😊 for informative video

[NandakumarWorlikar]

Could you please tell me if doing prepayment in the 11th month of first year of home loan is beneficial or could it be done any time during the 1st year for better tenure reduction?

[himanshusinha]

Agar 20lacs ka loan liya gya hai jise bank har 3 month me 4 - 4 lacs krke 5 baar me degi to aise case me emi kaise calculate hoga for complete tenure
Interest rate =8.85%
Tenure= 6 yrs
Please ispe video banaiye

[frksfk]

Nice Video Good Explanation in details

[rushikeshpatil]

I need this excel calculator its very useful

[priyankakapadiya]

Bank manejer 2 mahina pachi pre payment karvanu kahe che...Ane kahe che in come tex vala tex bharavase

[naveenkumarl]

Sir my home loan is 86 lakhs Nd emi is 74500 for 25 years.
With interest rate of 9.1%
So if I pay 4 lakhs yearly as part payment then how many years I can close the home loan

[RaviGupta-djeg]

Very informative pls share excel calculation

[LaxmanSingh-nytc]

आपका वीडियो काफी मददगार है!मैने साठ लाख का होम लोन बीस साल की अवधी के लिए लिया था!सैतालिस हजार रूपए प्रति माह की किस्त चुका रहा हू!फिलहाल ब्याज साढे नो प्रतिशत की दर से एस बी आई बैंक ले रही है, मै दस लाख रुपए एकमुश्त चुकाकर, बाकी लोन पांच या सात साल मे खत्म करना चाहता हू।!मुझे कोई ऐसा कोई फार्मूला बताइए जिससे मै कितने रूपए की एक्सट्रा किसत जमा कराकर लोन से मुक्त हो सकता हू!मै आपकी सलाह का इन्तज़ार करूंगा

[MaheshKumar-oibg]

time se pement nahi kare to uska fine or internet kaise add karege calculate me

[ameenrulz]

Bhai please share excel sheet link. 🙏 thanks

[pradeepredkar]

Boss, if we paid extra payment on loan. In this case bank will raise intrest then it will came same tenure.