Investing vs Loan Repayment EXPLAINED with Excel Sheet! | Ankur Warikoo Hindi

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

КОМЕНТАРІ • 957

  • @warikoo
    @warikoo  2 роки тому +54

    Change the way you bank with the help of Jupiter!
    Check it out here: bit.ly/WarikooJupiter

    • @ALLINONE-vn4gg
      @ALLINONE-vn4gg 2 роки тому +6

      Sir link of that Excel sheet.....??

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

      Exact timings of your videos....there's this situation in our life... And we check your channel for solution... And exact video is right up there...

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

      Sir What I'f someone has taken education loan and the bank is taking compound interest on that .....then how the situation changes with respect to principal amount and interest EMI...pls explain or can you pls make a single video on bank education loan taking compound interest how they take money and how much we end up paying pls make one video on this topic

    • @Surya-22
      @Surya-22 2 роки тому

      How to make investment excel sheet from starting please make a vedio

    • @RohitSolanki-cd1uz
      @RohitSolanki-cd1uz 2 роки тому +1

      @🆆hatsapp➕①②①③④⓪①④⑤③⑧ sir I couldn't do my loan calculation on the above pinged Excel sheet , how do I edit my loan details ?

  • @swapnilbhavsar3674
    @swapnilbhavsar3674 8 місяців тому +7

    Dear sir, in this description you have discounted one or two biggest factors.. First being Risk involved with carrying the debt. Second peace of mind when you don't have any debt to be paid.. I think that plays major role for overall well being.

  • @AryanSingh-xt1vu
    @AryanSingh-xt1vu 2 роки тому +61

    Following you helps me a lot. And i love your video that is " I was lost at 24" because its very hard to break the expectation of your family that you have show them. Thanks warikoo

    • @adarsh.m.bagade1561
      @adarsh.m.bagade1561 2 роки тому

      @🆆hatsapp➕①②①③④⓪①④⑤③⑧sir I'm having joining tomorrow I'm not interested to do job in IT sector .i want to do business but no idea WT business i should do . stressed lot sir 😥😥

  • @rakeshbharadwaj73
    @rakeshbharadwaj73 2 роки тому +93

    I had 17 Lakhs principal amount in Loan. I had 17 Lakhs lumpsom. So I cleared my home loan.. I don't believe in excel sheet. I don't have to pay EMI every month. I will now invest 25k in SIP.

    • @girishktyagi
      @girishktyagi 2 роки тому +13

      thats emotions and not maths..!! both are right in its own sense.

    • @divyanshbhargava2900
      @divyanshbhargava2900 Рік тому +4

      Bad call if you already had good monthly cash flow

    • @ankitparashar2523
      @ankitparashar2523 11 місяців тому +14

      What is the guarantee of life.. it's always better to pay off the debt for the well being of your family. Again, it's totally personal choice though.

    • @Nobody_Unknown_Man
      @Nobody_Unknown_Man 10 місяців тому +1

      You can't sava 2 lac loan now

    • @bharat7278
      @bharat7278 8 місяців тому +1

      You did fantastic. This is difference between theory which sir is giving and practical which you did.

  • @TheNicevideoclips
    @TheNicevideoclips 2 роки тому +25

    One other suggestion:
    Pay off the loan. Recalculate the EMI after payoff. Use the amount of EMI saved as above to invest in a Mutual Fund SIP and get triple benefits as below:
    1. Reduce future interest portion payable on the loan.
    2. Creation of additional savings without any extra burden. Because the total outflow per month for recalculated Loan EMI + MF SIP will be equal to old EMI amount.
    3. By investing in SIP, you average out the market uncertainties that come with investing in lump sum. Because timing of the investment also plays a role in determining whether your lump sum investment will be profitable at the time you need it and not trying to wait for the market to bounce back.
    The only catch is that the lump sum amount that you received in the initial stages of the loan, you need to forget it right now. But it will come back later with a decent return on investment.

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

      This is probably the better advice and best of both worlds. One thing to note though, Banks will not recalculate or reduce your EMI but instead recalculate and decrease your loan tenure. So if your goal is to save the difference in EMI and invest it, you need to contact your bank to have them reduce the EMI instead of loan tenure.

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

      ĺ

    • @rajeshhg1
      @rajeshhg1 4 місяці тому

      Bang on - and best advice according to me too.. The amount you save as EMI can be invested into MF's and let the money grow along with the peace of mind you have from a debt free situation..

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

    This video actually helped me when I played with the excel and explained me if I should pay off my loan or, should invest. Actually now I just calculated that for my left over loan my rate of interest is only 6.9%. Thank you so much. Big Heart ♥

  • @tanmoymukherjee2345
    @tanmoymukherjee2345 2 роки тому +60

    Very good explanation. Thank you Ankur. However, I think one more aspect needs to be considered while doing this comparative evaluation, i.e. Tax on Capital Gains applicable. In most cases, people forget to consider this Tax component while checking out return, which makes the difference in actual money availability. That's my personal thought.

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

      Good and important catch sir💯

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

      You get tax benefit on loan interest too.

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

      @@kumarindiaamit not on all type of loans, only home loan

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

      @@ravishkumar2205 education loan as well.

  • @vinayakrokade9237
    @vinayakrokade9237 2 роки тому +24

    What a consistency ankur sir
    Just finished 20habits video and made a notes of 8 page definitely that was the best video in 2022 I have seen
    I'm 17 and I'm grateful to know all this things this much early
    You're my mentor Ankur ♥️

  • @meghnamehta7694
    @meghnamehta7694 2 роки тому +11

    Another important factor to consider is job security.. Sometimes it is better to pay off a loan because jobs are not secure imo.

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

      ᴀʟᴡᴀʏs ᴀᴄᴛɪᴠᴇ ᴏɴ ᴡʜᴀᴛsᴀᴘᴘ👆🇮🇳✍️*

    • @adipratapsinghaps
      @adipratapsinghaps 10 днів тому

      Yeah people don't want to consider that possibility of job loss. Somehow they are ok with the fact that if they lose jobs in another COVID-like situation, everyone will lose it and not just them alone. And everyone will have their properties siezed and not just them alone. So people are ok being homeless if everyone around is being homeless.
      Second, even if some people consider the possibility of job loss, they just rule out the possibility of remaining jobless for years to come and eventually lose all their life savings along with their home. And trust me, there are people out there who lost their jobs 3-4 years ago and are still jobless.

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

    Good stuff. I used the other ways to do the re-payment. I prepayed my home home loan (35 lacs for 12 yrs 7.2%) by withdrawing the LIC & old PPF so after a year I paid 10 lacs after 7 months. During pandemic due to work from home I was not spending (10K on petrol + 1.4K on toll pass + 1.4K on metro pass and 2.5K parking charges ~ 15-16 K per month). I paid all that as a pre-payment & was able to bring the capital amount by 2-3 lacs. Now my liability to loan is 10 lacs or less and reducing. I will be done with this loan in next 1 yr & 1.5
    Also by any chance you have a spread sheet which takes into consideration multiple interest rates. Since the interest rates are now linked to RBIs rapo rates, one can reduce the same. Banks won;t tell you this stuff. One needs to do it by pursuing behind the branch manager.

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

    Ankur sir,
    Thanks a lot for educating us. I am in my 20's and working in MNC. Your video always inspirs me. In many videos you said " ki Maine paise ko lekar bahut galat bhi decision liye hey " always inspirs me in a different way. Thanks a lot.

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

    By referring your guidance I had cleared my personal loan taken while medical emergency of dads health from my EPF amount and saved intrest of 20000/- thanks for your video and improving our knowledge regarding money management

  • @nikhilvijayvergia7134
    @nikhilvijayvergia7134 2 роки тому +13

    Although I like what you presented in this video however there are 2 major factors that were not considered
    1) tax benifits on loan (like home loan etc)
    2) tax implications on capital Gains
    I know that this video would have become complicated if these 2 points would have been considered but we can't simply make content look simple just for sake of it and by simply ignoring 2 major major practical factors that will completely change the equation,
    Would Love to read your thoughts!
    Regards,
    -A admirer of your work

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

      Also when go to repay the partially or fully for the loan. Bank will charge extra 4% to 6% of the outstanding amount as penalty 😒 that is left out.

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

      @@sumankumary that’s only applicable on fixed rate loans, not on home loans. In that you can pay as much and whenever. I also know that the penalties are going away now on credit cards as companies wants both good and bad payers for profitable business.

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

    I always feel that , Instead of paying loan off very early, invest in market
    But after covid situation- life has no guarantee and now feeling I need to pay off my loan now and I can invest in market later (wait for crash n enter)

  • @satyam3129
    @satyam3129 2 роки тому +14

    Now I feel proud that I am having same thinking as my financial guru.
    Thank you sir

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

      According to this video, then, many people with home loan should take a top up loan, which they get at mostly same rate & invest in mutual funds.
      Hence, More Factors to consider are
      1. Ideally one should not invest when there is loan as loan brings mental burden for most of the people, unless
      A. you are government employee & have job security or
      B. you are good at maths & understand that this mental burden is only virtual, it is just in mind & actually doesn't exists or
      C. you are brave enough to live life with loans or doesn't care about loans.
      2. Is it the home loan on your very 1st home & you were so poor that even your parents couldn't build their own home in their life. According to financial experts, in this scenario you should pay of the loan & reduce mental burden. But according to maths, if you are in 20-30% tax bracket & enjoying the tax benefit due to home loan, then you can invest the money in safest mode of invest i. e. In SBI FDs, preferably in joint account with your "NON-EARNING" mother or father, make 200-1000 ₹/month profit by doing this (estimated by difference in FD Interest rate (0.5% extra for senior citizens in case of joint account) minus effective interest rate which comes after enjoying tax benefit) & also builds corpus to survive a crisis of sudden job loss. It is only applicable for loans less than around 22-24 lakhs & interest rates of 7-7.5%. (These exact figures shall be estimated by calculation taking into account the exact tax benefit).
      3. If you decide to invest, instead, for how long you plan to invest & how much is expected returns in that period? (probably this point Ankoor covered) 🙏

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

      Ankur is so great at what he does. People consider him a guru of finance and life in general.

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

    this calculation is valid provided the loan is in floating interest rate . If it is fixed interest anyhow one have to pay the total interest

  • @satyam3129
    @satyam3129 2 роки тому +6

    Yes sir. I have Personal loan and got bonus. I invested 40% in market and 60% in hand to invest in sip.
    I didn't cleared my loan as only 24 months left in completion and I saw my emi is now mostly principal and less interest.

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

    This is the exact dilemma I have right now. Commenting before finishing the video. I know already that I'll follow your instruction.

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

    Finally Ankur is back with being Ankur..! Keep up the quality.. Please yar, don't make it all ads..

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

    Whatever we need to know regarding financial management, one stop solution is this channel...
    Thanq so much Ankur ji

  • @aromaljoe4732
    @aromaljoe4732 2 роки тому +6

    I was waiting for you to mention about the tax benefits especially for home loan. I think it reduces home loan rate by about 2% if you are in highest tax paying bracket of 30%

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

    Thanks for this Ankur. It's very helpful as I have just started my Education Loan Repayment this month after passing out college in 2021...

  • @biswajitpal2472
    @biswajitpal2472 2 роки тому +5

    I can just thank you from my heart and soul. You are educating us what we need to make our financial decisions wisely. 🙏🏼❤️

  • @stevenpaul4394
    @stevenpaul4394 2 роки тому +27

    Never knew cryptocurrencys could be so challenging! Kept running back to these UA-cam videos to learn more about this your video is indeed helpful.

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

      Who else think this Crypto trade is kinda easy but is way to nervous to start,.

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

      Trade has left me no choice but to keep investing because it makes so much profit for me.

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

      i have been trading offshore and still have not made my own profit which strategy do you use please .

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

      Got linked up With Mrs Stacy Griffin Kartner o days ago never knew anyone will know her here.

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

      She is a genius

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

    Video came at the right moment. Was about to foreclose my loan which had only 1 year left n obviously most interest component i have already paid.

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

    Brilliant We are the blessed generation to learn all this for free through a screen that fits in a pocket. Thank you so much Anukar. All your videos helped a lot to make financial decisions easy and wise 😊😃

  • @vipul.kumbhar
    @vipul.kumbhar 2 роки тому +4

    I am facing exact senerio and i got Ankur sir's video...... Exactly on sam subject.... Thank you 😊❤️

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

      According to this video, then, many people with home loan should take a top up loan, which they get at mostly same rate & invest in mutual funds.
      Hence, More Factors to consider are
      1. Ideally one should not invest when there is loan as loan brings mental burden for most of the people, unless
      A. you are government employee & have job security or
      B. you are good at maths & understand that this mental burden is only virtual, it is just in mind & actually doesn't exists or
      C. you are brave enough to live life with loans or doesn't care about loans.
      2. Is it the home loan on your very 1st home & you were so poor that even your parents couldn't build their own home in their life. According to financial experts, in this scenario you should pay of the loan & reduce mental burden. But according to maths, if you are in 20-30% tax bracket & enjoying the tax benefit due to home loan, then you can invest the money in safest mode of invest i. e. In SBI FDs, preferably in joint account with your "NON-EARNING" mother or father, make 200-1000 ₹/month profit by doing this (estimated by difference in FD Interest rate (0.5% extra for senior citizens in case of joint account) minus effective interest rate which comes after enjoying tax benefit) & also builds corpus to survive a crisis of sudden job loss. It is only applicable for loans less than around 22-24 lakhs & interest rates of 7-7.5%. (These exact figures shall be estimated by calculation taking into account the exact tax benefit).
      3. If you decide to invest, instead, for how long you plan to invest & how much is expected returns in that period? (probably this point Ankoor covered) 🙏

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

    This is what I was thinking from last 2-3 days and now I saw your video.... Great help....Thank you....

  • @nabamitabown1879
    @nabamitabown1879 2 роки тому +22

    Hi Ankur, this was very helpful. However, can you please do a detailed video on how to smartly repay a huge education loan ? How to do lump sum payments and when to not? It would be really helpful. Thanks!!

    • @warikoo
      @warikoo  2 роки тому +6

      I have done a video on how to pay off loans faster.

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

      @@warikoo sir ek video banaye on how businesses person can pay zero taxes leagally thanks

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

      @🆆hatsapp➕①②①③④⓪①④⑤③⑧ fake account stay away .

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

    Another angle to prepayment - If you get a bonus in the initial 2-3 yrs itself, then prepayment would actually result in paying a higher effective rate of interest on the total principal as the initial 2-3 years had a higher proportion of interest payments.

  • @emilydavis8321
    @emilydavis8321 2 роки тому +31

    The stock market have always and will always be a volatile market, that is why it is important to have proper research, analysis and strategy when investing

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

      Great advice, i used to just watch youtube tutorials and videos,but still made losses when i traded on my own. luckily i came across and watched an interview on CNBC where the anchor kept mentioning "...Kathy Genelle Britton...". This prompted me to get in touch with her, her strategy and experience are what has made me so much profits these past months.

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

      I’m not good doing it alone but getting into the market has been my best decision so far in my road to financial independence as it turned out lucrative for me.

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

      Great stuff. I watch several youtube videos on how to trade in the stock market but haven't made any headstart because they are either talking some gibberish or sharing their story of how they made it and I do not want to make mistakes by taking risks in my own hands.

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

      it's really nice to see someone else talk about Kathy Britton, she really has been my guardian angel in the market, helping me recover from the losses i made when i was still trading on my own,her strategies and experience has made my financial journey more fruitful.

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

    Your videos are amazing. Just one request please keep realistic numbers while using excel because young people don’t pay interest /EMI of 1 lakh or so

  • @amitkumarsingh2749
    @amitkumarsingh2749 2 роки тому +12

    Thank You so much Sir, learning so much from your videos.

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

      People will be kicking themselves after the fluctuations in price and cryptocurrency this is the best time to trade Crypto.....BE WISE 🤷.

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

      I am from Denver Colorado USA I connected with him and he has helped me a lot,he makes so much profit for me he is a FINRA agent, the best I can invest with so far ever since I came across expert Steven Hatzakis' my bad turned out being good and profitable. He’s made success earlier than we thought.

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

      I invested $1,030 and I make $3,970 weekly trading with him, I only trust Steven Hatzakis with my investments. I am now able to send my kids to great schools in LA, all thanks to Steven J. Hatzakis'

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

    Ankur, do make a video on
    1. How to make better decisions
    2. 10 Life advice for people in their 20s amd 30s
    3. Business and Entrepreneurship tips and advice

  • @PankajSingh-qc5mq
    @PankajSingh-qc5mq 2 роки тому +36

    It isn't this complex. You pay the loan when:
    Rate of loan interest > Rate of return - rate at which your gains will be taxed

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

      Shouldn't your wordings be
      When Rate of loan interest is more that Rate of Return - rate at which your gains "are estimated AFTER paying tax"?
      By the way, concept is simple but not easy. It is to be noted that, Opposite of complex is simple & opposite of easy is difficult. Formula creating, solving it & estimating the answer is very difficult, given that there could be many factors like salary increment & Lump Sump amount of Performance Linked Incentive may come in June & one don't know how much it may come, revision in loan interest rate etc etc. 😊

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

      Inshort,
      take loan at some intrest,
      Invest that money in different spaces whose return(obv after taxation) is more than loan taken+intrest, = paisa hi paisa?

    • @PankajSingh-qc5mq
      @PankajSingh-qc5mq 2 роки тому +1

      @@Atzee yeah exactly, if you have some source which genarate more return % than your loan intrest then you will make money.
      That literally how bank makes money (Giving 4-5% return on FD and taking > 8% loan interest). Another example is corporate bonds or companies taking debt, it will only makes sense if they think their business will grow far more higher rate than interest.

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

      @@PankajSingh-qc5mq how about taking a loan of about some lakh from bank, investing whole on stocks.. will it work???
      As stocks return in approx 20 if everything goes right.. and intrest would be 8pa.. so there's a 12% extra money...
      I'm a student, and i think probably I'll do this in my future...

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

      @@Atzee While your theory may sound reasoned, you need to add mathematical risk. Let me explain.
      Equity market may provide 15% returns after removing taxes, which may be higher than loan interest rate. However, banks expect the loan to he repaid consistently, while equity markets are inherently risky & fluctuating - so 1. No bank will give you loan to invest in risky investments like equity market. 2. Even if you take the loan, there is huge risk that you'll default as you won't be able to consistently create cash to repay the installments - as to earn good returns, one must keep the investment as it is for a long term in equity market.

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

    This is my secret strategy, started since 2018...😉, But over the time I have revised the implementation.

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

    Ankur Warikoo, making Excel sheet cool again....

  • @RollingStoneVarun
    @RollingStoneVarun 2 роки тому +6

    Hooked to your videos Mr Warikoo! Already setting financial goals to be truly debt free soon 😊

    • @1617-i6i
      @1617-i6i 2 роки тому

      👆🏽 👆🏽 Thanks for watching. Reach out I have a project that you might find interesting.

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

      True ☺️ after watching this video I followed increasing the EMI last year and this year...my repayment tenure is reduced to only 11years from 25 years. Thank you Mr Warikoo! Now learning from your other videos and applying the knowledge given in my life. Thanks once again 🙂

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

    sir, this is exactly what I was trying to figure out from past 2 weeks with my excel If to repay loan faster or invest more aggressively...sure it did help to bring some clarity..thanks

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

    Great video, though pls account for various taxes in the transactions as they will take out a big chunk out of the percentages involved. And maybe bring in life stage expectation and goals. Great stuff, super helpful.

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

    Hi Ankur, yaar abb tum logo ke dimag padhna seekh Gaye ho... This topic was on my mind for almost 1 month and after lot of deliberation i too somewhat arrived at similar approach... Keep it up...

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

    hi Mr Ankur,thanks nice work as usual ...however for home loan one gets additional savings in tax so my study on the subject says even if someone is managing investment with returns similar to the home loan interest ...it is still better to avoid prepayment ...i have excel sheets also to prove my point if you like to see them will share the excel sheets... Thanks Utpal

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

      Please share the excel sheet

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

      All words, no play of yours. Most of you are justifying your home loans

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

    Jupiter bank is really great! My account got opened within 4 minutes and working really great, just have this single issue that jupiter app stops working when the registered SIM is out of that phone.

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

    Excellent video. Just to add some loans like home loan/ EV loan have some income tax expemtions. This should also be taken into consideration.

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

    Sir AI aur zucku bhai to hamari batein sun hi lete hai
    Par aap kabse hamari batein sunane lage😁😁
    Aaj hi dad ko bola ki car loan khatm karu ya invest kru??
    And here my idol comes up with good video❤️

  • @VIKASMAURYA-hh3fk
    @VIKASMAURYA-hh3fk 2 роки тому +3

    Hi Ankur,
    You have neglected the tax components.
    If we repay home/education loan we get tax benefits. On the other hand if we invest we will be taxed on salary+long term capital gains tax (Assuming investment in indexed MF). For someone in 20% / 30% tax slab, it will be huge difference.

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

      You are right! People paying 30% tax for them keeping the loan is better

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

    Time 0:56 mene abhi video dekhana start kari hai or mujko esa lagta hai ki phele mai loan pay karna shai samjhunga (:

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

    Mr. Jupiter forgot to take fees charged for prepayment of personal loan on remaining Bal into consideration in his Excel sheet. Eg HDFC says 4% fees will be levied if prepayment made within 24 months.. fees= (500000 -100000)*4%= 16000 . Total 116000

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

    Ye kuch nya sikhne ko mila... Muje to pehle se trust tha iss Excel pe... It plays around numbers like a pro 🎉

  • @anushrut5
    @anushrut5 2 роки тому +5

    Should the tax exemption on loans be also considered?

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

      It should , it missed , may be because it can make video very complex

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

      yes absolutely

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

    You are doing amazing work for the community for "Aam Admi" respect from a Pakistani, stay happy and healthy

  • @saswati-thesassygirl
    @saswati-thesassygirl 2 роки тому +3

    Sir,
    Is investing in an online certificate program (Executive MBA) from IIM worth 6 -7 lakhs INR worth it? What I mean is would it be beneficial for career growth?
    Awaiting your reply.
    Thanks

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

    Video is good Ankur Sir. However if we can pay off the loan early, the satisfaction it gives that you are loan free is more than the return on investment. Also if you want to take any other further loans, it gives clear way for applying for new loan. Pls share your thoughts

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

    How much does the factor of tax benefit on interest payment affect this process?

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

    Sounds like crazy...excel excel khelte hai...I am loving it. ❤️ Thank you ji

  • @sherrielynnsnyder3515
    @sherrielynnsnyder3515 2 роки тому +62

    *NOBODY BECOMES MILLIONAIRE OR A BILLIONAIRE'S BY WORKING FOR OTHERS AND DEPENDING ON THEM, GOOD INVESTMENT BRING MILLIONS OF DOLLARS, AND CONSISTENCY BRING BILLIONS, THE MARKET IS ALL ABOUT BITCOIN AT THE MOMENT NOW.,*

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

    You miss a crucial comparison. When two stocks are compared, ideal comparison is not return, but risk adjusted return (Sharpe ratio). I.e return for the risk you took. In this case, interest on loan is saved without any risk. You will for sure save that amount if you pay off the loan. Whereas returns from markets have a risk factor and are uncertain.
    That is why people feel intuitively that it is better to pay off the loan. And they're right to an extent because you haven't factored it in. Search Sharpe ratio you will understand.
    It is not only a mathematical calculation. The question is: Is return with zero risk = higher return with high risk. It's about each person's investing and risk appetite. Mere math model is insufficient

  • @thasortnia.786
    @thasortnia.786 2 роки тому +5

    *After a successful investment you have nothing to worry about, whether the rise and fall of economy or anything won't affect you, make your future brighter, by making good investment! Wondering if viewer's here are familiar with Nancy's trading strategy?*

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

      All good investors are conversant with expert Nancy. She's in the field just got to keep her instructions and you excel she has an intellectual strategy that cuts down losses, I have the best investing with the aid of Nancy , she is very friendly and so easy to get along within terms of signal and investing tips

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

      Expert Mrs Nancy has aided so many newbies including me. I have 12wins from forex trade with her help. Thanks to her strategies, she's really the best. I've made 16,400$ in 18days
      working with her.

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

      An extraordinary is the right word for expert Mrs Nancy, she's very experiences as a trader
      and so unique

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

      Wow..amazing to see another investor who trades with Mrs Nancy's , i am currently on my 5th trade with her and my portfolio has grown tremendously.

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

      @@alaysbiridjitskut6911 Same here lol, I also Earn weekly profits of $ 23, 830 on My Investment Since I started invest with Mrs Nancy's , her trading is the best I have seen

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

    It was right on time, when I just got the lumpsum amount and was planning to clear the loan. By the way I have got amount which I can payoff full loan amount and loan period ends in 12 months. Downloading your excel sheet to play with ;-)

  • @garciamiller5823
    @garciamiller5823 2 роки тому +13

    Despite the economic downturn,I'm so happy☺️. I have been earning $ 60,000 returns from my $7,000 investment every 13days.

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

      I have heard a lot about Investments with Christine Norine Martin, how good she is and how she has helped People. Please how safe are the profits ?

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

      I have also been trading with her, The profits are secured and over a 100% return on investment directly sent to your wallet. I made up to $560,000 in 2months trading with her

    • @ojoyce.6382
      @ojoyce.6382 2 роки тому

      after watching so many UA-cam tutorial videos about trading I was still making losses until Mrs Christine N Martin started managing my investments now I make $60,567 weekly. God bless Mrs Christine Norine Martin she's been a blessing to my family.

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

      As a first time investor with Mrs Christine Norine Martin, I started trading with $15,000, now my portfolio is worth $75,600 within the space 2weeks of trading with her ,I only trust Mrs Christine Norine Martin with my investments. I am now able to send my kids to great schools in LA.

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

      So delighted seeing my broker talked bout on UA-cam, This was exactly how I got recommendation bout Mrs Christine Norine Martin, At First I was a bit skeptical but eventually I gave her a trail with my little investment and I got huge profit..

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

    Every tries to sell you something, some sells Insurance policy, some sells credit cards, some sells loans and some sell content, and this is best content. Make a video in how to avoid all these sellers please in all our lifes

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

    One of most creative video i have ever seen on a financial literacy.

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

    I love these excel calculations and assumptions about life

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

    This still is a burning point of discussion in my family, what to do with a lump sum amount of money ?
    Thanks Ankur, for helping me out with this.

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

    Ankur... You make such informative videos... Applicable to people in all walks of life ...I feel watching your videos adds value to my day... Thanks and continue to do the good work of sharing experiences and building knowledge ☺️

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

    Thank you ankur. Your sheets and content really helps me to set my financial planning n goals..❤

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

    There is saying ki - agar aapke pas paise hai loan chukane ke aur aapke pas ek bad loan aur ek chota loan hai, toh chota loan chukae. Bada loan toh liya hi lambe samay k liye hai. This calculation says the same. Ek bada loan samay k sath chota hota jata hai.

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

    Only one important aspect is missed I think, if I prepay the loan with lumpsum then I can start investing the emi in nifty 50 sip which will also grow with 15 percent. Also investing lumpsum in nifty 50 may not be as good as sip

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

    This is for the people to think they are good at Maths.
    First of all, congratulations because there are only 5% on this planet who are actually good at maths!
    But note that life has its own complex calculations and in many unplanned and uncertain ways.
    Therefore, your first target should be to become debt-free whatever be your condition/situation.
    It not only gives you mental peace but also confines you in moving towards other opportunities that you can then start saving and investing aggressively.

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

    Wow do you really read our minds? I have a lumpsum amount and really confused if I need to pay my education loan or invest it.. I'm still confused ad I didn't understand the video fully (I do not understand hindi). May be I will watch it again or do more research

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

    You made me feel like a big bro to whom i can go sit and discuss my concerns in any topic of the life and have the surity to get some good direction) Keep impacting keep growing!

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

    Hi Ankur Sir,
    Thank you so very much for this detailed video.
    As I started watching your videos since last six months. I realized my few life mistakes ( Taking personal loan to invest into Real Estate & Closing the PL at the end of the tenure ).
    But fortunately I feel good after watching this video that the CHOICE for closing my PL was a good (at-least not too bad) idea.
    Hope to see you many more learnings from you.
    JAZAKALLAH
    Thanks
    Mirza

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

    I am obessed with your ads every where when i open UA-cam your ads appear btw video content is great.

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

    Solid explanation, Ankur. The excel sheet demonstration works like magic. Always great to see exactly what you’re talking about using mathematical proof on the screen.

    • @vikas.singh984
      @vikas.singh984 2 роки тому

      @waTsapp➕①④①⑨❷❸❼⑥③①②💯
      Hi sir

  • @vikassingh-xj7uv
    @vikassingh-xj7uv 2 роки тому

    To a layman like me, it seems there are other factors that should also be considered:-
    1. tax benefit
    2. inflation
    3. floating interest rates?
    4. Whether the same distribution of principle/ interest repayment method is applicable for all loans.
    If these were also included, it would have been a more convincing video. The explanation was also kind of all over the place.
    Sorry for being that guy.
    I just was hoping more really, from someone like you.
    Anyway great job like always.
    Big Fan.

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

    Superb intellectual content with all calculations, This is how we should focus on our cash flow. This is priceless content. Thank you very much sir.

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

      ᴀʟᴡᴀʏs ᴀᴄᴛɪᴠᴇ ᴏɴ ᴡʜᴀᴛsᴀᴘᴘ👆🇮🇳✍️*

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

    real life based scenario par video bana rahe ho sir, keep it up!

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

    Your explanation was fabulous ...But please add moratorium period in that.. Much needed.

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

    For the banker who are working with bank with loan of less simple interest should invest rather then to pay off the debt ....

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

    Sir last ka part to smj aya interest loan ka kam h to market me daal do market ka kam h to loan me daal do paise par starting ka sir ke upr se gya ek video bando ispe

  • @027_shivamdhyani2
    @027_shivamdhyani2 2 роки тому

    Please make a video in Insurance!! Which type of insurance to buy when we get our first job?
    Please Ankur Sir make one video on it🙏🙏

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

    sir please make a video ….. is taking loan for investment is good if good what should we do with it….. amount is good about 20-25 lakhs

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

    what a timing of the video warikoo sir.. same case is with me as I was working from last one week on this.. thank you for some insights which will help in my excel working.

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

    Very good topic! I think you are the first who thought about making a video on this very important topic

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

      👆👆👆Thank you for your comment…Contact the What'sap line above for more information and consultation on investment. I have a new investment.. I am sure you will like to be part of

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

    Excellent explanation as always while doing Excel sheet calculation showing other things in the vedio please reduce face cam (it's a personal opinion) that makes other things also betr

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

    Hello Ankur sir, I don't know if you read this and reply to my query. But hoping to get reply.
    I personally think that in this Loan repayment vs Investment topic, things are more complex to understand and explain when we choose stock market as a investment.
    To make this topic more simpler, can we take FD as hypothetical investment option where we get 8% of interest rate and home/car loan interest as 7%?
    I also think that we should not ignore 6% inflation rate in this calculation.
    We can assume that the individual has Rs 10 lakh with him on day 1 already but he want to take loan of Rs 10 lakh thinking he would get that additional 1% profit (8% interest income - 7 % interest paid)
    If above is the case, then according to you what should be chosen by an individual?

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

    Thank you sir. This is the video which i was waiting for...Loan vs Lumpsump..👌🏻👌🏻

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

    Sir your video are preety owesome and Fully explained concept. That give us an important value of laon and repayment

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

    This suggestion works for Home loan and not for home loans taken in private bank.
    For car loan in Axis and HDFC bank, increasing EMI price is not applicable and for pre-payment their is a additional charges of 5% service charges and 18% GST.

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

    Thank You Sir, As always you help people by sharing your best analysis to improve their financial conditions. God Bless You.

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

    I liked the facts explained. I would like to add that the loans have insurance and you need not pay loan in case of death. So do your calculations and invest / save lum sum amount for family.

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

      That insurance is v costly. More expensive than term insurance

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

    First target is to become loan free irrespective of rate of interest becoz it gives u mental peace . My car loan is at 5.5% then also I am putting my savings to close that loan.

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

    Ek number bacchi ❤️🔥

  • @sonalrsarthi
    @sonalrsarthi 10 місяців тому

    Thanks for the insights in this video. I would like to know how to make best use of HL OD account, not sure if there's a video already done on this topic else kindly make one.

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

    As per my understanding it doesn't really matter how old your loan is. Till last rupee is left as outstanding loan amount, bank will exactly charge set/agreed annual interest rate calculated per month will be considered as monthly interest and rest will be your principal in total EMI you are paying. Bottom line, till last month emi you pay same intrest rate. If you think you can earn more intrest outside compared to loan interest, invest outside. If not just close the loan early. Correct me if I am wrong, I would love to be proved worng.
    I am a great fan of your content!!

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

      ᴀʟᴡᴀʏs ᴀᴄᴛɪᴠᴇ ᴏɴ ᴡʜᴀᴛsᴀᴘᴘ👆🇮🇳✍️*

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

    Content king ...agar hota to 100 baar subscribe kar leta

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

    waiting for this video for long days thank you so much Ankur sir.

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

    I had this question for a long time. Thanks for the video. It helped me a lot 👏

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

    The second part is that the loan is for what reason if it's a house loan then u can save taxes on it so u should not pay it immediately.

  • @rajkumar.g9463
    @rajkumar.g9463 2 роки тому

    Super Thanks Bro....You Should Try in TV and Ad Film....U look very Cool