Video není dostupné.
Omlouváme se.
Investing vs Loan Repayment EXPLAINED with Excel Sheet! | Ankur Warikoo Hindi
Vložit
- čas přidán 14. 08. 2024
- If you receive a lump sum amount of money, should you invest it and grow your money, or should you pay off your loan and reduce your debts?
Can the answer be different based on interest rate and tenure? Let’s figure out in this video!
You can download this excel sheet (used in the video) and make your own calculations: bit.ly/3GJCcc1
Get the notes of this video here - bit.ly/3vc7fLE
Change the way you bank with the help of Jupiter!
Check it out here: bit.ly/Warikoo...
Here is my video on how to invest a lump sum amount: • How to Invest a Lumpsu...
00:00 Introduction
02:50 Loan calculation on excel sheet
09:15 Lumpsum Investing on excel sheet
18:00 Invest or pay off loan?
20:00 Conclusion
#LoanRepayment #Investing #Warikoo
Click here to subscribe to my CZcams channel: shorturl.at/bizNX
------------------------------------------------------------------------------------------------------------------------------
My bestselling books:
‘GET EPIC SHIT DONE’: ankurwarikoo.c...
‘Do Epic Shit’: ankurwarikoo.c...
My gear for shooting this video:
🎥 Sony a7III camera: bit.ly/3M42wAV
🎬 Sony FE 24-70 f2.8 Lens: bit.ly/3KCCiF0
🎙️ Shure SM7B Microphone: bit.ly/3O1NAVA
🔆 Fill Light 60W: bit.ly/37aJolP
💡 Key Light 150W: bit.ly/3O9nyjs
📽️ Benro IT15 Tripod for Sony a7III camera: bit.ly/3O4PvJ1
Useful links:
20 books for your 20s: bit.ly/Warikoo...
20 online courses for your 20s: bit.ly/Warikoo...
Gadgets that I use: bit.ly/Warikoo...
The above links are on Amazon.
If you buy any of these using the above links, I stand to make affiliate income from it. 100% of this income is contributed towards the education of kids who cannot afford it. In 2021 we contributed 38L and in 2022 we contributed 53L.
Let’s connect online:
🎙️ My weekly podcast Woice with warikoo (Spotify): open.spotify.c...
📩 My weekly newsletter warikoo Wanderings: ankurwarikoo.c...
📱 Instagram: / ankurwarikoo
🐦 Twitter: / warikoo
👨🏻💻 LinkedIn: / warikoo
😄 Facebook: / awarikoo
🖋️ Daily Blog: ankurwarikoo.c...
Change the way you bank with the help of Jupiter!
Check it out here: bit.ly/WarikooJupiter
Sir link of that Excel sheet.....??
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...
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
How to make investment excel sheet from starting please make a vedio
@🆆hatsapp➕①②①③④⓪①④⑤③⑧ sir I couldn't do my loan calculation on the above pinged Excel sheet , how do I edit my loan details ?
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.
thats emotions and not maths..!! both are right in its own sense.
Bad call if you already had good monthly cash flow
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.
You can't sava 2 lac loan now
You did fantastic. This is difference between theory which sir is giving and practical which you did.
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.
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
@🆆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 😥😥
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.
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.
ĺ
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..
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.
Good and important catch sir💯
You get tax benefit on loan interest too.
@@kumarindiaamit not on all type of loans, only home loan
@@ravishkumar2205 education loan as well.
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 ♥️
Another important factor to consider is job security.. Sometimes it is better to pay off a loan because jobs are not secure imo.
ᴀʟᴡᴀʏs ᴀᴄᴛɪᴠᴇ ᴏɴ ᴡʜᴀᴛsᴀᴘᴘ👆🇮🇳✍️*
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
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.
@@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.
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
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. 😊
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?
@@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.
@@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...
@@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.
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.
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 ♥
Never knew cryptocurrencys could be so challenging! Kept running back to these CZcams videos to learn more about this your video is indeed helpful.
Who else think this Crypto trade is kinda easy but is way to nervous to start,.
Trade has left me no choice but to keep investing because it makes so much profit for me.
i have been trading offshore and still have not made my own profit which strategy do you use please .
Got linked up With Mrs Stacy Griffin Kartner o days ago never knew anyone will know her here.
She is a genius
Now I feel proud that I am having same thinking as my financial guru.
Thank you sir
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) 🙏
Ankur is so great at what he does. People consider him a guru of finance and life in general.
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)
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
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.
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%
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
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...
Finally Ankur is back with being Ankur..! Keep up the quality.. Please yar, don't make it all ads..
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.
Whatever we need to know regarding financial management, one stop solution is this channel...
Thanq so much Ankur ji
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!!
I have done a video on how to pay off loans faster.
@@warikoo sir ek video banaye on how businesses person can pay zero taxes leagally thanks
@🆆hatsapp➕①②①③④⓪①④⑤③⑧ fake account stay away .
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
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.
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.
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.
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.
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.
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
Thank You so much Sir, learning so much from your videos.
People will be kicking themselves after the fluctuations in price and cryptocurrency this is the best time to trade Crypto.....BE WISE 🤷.
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.
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'
I can just thank you from my heart and soul. You are educating us what we need to make our financial decisions wisely. 🙏🏼❤️
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
For the banker who are working with bank with loan of less simple interest should invest rather then to pay off the debt ....
I am facing exact senerio and i got Ankur sir's video...... Exactly on sam subject.... Thank you 😊❤️
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) 🙏
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.
You are right! People paying 30% tax for them keeping the loan is better
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❤️
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
*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.,*
You're right ma,
That is why I had to start forex trading
2months ago and now am making benefits from it,
Thanks for introducing me to Sam Justin.
O' Yes I'm a living testimony of Sam Justin
Mr Sam Justin has changed my financial
status for the best,
Sam Justin is obviously the best,
Hooked to your videos Mr Warikoo! Already setting financial goals to be truly debt free soon 😊
👆🏽 👆🏽 Thanks for watching. Reach out I have a project that you might find interesting.
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 🙂
This is the exact dilemma I have right now. Commenting before finishing the video. I know already that I'll follow your instruction.
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 ;-)
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
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 😊😃
Should the tax exemption on loans be also considered?
It should , it missed , may be because it can make video very complex
yes absolutely
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.
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
How much does the factor of tax benefit on interest payment affect this process?
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
Who's Jupiter
This is what I was thinking from last 2-3 days and now I saw your video.... Great help....Thank you....
Sir, if the loan is for 5 yr, it may be possible that 2 to 3 yr of that period market may be down and later it is possible that during this 5yr money will not grow with 15% rate... As you always told us the stock market is good for over 10+ yrs, is it really safe to invest for repayment of loan? Please reply
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
Please share the excel sheet
All words, no play of yours. Most of you are justifying your home loans
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.
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 ☺️
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...
Excellent video. Just to add some loans like home loan/ EV loan have some income tax expemtions. This should also be taken into consideration.
*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?*
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
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.
An extraordinary is the right word for expert Mrs Nancy, she's very experiences as a trader
and so unique
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.
@@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
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
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
Despite the economic downturn,I'm so happy☺️. I have been earning $ 60,000 returns from my $7,000 investment every 13days.
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 ?
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
after watching so many CZcams 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.
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.
So delighted seeing my broker talked bout on CZcams, 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..
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.
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.
@waTsapp➕①④①⑨❷❸❼⑥③①②💯
Hi sir
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.
nie video. but nit able to use or edit that excel sheet. kindly help. thank you.
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
SIR EXCEL SHEET IS NOT IN EDITABLE FORMAT . PL GIVE ITS ACCESS
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.
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.
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?
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
I love these excel calculations and assumptions about life
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
Thank you ankur. Your sheets and content really helps me to set my financial planning n goals..❤
This is my secret strategy, started since 2018...😉, But over the time I have revised the implementation.
❌Very good comments above Ankit, Bharat, Prasant. I lost job suddenly & now I regret why haven't cleared my Home Loan, when I could. Really Excel doesn't work during STRESS. Go 200% to clear all debts without hearing anyone, Life really No Guarantee. PPN
Great video Ankur Sir
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!
Time 0:56 mene abhi video dekhana start kari hai or mujko esa lagta hai ki phele mai loan pay karna shai samjhunga (:
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.
ᴀʟᴡᴀʏs ᴀᴄᴛɪᴠᴇ ᴏɴ ᴡʜᴀᴛsᴀᴘᴘ👆🇮🇳✍️*
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
Sir, sub invest karkke after retirement I don’t know If i will be able to enjoy or maintain a even 1000sqft house or drive an automatic car even😂. In 20s or 30s even if we loose job we still have the opportunity to find jobs.. if i can live my dream life 30 years earlier, i would definitely get a loan and pay it back easily by installments in 20 years or whatever.Not being a bad influence but I don’t find a reason to think otherwise even after excel calc. Having said that i love your videos and appreciate how much you emphasis the importance of investing and excel works🙌🏻. Kudos!
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) 🙏
@@tejasbhagat4889 thanks for trying to make me understand this.. im not here saying everything you earn should go to paying loan.. ofcourse you will be mentally sick then.. Here im saying we definitely have emergency funds which is say 6 months expenses which is definitely including these loan amounts also.. so like other investment a loan can also paralley be closed just like another investment paying monthly mutual funds or paying insurance EMIs or even investing in stocks🤷🏻♀️ this is what I am thinking or believing .. and im not convinced by any other explanation so far. I get the point anyway of how not take loan instead invest. But afterall living a life of your dreams is different for different people. May be!
Sounds like crazy...excel excel khelte hai...I am loving it. ❤️ Thank you ji
You are doing amazing work for the community for "Aam Admi" respect from a Pakistani, stay happy and healthy
Thanks for your suggestions,but I can't edit the above execl. Please provide approval to do changes in above Excel sheet.
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
sir mere ek home loan hai 20 lakhs ka hai aur uska Interest rate 14% hai i want a solution and emi is 25000 and mt salary is same what should I do
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.
Sir i took a loan of 3lakh and the interest is 7%. And i got 1lakh lum sum ammount
What is the process of investment in mutual funds? And which mutual fund is better for investment?
Please provide excel sheet in which i can edit my actual loan amount and calculate the interest .its help me to decide either payoff loan or invest
Hello Ankur Sir,
I have watched both the videos on loan repayment but couldn't get solution to my situation. Whether to clear the education loan during moratorium period or wait to start for emi to start, because in the previous case i don't have to pay interest on my loan. And in any case I won't get tax benefit on principal amount.
This video is going to help me a lot. Thank you Sirji
👆🏽 👆🏽 Thanks for watching. Reach out I have a project that you might find interesting.
Thank you sir. This is the video which i was waiting for...Loan vs Lumpsump..👌🏻👌🏻
Basically it's the mental burden of loan which people wants to remove from their shoulder so they never thinks about investing lump-sum amount to market
Please give me the access to the excel to edit and calculate for me and also for future usage- thanks...!!!
real life based scenario par video bana rahe ho sir, keep it up!
lovely video sir. but i am not able to use that excel sheet. it is read only. I have also sent the message to the owner as was asked in the sheet. it will b helpful if can guide me to use that sheet.
One of most creative video i have ever seen on a financial literacy.
Cloud you please make a video on how we can buy Mutual funds and set up automatic payments in Coin App
it was really confusing for me. It will beneficial for many people like me.
☝️☝️☝️☝️ write me now for mentoring and investing purposes
Sir I invest in this correction and I pick some 5 stock's and if I see in trick tip forcast it showing your portfolio will give 19% percent return on next year it good or bad percent piz say 🙏 me I just become 18
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!!
ᴀʟᴡᴀʏs ᴀᴄᴛɪᴠᴇ ᴏɴ ᴡʜᴀᴛsᴀᴘᴘ👆🇮🇳✍️*
Sir please share the Excel sheet link. The given sheet got corrupted.
Sir, pre approved loan amount disbursed bank account nahi aaya hai, bank Emi kya le sakta hai, I am confused please help.