Home Loan EMI Calculator Excel with Principal & Interest Examples| Home Loan EMI Excel Calculation

[@fincalc]

Calculator Link: fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/ MORE VIDEOS: Loan EMI Prepayment Calculator: kzbin.info/www/bejne/opqqmJmdgtNorsk SIP Excel Calculator: kzbin.info/www/bejne/b6nOhGqqqJl-rMU Income Tax Calculator: kzbin.info/www/bejne/o6iQlqV8qr6Vpa8 20 Years SIP Calculator: kzbin.info/www/bejne/ZmmbhGWQoJymj7c PPF Excel Calculator: kzbin.info/www/bejne/kH_JiWOohtCVhqs FREE Android App: play.google.com/store/apps/details?id=com.rrr.apps.financialcalculator Telegram: t.me/fincalc_tv LIKE || SHARE || SUBSCRIBE

[@rajeshwariregonda1311]

9ĺò8ppppppppppp0pppp0ppppppppppppppppppp

[@JAIPUR2465]

Apka video dek kar mane 2lak ka intrest bcha iyaa thankyou sirrrrrr😊

[@fincalc]

Welcome 🙂

[@marvellouschandan]

Best video I found after struggling for so long. Thank you so much bro for the simple explanation. Hats off ❤

[@cliffordmanohar9553]

Thank you very much, this presentation helped me a lot!!!!

[@fincalc]

Glad it helped!

[@Superr77-m9v]

Thank you for such informative video. I have a question that can we transfer money from foreign account to Indian home loan account?

[@fincalc]

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

[@mclub_mclub]

Best Video ever in youtube

[@fincalc]

thank you so much

[@iramworld95]

Outstanding bro ... What a unique voice .... And so easy to understand... Thank you bro

[@fincalc]

Welcome bro 😀👍

[@sushmaranishandilya3722]

Nice। information...thanks for sharing

[@fincalc]

Welcome 👍

[@muralikrishnansiddharaj1342]

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?

[@alphatgamer9073]

Bro very nice video very helpfull bro

[@fincalc]

Glad it helped

[@arshinaaz1658]

Thankyou very much for such a very informative video.

[@fincalc]

Welcome 👍

[@shilpakarpe1955]

I have calculated, thank you

[@rajeshlanke]

So easy and simple to understand 👌

[@Achieve.cookie]

Very good explaination sir❤❤

[@bhumikasoni361]

Very Well Explained.

[@fincalc]

Thanks for liking

[@AbhiR-gk7kz]

Very Helpful, thanks for this.

[@rakeshchinna7946]

Good job bro... ! Keep posting this kind of info

[@fincalc]

yes sure. thanks for your comment. Keep sharing and commenting :)

[@bankingbanking8401]

Personal Loan for contact me ...

[@balakumar5137]

Very useful sir and one think pesonal loan interest type of videos sharing sir

[@fincalc]

Will upload soon. Thank you :)

[@bankingbanking8401]

Personal Loan for contact me .

[@mycreations.5505]

Zabardast .

[@fincalc]

thanks

[@muhammadaamil]

Sir thank u very much for such a nice information i was searching for the same information

[@fincalc]

Welcome. Check this video as well, you might like it link kzbin.info/www/bejne/opqqmJmdgtNorsk

[@imcjeewan0627]

Thank you so much..bhai.. was looking for this..

[@fincalc]

Most welcome 😊

[@imcjeewan0627]

@@fincalc However is it same for Mortgage loan ?

[@fincalc]

@@imcjeewan0627 yes

[@imcjeewan0627]

@@fincalc Okie thank u..😊

[@basudebbhatta3492]

Thank you very much sir.

[@fincalc]

Welcome 👍

[@anildiwaker2850]

500 👍 like meri taraf se

[@fincalc]

Thanks a lot 🙂👍

[@bankingbanking8401]

Personal Loan for contact me ....

[@kajal3441]

Useful video 👍❤

[@spsingh4206]

500 👍 likes from my side

[@fincalc]

Thanks 👍🙂

[@stuart8243]

Thanks for this video

