EMI Calculation - Excel Formula & Expert EMI Calculator

Sdílet
Vložit
  • čas přidán 21. 08. 2024

Komentáře • 909

  • @AssetYogi
    @AssetYogi  Před 11 měsíci +1

    Sign-up to our new app for discounts and early access:
    ✔ assetyogi.com/sign-up/

  • @yktewatia
    @yktewatia Před 4 lety +5

    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

  • @guitarkahero4885
    @guitarkahero4885 Před 3 lety +7

    Genuinely want to thank you for sharing your knowledge. Gratitude🙏. Your calculator is very precise. Great great work. Kudos!

  • @VaibhavYawalkar
    @VaibhavYawalkar Před 4 lety +9

    best calculator ever. Especially graphical representation is wonderful. Respect for your hard and smart work

    • @AssetYogi
      @AssetYogi  Před 4 lety +1

      Thanks for appreciation Vaibhav

    • @rakeshsingha7451
      @rakeshsingha7451 Před 2 lety

      @@AssetYogi Sir aap types of interest ke baade mein ek video banaiye jo bank se duara lete hai

  • @NadeemAbbasnadx
    @NadeemAbbasnadx Před 3 lety +12

    Your Explanation is precise and realistic,and the excel sheet is amazing-definitely what I was searching for.
    Thank-you!

  • @sachinpatil8360
    @sachinpatil8360 Před 4 lety +6

    Thank you..This sheet will be with me for 18 years from now.

  • @yagvendratiwari1969
    @yagvendratiwari1969 Před 6 měsíci

    सर, मैं आप का दिल से बहुत - बहुत धन्यवाद करता हूँ Excel EMI Calculator उपलब्ध करवाने के लिए । 🙏

  • @vinaykumarsingh9042
    @vinaykumarsingh9042 Před 3 lety +1

    आप द्वारा दी गयी जानकारी के लिए हम आप के अत्यंत आभारी हैं... शुभकामनाएं!💖🙏🏻🙏🏻

  • @tzubair8671
    @tzubair8671 Před 4 lety +9

    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 :)

  • @rupsonakhatun6894
    @rupsonakhatun6894 Před 4 lety +10

    Thank you... Sir... This video is really helpful.

  • @rahdk
    @rahdk Před 6 lety +1

    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.

    • @AssetYogi
      @AssetYogi  Před 6 lety

      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.

    • @vijayprajapati6458
      @vijayprajapati6458 Před 5 lety

      Monthly Emi He Yaa Yearly

  • @rashedali4298
    @rashedali4298 Před 4 lety +1

    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.

    • @sangitasatam9977
      @sangitasatam9977 Před 4 lety

      Sir please PMT calculation of present value on simple calculater

  • @amanmishra9445
    @amanmishra9445 Před 4 lety +7

    Sir, very helpful calculator. Thank you so much

    • @AssetYogi
      @AssetYogi  Před 4 lety +2

      Keep supporting Aman :)

    • @ajinkyabadakh6244
      @ajinkyabadakh6244 Před 3 lety

      @@AssetYogi Very helpful Sheet
      Sir,
      May we get EMI excel sheet using simple interest formula ?

  • @-7-man
    @-7-man Před 4 lety +4

    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

  • @pradeepchauhan2107
    @pradeepchauhan2107 Před 2 lety +1

    थैंक्स भाई आपकी मेहनत को सलाम

  • @infinitysolution4053
    @infinitysolution4053 Před rokem +1

    😊thank u boss it is very good for not known person in Loan segment like me.

  • @bhaskarraju5432
    @bhaskarraju5432 Před 5 lety +10

    Sir this calculator is fantastic. How can I download this.

    • @sahil_patni47
      @sahil_patni47 Před rokem

      Calculator nahi h ms-excel he vo sirf pc me hi hota h

  • @saurabhgadi5817
    @saurabhgadi5817 Před 4 lety +4

    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.

  • @tejashreedeshmukh7600
    @tejashreedeshmukh7600 Před 3 lety +2

    Amazing.. This has help me to understand in better way. What I like the most is prepayment column mentioned in sheet.... Thank you😊

  • @Aspirant_Aspects
    @Aspirant_Aspects Před 5 měsíci

    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

  • @SaeedKhan20319
    @SaeedKhan20319 Před 5 lety +3

    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

  • @jaybarva7350
    @jaybarva7350 Před 4 lety +7

    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

  • @mmrahman85
    @mmrahman85 Před rokem +1

    Very Helpful Sir, Yahi main dhund raha tha. Thanks a lot and keep upto date..

  • @rituchopara1762
    @rituchopara1762 Před 6 lety +4

    Easy EMI calculation tool

    • @AssetYogi
      @AssetYogi  Před 6 lety

      Thanks! You can download the EMI calculator and use it the way you want.

    • @subhashshrestha2884
      @subhashshrestha2884 Před 5 lety

      download nahi hota hey sir
      ..please make a process of download

    • @nansfilms2430
      @nansfilms2430 Před 5 lety

      I have downloaded your EMI calculator under tenure i am unable enter the value its only showing date

    • @singhroshan600
      @singhroshan600 Před 5 lety

      Download hota kaha hai ??

    • @sayeedmushraf3378
      @sayeedmushraf3378 Před 5 lety

      Ritu Chopara hi

  • @rahulmehra375
    @rahulmehra375 Před 5 lety +8

    Is it possible to check if we make any part payment without reducing loan tenure then how much EMI amount will decrease?

    • @surindermohan9632
      @surindermohan9632 Před 3 lety

      I am interested to take loan from bank amounting to rs2lakh @9.75 for I year . please tell me EMI.Thank you

  • @anilgaur9747
    @anilgaur9747 Před 5 lety +2

    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

  • @kalp9832
    @kalp9832 Před 2 lety +1

    What an amazing calculator 👏👏👏🥳🥳🥳 thank you assetyogi sahab...

  • @vishalgavande3477
    @vishalgavande3477 Před 4 lety +3

    how to calculate loan tenure
    example : loan amount = 20000, rate of int = 18%, and emi amount =2000
    find out tenure

  • @sappywakode
    @sappywakode Před 5 lety +3

    can't download the file

  • @anoopsharma3742
    @anoopsharma3742 Před 4 lety +1

    Sir I watch this video it's very fantastic and your way to teaching EMI calculation simple.Thanks a lot

  • @Learn.With.Krishna.
    @Learn.With.Krishna. Před 3 měsíci

    Thank you so much sir due to your video of loan calculator I save my good amount.... Thanks a lot sir 🎉🎉🎉🎉🎉

  • @johnywesco4143
    @johnywesco4143 Před 4 lety +4

    That calculator still available to download?

  • @debkumarnaha1413
    @debkumarnaha1413 Před 4 lety +3

    If interest rate change in the middle of month then how it calculate?

  • @dipeshgupta1173
    @dipeshgupta1173 Před 2 lety +1

    Your explanation is so easy & nice.

  • @carepatel6266
    @carepatel6266 Před 4 lety +1

    sir app ke video or app dono bahut nice ho . me roj rapke video dekha hu.

  • @thekuabazarrastriyayouthco3913

    sir ji emi calculation downlod nei hota ha

  • @officesumitkhanna8980
    @officesumitkhanna8980 Před 3 lety +2

    Great Sir, Really Thankful to you for your genuine guidance and concept explanation in a very simple way ,you are really doing wonderful job

  • @enjoyinghere8095
    @enjoyinghere8095 Před 3 lety +2

    I like the work you have done on Excel

  • @sandeepsingh-hm9ty
    @sandeepsingh-hm9ty Před 2 lety +2

    Sir It's outstanding calculator 👌👌

  • @brd8764
    @brd8764 Před 4 lety +1

    Calculated savings. Risk management. Support for family. Money in need.

  • @palashmairal3271
    @palashmairal3271 Před 10 měsíci

    Thankyou for the information and the calculator. Easy and simple to use.

  • @g.ghiremath7387
    @g.ghiremath7387 Před 4 lety +1

    thank you sir for explanation & that calculator made my doubts clear regarding my house loan.thank u so much

  • @rakeshrawat21
    @rakeshrawat21 Před 4 lety +1

    bahut acha hai apka calculator... ekdam mast.....

  • @AnilKumar-hf3zo
    @AnilKumar-hf3zo Před 4 lety +1

    Very nice calculator. I would like to great thanks to you that you are providing such informative videos ralated to finance. Thank you

  • @ncreationvlog
    @ncreationvlog Před 2 lety +1

    Thank you
    Very very good information
    Thanks again

  • @SandeepChauhan-kk2pp
    @SandeepChauhan-kk2pp Před 4 lety +1

    I never see this type of video with a very simple method

  • @rahulgajgjghate
    @rahulgajgjghate Před 4 lety +1

    thanks for the excel sheet and you described in a very good way. all the best for the upcoming videos

    • @AssetYogi
      @AssetYogi  Před 4 lety

      Thanks for appreciation Rahul :)

  • @santoshpatel2060
    @santoshpatel2060 Před 4 lety +1

    Bahut achha calculation hai

  • @harishgautambhaktisagar656

    Bahut help full video hain

  • @ramsalunkhe4521
    @ramsalunkhe4521 Před 4 lety +1

    Great EMI calculator neverseen before
    Great efforts thanks for it i was looking for that and i found it in your channel 🤗🤗🙏

  • @anandchoudhary6575
    @anandchoudhary6575 Před 3 lety +1

    Thank You So much Mukul Ji. Really Helpful.

  • @jatinderchohan3288
    @jatinderchohan3288 Před 6 lety +1

    Thankyou sir,I have downloaded the free EMI calculator.

  • @foundaditya
    @foundaditya Před 10 měsíci

    This is a very useful calculator sir 🙏🙏

  • @rakeshmohan754
    @rakeshmohan754 Před 6 lety +1

    Very Nice EMI Calculator and Super easy to Use

    • @AssetYogi
      @AssetYogi  Před 6 lety

      Thanks! Hope you've download the EMI calculator.

  • @syedazam275
    @syedazam275 Před 3 lety +1

    Superb explanation very simple thank you.

  • @yogeshavhad5724
    @yogeshavhad5724 Před 3 lety +1

    Thanks sir
    For very helpful pre payment calculator

  • @mohammedqan1402
    @mohammedqan1402 Před 2 lety +1

    Appreciate your efforts..!

  • @shivamvohra3016
    @shivamvohra3016 Před 4 lety +1

    Thanks sir aap ne bohot accha samjhaya

  • @user-us8jv3hy6k
    @user-us8jv3hy6k Před 2 lety +2

    Best calculator 💯💯💯

  • @user-qq5fp4he3v
    @user-qq5fp4he3v Před rokem

    Amazing calculator !! Great job !!

  • @MujaffarsPodcast
    @MujaffarsPodcast Před 4 lety +1

    *Gazab sir.* Thank YoU For this Calculator. Thank YoU so Much Sir.

  • @asitbaranchoudhury1351
    @asitbaranchoudhury1351 Před 3 lety +1

    Fantastic articulation of concept, very helpful

  • @aashishmishra4159
    @aashishmishra4159 Před 3 lety +1

    Nice explaination, The excel shared is not editable, it's view only

  • @parmarmayur144
    @parmarmayur144 Před 2 lety +1

    I love your work very very helpful sir 🙏🙏🙏🙏

  • @sandeshdhamnekar5866
    @sandeshdhamnekar5866 Před 4 lety +2

    Thanks this is the best EMI calculator

  • @richaathavale8481
    @richaathavale8481 Před 3 lety

    excellent job. Very useful as calculation of break-up and after prepayment is complicated.

  • @musicmix8826
    @musicmix8826 Před 10 měsíci

    Best calculater sir 👍👍👍👍👍👍👍👍👍

  • @md.ayubansari730
    @md.ayubansari730 Před 6 měsíci

    Jabardasta hai sir , thank you for sharing

  • @noumaanrazaismaily9607
    @noumaanrazaismaily9607 Před rokem +1

    Very good all in one EMI Calculator file

  • @preetibhatt2616
    @preetibhatt2616 Před rokem +1

    Thank you so much its very helpful🙏

  • @financecentre1079
    @financecentre1079 Před 4 lety +1

    what a calculator sir really owesome

  • @HardeekSShah
    @HardeekSShah Před 2 lety +1

    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.

  • @ssiddiqui8079
    @ssiddiqui8079 Před 2 lety +1

    Bhai Ek no ... I want to gain my financial Knowledge any suggesstion

  • @rohitwankhede4390
    @rohitwankhede4390 Před 4 lety

    Thankyou sir..Bahot badhiya hai ye calculator..

  • @chetantomar6487
    @chetantomar6487 Před 4 lety +2

    Thank You! Great Job done by you as always ..!!!

  • @harishgautambhaktisagar656

    Sir very useful information

  • @kartikgulatti8091
    @kartikgulatti8091 Před 6 lety +1

    very nice EMI calculator. It is really very easy in use

    • @AssetYogi
      @AssetYogi  Před 6 lety

      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.

  • @YashwantV07
    @YashwantV07 Před 2 lety +1

    VERY VERY THANKS 🙏

  • @mohitphp5
    @mohitphp5 Před 2 lety

    Really helpful! You’re doing a wonderful job!

  • @rajendrabajpai1443
    @rajendrabajpai1443 Před 3 lety +1

    Nicely explained the nuances. Thanks

  • @soumyodiptamukherjee
    @soumyodiptamukherjee Před 3 lety +1

    Thank you for sharing. Really helpful!!

  • @mzrto825
    @mzrto825 Před 3 lety +1

    Thank you for your great help Sir, its is really helpful

  • @mangeshhagawane3214
    @mangeshhagawane3214 Před rokem +1

    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.

  • @mayankkhare8746
    @mayankkhare8746 Před 4 lety +1

    Superb job sir.. calculator is very helpful. Thank you

    • @AssetYogi
      @AssetYogi  Před 4 lety

      Hope it helps Mayank :)

    • @Ranganath2936
      @Ranganath2936 Před 4 lety

      @@AssetYogi sir, could you give us the protection password of excel sheet

  • @SandeepChauhan_Channel

    Great calculator and easy to understand, thanks a lot

  • @pankajbaher
    @pankajbaher Před 3 lety +1

    Thanks AY for the calculator and nice content! Keep it up.

  • @RinkeshAcharya
    @RinkeshAcharya Před 4 lety

    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 .

  • @Kalijidurgajimandirfatehgarh

    Very Nice, Thanks ,I have downloaded the free EMI calculator.

    • @AssetYogi
      @AssetYogi  Před 6 lety

      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.

    • @amitkapoor5
      @amitkapoor5 Před 6 lety

      I also want to download pls help

    • @rushikeshchavan8427
      @rushikeshchavan8427 Před 4 lety

      hi, vinay can u able to send me that excel sheet, m not getting it, please support.

  • @kishorpawar4087
    @kishorpawar4087 Před 2 lety +1

    Nice Sir...very helpful calculator

  • @hardeepsingh7390
    @hardeepsingh7390 Před 6 lety +1

    Bhai Waah Kia calculator bnaia hee it's very helpful to other people jinko iska Pta nhi lagtaa

    • @AssetYogi
      @AssetYogi  Před 6 lety

      Jankar khushi huyi, thank you 😊

  • @nehanirala6300
    @nehanirala6300 Před 4 lety +1

    I downloaded the calculator..thanks for it..

  • @RanjeetKumar-jl1fs
    @RanjeetKumar-jl1fs Před 4 lety +1

    Sir,This calculator is Very helpful.

  • @ravitripathiforsex
    @ravitripathiforsex Před 6 lety +1

    Nice technique of EMI calculation

    • @AssetYogi
      @AssetYogi  Před 6 lety

      Hope you have downloaded the EMI calculator.

  • @dulaldas7650
    @dulaldas7650 Před 2 lety +1

    very detailed calculator
    Thanks for the calculator

  • @vamshi270
    @vamshi270 Před 5 lety +1

    Thank you. I was looking for this functionality.

  • @ManjiitSingh
    @ManjiitSingh Před 4 lety +1

    Thank you sir, main aesa hi kuch dhund raha tha

  • @sumitn44
    @sumitn44 Před 4 lety +1

    Thank you for sharing, very helpful. Really appreciate it.

    • @AssetYogi
      @AssetYogi  Před 4 lety

      Thanks for appreciation Sumit

  • @krushnawayal3212
    @krushnawayal3212 Před 4 lety +1

    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

  • @vishnumeena840
    @vishnumeena840 Před 3 lety +1

    very help full video sir ji

  • @girishbondarde7915
    @girishbondarde7915 Před 3 lety +1

    very well explain 👌👌👌
    and thanx alot sir🙏