EMI Calculation - Excel Formula & Expert EMI Calculator

Поділитися
Вставка
  • Опубліковано 27 жов 2024

КОМЕНТАРІ • 912

  • @AssetYogi
    @AssetYogi  Рік тому +1

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

  • @yktewatia
    @yktewatia 4 роки тому +6

    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 3 роки тому +8

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

  • @yagvendratiwari1969
    @yagvendratiwari1969 9 місяців тому

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

  • @VaibhavYawalkar
    @VaibhavYawalkar 4 роки тому +10

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

    • @AssetYogi
      @AssetYogi  4 роки тому +1

      Thanks for appreciation Vaibhav

    • @rakeshsingha7451
      @rakeshsingha7451 2 роки тому

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

  • @Aspirant_Aspects
    @Aspirant_Aspects 7 місяців тому

    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

  • @NadeemAbbasnadx
    @NadeemAbbasnadx 4 роки тому +12

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

    • @AssetYogi
      @AssetYogi  4 роки тому +4

      Hope it's helpful 😊

  • @sachinpatil8360
    @sachinpatil8360 5 років тому +7

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

  • @rahdk
    @rahdk 6 років тому +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  6 років тому

      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 5 років тому

      Monthly Emi He Yaa Yearly

  • @tzubair8671
    @tzubair8671 4 роки тому +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 :)

  • @infinitysolution4053
    @infinitysolution4053 2 роки тому +1

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

  • @rupsonakhatun6894
    @rupsonakhatun6894 5 років тому +11

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

    • @AssetYogi
      @AssetYogi  5 років тому +1

      Good to hear that Rupsona :)

    • @RDXteam484
      @RDXteam484 3 роки тому

      Dwlod nai hora sir emi ka

  • @Learn.With.Krishna.
    @Learn.With.Krishna. 5 місяців тому

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

  • @amanmishra9445
    @amanmishra9445 4 роки тому +7

    Sir, very helpful calculator. Thank you so much

    • @AssetYogi
      @AssetYogi  4 роки тому +2

      Keep supporting Aman :)

    • @ajinkyabadakh6244
      @ajinkyabadakh6244 4 роки тому

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

  • @dipeshgupta1173
    @dipeshgupta1173 3 роки тому +1

    Your explanation is so easy & nice.

  • @saurabhgadi5817
    @saurabhgadi5817 4 роки тому +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.

  • @kalp9832
    @kalp9832 2 роки тому +1

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

  • @SaeedKhan20319
    @SaeedKhan20319 5 років тому +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

  • @palashmairal3271
    @palashmairal3271 Рік тому

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

  • @-7-man
    @-7-man 4 роки тому +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 2 роки тому +1

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

  • @bhaskarraju5432
    @bhaskarraju5432 5 років тому +10

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

    • @sahil_patni47
      @sahil_patni47 Рік тому

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

  • @carepatel6266
    @carepatel6266 4 роки тому +1

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

  • @jaybarva7350
    @jaybarva7350 4 роки тому +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 2 роки тому +1

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

    • @AssetYogi
      @AssetYogi  2 роки тому

      Thanks

    • @tie4621
      @tie4621 2 місяці тому

      ​@@AssetYogiarey chutiye kaha se sikha ye, kuch bhi?

  • @vishalgavande3477
    @vishalgavande3477 4 роки тому +3

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

  • @ncreationvlog
    @ncreationvlog 2 роки тому +1

    Thank you
    Very very good information
    Thanks again

  • @rituchopara1762
    @rituchopara1762 7 років тому +4

    Easy EMI calculation tool

    • @AssetYogi
      @AssetYogi  7 років тому

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

    • @subhashshrestha2884
      @subhashshrestha2884 6 років тому

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

    • @nansfilms2430
      @nansfilms2430 6 років тому

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

    • @singhroshan600
      @singhroshan600 6 років тому

      Download hota kaha hai ??

    • @sayeedmushraf3378
      @sayeedmushraf3378 5 років тому

      Ritu Chopara hi

  • @rashedali4298
    @rashedali4298 4 роки тому +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 4 роки тому

      Sir please PMT calculation of present value on simple calculater

  • @rahulmehra375
    @rahulmehra375 5 років тому +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 3 роки тому

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

  • @foundaditya
    @foundaditya Рік тому

    This is a very useful calculator sir 🙏🙏

  • @sappywakode
    @sappywakode 5 років тому +3

    can't download the file

  • @debkumarnaha1413
    @debkumarnaha1413 4 роки тому +3

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

  • @harishgautambhaktisagar656
    @harishgautambhaktisagar656 Рік тому +1

    Bahut help full video hain

  • @johnywesco4143
    @johnywesco4143 4 роки тому +4

    That calculator still available to download?

  • @musicmix8826
    @musicmix8826 Рік тому

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

  • @thekuabazarrastriyayouthco3913
    @thekuabazarrastriyayouthco3913 6 років тому +2

    sir ji emi calculation downlod nei hota ha

  • @noumaanrazaismaily9607
    @noumaanrazaismaily9607 Рік тому +1

    Very good all in one EMI Calculator file

  • @anoopsharma3742
    @anoopsharma3742 4 роки тому +1

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

  • @DEVANGVERMA-k7g
    @DEVANGVERMA-k7g Рік тому

    Amazing calculator !! Great job !!

  • @rakeshrawat21
    @rakeshrawat21 4 роки тому +1

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

  • @richaathavale8481
    @richaathavale8481 3 роки тому

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

  • @aashishmishra4159
    @aashishmishra4159 3 роки тому +1

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

  • @amitrajmane5326
    @amitrajmane5326 Рік тому

    very nice sir....very informative...thank you sir

  • @preetibhatt2616
    @preetibhatt2616 Рік тому +1

    Thank you so much its very helpful🙏

  • @ssiddiqui8079
    @ssiddiqui8079 3 роки тому +1

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

  • @enjoyinghere8095
    @enjoyinghere8095 3 роки тому +2

    I like the work you have done on Excel

  • @md.ayubansari730
    @md.ayubansari730 8 місяців тому

    Jabardasta hai sir , thank you for sharing

  • @RinkeshAcharya
    @RinkeshAcharya 4 роки тому

    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 .

  • @dulaldas7650
    @dulaldas7650 2 роки тому +1

    very detailed calculator
    Thanks for the calculator

  • @rohitwankhede4390
    @rohitwankhede4390 4 роки тому

    Thankyou sir..Bahot badhiya hai ye calculator..

  • @syedazam275
    @syedazam275 3 роки тому +1

    Superb explanation very simple thank you.

    • @AssetYogi
      @AssetYogi  3 роки тому

      Keep learning Syed 😊

  • @SandeepChauhan_Channel
    @SandeepChauhan_Channel Рік тому

    Great calculator and easy to understand, thanks a lot

  • @vinaykumarsingh9042
    @vinaykumarsingh9042 4 роки тому +1

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

  • @anandchoudhary6575
    @anandchoudhary6575 3 роки тому +1

    Thank You So much Mukul Ji. Really Helpful.

  • @mohammedqan1402
    @mohammedqan1402 2 роки тому +1

    Appreciate your efforts..!

  • @rahulgajgjghate
    @rahulgajgjghate 4 роки тому +1

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

    • @AssetYogi
      @AssetYogi  4 роки тому

      Thanks for appreciation Rahul :)

  • @rakeshmohan754
    @rakeshmohan754 7 років тому +1

    Very Nice EMI Calculator and Super easy to Use

    • @AssetYogi
      @AssetYogi  7 років тому

      Thanks! Hope you've download the EMI calculator.

  • @anilgaur9747
    @anilgaur9747 5 років тому +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

  • @financecentre1079
    @financecentre1079 4 роки тому +1

    what a calculator sir really owesome

  • @kishorpawar4087
    @kishorpawar4087 2 роки тому +1

    Nice Sir...very helpful calculator

  • @santoshpatel2060
    @santoshpatel2060 4 роки тому +1

    Bahut achha calculation hai

  • @shivamvohra3016
    @shivamvohra3016 4 роки тому +1

    Thanks sir aap ne bohot accha samjhaya

  • @YashwantV07
    @YashwantV07 2 роки тому +1

    VERY VERY THANKS 🙏

  • @ramsalunkhe4521
    @ramsalunkhe4521 4 роки тому +1

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

  • @officialvermaji92
    @officialvermaji92 2 роки тому +1

    Great teaching ... 👍
    I am subscribe you for the future update in all ,hope you updated me everything in financial

  • @tejashreedeshmukh7600
    @tejashreedeshmukh7600 4 роки тому +2

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

  • @AnilKumar-hf3zo
    @AnilKumar-hf3zo 4 роки тому +1

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

  • @vishnumeena840
    @vishnumeena840 4 роки тому +1

    very help full video sir ji

  • @manojpaswan5711
    @manojpaswan5711 3 роки тому

    This video is very usefull for me

  • @prathameshmukadam2299
    @prathameshmukadam2299 4 роки тому +1

    Nice Calculator.... & also Best Video.... thank you so much AssetYogi!!!

  • @mzrto825
    @mzrto825 3 роки тому +1

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

  • @adarshkumarsinha1204
    @adarshkumarsinha1204 2 роки тому +1

    Thank you sir for the calculator

  • @sefatkabir624
    @sefatkabir624 3 роки тому +1

    thank you very much,, very helpful..

  • @chandrikamauryarahul6213
    @chandrikamauryarahul6213 3 роки тому +1

    Thankyou so much sir ❤️🥰🙏🏻👍🏻👍🏻👍🏻

  • @officesumitkhanna8980
    @officesumitkhanna8980 4 роки тому +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

  • @shibanijena7673
    @shibanijena7673 3 роки тому

    Thank you sir excellent Calculator 👍

  • @SandeepChauhan-kk2pp
    @SandeepChauhan-kk2pp 4 роки тому +1

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

  • @TilakrajSinghPanwar
    @TilakrajSinghPanwar 2 роки тому +2

    Best calculator 💯💯💯

  • @mayankkhare8746
    @mayankkhare8746 5 років тому +1

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

    • @AssetYogi
      @AssetYogi  5 років тому

      Hope it helps Mayank :)

    • @Ranganath2936
      @Ranganath2936 4 роки тому

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

  • @maheshkharangate3675
    @maheshkharangate3675 3 роки тому +1

    Best ...thanku sir very helpful

  • @decormylife4038
    @decormylife4038 2 роки тому

    Help full explanation sir thank you

  • @SanjayDubeyLICAgent
    @SanjayDubeyLICAgent 4 роки тому +1

    Very Good Calculator

  • @Kalijidurgajimandirfatehgarh
    @Kalijidurgajimandirfatehgarh 6 років тому +1

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

    • @AssetYogi
      @AssetYogi  6 років тому

      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 6 років тому

      I also want to download pls help

    • @rushikeshchavan8427
      @rushikeshchavan8427 5 років тому

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

  • @mustafakhan5860
    @mustafakhan5860 Рік тому +1

    Amazing sir 🙏

  • @sarojkumarrout1989
    @sarojkumarrout1989 4 роки тому +1

    Nice video sir, I always see your video.

  • @priyakadam8064
    @priyakadam8064 4 роки тому +1

    Superb ...thanku very much Sir

    • @AssetYogi
      @AssetYogi  4 роки тому

      I hope this will be helpful :)

  • @abhijeetbera777
    @abhijeetbera777 2 роки тому +1

    Great help Sir

  • @kartikgulatti8091
    @kartikgulatti8091 7 років тому +1

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

    • @AssetYogi
      @AssetYogi  7 років тому

      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.

  • @jatinderchohan3288
    @jatinderchohan3288 7 років тому +1

    Thankyou sir,I have downloaded the free EMI calculator.

    • @AssetYogi
      @AssetYogi  7 років тому

      Jatinder Chohan Great!

  • @umeshbhutekar2322
    @umeshbhutekar2322 4 роки тому +1

    Very nice information sir

  • @girishbondarde7915
    @girishbondarde7915 4 роки тому +1

    very well explain 👌👌👌
    and thanx alot sir🙏

  • @asitbaranchoudhury1351
    @asitbaranchoudhury1351 4 роки тому +1

    Fantastic articulation of concept, very helpful

  • @krushnawayal3212
    @krushnawayal3212 5 років тому +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

  • @rajubhuvad2956
    @rajubhuvad2956 3 роки тому +1

    I am happy sir your calculator thanks sir

  • @g.ghiremath7387
    @g.ghiremath7387 5 років тому +1

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

  • @nehanirala6300
    @nehanirala6300 4 роки тому +1

    I downloaded the calculator..thanks for it..

  • @dharamvirsinghverma2182
    @dharamvirsinghverma2182 2 роки тому +1

    Very nice Sir ji

  • @princepathak2902
    @princepathak2902 2 роки тому +1

    Great sir

  • @00004abhi
    @00004abhi 3 роки тому +1

    Superb Sir, thanks!

    • @AssetYogi
      @AssetYogi  3 роки тому +1

      Hope it's helpful 😊

    • @00004abhi
      @00004abhi 3 роки тому

      @@AssetYogi very helpful & easy to comprehend !