[@fincalc]

Most welcome

[@sarathbalivada6479]

Thanks alot

[@fincalc]

Welcome

[@vilasvaydande2676]

Nice video Thanks

[@fincalc]

Glad you liked it

[@abhishekverma4290]

Very informative video

[@fincalc]

Glad you liked it

[@santhoshkumar-pq4nf]

Thank u for ur kind information

[@fincalc]

welcome

[@veer8393]

Very good explain thanks

[@fincalc]

Glad it was helpful!

[@neethuvijaykumar1461]

Excellent explanation helped me alot thank you for this :) you got a new subscriber :)

[@fincalc]

Thank you so much for your lovely comment. Please share my videos with your friends as well🙂👍

[@bankingbanking8401]

Personal Loan for contact me ..

[@bankingbanking8401]

7351072160

[@janakiramananv8920]

Amazing explanation...very clear and precise...thank you so much for sharing

[@fincalc]

Glad it was helpful!

[@hawkeye5611]

Bohot khoob

[@fincalc]

thank you

[@sunilbaskerraokothuri9281]

Good information

[@fincalc]

Thanks

[@pappukumar2200]

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?

[@fincalc]

Yes minus hota hai.. prepayment ka video dekho ye vala kzbin.info/www/bejne/opqqmJmdgtNorsksi=ZiDj6qAG7xHb7dDk

[@Ckyadavvlog435]

Very useful ❤️❤️

[@fincalc]

thanks

[@meenakharatmal6575]

very useful. thanks

[@fincalc]

Welcome 🙂👍

[@bankingbanking8401]

Personal Loan for contact me ...

[@subhashkhatri9609]

Nicely explained...good job bro..keep it up👍

[@fincalc]

welcome, keep watching

[@papiyamazumder2215]

Excellent video !! Very well explained

[@fincalc]

Thank you 👍🙂

[@bankingbanking8401]

Personal Loan for contact me ...

[@shrivastwaravi4509]

Thank you sir

[@fincalc]

Welcome 👍🙂

[@subhashjatta9392]

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

[@pranavvaishy]

Information 👏👏👏

[@hareshyewale609]

Very nice

[@tapannandi1283]

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?

[@OmPandey-mk4ny]

Can i increase my Emi or can i pay lum sum amount like one EMI extra Which is beneficial

[@fincalc]

both options are good. If you can afford to increase EMI than you should do that, or else make prepayments every 3-4 months

[@fragrenceful]

awaiting your additional or advance payment in home loan,please create asap. further i request to create video on gold loan emi also. thanks

[@fincalc]

Yes will be uploading those videos as well. Stay tuned 👍🙂

[@fincalc]

Here's the video on home loan prepayment / advance loan payment: kzbin.info/www/bejne/opqqmJmdgtNorsk

[@bankingbanking8401]

Personal Loan for contact me ..

[@prabirpaul5526]

..Bardhokko Bhatar taka..ki joint account Thakle Tate Paowa jabe..??

[@sfdmusic7666]

సూపర్

[@raniras8850]

Superb Sir

[@Mumbai80]

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

[@fincalc]

It will be considered as full principal amount + interest of few days will be taken Watch this video for loan prepayment kzbin.info/www/bejne/opqqmJmdgtNorsk

[@Mumbai80]

@@fincalc Thank you

[@Mumbai80]

@@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.

[@fincalc]

@@Mumbai80 total emi should not be more than 50% of your monthly salary for easy life

[@vikashalve5566]

Hi sir ji muze ye excel sheet me mera loan dalna hai to main kaise download karke edit kar sakta hu ...pls guide me

[@fincalc]

Home loan emi calculate karne ke liye ye calculator use Karo fincalc-blog.in/home-loan-emi-calculator-and-calculation-method/ Isme hi mene excel ka bhi link Diya hai

[@vipulkadam1697]

Please provide video after disbursement loan calculation

[@amitchettri_ac]

Do you have any video which explain about the under construction properly and where full emi is getting deducted

[@fincalc]

Not yet but planning to upload soon. Stay tuned👍

