I cannot express how grateful I am for this excel you have shared. Can gauge that from the fact that I have watched lakhs of videos on youtube but this is my first comment ever. You are doing a great job by making these videos. Thanks a lot. Respect
Kudos!!! very informative brother Mukul , watched around 15 of your videos on different important topics in past few days. Here I'd like to know that these days as per RBI norms few banks such as HDFC Bank is calculating RPLR which is changing quarterly, so in this case how can we calculate Quarterly changing Loan Amount, Interest Rate and New Tenure left (in months)? Can you please update your EMI calculator so that those who watched this video like me now in 2020 during this pandemic can be benefitted. May God bless you....Thanks :)
Thanks Rahul. Hope you have subscribed to the channel. Many more informative videos coming up. Also, please press the bell icon in your mobile so that you get the notification of our latest video.
thanks bro for your precious gift to us, got complete figure of my loan repayment........i was afraid that i am paying more but the principal amount is decreasing very less, now its clear.
Hi sir, I checked your emi calculator. In case of pre-payment, this calculator reduces Tenure and keeps EMI constant. Can we keep the tenure constant and reduce EMI in this calculator? or if you can include that option in this calculator, it would be great.
Sir ye EMI calculator bahut achha hai isme apko ek important thing aur add karna chahiye jaise kisi ka koi emi agar miss ho Jaye to loan ke month aur interest par kya asar hota hai iski calculation honi chahiye
Great video But home loan m interest amount, property ki price s Zyada kyu hota h? Or 8.5% interest rate ka phir kya matlab Mujhe 25 lacs ka home loan lena h To mujhe 25 years m kitna interest pay Karna padega Pls reply
Good Morning Mukul, I regularly follow your channel, it's been great so far! Can you please help me with formula for calculation of EMI if loan is on Simple Interest and principal gets deducted first? @Assetyogi
Informative video. Thanks. There is fundamental difference in loan REPAYMENT PROCESS of govt deptt and Banks. In case of govt LOAN we first repay only PRINCIPAL.EMI does not include interest. After repayment of principal we pay the interest. Example;: loan ten lakh, rate 10 % period 15 yrs for principal repayment. EMI 5000 PM FOR 170 MONTH and 15000 pm for remaining 10 month. loan is received in 2 instalment. 5 lakh in jan 2000 and 5 lakh in May 2000. REPAYMENT EMI of principal begin in JULY 2000. PL CALCULATE MONTH WISE interest. ANIL GAUR ,DD
Excellent calculator. Thanks a lot. Could you also show the working of how Under Construction is better of or worse off than RTMI or vice-versa - as the case may be. Especially when we are currently staying on rent.
Thanks! You can use this EMI calculator to calculate EMI for any type of Loan including home loan, personal loan, education loan, car loan, bike loan or any other type of EMI credit card EMI, EMI for online shopping etc.
Hi Mukul Ji, This is a nice calculator, It would be great help if you also consider the changing rate of interest %, change in EMI amount, etc (interim changes to loan) to capture so that this will give us the exact details of the remaining Payments & tenure.This will be great help.
Tq sir .Your Video Helps A lot . Please Make a video with Real example about how to make Financial Statment For Bank Loan . which factors are very Immeportant at Bankers Point Of view . please . waiting For Your Reply .
Thanks Vinay. Hope you have subscribed to the channel. Many more informative videos coming up. Also, please press the bell icon in your mobile so that you get the notification of our latest video.
Videos are best for finance knowledge but sir can you add videos on how to calculate banking by financial institutions or any bank for any type of loan
Sign-up to our new app for discounts and early access:
✔ assetyogi.com/sign-up/
I cannot express how grateful I am for this excel you have shared. Can gauge that from the fact that I have watched lakhs of videos on youtube but this is my first comment ever.
You are doing a great job by making these videos. Thanks a lot. Respect
Genuinely want to thank you for sharing your knowledge. Gratitude🙏. Your calculator is very precise. Great great work. Kudos!
Thanks
best calculator ever. Especially graphical representation is wonderful. Respect for your hard and smart work
Thanks for appreciation Vaibhav
@@AssetYogi Sir aap types of interest ke baade mein ek video banaiye jo bank se duara lete hai
Your Explanation is precise and realistic,and the excel sheet is amazing-definitely what I was searching for.
Thank-you!
Hope it's helpful 😊
Thank you..This sheet will be with me for 18 years from now.
सर, मैं आप का दिल से बहुत - बहुत धन्यवाद करता हूँ Excel EMI Calculator उपलब्ध करवाने के लिए । 🙏
आप द्वारा दी गयी जानकारी के लिए हम आप के अत्यंत आभारी हैं... शुभकामनाएं!💖🙏🏻🙏🏻
Kudos!!! very informative brother Mukul , watched around 15 of your videos on different important topics in past few days. Here I'd like to know that these days as per RBI norms few banks such as HDFC Bank is calculating RPLR which is changing quarterly, so in this case how can we calculate Quarterly changing Loan Amount, Interest Rate and New Tenure left (in months)? Can you please update your EMI calculator so that those who watched this video like me now in 2020 during this pandemic can be benefitted. May God bless you....Thanks :)
Thankyou 😊
Thank you... Sir... This video is really helpful.
Good to hear that Rupsona :)
Dwlod nai hora sir emi ka
This is one of the best EMI calculator. Best part is , it show if you pay much how much interest will get calculate.
Thank you.
Thanks Rahul. Hope you have subscribed to the channel. Many more informative videos coming up. Also, please press the bell icon in your mobile so that you get the notification of our latest video.
Monthly Emi He Yaa Yearly
thanks bro for your precious gift to us, got complete figure of my loan repayment........i was afraid that i am paying more but the principal amount is decreasing very less, now its clear.
Sir please PMT calculation of present value on simple calculater
Sir, very helpful calculator. Thank you so much
Keep supporting Aman :)
@@AssetYogi Very helpful Sheet
Sir,
May we get EMI excel sheet using simple interest formula ?
Hello.
One question.
I think the bank calculates interest on a daily basis and not on a monthly basis. There is huge difference after a few years
थैंक्स भाई आपकी मेहनत को सलाम
😊thank u boss it is very good for not known person in Loan segment like me.
Glad to hear that
Sir this calculator is fantastic. How can I download this.
Calculator nahi h ms-excel he vo sirf pc me hi hota h
Hi sir, I checked your emi calculator. In case of pre-payment, this calculator reduces Tenure and keeps EMI constant. Can we keep the tenure constant and reduce EMI in this calculator? or if you can include that option in this calculator, it would be great.
Amazing.. This has help me to understand in better way. What I like the most is prepayment column mentioned in sheet.... Thank you😊
Sir ye EMI calculator bahut achha hai isme apko ek important thing aur add karna chahiye jaise kisi ka koi emi agar miss ho Jaye to loan ke month aur interest par kya asar hota hai iski calculation honi chahiye
Great video
But home loan m interest amount, property ki price s Zyada kyu hota h?
Or 8.5% interest rate ka phir kya matlab
Mujhe 25 lacs ka home loan lena h
To mujhe 25 years m kitna interest pay Karna padega
Pls reply
Good Morning Mukul,
I regularly follow your channel, it's been great so far!
Can you please help me with formula for calculation of EMI if loan is on Simple Interest and principal gets deducted first? @Assetyogi
Very Helpful Sir, Yahi main dhund raha tha. Thanks a lot and keep upto date..
Thanks
Easy EMI calculation tool
Thanks! You can download the EMI calculator and use it the way you want.
download nahi hota hey sir
..please make a process of download
I have downloaded your EMI calculator under tenure i am unable enter the value its only showing date
Download hota kaha hai ??
Ritu Chopara hi
Is it possible to check if we make any part payment without reducing loan tenure then how much EMI amount will decrease?
I am interested to take loan from bank amounting to rs2lakh @9.75 for I year . please tell me EMI.Thank you
Informative video. Thanks. There is fundamental difference in loan REPAYMENT PROCESS of govt deptt and Banks. In case of govt LOAN we first repay only PRINCIPAL.EMI does not include interest. After repayment of principal we pay the interest. Example;: loan ten lakh, rate 10 % period 15 yrs for principal repayment. EMI 5000 PM FOR 170 MONTH and 15000 pm for remaining 10 month.
loan is received in 2 instalment. 5 lakh in jan 2000 and 5 lakh in May 2000. REPAYMENT EMI of principal begin in JULY 2000. PL CALCULATE MONTH WISE interest. ANIL GAUR ,DD
What an amazing calculator 👏👏👏🥳🥳🥳 thank you assetyogi sahab...
how to calculate loan tenure
example : loan amount = 20000, rate of int = 18%, and emi amount =2000
find out tenure
can't download the file
Sir I watch this video it's very fantastic and your way to teaching EMI calculation simple.Thanks a lot
Thank you so much sir due to your video of loan calculator I save my good amount.... Thanks a lot sir 🎉🎉🎉🎉🎉
That calculator still available to download?
it is in description
If interest rate change in the middle of month then how it calculate?
Your explanation is so easy & nice.
Thanks a lot
sir app ke video or app dono bahut nice ho . me roj rapke video dekha hu.
sir ji emi calculation downlod nei hota ha
how can i get the link?
Great Sir, Really Thankful to you for your genuine guidance and concept explanation in a very simple way ,you are really doing wonderful job
Thanks 😊
Sir EMI calculator work nhi kerta
I like the work you have done on Excel
Thanks
Sir It's outstanding calculator 👌👌
Thanks and welcome
Calculated savings. Risk management. Support for family. Money in need.
Thankyou for the information and the calculator. Easy and simple to use.
thank you sir for explanation & that calculator made my doubts clear regarding my house loan.thank u so much
bahut acha hai apka calculator... ekdam mast.....
Thanks 😊
Very nice calculator. I would like to great thanks to you that you are providing such informative videos ralated to finance. Thank you
Keep learning Anil
Thank you
Very very good information
Thanks again
You are welcome.
I never see this type of video with a very simple method
thanks for the excel sheet and you described in a very good way. all the best for the upcoming videos
Thanks for appreciation Rahul :)
Bahut achha calculation hai
Dhanyawad 😊
Bahut help full video hain
Great EMI calculator neverseen before
Great efforts thanks for it i was looking for that and i found it in your channel 🤗🤗🙏
Bro phone mein chlta hai kyaa yeh?
@@neerajsharma15431 ha bHia chalta hai
Thank You So much Mukul Ji. Really Helpful.
Keep learning 😊
Thankyou sir,I have downloaded the free EMI calculator.
Jatinder Chohan Great!
This is a very useful calculator sir 🙏🙏
Very Nice EMI Calculator and Super easy to Use
Thanks! Hope you've download the EMI calculator.
Superb explanation very simple thank you.
Keep learning Syed 😊
Thanks sir
For very helpful pre payment calculator
Appreciate your efforts..!
So nice of you
Thanks sir aap ne bohot accha samjhaya
Dhanyawaad :)
Best calculator 💯💯💯
Thanks :)
Amazing calculator !! Great job !!
*Gazab sir.* Thank YoU For this Calculator. Thank YoU so Much Sir.
Fantastic articulation of concept, very helpful
Thanks Asit 😊
Nice explaination, The excel shared is not editable, it's view only
Thanks :)
My bad working fine, Thank you so much sirji
I love your work very very helpful sir 🙏🙏🙏🙏
Thanks.
Thanks this is the best EMI calculator
Keep learning
excellent job. Very useful as calculation of break-up and after prepayment is complicated.
Best calculater sir 👍👍👍👍👍👍👍👍👍
Jabardasta hai sir , thank you for sharing
Very good all in one EMI Calculator file
Thanks
Thank you so much its very helpful🙏
Most welcome Preeti
what a calculator sir really owesome
Excellent calculator. Thanks a lot. Could you also show the working of how Under Construction is better of or worse off than RTMI or vice-versa - as the case may be. Especially when we are currently staying on rent.
Bhai Ek no ... I want to gain my financial Knowledge any suggesstion
Watch our videos :)
Thankyou sir..Bahot badhiya hai ye calculator..
Thank You! Great Job done by you as always ..!!!
Thanks Chetan :)
Sir very useful information
Keep watching
very nice EMI calculator. It is really very easy in use
Thanks! You can use this EMI calculator to calculate EMI for any type of Loan including home loan, personal loan, education loan, car loan, bike loan or any other type of EMI credit card EMI, EMI for online shopping etc.
VERY VERY THANKS 🙏
Really helpful! You’re doing a wonderful job!
Nicely explained the nuances. Thanks
Thank you for sharing. Really helpful!!
Keep learning 😊
Thank you for your great help Sir, its is really helpful
You are most welcome
Hi Mukul Ji, This is a nice calculator, It would be great help if you also consider the changing rate of interest %, change in EMI amount, etc (interim changes to loan) to capture so that this will give us the exact details of the remaining Payments & tenure.This will be great help.
How to download your calculator
Superb job sir.. calculator is very helpful. Thank you
Hope it helps Mayank :)
@@AssetYogi sir, could you give us the protection password of excel sheet
Great calculator and easy to understand, thanks a lot
Thanks AY for the calculator and nice content! Keep it up.
Hope it's helpful 😊
Tq sir .Your Video Helps A lot .
Please Make a video with Real example about how to make Financial Statment For Bank Loan . which factors are very Immeportant at Bankers Point Of view . please . waiting For Your Reply .
Very Nice, Thanks ,I have downloaded the free EMI calculator.
Thanks Vinay. Hope you have subscribed to the channel. Many more informative videos coming up. Also, please press the bell icon in your mobile so that you get the notification of our latest video.
I also want to download pls help
hi, vinay can u able to send me that excel sheet, m not getting it, please support.
Nice Sir...very helpful calculator
Keep watching
Calculator name Kya hai
Bhai Waah Kia calculator bnaia hee it's very helpful to other people jinko iska Pta nhi lagtaa
Jankar khushi huyi, thank you 😊
I downloaded the calculator..thanks for it..
Keep learning
Sir,This calculator is Very helpful.
Keep learning
Nice technique of EMI calculation
Hope you have downloaded the EMI calculator.
very detailed calculator
Thanks for the calculator
You are welcome
@@AssetYogi ✌️
Thank you. I was looking for this functionality.
Thank you sir, main aesa hi kuch dhund raha tha
I hope this will be useful:)
Thank you for sharing, very helpful. Really appreciate it.
Thanks for appreciation Sumit
Videos are best for finance knowledge but sir can you add videos on how to calculate banking by financial institutions or any bank for any type of loan
very help full video sir ji
Glad to hear that
very well explain 👌👌👌
and thanx alot sir🙏
Hope it's helpful