No video

EMI என்றால் என்ன? EMI கணக்கிடுவது எப்படி? How to calculate EMI?

In this video, We have explained how EMI is calculated. What are the components of EMI. As a financially sound person, what should one do.
Download EMI calculator - docs.google.com/spreadsheets/...
Download instructions:
1) Click the link
2) Go to File
3) Click download as Microsoft Excel
Note: DO NOT TRY TO EDIT IN BROWSER AND ASK FOR ACCESS REQUEST

Пікірлер: 147

  • @MrSnakediamond
    @MrSnakediamond2 жыл бұрын

    ரொம்ப தெளிவா வகுப்பரையில படித்ததுபோல் இருந்தது சகோதரா நன்றி! வாழ்த்துக்கள்!!

  • @paulpandir
    @paulpandir Жыл бұрын

    ரொம்ப தெளிவான வீடியோ இஎம்ஐ கால்குலேட்டர் எப்படி போடுவது என்று கொஞ்சம் சொல்லிக் கொடுத்தீங்கன்னா அதுவும் எங்களுக்கு பயனுள்ளதாக இருக்கும்

  • @gopalshanmugam610
    @gopalshanmugam61011 ай бұрын

    Very good things in this video: 1. In Tamil. Useful to our people. 2. The pie diagram at the right side gives the demo nicely. 3. Link to download work sheet 4. Locking the formulae to avoid mistakes by viewers. Well thought out video. Congratulations. Keep your financial education to common people.👏👏

  • @divakarsubramaniam5609
    @divakarsubramaniam56092 жыл бұрын

    மிகவும் எளிமையான விளக்கவுரையில் இருந்தது நன்றி 👏👏👏

  • @velmurugan8312
    @velmurugan8312 Жыл бұрын

    மிக அருமையாக ,தெளிவாக சொன்னீங்க அண்ணா சூப்பர்.நன்றி அண்ணா

  • @K7Padmanaban
    @K7Padmanaban4 ай бұрын

    அருமையான பதிவு, தெளிவான விளக்கம் நன்றி சகோ 🙏

  • @baburajendran6951
    @baburajendran69515 ай бұрын

    மிக தெளிவான விளக்கம் அளித்துள்ளீர்கள் நன்றி வணக்கம்

  • @nirmalraj8985
    @nirmalraj89852 жыл бұрын

    Very useful information sir. Thank you so much. 🙏🙏🙏🙏🙏👍👍👍👍👍💐💐💐💐💐

  • @annamalaial6448
    @annamalaial64482 жыл бұрын

    Super explanation..Thank you very much..

  • @palanichamyrajamanickam6052
    @palanichamyrajamanickam60522 жыл бұрын

    Very very useful information.Thanks

  • @vigneshvicky4088
    @vigneshvicky40882 жыл бұрын

    Bro koottravu bank loans pathi details podunga

  • @cheetah2108
    @cheetah21089 ай бұрын

    Bro semaiya solli kuduthinga tq bro

  • @ImpossibleFF-r1p
    @ImpossibleFF-r1p Жыл бұрын

    SUPERB SIR. THANKS FOR THE CLEAR EXPLANATIONS

  • @Rajkumar-lc2lr
    @Rajkumar-lc2lr2 жыл бұрын

    Really informative video... 👏 👌 👍

  • @Francis-cj5kv
    @Francis-cj5kv10 ай бұрын

    Thank you sir. Nice video and nice excel sheet

  • @hihihi3723
    @hihihi37232 жыл бұрын

    Really helpful video..thank you..

  • @dganapathi7968
    @dganapathi796810 ай бұрын

    Bro super 🎉. 👌. Thanks for the valuable information.

  • @sagayarajs1937
    @sagayarajs1937 Жыл бұрын

    Very good information, thank you.

  • @chatmasala6980
    @chatmasala6980 Жыл бұрын

    Superb video. Good explanation

  • @hellofriends733
    @hellofriends7332 жыл бұрын

    Super 👌clear explanation.

  • @kamaleshand6459
    @kamaleshand64592 жыл бұрын

    Very informative brother 🙂👍

  • @mageshkumar7255
    @mageshkumar72552 жыл бұрын

    Nalla thagaval anna

  • @dhilip7764
    @dhilip7764 Жыл бұрын

    Thank you thalaivaa👍

  • @karkuzhali9046
    @karkuzhali90462 жыл бұрын

    அருமை

  • @murugesanjegannathan5254
    @murugesanjegannathan5254 Жыл бұрын

    ரொம்பவும் தெளிவான பதிவு. நன்றி.கிரெடிட் கார்டு பற்றி அறிய ஒரு வீடியோ தேவை.

  • @thinkingtamizha007

    @thinkingtamizha007

    Жыл бұрын

    Credit Card video - kzread.info/dash/bejne/gmh1mcdxgrK3Z6g.html

  • @srajasraja2055
    @srajasraja2055 Жыл бұрын

    Super video thinks you soooooooo much like s.raja Chennai tn India 👌👌👌🙏🙏🙏👍👍👍

  • @shalinishalini772
    @shalinishalini7723 ай бұрын

    Superb explanation abt emi

  • @LalithaParameshwari2020
    @LalithaParameshwari2020 Жыл бұрын

    Thanku so much for the excel.

  • @muthu9108
    @muthu91082 жыл бұрын

    Good information tnq....

  • @kamalakkanananvenkatesan4419
    @kamalakkanananvenkatesan4419Ай бұрын

    Fruitful information sir❤

  • @sudalaimuthum6660
    @sudalaimuthum66602 жыл бұрын

    Thanks for your info.

  • @sampathkumarradhamani2426
    @sampathkumarradhamani24262 жыл бұрын

    Nice sir very useful

  • @sundarraju8383
    @sundarraju83832 жыл бұрын

    Very nice teaching

  • @sakthivelthiru6765
    @sakthivelthiru67652 жыл бұрын

    Really Very nice

  • @AnandRaj-nr5hh
    @AnandRaj-nr5hh2 жыл бұрын

    Usefull thank you

  • @psvibeesh8878
    @psvibeesh88782 жыл бұрын

    Nice explanation

  • @muthukumar8180
    @muthukumar8180 Жыл бұрын

    Very useful sir

  • @sribalaji85
    @sribalaji852 жыл бұрын

    PPF ku sonnapla idhu maasam ethanaam thedhikkul seluthinaal namakku aadhaayam sollunga boss. Andha ppf video semma 👌

  • @sribalaji85

    @sribalaji85

    2 жыл бұрын

    Eno innum thagaval varla... Please

  • @selwyngnanaraj7804

    @selwyngnanaraj7804

    Жыл бұрын

    PPF if paid before 5th of every month, it is taken for interest calculation for that month

  • @vediappans5162
    @vediappans5162 Жыл бұрын

    Thank you sir ☺️

  • @srbraj2991
    @srbraj2991 Жыл бұрын

    Hi , what is the difference between compound interest vs simple interest,, for 10L loan 7 yrs ,, how about HL 19 L for 20 yrs

  • @amluamlu3169
    @amluamlu316910 ай бұрын

    Very nice speech

  • @karthigeyansundaram5049
    @karthigeyansundaram50492 жыл бұрын

    Excellent

  • @swaduocutetwins1827
    @swaduocutetwins18272 жыл бұрын

    sir,if we consider increasing inflation (rate of increase),the long tenure of EMI will be a profitable ie.comparing the rate of increase in the inflation with the rate of interest of the loan. if the increase in rate of inflation is higher than the rate of interest for the loan ,then comparatively profitable. and Vice versa.

  • @saravananmahesh2426
    @saravananmahesh24262 жыл бұрын

    நன்றி

  • @RajeshKumar-vb5fv
    @RajeshKumar-vb5fv Жыл бұрын

    Thanks bro....

  • @909kishore
    @909kishore2 жыл бұрын

    Sir, Your video was very easy to understand. Thanks for that., But anyhow we need to know the concept of how to calculate EMI, total interest paid, the total amount paid, etc. Now you have provided your excel sheet for easy calculation. But to improve our EMI concept still more practically, please share the formula used in excel for calculating the values. It will be more helpful if you add this as one short video.

  • @thinkingtamizha007

    @thinkingtamizha007

    2 жыл бұрын

    It is already there in video bro. watch carefully. I have explained the formula

  • @ganesanramasamy7093
    @ganesanramasamy7093 Жыл бұрын

    Thanks Sir.

  • @jeyakrishnan.n9276
    @jeyakrishnan.n92762 жыл бұрын

    thank you for your explained.

  • @NsoundarMCA
    @NsoundarMCA2 жыл бұрын

    Thanks bro.

  • @praburathinam7731
    @praburathinam77312 жыл бұрын

    nice video with good explanation.

  • @balugkkl6216
    @balugkkl62162 жыл бұрын

    Thanks

  • @udayasuriyans7294
    @udayasuriyans72942 жыл бұрын

    Thank you

  • @manickamvishnu7018
    @manickamvishnu70182 жыл бұрын

    Thankyou sir

  • @cschanel8236
    @cschanel8236 Жыл бұрын

    Thanks 😊

  • @manickam909
    @manickam9092 жыл бұрын

    Thankes

  • @chandrakalakaruthan6429
    @chandrakalakaruthan64294 ай бұрын

    Thank you sago

  • @sureshr2968
    @sureshr2968 Жыл бұрын

    There is tax levied on EMI by the government. This is ignored in the discussion. This tax component is not negligible. It is significantly high. This burden will be more if you go for short period EMI, especially very high for no cost EMI.

  • @manokaranmanokaran4996
    @manokaranmanokaran499610 ай бұрын

    Thanks bro

  • @muzammilhussain5143
    @muzammilhussain51437 ай бұрын

    Sir Inda formula Android calculator la podunge

  • @velasvd9935
    @velasvd99357 ай бұрын

    Usefull

  • @Cellular_Repairs
    @Cellular_Repairs2 жыл бұрын

    Good Explanation Bro.. Thank you 😍

  • @pushpalathalatha-zn2kl
    @pushpalathalatha-zn2kl Жыл бұрын

    Super

  • @marichamy.c1170
    @marichamy.c11702 жыл бұрын

    Good

  • @prabhakaranshanmugam5295
    @prabhakaranshanmugam52954 ай бұрын

    If possible, Please post videos regarding Loans etc. Do's and Don'ts which will educate many and play a big role in personal finance and restructuring their current loans etc. Just like you provide knowledge of taxation..

  • @thinkingtamizha007

    @thinkingtamizha007

    4 ай бұрын

    Already posted about personal loans, emi calculation and credit cards

  • @rafi5732
    @rafi5732 Жыл бұрын

    Bro I have loan no in icici how to check the status of it...loan was in my brother's account rbl bank 🏦 how to check the emi status and clear View of How much loan amount and Due date and Pending amount!! Please reply

  • @tamilking03
    @tamilking03 Жыл бұрын

    This method for all loan or few category

  • @FINANCIALAdvisorTGopiMCA
    @FINANCIALAdvisorTGopiMCA2 жыл бұрын

    GOOD

  • @srbraj2991
    @srbraj2991 Жыл бұрын

    Hi shall I preclose 10 yr old HL loan taken 19L loan

  • @haribaskaran3046
    @haribaskaran30462 жыл бұрын

    I taught who will teach how to calculate EMI by manually. But you have done all process in computerised , it can even done EMI calculater app and websites.

  • @thinkingtamizha007

    @thinkingtamizha007

    2 жыл бұрын

    The main idea is to show a break up of interest and principal in EMI. How it varies based on loan period. NO point in calculating manually right. And the online calculators doesnt show the breakup with in the EMI amount and its accrual

  • @venkatrman
    @venkatrman2 жыл бұрын

    Bro. Very nice video. Suppose if I am getting a substantial amount and wish to reduce the loan amount after a period of some EMI payment,what are the best points I have to discuss with the financier.

  • @thinkingtamizha007

    @thinkingtamizha007

    2 жыл бұрын

    Negotiate for part closure and reducing the emi.. they may put charges for part closure.. ask how much and negotiate to reduce it..

  • @rams5474
    @rams54742 жыл бұрын

    Today we have Excel program. Once you master this everything is under your control. Set up formula and drag down as per months, all set up. It is easy to know where your loan EMI stands. Many years back, I happen to visit a Hire purchase Auto loan agency who put flat rate % low interest. Naturally it looks sweet but no fool will agree it is under low interest. When I asked him what is the real interest he it depends but just multiply it by 1.80 to 1.95 you get the real RBM reducing balance method which is the real interest in their books. In Excel you easily float the rate of interest to check it, a small correction will get +/- in the final EMI. Those time we issue post dated cheques. If you go to windup in the middle of term by repaying in one lumpsum then immediately their flat rate will become float rate and demand more principal.

  • @kumarttr4828
    @kumarttr48282 жыл бұрын

    I borrow 220000 monthly emi 5200/month for5years is it right.interest 12percent.

  • @silambuanitta4724
    @silambuanitta47249 ай бұрын

    Principal Paid and interest paid calculate pannuvathu yepadi

  • @thanarajanj4694
    @thanarajanj46942 жыл бұрын

    Do the best for less emi and identify the hidden charges

  • @sandilyang7473
    @sandilyang7473 Жыл бұрын

    What is the no cast EMI SIR pls explain

  • @divyar5279
    @divyar52792 жыл бұрын

    நன்றி அண்ணா...

  • @whitedevil78515
    @whitedevil78515 Жыл бұрын

    EMI shoping panna Eligible age evlo bro

  • @nizarahamedkhankhaderkhan8869
    @nizarahamedkhankhaderkhan88692 жыл бұрын

    EXCEL SHEET IL MORTGAUGE TEMPLATE ULLATHU ATHI PAYANPADUTHI KOLLALAAM

  • @aravindhandhina6417
    @aravindhandhina6417 Жыл бұрын

    Loan amount -400000 Time period 5years interest rate 10%but my emi - 10376. Na ippo pay pannitu iruka sir. But neega sonna mathiri emi calculate panna 8900 tha varuthu. Ethuku ivalo difference nu solla mudiyuma sir. Pls

  • @psvibeesh8878
    @psvibeesh88782 жыл бұрын

    First view bro

  • @rajugowda4294
    @rajugowda42949 ай бұрын

    bro ippa namma emi ya ,10,month la close pannita intrst kuraiya vaipu irukungila

  • @gokulkrishnan9156
    @gokulkrishnan91562 жыл бұрын

    sir please do video on how to finish EMI so quick to save money

  • @swaduocutetwins1827

    @swaduocutetwins1827

    2 жыл бұрын

    pl consider the trend of inflation,longer tenure may be profitable,I think.

  • @pk-lh7jr
    @pk-lh7jr2 жыл бұрын

    👏👏👏👏👏

  • @leiiengaoorukanyakumari6002
    @leiiengaoorukanyakumari600211 ай бұрын

    Time period 20years ல இருந்து 10years ஆ change panna ena panna vendum... இல்லையென்றால் time period change pannama EMI அதிகமாக கட்டினால் ENA இலாபம்

  • @gauthamg6942
    @gauthamg69422 жыл бұрын

    Bro, can you please say how did you find the proprtion of amount spent on interest and principal paid i e in video EMI amt 13,215 how did you segregate 4882 towards principal and remaining towards interest? I like all your videos and thank you for sharing your knowledge in finance, and I had a learnt a lot from this channel

  • @thinkingtamizha007

    @thinkingtamizha007

    2 жыл бұрын

    Interest= outstanding principal x interest rate/12 Remaining amount in emi will be principal component

  • @spalanisamy34
    @spalanisamy34 Жыл бұрын

    👍

  • @iarnhere
    @iarnhere9 ай бұрын

    Bankers are too wise than us. They wont allow us to go by less tenure. Even if they accept, the loan amount is reduced drastically. You need money, you have to pay them the price. No other safer way out 😢

  • @Abdullah-hf9sb
    @Abdullah-hf9sb Жыл бұрын

    10.5 did not show . it turned into 11. why?

  • @hameedsahran
    @hameedsahran Жыл бұрын

    Sir my credit card loan interest pathi konjam telivillamal iruku Ada konjam solla mudiyuma

  • @thinkingtamizha007

    @thinkingtamizha007

    Жыл бұрын

    Credit cards - Things to know kzread.info/dash/bejne/gmh1mcdxgrK3Z6g.html

  • @pearl6756
    @pearl67569 ай бұрын

  • @karthickn8503
    @karthickn85039 ай бұрын

    BRO THNX BRO NAN BAJAJ FINANCE THAN WORK PANREN IPPA THAN JOIN PANNEN ENAKU ITHAPATHI PURIYALA ANGA EXPLAIN PANNUM POTHU NENNGA SEMMAYA PURIYA VACHITINGA ANA ONNU BAJAJ LA MATTUM YARUM PERSONAL LOAN EDUKATHINGA OMMALA VATTI POTTE SAVADICHIDUVANGA PLS NAN INTHA MONTH ODA JOB RESIGN PANNA POREN

  • @velp2705
    @velp27053 ай бұрын

    Caculatina sollunga

  • @prabhumaruthappan936
    @prabhumaruthappan9364 ай бұрын

    முதல் 3:40 நிமிடம் 😢😢😢 வேஸ்ட், 10, 20 வினாடிகளில் கண்டென்ட் க்கு வாங்க ப்ரோ..

  • @sathisha9859
    @sathisha9859 Жыл бұрын

    Sir excel sheet edit option illa sir, please able to edit option

  • @thinkingtamizha007

    @thinkingtamizha007

    Жыл бұрын

    You need to download in your pc and use it., edit option is browser is not available.

  • @mohanms3768
    @mohanms37682 жыл бұрын

    Sir House Loan epdi edukkanum.. Epdi effective ah loan adaikkanum nu oru video podunga 🙏

  • @gobinathb8032
    @gobinathb80322 жыл бұрын

    Hi you are doing demo for fixed rate. But home loans ROI will change every quarter as per RBI. How to calculate that sir. Pls explain demo for varying ROI calculations for especially for home loans

  • @thinkingtamizha007

    @thinkingtamizha007

    2 жыл бұрын

    Yes. Interest change aagum podhu, emi will be calculated based on outstanding principal

  • @srikanthmadhu7078
    @srikanthmadhu70782 ай бұрын

    Yannaku sollungaa bro 860000 loan amount

  • @ArifKhan-sm6hx
    @ArifKhan-sm6hx Жыл бұрын

    Sir, ஒவ்வொரு மாதமும், எவ்வளவு அசல், எவ்வளவு வட்டி என்பது எப்படி கழிக்கிறார்கள்? எத்தனை சதவீதம் அசல், எத்தனை சதவீதம் வட்டி, ஒவ்வொரு மாதமும் எந்த அடிப்படை யில் பிரிக்க படுகிறது என்பதை கூறுங்கள்.

  • @vimalrajvasu3706

    @vimalrajvasu3706

    Жыл бұрын

    Atha sollavae illa...

  • @madasamym3515
    @madasamym35152 жыл бұрын

    PMTdetails

  • @TN-fc5hd
    @TN-fc5hd2 жыл бұрын

    நண்பா bike loan 130000 amount monthly emi 4796*36 நீங்க சொல்வது போல ஒரே emi தான் எல்லா மாசம் வருது ஆனா principal amount குறையாமல் இருக்கு

  • @TN-fc5hd

    @TN-fc5hd

    2 жыл бұрын

    Next month வர வர யேன் loan amount குறையாது

  • @thinkingtamizha007

    @thinkingtamizha007

    2 жыл бұрын

    You need to check with bank on breakup of principal and interest part of emi. Appo than evlo masa masam korayudhunu therium

Келесі