[@amitchettri_ac]

@@fincalc will be waiting for it. Also another point is how interest and principal getting impacted due to change of ROI base RLLP

[@fincalc]

@@amitchettri_ac already made a video recently on home loan interest rate increase impact with calculations. Watch here: kzbin.info/www/bejne/f5XHp6hrarhjrMk

[@ADITYARAJ-yg3zy]

super sir

[@fincalc]

thanks

[@rishabhgarg9371]

Bhai apne interest rate simple liya h ya compound ?

[@kamarrajn2103]

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.

[@arun4846]

Thanks sir ❤❤❤

[@rajeevvarshney4956]

Is there any excel sheet, where we can calculate wth floating roi also ?

[@fincalc]

for floating rates you need to make changes in the excel. Watch this video: kzbin.info/www/bejne/f5XHp6hrarhjrMk soon I'll make another vide on floating rates as well with excel. Stay tuned

[@kumarmnojpvc4687]

🙏 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 🙏

[@fincalc]

Daily deposit kisme? Savings account me ya loan account me?

[@Waheed_Shaik]

Actual video will start at 4:50

[@vadlamaniaditya7020]

Thanks man very informative

[@fincalc]

Glad it was helpful!

[@bankingbanking8401]

Personal Loan for contact me ...

[@SuvojitAown]

How to accommodate this calculators with increasing/decreasing interest rate during the tenure ?

[@fincalc]

watch this video: kzbin.info/www/bejne/aXa0p6aNmaelq7s excel already shared on my website

[@basudebbhatta3492]

Good night.

[@prabhatsingh9571]

Great info thanks

[@fincalc]

Welcome 🙂👍

[@bankingbanking8401]

Personal Loan for contact me ..

[@kunal.rathod]

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.

[@fincalc]

Yes, correct. Watch this video when interest rate changes in home loan: kzbin.info/www/bejne/aXa0p6aNmaelq7s hope this helps

[@fragrenceful]

Please also create video on vehicle loan , consumer loan,gold loan ASAP

[@bankingbanking8401]

Personal Loan for contact me ..

[@tarunsir09]

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.

[@fincalc]

Same procedure hai EMI calculate Karne Ka. Disbursement amount pe calculate hota hai EMI

[@bankingbanking8401]

Personal Loan for contact me ..

[@mallikarjunhadimani7230]

Thnqu sir

[@fincalc]

Most welcome

[@atharva_khiste]

Great

[@brainsbrawns3933]

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 ?

[@esarabhiram]

Thanks for the detailed information dude, its very useful

[@fincalc]

welcome. Stay tuned for more such videos :)

[@tgvlogs2000]

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?

[@SureshKumar-xb3ol]

10q so much sir

[@fragrenceful]

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

[@bankingbanking8401]

Personal Loan for contact me ..

[@bankingbanking8401]

7351072160

[@ravalhiren9479]

Emi se jyada rakam bharege to interest cut hoga?

[@xyzvideos288]

Personal loan par income tax me rebate milti hai kya ji

[@fincalc]

Nahi

[@mynk9046]

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.

[@shwetametri3704]

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.

[@fincalc]

Yes, correct

[@bankingbanking8401]

Personal Loan for contact me ..

[@bankingbanking8401]

7351072160

[@chandrakanttatkare2839]

Pl

[@ajaykumar571]

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

[@fincalc]

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/

[@sunnyray4550]

Maza aagya

[@littlechamp-agam2012]

Sir, l planned for home loan of 35 lakh for 15 years.one bank gives me roi 8.0℅ and he charges about 21000 for processing fee stamp duty etc.and start emi from next month. In which I pay both principal and interest both. Where as other bank gives roi 8.10℅ for same tenure and his processing fee is nill but he takes only interest for one year and then set his emi. I want to know that which bank I prefer for loan so that I pay minimum interest. Please guide me and send me your emi calculations table. So that I could know what interest I payed for whole tenure. Thank you. Please answer shortly

[@nehamoroney]

Video starts at 5. It’s should be crisp. No need to repeat same thing again and again.

