Home Loan EMI Calculator Excel with Principal & Interest Examples| Home Loan EMI Excel Calculation
HTML-код
- Опубликовано: 19 авг 2024
- Home Loan EMI Calculator Excel with Principal & Interest Examples| Home Loan EMI Excel Calculation
In this video by FinCalC TV, we will see how to calculate home loan EMI using Excel Calculator formula examples in hindi and home loan principal & interest amounts calculation excel sheet prepayment option. We will also see how you can save home loan interest by home loan repayment calculation. We will also see how interest and principal amounts of Home Loan EMI will be calculated. Home loan EMI can be increased to reduce the total interest.
DOWNLOAD Home Loan EMI Excel Calculator:
fincalc-blog.i...
Loan Prepayment Video:
• Home Loan EMI Prepayme...
After watching this video following queries will be solved:
How to calculate home loan EMI?
How to calculate home loan EMI in excel sheet?
What is home loan EMI calculation excel formula?
What is home loan EMI calculation formula?
How to reduce home loan interest?
Home loan prepayment or repayment options?
Principal and interest amounts of home loan emi?
Home loan emi increase will save interest amount?
Increase in EMI will decrease loan interest payment?
Benefits of home loan prepayments?
What is home loan emi not paid?
DOWNLOAD our FREE ANDROID APP "FinCalC":
play.google.co...
OUR 2nd CHANNEL LINK:
/ @gharkirecipes558
What is Home Loan EMI Calculator?
Home Loan EMI Calculator assists in calculation of the loan installment i.e. EMI towards your home loan. It an easy to use calculator and acts as a financial planning tool for a home buyer.
What is Home Loan EMI?
EMI stands for Equated Monthly Installment. It includes repayment of the principal amount and payment of the interest on the outstanding amount of your home loan. A longer loan tenure (for a maximum period of 30 years) helps in reducing the EMI.
How does EMI calculation help in planning the home purchase?
Home Loan EMI calculator gives a clear understanding of the amount that needs to be paid towards the EMIs and helps make an informed decision about the outflow towards the housing loan every month. This helps estimate the loan amount that can be availed and helps in assessing the own contribution requirements and cost of the property. Therefore knowing the EMI is crucial for calculation of home loan eligibility and planning your home buying journey better.
Factors that Affect Housing Loan EMI
Principal- The principal is the loan amount that you avail from the lender. It is directly proportional to your EMIs - lower principal will lower your monthly instalments and vice versa.
Rate of interest- The rate of interest is the rate at which the lender offers you the loan. It is also directly proportional to the value of your loan EMIs.
Tenure- The tenure is the time within which you repay your loan. The tenure is inversely proportional to your loan EMIs - longer tenure makes the monthly instalments cheaper and vice versa.
What is Home Loan Amortization Schedule?
Loan amortization is the process of reducing the debt with regular payments over the loan period. A home loan amortization schedule is a table giving the details of the repayment amount, principal and interest component.
EMI calculators give a fair understanding about the ratio of the principal amount to the interest due, based on the loan tenure and interest rates. EMI calculator also provides an amortization table elucidating the repayment schedule. Home loan calculator provides a complete break-up of the interest and principal amount.
How do part-prepayments impact your EMIs?
Part-prepayment brings down the principal amount, which in turn lowers the interest amount that you have to pay, which results in lower EMI amounts overall.
#LoanEMICalculator #HomeLoanEMI #EMIExcelFormula #Excel #Calculator #FinCalCTV
=============================
LIKE || SHARE || COMMENT || SUBSCRIBE
Mujhe Social Media par FOLLOW kare:
Facebook : / fincalctv
Twitter : / fincalctv
BLOG: fincalc-blog.in
==========================================
PPF Interest Calculation with Examples in EXCEL:
• PPF Excel Calculator |...
Income Tax Calculation using EXCEL:
• Income Tax Excel Calcu...
Senior Citizen Savings Scheme EXCEL Calculator:
• SCSS Excel Calculator|...
Fixed Deposits EXCEL Calculator:
• FD Interest Calculatio...
Income Tax Return Filing Step by Step Video:
• How To File ITR Online...
Income Tax Calculation for Senior Citizens Video:
• Income Tax Calculation...
==========================================
DISCLAIMER:
Examples used are for Illustration purpose only and might not cover every detail of examples shown. It is advised to seek professional help before taking any financial decisions. The owner of this channel shall not be liable in any way.
Calculator Link: fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/
MORE VIDEOS:
Loan EMI Prepayment Calculator: ruclips.net/video/liGgfgMn5xg/видео.html
SIP Excel Calculator: ruclips.net/video/9xkS7ts4Kvc/видео.html
Income Tax Calculator: ruclips.net/video/mw-erFuYboM/видео.html
20 Years SIP Calculator: ruclips.net/video/088S2Zk7sYU/видео.html
PPF Excel Calculator: ruclips.net/video/ZNfX0rQkbPI/видео.html
FREE Android App: play.google.com/store/apps/details?id=com.rrr.apps.financialcalculator
Telegram: t.me/fincalc_tv
LIKE || SHARE || SUBSCRIBE
9ĺò8ppppppppppp0pppp0ppppppppppppppppppp
Best video I found after struggling for so long. Thank you so much bro for the simple explanation. Hats off ❤
Apka video dek kar mane 2lak ka intrest bcha iyaa thankyou sirrrrrr😊
Welcome 🙂
Very good explaination sir❤❤
Outstanding bro ... What a unique voice .... And so easy to understand... Thank you bro
Welcome bro 😀👍
Thank you very much, this presentation helped me a lot!!!!
Glad it helped!
500 👍 likes from my side
Thanks 👍🙂
Best Video ever in youtube
thank you so much
Very Helpful, thanks for this.
Thankyou very much for such a very informative video.
Welcome 👍
So easy and simple to understand 👌
Excellent explanation helped me alot thank you for this :) you got a new subscriber :)
Thank you so much for your lovely comment. Please share my videos with your friends as well🙂👍
Personal Loan for contact me ..
7351072160
Thanks alot
Welcome
Good job bro... ! Keep posting this kind of info
yes sure. thanks for your comment. Keep sharing and commenting :)
Personal Loan for contact me ...
Bro very nice video very helpfull bro
Glad it helped
Nice। information...thanks for sharing
Welcome 👍
Thanks a lot dear 🙏🙏💐💐
Most welcome 😊
500 👍 like meri taraf se
Thanks a lot 🙂👍
Personal Loan for contact me ....
Thanks for this video
Most welcome
Very Well Explained.
Thanks for liking
I have calculated, thank you
Thank you very much sir.
Welcome 👍
Nice video Thanks
Glad you liked it
Thank u for ur kind information
welcome
Video starts at 5. It’s should be crisp. No need to repeat same thing again and again.
Thanks for your feedback Neha. Will improve on upcoming videos. Stay tuned 🙂👍
Home loan me emi me se intrest jyada kt ta h or principal bhut km
Apk example me emi me se principal amount jyada h or intrest amount km
Hmare ek sal ka jo emi gya h usme se principal amount 19000 or intrest amount 68000 gya tha
yes kyuki aapka loan tenure lambe samay ke liye hoga. Mere example me 8 years hai isliye kam hai
loan calculator check karo: fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/
Actual video will start at 4:50
Very good explain thanks
Glad it was helpful!
Very informative video
Thank you 👍
Personal Loan for contact me ...
Thnqu sir
Most welcome
Great work.. I tried downloading it by filling the form, but haven't received yet in mail. By the way, can u plz share the calculation with reducing EMI, too?
Thank you so much..bhai.. was looking for this..
Most welcome 😊
@@fincalc However is it same for Mortgage loan ?
@@imcjeewan0627 yes
@@fincalc Okie thank u..😊
Amazing explanation...very clear and precise...thank you so much for sharing
Glad it was helpful!
Bohot khoob
thank you
Useful video 👍❤
Nicely explained...good job bro..keep it up👍
welcome, keep watching
very useful. thanks
Welcome 🙂👍
Personal Loan for contact me ...
Sir thank u very much for such a nice information i was searching for the same information
Welcome. Check this video as well, you might like it link ruclips.net/video/liGgfgMn5xg/видео.html
Very helpful
Very useful ❤️❤️
thanks
Very useful sir and one think pesonal loan interest type of videos sharing sir
Will upload soon. Thank you :)
Personal Loan for contact me .
Aapne accha bataya jo bhi bataya sbko smajh aya par mujhe nhi aya kyoki mera installment bharne ke baad bhi kabhi dusra account kabhi kam ho jata hai phir badh jata hai
Thank you for such informative video. I have a question that can we transfer money from foreign account to Indian home loan account?
Thanks. You can transfer from foreign account to Indian Bank account from which emi is getting deducted every month. From this account you can pay the loan amount
Thank you sir
Welcome 👍🙂
Zabardast .
thanks
Great
Thanks sir ❤❤❤
Good information
Thanks
Excellent video !! Very well explained
Thank you 👍🙂
Personal Loan for contact me ...
Superb Sir
Information 👏👏👏
awaiting your additional or advance payment in home loan,please create asap. further i request to create video on gold loan emi also. thanks
Yes will be uploading those videos as well. Stay tuned 👍🙂
Here's the video on home loan prepayment / advance loan payment: ruclips.net/video/liGgfgMn5xg/видео.html
Personal Loan for contact me ..
How to accommodate this calculators with increasing/decreasing interest rate during the tenure ?
watch this video:
ruclips.net/video/3EQvsWdBruY/видео.html
excel already shared on my website
Matlab Excel Wale Bhaiya Ne Jo Loan Liya Tha 30lakh ka
Unhone 8 saal mein 9 lakh ke kareeb interest diya aur 30 lakh principle amount bhi alag se diya.
Total.smjh lo 40lakh diya bank ko
10lakh rs extraa 🤯🤯 wahh
haan ji bhaiya..
aur ye video ki tarah prepayment karke loan interest bhi bacha liya
ruclips.net/video/liGgfgMn5xg/видео.html :):)
@@fincalc sir kya aap
"ADHAAR HOUSING FINANCE "
COMPANY LT
MEIN DETAIL VIDEO SHARE KR SKTE HAI?
KYA USSE LOAN LENA CHAHEYE KI NAHI OR USKE INTERESTS RATE.
Very nice
Thanks man very informative
Glad it was helpful!
Personal Loan for contact me ...
Maza aagya
Good night.
Great video 👍
Thanks 👍
Personal Loan for contact me ..
Video start after 2:55
He was expecting 500 likes for this and he is at 7.6K.
Great info thanks
Welcome 🙂👍
Personal Loan for contact me ..
Thanks for the detailed information dude, its very useful
welcome. Stay tuned for more such videos :)
super sir
thanks
10q so much sir
Sir home loan amount: 48,00,000, 8.6% tenur:17 years, loan taken single time: but first: 4 years: 59771 rs ,remains:13 years= 35768 rs how to calculate excel sheet for prepayment ,planning for reducing Tenurs please explain sir.
(Interest rate+1) to the power n how to calculate formula please provide
Use this emi calculator on my website
fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/
Also watch this video to understand more about home loan
ruclips.net/video/lsbcQkJBGC8/видео.htmlsi=sRjzKOG3JQttzBVb
Please also create video on vehicle loan , consumer loan,gold loan ASAP
Personal Loan for contact me ..
Please provide video after disbursement loan calculation
Ok
Personal Loan for contact me .
7351072160..
Jitna disbursement hota hai uske anusar emi banati hai ya sanction loan par. Yadi pura disbursh hone me 6 month lagte hai to emi kaise calculate karenge.
Same procedure hai EMI calculate Karne Ka. Disbursement amount pe calculate hota hai EMI
Personal Loan for contact me ..
Is me ye to batana tha ki is setup me ham total kitna intrest bharenge, yaani hamne jo 30 lakh ka loan lia is pe kitna extra pay kia hamne
Bataya hai na Bhai total interest paid. Home loan emi calculator bhi banaya hai vaha bhi aap check kar sakte ho total amount paid. Link fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/
Can i increase my Emi or can i pay lum sum amount like one EMI extra
Which is beneficial
both options are good. If you can afford to increase EMI than you should do that, or else make prepayments every 3-4 months
Thanks for video. But I have different query. I have in last stage of home loan after 10 years. Aprox 6 lakhs is remaining. Should I pay the whole amount or let it go as emi? Any suggestions? Any calculator available?
Sir, Maine 15 lac home loan 9.5 % interest par 23 saal tak loan liya hai. Iske liye har mahine 13195 rs EMI de raha hoon. Iske alawa har saal ek emi zyada pay karta hoon, aur har mahine repayment of principal amount 10000 rs pay karta hoon. Kripya karke aap mujhe yeh batha deejiye mera loan kitne saal me khatam hoga? Thankyou.
🙏 veer ji aap se ek request hai veere muje ek video daily rs1000 deposit par mil jaye aap ki sied se agr posible ho to uss par interest rate 3% ya kuch bhi example k liye jo bhi ho ek chota sa video agr posible ho to veer ji daily deposit par 🙏
Daily deposit kisme? Savings account me ya loan account me?
Hi there, execellent video. I have a query; this calculation doesn't match when there is a rise in interest rates, since bank also changes the tenure depending on that. In that scenario how to calculate?
PS. I have tried putting the modified values in the "Months Remaining" and "Interest" column.
Yes, correct.
Watch this video when interest rate changes in home loan:
ruclips.net/video/3EQvsWdBruY/видео.html
hope this helps
Very important and helpful video. But I want to know that some bank after home loan disbursement to the staff members of the Bank recover only interest amount from staff members up to some period on housing loan, then some period they start to recover principal amount from staff members of housing loan. So in this case how to prepare Excel worksheet for this type of recovery home loan EMI in case of staff members,,? Please guide us according ly . ASAP thanks
Personal Loan for contact me ..
7351072160
What if I deposit a certain sum of money to my loan account other than the emi ...how will it work ? Got to hear that the amount deposited will be directly reduced from the principal amount . Is it true ?
Do you have any video which explain about the under construction properly and where full emi is getting deducted
Not yet but planning to upload soon. Stay tuned👍
@@fincalc will be waiting for it. Also another point is how interest and principal getting impacted due to change of ROI base RLLP
@@amitchettri_ac already made a video recently on home loan interest rate increase impact with calculations.
Watch here: ruclips.net/video/Iddvu55S0vg/видео.html
Amazing excel explanation 👌just wanted to confirm the amount mentioned under "interest" tab would be the amount we would be paying to the bank on monthly basis right.
Yes, correct
Personal Loan for contact me ..
7351072160
Pl
What about floating interest rate? How we can calculate
yes floating interest rate calculation in another video.
watch here: ruclips.net/video/3EQvsWdBruY/видео.html
Hi ..sir same apke.jaisa formula lagane k baad enter marte hi value error aa rha ...pls tell me how to resolve.it
Ye home loan calculator use Karo emi check karne ke liye fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/
Loan - 9,80,000
Time - 15 year
Interst -13%
I am paying EMI on every month 15th how to prepare repayment schedule
My loan is not fully arrived.. And they started taking installment for the amount which they provided, what to do sir.. Could u tell me when is the starting of installment, after loan fully arrived or in between 1part of loan?
I don't have Excel file But I tried to calculate emi I can't understand
Use this emi calculator on my website
fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/
Also watch this video to understand more about home loan
ruclips.net/video/lsbcQkJBGC8/видео.htmlsi=sRjzKOG3JQttzBVb
Sir I took car loan for five lakhs with 7.75 interest rate for three years and what will be the EMI
Ok please use the car loan emi calculator here
fincalc-blog.in/car-loan-emi-calculator/
Hope this helps 👍
Thank you sir but as per your calculation I have to pay 15611 but the bank is deducting 16100 why this difference..?
As i extended the values for 8 years, the emi amount wasn’t constant…it kept increasing. Any reason why this must be happening…i want to keep it fixed. What should i do in excel to fix this?
Copy the value of first EMI and select all remaining cells, right click > paste special > values in the remaining cells instead of extending 🙂
Soon I'll fix that issue in the shared loan document. Stay tuned 🙂👍
Personal Loan for contact me ..
Sir ap muje principal amount ka btaye ki vo kaise bdah jati hai
loan prepayment karke aap principal badha sakte ho.. ye video dekho: ruclips.net/video/liGgfgMn5xg/видео.html
Tq sir ,sir aap hame bataye ki EMI continue karte huye jo kuch amounts pre pay karte h to kya wo amount remaining principal amount me minus hoga?
Yes minus hota hai.. prepayment ka video dekho ye vala
ruclips.net/video/liGgfgMn5xg/видео.htmlsi=ZiDj6qAG7xHb7dDk
Is there any excel sheet, where we can calculate wth floating roi also
?
for floating rates you need to make changes in the excel. Watch this video: ruclips.net/video/Iddvu55S0vg/видео.html
soon I'll make another vide on floating rates as well with excel. Stay tuned
bhai mere upar Home loan hai jiska mere account se 14500 ki EMI katati hai... par pichle mahine se iske saath 9500 ka ek or deduction ho raha hai... jispe Drawdown from CASA likha hota hai... ye kya hota hai ??? please explain.
Hello, if you know the principal amount and repayment total value. How to find the interest percentage on this method And also know about the Monthly EMI.
But the SBI staff not willing to explain this difference and saying go and check in your yono SBI app there is nothing to talk with you
Sir, I will pay 1 or 2 extra EMI in every year. So these extra amount will count as full principal amount or including minimum interest. My loan lender said your extra emi will be calculate from Last EMi. Hope my question understable
It will be considered as full principal amount + interest of few days will be taken
Watch this video for loan prepayment
ruclips.net/video/liGgfgMn5xg/видео.html
@@fincalc Thank you
@@fincalc 1 more question, How much % EMI can pay from salary for easy life. Because I will going to take 2 loan PL and HL. PL for Down payment and others. And HL for flat cost.
@@Mumbai80 total emi should not be more than 50% of your monthly salary for easy life
Pahle nahi liya jata hai...jaise jaise principle paid kiya jata hai ...obviously...interest kam hoga.....
Mujhe bank me bataya ki "pehle hum interest wasool karenge in EMI bad me apka principal amount add hota jayega". Pls ye bat mene usko samzai nhi man raha tha.pehle sirf interest EMI se jayega bola.ye rules kaha milenge kou bataye pls.
ye saare rules bank vale nahi samjhayenge
EPF Excel Calculation for closing organization please give table
Here's the excel file calculation video for EPF
Link: ruclips.net/video/t7CsLyqaFac/видео.html
Personal Loan for contact me ...
I am doing with the same formula when I entered fx, the ans is not getting in to box B3. The formula dialog box showing the correct result, but getting xxxxxxx in the B3 box. Why ? Please guide me in this regard. Thank you .
Please increase the width of that B column or any other column you are facing such issue. This issue occurs when the number doesn't get enough width to fit itself in excel sheet
Personal Loan for contact me ..