Here is the Excel Sheet for the video: bit.ly/3B6JjOE My Money Apps: Indian Stock Investing (Zerodha): bit.ly/3iYKROh Mutual Fund Investing (Coin by Zerodha) (You will need to create a Zerodha account for it first. Coin is free): bit.ly/3iYKROh US Stock Investing + Investment Tracking (INDMoney): bit.ly/3tT5moR Portfolio Investing (Smallcase): bit.ly/3u0is0I Corporate Bonds (Wint Wealth): bit.ly/3sbUI8c How to pick the right insurance (Ditto): bit.ly/3xFh7OU The above links are for products that I personally use for my own investing. If you create an account on any of these using the above links, I stand to make a referral income from it. 100% of this income is contributed towards the education of kids who cannot afford it. In 2021 we contributed 38L, in 2022 we contributed 53L and in 2023 we contributed 52L. DO NOT assume that these are the best products in the industry. Please do your research and let me know if you have any questions. My bestselling books: 'Make EPIC Money' here: amzn.to/3WHJ43F ‘Get EPIC Shit Done’: amzn.to/4fK1IR5 ‘Do Epic Shit’: amzn.to/4fK9uuv
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 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, in 2022 we contributed 53L and in 2023 we contributed 52L.
Hey you haven't mentioned one most important thing that is duration of loan because that thing changes the calculation, if someone has taken a loan for 3years then post three years he can increase his/her investment again
Sir ur advise helped me to do financially planning to next level please allow me to speak in your channel . I started investing at 2018 with 500 now I invest 20k from next month I will increase to 40k investment . Started emergency fund for 6 miths I have 1 lic I have 1 term insurance I have 1 medical insurance Thanks from bottom of my heart in making my life discipline. Just let me know if I continue like this for 25 year I can retire
I've always wanted to combine all the Excel sheets you made for our planning, and now I've finally got it all in one place. Thank you-it's just what I needed!
All we want to say is “ Thank you so much “. You owe us a lot! One day I will definitely meet with you , it is my commitment to myself… to say “ thank you” behalf of our generation.
Sir i am 23 years old and i work in sbi as a po and i am investing 30k per month and i want to keep investing till the age of 50 Thanks sir only because of you i started all of these things in such a young i have been following you from the last 4 years 🙏🏻❤️
Bhai saari life unwind hogayi. (1) Accha school kyun jaruri tha (2) Accha college (3) Acche number (4) High Paying Job (5) Acchi Saving skill ya jo bhi hamare parents ka fear hai vo kitna real hai. Kyunki sab maths yeh btati hai ke aap kab tak majdoori karoge yeh bhi apki pocket decide kregi. Aisa lagra hai jo realisation 40+ me hota hai, vo bahaut saare logo ko ab jaldi hit karega.
And abhi bahaut saare expenses planned hi nhi hain. Jaise emergencies, ghar, shadiyan, etc etc etc. I wouldn’t say this sheet is a real tool but what I understand that he means if I live only by myself and I haven’t done a easy-but-good mathematical calculation of my budget, sooner or later I’ll loose hang of it. Things might start to burden and I won’t be able to understand.
i started low paying early job at the age of 21, rather than continuing my studies further for a higher paying start and now i am seeing the error of my ways. This was my own decision , i could have studied further without any problem but got money chaska. My advice to young people to go for a higher paying starting job even if it takes you few more years.
At nearly 27, I find myself reflecting on my journey. With no ancestral wealth or savings from my family, I’m grateful for the strong education they provided. As a software engineer earning around 26k, I hadn’t considered saving for the future until recently. After watching many reels about savings, I’ve taken the important step of starting SIPs for my future. Thank you for and keep inspiring
It is really nice that you share your knowledge on financial planning. This is a very important topic that everyone should be aware of but unfortunately no school or college teaches these things. Thank you for doing these videos. In fact I started my financial planning after watching your videos.
This is not simply a sheet, this is an absolute weapon to plan yourself out of trouble. An entire series can be made out of this 1 sheet. I've used the retirement planner previously shared and with an expense tracker, I can truly keep a track of my money and then invest appropriate,. Ankur Sir, I want to Thankyou for providing this enlightening work. Thanks a Lot
Dear sir At the very first time when I watched your video really i feel you and your pain regarding to all the peoples who don't have any ideas of financial knowledge and even losses life hope even smart income which clearly indicates still and even lot of knowledge and income peoples could not able to understand the financial activities in their life and you are very surprised to know I invested in sip in 2014 at the age of 27 with 500 RS and currently increased to 12000 per month at the age of 37 which makes me happy and watching your all vedios very deeply and still trying to learn more and more from it
Sir aapka instructions bahut motivation deta hain. Mera maa aur papa ko dekha hoon har ek choti chhez ka hisab likhte hain aur mujhe bhi sikhaya hain..😢 but really I am waste only...micromanagement purane log se hi sikhte hain
What a fantastic video and explanation. Awesome Ankur 👍. I am going to use this excel document and amend it to my requirements and then, update my comment. I read a lot of comments below where most people are missing the point and pointing at what is missing from the sheet. This is just a template. You can customise it to your requirements. So don't blame the worksheet understand the concept and this free starting tool provided and feel grateful. After that modify the excel sheet to your requirements. If you then find any errors, please do mention so all of us can learn and Ankur can amend it. Well Done Ankur!👏.
I cannot be more thankful to you. This is like game changer. Ankur ji you made the life more easy now. This is what I wanted to make and you made it for me thank you so so much. I think this is going to be to help tons of people who cannot get clarity for finance planning.
Thanks a lot for creating this sheet. This is very helpful. Is it possible to update sheet with existing investments and adjust the Financial Planning Tab accordingly? I think it will be very helpful. 1. PF 2. PPF 3. FD 4. NPS 5. Existing mutual funds / Stocks
Fantastic... Kudos to your patience to build up this simple yet effective sheet. I am 45 years old. Just want to understand whatever I have already saved in ppf n epf, should I put it in the starting balance of financial planning sheet? Pls guide.
Ankur sir's videos are best for gaining great insights regarding second opinion when we are doing financial planning. Never stop teaching us sir. Thanks a lot!!!!
I would like to request an enhancement to the retirement Excel sheet by adding the ability to input a list of EMIs, including the start year, end year, and amount. The retirement calculation logic should then factor in these EMIs, allowing for more accurate and comprehensive financial planning.
One thing which I find missing is we are considering that loan EMI will be there entire time till earning. But EMI will have different tenure and those fund will get free to invest.
Hi Ankur, I just wanted to say a big thank you for the amazing explanation and the financial planning Excel sheet. I watch all your content, and it’s always so clear, helpful, and inspiring. I do have a couple of suggestions: Loan Factor: It would be great if you could add an option to start with no EMI until possession for a home loan, and then switch to full EMI after the possession date. Income Growth: Could you include a yearly growth factor for income? Additional Investments: It would be awesome to see the continuous growth of additional investments like mutual funds, stocks, LIC, etc., reflected in the overview. Thanks again for all your hard work!🙂
Hello, Thanks for this video. I have a point to add. You have calculated tax only for the years someone is working and not after that. This can change the equation a lot.
@warikoo - couple of changes you should to sheet like - EMI can go beyound retirement also, the % of return of saving should be in bracket of 5 years, say a person getting FIRE at 40, can still invest in mid and small cap as compare to when he is in 55yr so the % of XIRR difference should be considered, Not sure if tax is properly factored in or not....would be happy to see new sheet with wish list changes
Thank you sir, you always try to give us something new and motivate us all the time,, There are some negative comments and replies,, just neglect it,, and keep motivating us/or your students❤❤❤
Seems like Ankur ji is also responsible for low cars sales 😊People have started savings and investing rather than putting money on depreciating assets.
Ankur Sir, Honestly when I go through these Excel Sheets then it truely feels that even if you start in your early 20s, Retiring in your mid 40s is a Fallacy! Until you are doing something exceptional or you have Financial support of your Parents.....
Well at age of 40 you can plan a passive income stream, ie, food business, travel, some frenchise etc and then make seperate goal for diversified income streams every 5-10 years to increase profit and mitigate unforeseen scenarios Take out 1cr or more/less and plan accordingly that way you may have a soft retirement at 40 and that passive income will take you long way may be even after 60s
Hi Ankur, Thank you for sharing such gems of knowledge with us. I started investing after watching your videos. You have been a great inspiration for me and my family. Thank you for being such an amazing teacher! I have a small request - can you please make a detailed video on NPS Vatsalya and whether it is worth investing in it for one's child? Also how can a parent plan for investments for kids. Are there any instruments, we can explore?
Hi Ankur, thanks for sharing the retirement plan. I personally benefit from your wisdom. Could you create a video of financial planning for someone who is 40 years and is near achieving financial independence with investments and savings already in place and is planning to retire early at 45 years. What is the retirement corpus one needs to ensure living costs are taken care off and there will be wealth pot left to be given as legacy. Would appreciate if a video catering towards income earners in their 40's can be created. Thanks.
The information was definitely a big help to ascertain the kind of wealth creation and expenses to expect in future. Thanks a ton. Just one thing if possible can be added is plan child education cost and investment profile.
Please make an interesting case study of UPS vs NPS. All Govt employees are confused about which to choose. Your insightful video will be surely viral among 2 Crs Govt employees .
Great fantastic investment planning, this gives lot of confidence and release stress in life further we can simplify our by applying some basic rules, though life is unpredictable. This investment required a discipline. Thanks Mr. Ankur for sharing your ideas.👍👍👍
That's a nice explanation @warikoo Ankur Sir, I had put my data in this Excel, but I feel it needs more columns to add. For expenses, there should be some column to add income like pension from my job, and NPS corpus which the company deducts and the company adds their 10% and 14% funds to NPS. Also, short-term goals have to be completed so that expenses need to be addressed in sheet.
Sir, this is good excel sheet, but in this 15 years there are personal expenses that pop up. At age of 28 marriage, @ 30 years one kid will add up, 35 years school fees starts, @ 40 or 45 one may lose job for 4 months, 46 years need for new or bigger house 50 years, kids higher studies expenses, 55 kids marriage. If all the savings are invested we will ger 6 crores, but you never mentioned how all the expenses occur between 25 - 50 will be earned.
If you are increasing your investment by 5%. what about your salary will that also increase same %? Also, will the expenses get increase proportionate to salary increase? Answer is No. Whatever Ankur has said, he assumed your expenses has increased with salary and you invest only increase by 5%? Which is not the case as you can control your expense.
buddy this sheet is to you to plan your expense and Invest. you how much you are investing depending on that its your corpus. In the excel there is a column for all these expense in Financial Planning sheet
@@amitkumarrai6127 well this doesn't look like investment planning, it looks like a pit to invest in mutual funds. Unless somebody doesn't guide the youngster of the future expenses, they wouldn't know.
Nice effort sir, but your excel sheet needs to be updated because it does not separate yearly spending from total monthly investment. I suppose "=Expenses!B27/12" will be the right calculation for Investment Section (B2 cell)
An excellent sheet that provides lot of clarity. Helped me in making some decisions how I want to spend and how I want to live. I can’t thank you enough
By the time you reach 42-43 years it is too late. Lot of uncertainty come into picture like Job security, Health risk, kid education, limited time till retirement due to which less compounding effect. If you have any money saved till 42-43 then you can plan for retirement. If you want start from scratch then it is too late.
Ankur, thanks for simple explanation of difficult subject (for young generation). Now in your sheet I do not see the section for statutory deductions / investments like PF and NPS / Superannuation. Cause the 25% of the total savings are going in safe instruments which is VPF / PPF etc. which are different that PF & NPS. Also many employees now have option of ESOPS (either Monthly or lumpsum) So that column to be added as well. Yearly Bonus is also there but that can be added to yearly additional income. I don't need the sheet but it's always fun to play with excel and this sheet I am downloading to work out my own version. Thanks Again.
Hello Ankoor Sir, This is a fantastic Excel for all of us struggling with financial planning. I have one suggestion: could you include a section on building an emergency fund, along with a method to calculate the necessary amount based on different salary and age ratios? As a young professional just starting my career, I'm eager to establish an emergency fund, as you've emphasized its importance before beginning to invest. Please let me know. Parth Trivedi.
@warikoo sir, one piece that would have been helpful if added in this sheet is adding any current investments, their current value and expected rate of return and how it would have impacted the future wealth.
Awesome, Please make a video for those people making daily or weekly income like from intraday trading/business. I never find this kind of video on utube.
He won't because it's not possible for everyone to earn that much in short time. He doesn't support it and hence won't make any video regarding it. 99% of the people will lose money in these so what's the point event?
@@mynk_rjputi am not promoting stock market/ intraday/any investment or business, im just curious to watch any video to manage my finances. Anyways, thanks for the feedback.
bhai step up 5% every year nikal do fir jo milega vo hakikat hogi....logo ke salary package increment 10% ho gyi to bhi bohot hoga aur inflation 6% se grow karta hai....ek bar tum vo dikha do ke 45 years ke baad sip kitna karna hai when 5% is in picture and not in picture....nearly 50% sal will be consumed in sip if you keep step up of 5%...
Big Fan Sir...! Thank You for sharing all the knowledge and values. One doubt why are we not adding inflation while calculating Ending Savings when we are Earning?
Biggest flaw in all the FIRE calculation is 1. Taxes which can destroy all FIRE planning...all governments are moving towards to bring all incomes under slab rates current 12.5% will eventually will became 35.88% tax rates on withdrawals....2. Even more important is Stock Market return of first five years....your retired...2008 market like crashed happens...market goes 4-5 years sideways after crash...and your FIRE completely destroyed.
Bhai iphone 13 hi leleta hoon. Ek cable leke hi toh ghumna padega kuch saal bas. 4-5 saal khich jayega. Next iteration me iphone 15 lelunga. Type C ka Type C aur no more jhanjhat.
I have been watching your videos recently and I really think now that I have regret that I didn’t found out your videos earlier, but now I have started learning from you and it’s really helpful , but I have a humble request from you , I have seen most of your videos there is great way of investing in some midcaps an all these stuff but can you please show how to invest from which platform or how to purchase them??❤
Bro you're clearly a liar, if you have seen most of his videos then how come you didn't see Ankur's one of the recent video where he clearly showed how to create account, find and then invest, do sip etc in mutual funds on his go to platform Zerodha
Sir, my recommedation, you suggests somethig where you don't need to cut your expenses but still you can good income or return in future. Please take note of this.
This is an absolute and great planning worksheet. Thank you so much as this could bring lots of discipline. Just a question? IRR return expectations are post income tax or pre-income tax? As somehow couldn't able to see the accounting for the income tax as expense on a yearly basis in the financial planning worksheet. Pls guide.
Sir plz make vedio of rental and own home.. which 1 is bttr we only trust u.. although there are so many of vedio available on yt bt i want ur perception. Kuch bolte h rent pr rh lo bt loan na ho jyada bttr h Kuch ka bolna h at the end of the day EMIs pay krte krte ek din ap ghr k malik ho jate ho to bhtt confusion hoti h
Here is the Excel Sheet for the video: bit.ly/3B6JjOE
My Money Apps:
Indian Stock Investing (Zerodha): bit.ly/3iYKROh
Mutual Fund Investing (Coin by Zerodha) (You will need to create a Zerodha account for it first. Coin is free): bit.ly/3iYKROh
US Stock Investing + Investment Tracking (INDMoney): bit.ly/3tT5moR
Portfolio Investing (Smallcase): bit.ly/3u0is0I
Corporate Bonds (Wint Wealth): bit.ly/3sbUI8c
How to pick the right insurance (Ditto): bit.ly/3xFh7OU
The above links are for products that I personally use for my own investing. If you create an account on any of these using the above links, I stand to make a referral income from it. 100% of this income is contributed towards the education of kids who cannot afford it. In 2021 we contributed 38L, in 2022 we contributed 53L and in 2023 we contributed 52L. DO NOT assume that these are the best products in the industry. Please do your research and let me know if you have any questions.
My bestselling books:
'Make EPIC Money' here: amzn.to/3WHJ43F
‘Get EPIC Shit Done’: amzn.to/4fK1IR5
‘Do Epic Shit’: amzn.to/4fK9uuv
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
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, in 2022 we contributed 53L and in 2023 we contributed 52L.
Hey you haven't mentioned one most important thing that is duration of loan because that thing changes the calculation, if someone has taken a loan for 3years then post three years he can increase his/her investment again
Yeh lwk laisa kaise kamana ow nehi shikhata hain internet pe raaj kar raha hain ow amir joke wariko bodha horahah hain
@@mrsumitmukherjiYeh lwk laisa kaise kamana ow nehi shikhata hain internet pe raaj kar raha hain ow amir joke wariko bodha horahah hain
@@GaneshDebbarma-kt2zn bro paisa kamana khud se shikna padhta hai
Sir ur advise helped me to do financially planning to next level please allow me to speak in your channel .
I started investing at 2018 with 500 now I invest 20k from next month I will increase to 40k investment . Started emergency fund for 6 miths
I have 1 lic
I have 1 term insurance
I have 1 medical insurance
Thanks from bottom of my heart in making my life discipline.
Just let me know if I continue like this for 25 year I can retire
I've always wanted to combine all the Excel sheets you made for our planning, and now I've finally got it all in one place. Thank you-it's just what I needed!
All we want to say is “ Thank you so much “. You owe us a lot! One day I will definitely meet with you , it is my commitment to myself… to say “ thank you” behalf of our generation.
Sir i am 23 years old and i work in sbi as a po and i am investing 30k per month and i want to keep investing till the age of 50
Thanks sir only because of you i started all of these things in such a young i have been following you from the last 4 years 🙏🏻❤️
Very good keep going i m from union bank of india
Bhai mai toh 32 ka hun aur abhi tk unemployed....
Bro aapka in hand salary kitna hai as a sbi po
@@sachinsk1802 rassi kharidne ke paise hai?
@@himage6540 hn bhai
Thank you Ankur, have not seen anyone share such workings openly... many ppl's earning is from such sheets. Hatts off bro... thanks once again..
Bhai saari life unwind hogayi. (1) Accha school kyun jaruri tha (2) Accha college (3) Acche number (4) High Paying Job (5) Acchi Saving skill ya jo bhi hamare parents ka fear hai vo kitna real hai. Kyunki sab maths yeh btati hai ke aap kab tak majdoori karoge yeh bhi apki pocket decide kregi. Aisa lagra hai jo realisation 40+ me hota hai, vo bahaut saare logo ko ab jaldi hit karega.
And abhi bahaut saare expenses planned hi nhi hain. Jaise emergencies, ghar, shadiyan, etc etc etc.
I wouldn’t say this sheet is a real tool but what I understand that he means if I live only by myself and I haven’t done a easy-but-good mathematical calculation of my budget, sooner or later I’ll loose hang of it. Things might start to burden and I won’t be able to understand.
i started low paying early job at the age of 21, rather than continuing my studies further for a higher paying start and now i am seeing the error of my ways. This was my own decision , i could have studied further without any problem but got money chaska. My advice to young people to go for a higher paying starting job even if it takes you few more years.
At nearly 27, I find myself reflecting on my journey. With no ancestral wealth or savings from my family, I’m grateful for the strong education they provided. As a software engineer earning around 26k, I hadn’t considered saving for the future until recently. After watching many reels about savings, I’ve taken the important step of starting SIPs for my future. Thank you for and keep inspiring
26k rupees per month? If yes then your education isn't that strong.
@@AdarshRaj-t5u I am from mechanical engineering, joined startup as full stack dev with almost 2yr exp , I wfh that's enough for now
27 now with 50k salary still confused for the future
Are your parents depended on your salary?
@@rudrachatterjee2614 Yea
It is really nice that you share your knowledge on financial planning. This is a very important topic that everyone should be aware of but unfortunately no school or college teaches these things. Thank you for doing these videos. In fact I started my financial planning after watching your videos.
This is not simply a sheet, this is an absolute weapon to plan yourself out of trouble.
An entire series can be made out of this 1 sheet. I've used the retirement planner previously shared and with an expense tracker, I can truly keep a track of my money and then invest appropriate,. Ankur Sir, I want to Thankyou for providing this enlightening work.
Thanks a Lot
I am not able to edit that sheet
Don't edit that sheet. Make a copy and edit the copy
Dear sir
At the very first time when I watched your video really i feel you and your pain regarding to all the peoples who don't have any ideas of financial knowledge and even losses life hope even smart income which clearly indicates still and even lot of knowledge and income peoples could not able to understand the financial activities in their life and you are very surprised to know I invested in sip in 2014 at the age of 27 with 500 RS and currently increased to 12000 per month at the age of 37 which makes me happy and watching your all vedios very deeply and still trying to learn more and more from it
Sir aapka instructions bahut motivation deta hain. Mera maa aur papa ko dekha hoon har ek choti chhez ka hisab likhte hain aur mujhe bhi sikhaya hain..😢 but really I am waste only...micromanagement purane log se hi sikhte hain
you are not a waste! You have room to grow no matter what age you are at!
What a fantastic video and explanation. Awesome Ankur 👍. I am going to use this excel document and amend it to my requirements and then, update my comment.
I read a lot of comments below where most people are missing the point and pointing at what is missing from the sheet. This is just a template. You can customise it to your requirements. So don't blame the worksheet understand the concept and this free starting tool provided and feel grateful. After that modify the excel sheet to your requirements. If you then find any errors, please do mention so all of us can learn and Ankur can amend it. Well Done Ankur!👏.
I cannot be more thankful to you. This is like game changer. Ankur ji you made the life more easy now. This is what I wanted to make and you made it for me thank you so so much. I think this is going to be to help tons of people who cannot get clarity for finance planning.
is the excel file read only? can it not be edited?
Thanks a lot for creating this sheet. This is very helpful.
Is it possible to update sheet with existing investments and adjust the Financial Planning Tab accordingly? I think it will be very helpful.
1. PF
2. PPF
3. FD
4. NPS
5. Existing mutual funds / Stocks
Thanks a lot maine aapka video ka link save bhi karlia hai or social media per SHARE bhi kar diya hai
Aapki yeh koshish bhut achchi lagi great job 👍
Thanks for sharing this sir. I will try to use it but I think it will make my work done easily. Really grateful to you. 😊
One of the best financial advice with very simplistic way. ❤
Sir Sorry 😢
pata nhi kyu ye video thik se samajh me nahi aaya.
You are My Mentor & best financial Teacher ❤️❤️❤️❤️
Fantastic... Kudos to your patience to build up this simple yet effective sheet.
I am 45 years old. Just want to understand whatever I have already saved in ppf n epf, should I put it in the starting balance of financial planning sheet? Pls guide.
Yes
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
Ankur sir's videos are best for gaining great insights regarding second opinion when we are doing financial planning. Never stop teaching us sir. Thanks a lot!!!!
Excellent sheet! This sorts most of the crucial decisions in life! Thank you for sharing!
I would like to request an enhancement to the retirement Excel sheet by adding the ability to input a list of EMIs, including the start year, end year, and amount. The retirement calculation logic should then factor in these EMIs, allowing for more accurate and comprehensive financial planning.
You could add these emi in the needs section
One thing which I find missing is we are considering that loan EMI will be there entire time till earning. But EMI will have different tenure and those fund will get free to invest.
Correct. However, it can be replaced by any other such expense, so ultimately, it has covered pretty much everything
Aap ek bahut hi accha kam kar rahe ho 🎉🎉❤❤
Finally isle baad koi air video bhi aaegi because as u say this is it. So thank you for your services.
Very good calculations Sir, but one thing is to be added. that is rental income and other income after retierement. Please add if possible.
Hi Ankur,
I just wanted to say a big thank you for the amazing explanation and the financial planning Excel sheet. I watch all your content, and it’s always so clear, helpful, and inspiring. I do have a couple of suggestions:
Loan Factor: It would be great if you could add an option to start with no EMI until possession for a home loan, and then switch to full EMI after the possession date.
Income Growth: Could you include a yearly growth factor for income?
Additional Investments: It would be awesome to see the continuous growth of additional investments like mutual funds, stocks, LIC, etc., reflected in the overview.
Thanks again for all your hard work!🙂
Hello, Thanks for this video. I have a point to add. You have calculated tax only for the years someone is working and not after that. This can change the equation a lot.
@warikoo - couple of changes you should to sheet like - EMI can go beyound retirement also, the % of return of saving should be in bracket of 5 years, say a person getting FIRE at 40, can still invest in mid and small cap as compare to when he is in 55yr so the % of XIRR difference should be considered, Not sure if tax is properly factored in or not....would be happy to see new sheet with wish list changes
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
Outstanding Video Sir. I really get very good idea about FIRE. It is one of my best video watched on TH-cam.🙏🙏🙏✍
Please add a Column for EPF that we will get at retirement...Great Excel, Loved it!!
An uncle from Gurugram is always criticizing your excel sheets
😂
Wo real estate wala ? 😂😂😂
@@themboys304 woh all in one hai, 4 youtube channels hain uske
😂
how to edit it
Watched several times... Understand now...
Thanks sir
Great sheet with a simple approach 😊😊 love it❤
Thank U Ankur for the Excel Sheet... It is very much helpful.
Thanks for helping out and keeping your video more interesting ❤️
Repititive , but it is what it is actually required in life - The Basics👌
Please make financial planning of middle class to rich by assuming a person in different levels of life and steps to be taken
Thank you sir, you always try to give us something new and motivate us all the time,,
There are some negative comments and replies,, just neglect it,, and keep motivating us/or your students❤❤❤
Great initiative sir. Thank you so much for helping me. I will follow.
Seems like Ankur ji is also responsible for low cars sales 😊People have started savings and investing rather than putting money on depreciating assets.
You are amazing sir... Definitely changing many life's❤
Ankur Sir, Honestly when I go through these Excel Sheets then it truely feels that even if you start in your early 20s, Retiring in your mid 40s is a Fallacy!
Until you are doing something exceptional or you have Financial support of your Parents.....
Well at age of 40 you can plan a passive income stream, ie, food business, travel, some frenchise etc and then make seperate goal for diversified income streams every 5-10 years to increase profit and mitigate unforeseen scenarios
Take out 1cr or more/less and plan accordingly that way you may have a soft retirement at 40 and that passive income will take you long way may be even after 60s
Hi Ankur, Thank you for sharing such gems of knowledge with us. I started investing after watching your videos. You have been a great inspiration for me and my family. Thank you for being such an amazing teacher! I have a small request - can you please make a detailed video on NPS Vatsalya and whether it is worth investing in it for one's child? Also how can a parent plan for investments for kids. Are there any instruments, we can explore?
Hi Ankur, thanks for sharing the retirement plan. I personally benefit from your wisdom. Could you create a video of financial planning for someone who is 40 years and is near achieving financial independence with investments and savings already in place and is planning to retire early at 45 years. What is the retirement corpus one needs to ensure living costs are taken care off and there will be wealth pot left to be given as legacy. Would appreciate if a video catering towards income earners in their 40's can be created. Thanks.
Thank you very much sir, for sharing valuable quality content.
Make video on how to choose small cap large cap mutual funds effectively for investments
Sheet is awesome,
I would like to add insurance in this for me and parents as well
Bhai gazab, excel banake kuch bhi sikha rahe sir humare. Hum bhale paise na banaye, ye chacha bohot paise chaap rahe
The information was definitely a big help to ascertain the kind of wealth creation and expenses to expect in future. Thanks a ton.
Just one thing if possible can be added is plan child education cost and investment profile.
Please make an interesting case study of UPS vs NPS. All Govt employees are confused about which to choose. Your insightful video will be surely viral among 2 Crs Govt employees .
Much awaited. Thanks Ankur bhai!!!🙏
Bahut Bahut Bahut helpful 💖💖💖💖💖💞💞💖💖💖💖
superb Nice explain in Excel overall financial portfolio
Great fantastic investment planning, this gives lot of confidence and release stress in life further we can simplify our by applying some basic rules, though life is unpredictable. This investment required a discipline. Thanks Mr. Ankur for sharing your ideas.👍👍👍
Very nice video .. thank you for your efforts
Warikoo sahab, sheet chu Zabar, I like your videos about the financial literarcy
That's a nice explanation @warikoo Ankur Sir, I had put my data in this Excel, but I feel it needs more columns to add. For expenses, there should be some column to add income like pension from my job, and NPS corpus which the company deducts and the company adds their 10% and 14% funds to NPS. Also, short-term goals have to be completed so that expenses need to be addressed in sheet.
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
बहोत अच्छा लगा सर धन्यवाद
Sir, this is good excel sheet, but in this 15 years there are personal expenses that pop up. At age of 28 marriage, @ 30 years one kid will add up, 35 years school fees starts, @ 40 or 45 one may lose job for 4 months, 46 years need for new or bigger house 50 years, kids higher studies expenses, 55 kids marriage. If all the savings are invested we will ger 6 crores, but you never mentioned how all the expenses occur between 25 - 50 will be earned.
Yes this should be considered
Bro who's asking to invest your whole salary?
If you are increasing your investment by 5%. what about your salary will that also increase same %?
Also, will the expenses get increase proportionate to salary increase? Answer is No.
Whatever Ankur has said, he assumed your expenses has increased with salary and you invest only increase by 5%? Which is not the case as you can control your expense.
buddy this sheet is to you to plan your expense and Invest. you how much you are investing depending on that its your corpus. In the excel there is a column for all these expense in Financial Planning sheet
@@amitkumarrai6127 well this doesn't look like investment planning, it looks like a pit to invest in mutual funds. Unless somebody doesn't guide the youngster of the future expenses, they wouldn't know.
I filed the form for money matters last week Sunday. I'm Waiting
You have excelled in excel 🤪
Best Video so far😇
An eye opener for any person.
Amazing information❤
Great content as usual 👍
Thanks for sharing and easy explanation sir.
Not able to download Excel sheet sir
Excellent works, thanks for the Excel
Great video and explanation through excel sheet
Nice effort sir, but your excel sheet needs to be updated because it does not separate yearly spending from total monthly investment. I suppose "=Expenses!B27/12" will be the right calculation for Investment Section (B2 cell)
Thanks Sir i think this need to be updated as mentioned above
Sir u have become excel 🐯
An excellent sheet that provides lot of clarity. Helped me in making some decisions how I want to spend and how I want to live. I can’t thank you enough
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
Sir, actully financial freedom mindset comes after 42-43 yrs..... So plz make video on calculating this age.....
True
By the time you reach 42-43 years it is too late. Lot of uncertainty come into picture like Job security, Health risk, kid education, limited time till retirement due to which less compounding effect.
If you have any money saved till 42-43 then you can plan for retirement. If you want start from scratch then it is too late.
Sir aap jo baat karte hai bahot accha sidha Dil par asar Karti hai 🎉❤❤❤❤❤
Love your calculation...❤
Great efforts, Thanks 🙏
Ankur, thanks for simple explanation of difficult subject (for young generation). Now in your sheet I do not see the section for statutory deductions / investments like PF and NPS / Superannuation. Cause the 25% of the total savings are going in safe instruments which is VPF / PPF etc. which are different that PF & NPS. Also many employees now have option of ESOPS (either Monthly or lumpsum) So that column to be added as well. Yearly Bonus is also there but that can be added to yearly additional income. I don't need the sheet but it's always fun to play with excel and this sheet I am downloading to work out my own version. Thanks Again.
Hello Ankoor Sir, This is a fantastic Excel for all of us struggling with financial planning. I have one suggestion: could you include a section on building an emergency fund, along with a method to calculate the necessary amount based on different salary and age ratios? As a young professional just starting my career, I'm eager to establish an emergency fund, as you've emphasized its importance before beginning to invest. Please let me know. Parth Trivedi.
Thank you for sharing the excel sheet! This is very useful.
Bhai kaha se download kiye
Edit kese kar pa rahe please suggest
@warikoo sir, one piece that would have been helpful if added in this sheet is adding any current investments, their current value and expected rate of return and how it would have impacted the future wealth.
Awesome, Please make a video for those people making daily or weekly income like from intraday trading/business. I never find this kind of video on utube.
He won't because it's not possible for everyone to earn that much in short time. He doesn't support it and hence won't make any video regarding it.
99% of the people will lose money in these so what's the point event?
@@mynk_rjputi am not promoting stock market/ intraday/any investment or business, im just curious to watch any video to manage my finances.
Anyways, thanks for the feedback.
Sir, I love u. I've started the path, may be some daydown the line I wish to see you... .
Chalo aaj phir excel excel khelte h 😊❤
bhai step up 5% every year nikal do fir jo milega vo hakikat hogi....logo ke salary package increment 10% ho gyi to bhi bohot hoga aur inflation 6% se grow karta hai....ek bar tum vo dikha do ke 45 years ke baad sip kitna karna hai when 5% is in picture and not in picture....nearly 50% sal will be consumed in sip if you keep step up of 5%...
Amazing information 👍
Big Fan Sir...! Thank You for sharing all the knowledge and values.
One doubt why are we not adding inflation while calculating Ending Savings when we are Earning?
Thanks a lot. It is very useful
Biggest flaw in all the FIRE calculation is 1. Taxes which can destroy all FIRE planning...all governments are moving towards to bring all incomes under slab rates current 12.5% will eventually will became 35.88% tax rates on withdrawals....2. Even more important is Stock Market return of first five years....your retired...2008 market like crashed happens...market goes 4-5 years sideways after crash...and your FIRE completely destroyed.
Bhai iphone 13 hi leleta hoon. Ek cable leke hi toh ghumna padega kuch saal bas. 4-5 saal khich jayega. Next iteration me iphone 15 lelunga. Type C ka Type C aur no more jhanjhat.
Looks good my friend, I see what you did there I myself settled my problems with Arnold Jackson’s help
Arnold
1899
Telegram
Or
Arnold1899
Telegrams
I hope i had such guidance once i started my professional career.
You are already 44, only 1 year left for your youtube channel, then its retirement!!
This is just amazing Ankur Sir... One sheet for everything... SIP, SWP sab include ho gya
I have been watching your videos recently and I really think now that I have regret that I didn’t found out your videos earlier, but now I have started learning from you and it’s really helpful , but I have a humble request from you , I have seen most of your videos there is great way of investing in some midcaps an all these stuff but can you please show how to invest from which platform or how to purchase them??❤
You can do it from groww
Bro you're clearly a liar, if you have seen most of his videos then how come you didn't see Ankur's one of the recent video where he clearly showed how to create account, find and then invest, do sip etc in mutual funds on his go to platform Zerodha
Bohot dino ke bad aj ❤❤.
Best video you ever made ❤❤ i Loved the video ankur ! 🫡🫡
Sir, my recommedation, you suggests somethig where you don't need to cut your expenses but still you can good income or return in future. Please take note of this.
GOD BLESS YOU ANKUR WARIKOO!! THANK YOU FOR THIS SHEET! ❤❤❤
This is an absolute and great planning worksheet. Thank you so much as this could bring lots of discipline. Just a question? IRR return expectations are post income tax or pre-income tax? As somehow couldn't able to see the accounting for the income tax as expense on a yearly basis in the financial planning worksheet. Pls guide.
Sir plz make vedio of rental and own home.. which 1 is bttr we only trust u.. although there are so many of vedio available on yt bt i want ur perception.
Kuch bolte h rent pr rh lo bt loan na ho jyada bttr h
Kuch ka bolna h at the end of the day EMIs pay krte krte ek din ap ghr k malik ho jate ho to bhtt confusion hoti h