[@fincalc]

Thanks for your feedback Neha. Will improve on upcoming videos. Stay tuned 🙂👍

[@mathsreasoningclasses6074]

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

[@fincalc]

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/

[@keshavlande2122]

I am paying EMI on every month 15th how to prepare repayment schedule

[@srinivaskandala4578]

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.

[@suhitbasu2507]

(Interest rate+1) to the power n how to calculate formula please provide

[@fincalc]

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 kzbin.info/www/bejne/oqTFlIShf6d6eZosi=sRjzKOG3JQttzBVb

[@sushma6556]

Sir I took car loan for five lakhs with 7.75 interest rate for three years and what will be the EMI

[@fincalc]

Ok please use the car loan emi calculator here fincalc-blog.in/car-loan-emi-calculator/ Hope this helps 👍

[@sushma6556]

Thank you sir but as per your calculation I have to pay 15611 but the bank is deducting 16100 why this difference..?

[@2u4uAnand]

He was expecting 500 likes for this and he is at 7.6K.

[@user-gu9qz5ns7v]

Sir, your videos are very helpful and informative .thank you so much . I don't understand what I do ? kindly calculate the tenure , principle , interest, against 1.2 percent increased ROI. I have taken home loan 15,00,000 for 15 yrs. Emi 15581. at 9.2 % roi But( nbfc) has increased 1.2%more. Now it becomes 10.4 percent. EMI is same .but nbfc has increased my tenure by 2 yrs. Without asking me. Kindly calculate the tenure please.also principle and interest. Kindly provide the correct info. to know what actually is going on at nbfc. Please please 🙏 help me.

[@Deepak-qe2li]

What about floating interest rate? How we can calculate

[@fincalc]

yes floating interest rate calculation in another video. watch here: kzbin.info/www/bejne/aXa0p6aNmaelq7s

[@rokky2916]

Government bank ka bhi yahi system hai?

[@fincalc]

Ha

[@shaikhussain6110]

What tenure is to select better for homeloan .

[@apurva315]

Thanks sir mujhe asset from home. Lone Mai kase bharte h

[@bankingbanking8401]

Personal Loan for contact me .

[@manishanarang4827]

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?

[@fincalc]

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 🙂👍

[@bankingbanking8401]

Personal Loan for contact me ..

[@gagandeepSingh-oj5ot]

Sir ap muje principal amount ka btaye ki vo kaise bdah jati hai

[@fincalc]

loan prepayment karke aap principal badha sakte ho.. ye video dekho: kzbin.info/www/bejne/opqqmJmdgtNorsk

[@sushma6556]

Thank you sir as per your calculator the amount is 15611 but the bank deducting 16100 why this difference..?

[@fincalc]

Which bank?

[@sushma6556]

SBI

[@nainaslifestyle161]

Home loan 40lakh tak milta hai kya?? Or agar to emi kitana hoga monthly or kitnti time ke liye pay karna hoga

[@jufsrdaghyijfrazdsfujngfgo2153]

हां मिलता है॥

[@jufsrdaghyijfrazdsfujngfgo2153]

महीने में कितना Pay करना होगा यह देखने के लिए अपने कितनी साल के लिए लोन लिया है और कितने ब्याज दर पर लिया है यह देखना होता है॥

[@ana_freesoul]

Sir the link for excel download does not work. Can you pls provide the excel sheet

[@fincalc]

it's working. Please fill the form in below link to download excel: fincalc-blog.in/home-loan-calculation-method-emi-prepayment-examples-formula/

[@KaranKumar-ty4sd]

Bhai ye batao ki agar me 15 lakh 20 sal ke liye leta hu 7% ke hisab se to Me 20 sal me total kitne pese bank ko vapis dunga pls batana jrur

[@fincalc]

15 Lakh 20 saal me 7% ke hisab se: Total amount aap bank ko vapis doge = ₹ 23,97,143.14 EMI hoga = Rs. ₹ 11,629.48 Total Interest = ₹ 8,97,143.14

[@bankingbanking8401]

Personal Loan for contact me ..