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.
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
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.
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
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!👏.
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
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
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.
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 🙏🏻❤️
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.
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
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.
it is really nice Ankur ji, you are so genuine and humble person I remember i met you in Vipul tower Nearby Office i was working in NCR corporation, I saw you coming from outside on stairs with pair of sleepers and dairy in hand (somewhere around 2018-19). i would like to suggest few things here, 1. loan we should add number of years remaining etc, 2. after 18 years kids need to go to higher studies (big expense) 3. kids marriage at approx. age of 27-28 year(which is also big expense). 4. Any medical issue 5. Any once in life time expense stuff. Also in saving side (like sukanya, NPS, LIC money back etc) because that will also add to final amount. and if possible we can also add Current amount in hand or possibly already invested amount in mutual funds etc.
Everything is clear...just one thing need to understand Ankur sir..how increase yearly investments in same funds which are running from last 5 yrs ..can u make one short video on this topic.. Bocz i checked and found only new fund can be taken which will start from zero....pls put light on this topic.thanks
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!!!!
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.
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!🙂
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.
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.
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.
Your explaining skills are always best I am already 29 And wants to plan myself with this pattern But i am having issue making changes in sheet I requested you to allow me to make changes in sheet
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.
@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
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.
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?
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.👍👍👍
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❤❤❤
Sir, do a video like say a person starting financial planning at the age of 40 and how he or she can retire at the age of 50? I know time plays a vital role in financial but still what to know about this sincerio how it works. Thank you.
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)
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.
Hello Sir, Thank you for sharing the sheet with us. I tried it and was happy to see the corpus at the end of it. Although, I was wondering if we can add a section that features the part wherein our income increases with some % as well and if we can also add an index that tells us what the abbreviation stands for. Additionally, including a section with emergency fund, medical/term insurance, retirement fund(current amount), current amount in PF, PFF with their possible rate of growth and any additional assets owned etc. I see there is a section that does reflect the value but doesn't account for the current savings that are already present. Again, very much appreciated for the labor you had to put into it.😊
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?
Ankur ji, i see the earnings you consider is more reasonable considering the majority population of the country. However one basic assumption is error prone: that a person works till 60 and steps ups his investments… in real world since mostly are working in private and unorganised sector, working till 60 is a rarity and often people are forced to change career path mid career in late 30s or 40s when they take a big salary cut, up skilling costs are also involved. That’s why i feel the step up plan is not feasible for most. The kind of youth joining the workforce every year or waiting is huge and that puts people in their mid or late career on their toes. It’s easy to ask to sharpen the axe, but not so easy for all. Your formula definitely works on the happy path scenario.
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.
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.
@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.
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.
Many thanks Ankur. There seems some issue under Tab "Financial Panning", Row 24 " planned expenses". The formula under this field is G25 either " earning" or "dead". May be "dead" shld be replaced with "retired". Dead would not use the work sheet anyways :-). Please correct me if I am reading this erroneously. I started using the sheet (I am a retired person) and see that the sheet is throwing error due to this...
@warikoo Q. Nowadays we have multiple categories in MF's for example - Large Cap, Mid Cap, Small Cap, Flexi Cap, Large Cap + Mid Cap etc how to manage the investment matrix as per those mutual funds w.r.t the age range? Thank you.
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!
can you help me as the excel sheet using this links it isnt work it say you need permission for account holder
@@yasarali-o8t I don't have problem with it. I am using brave on my laptop
@@yasarali-o8t file > make a copy
make a copy on your drive and change it as per your data
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.
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
Share one copy of that sheet
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.
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..
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
You are simply awesome....made perfect easy way for financial planning
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!👏.
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
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!
Hi Sir, thank you so much for explaining it so well. We can learn from this also your financial videos are very good keep doing it.
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 👍
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?
@@navdeep983879 same issue
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
Money matters series is such a great concept!
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?
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.
Excellent sheet! This sorts most of the crucial decisions in life! Thank you for sharing!
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
@@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
@@rudrachatterjee2614 not much my mom works too
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
it is really nice Ankur ji, you are so genuine and humble person I remember i met you in Vipul tower Nearby Office i was working in NCR corporation, I saw you coming from outside on stairs with pair of sleepers and dairy in hand (somewhere around 2018-19). i would like to suggest few things here, 1. loan we should add number of years remaining etc, 2. after 18 years kids need to go to higher studies (big expense) 3. kids marriage at approx. age of 27-28 year(which is also big expense). 4. Any medical issue 5. Any once in life time expense stuff. Also in saving side (like sukanya, NPS, LIC money back etc) because that will also add to final amount. and if possible we can also add Current amount in hand or possibly already invested amount in mutual funds etc.
Everything is clear...just one thing need to understand Ankur sir..how increase yearly investments in same funds which are running from last 5 yrs ..can u make one short video on this topic..
Bocz i checked and found only new fund can be taken which will start from zero....pls put light on this topic.thanks
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!!!!
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. 😊
Very good calculations Sir, but one thing is to be added. that is rental income and other income after retierement. Please add if possible.
One of the best financial advice with very simplistic way. ❤
Outstanding Video Sir. I really get very good idea about FIRE. It is one of my best video watched on RUclips.🙏🙏🙏✍
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.
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!🙂
Great sheet with a simple approach 😊😊 love it❤
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.
Thanks for helping out and keeping your video more interesting ❤️
Aap ek bahut hi accha kam kar rahe ho 🎉🎉❤❤
Bahut Bahut Bahut helpful 💖💖💖💖💖💞💞💖💖💖💖
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 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
Your explaining skills are always best
I am already 29
And wants to plan myself with this pattern
But i am having issue making changes in sheet
I requested you to allow me to make changes in sheet
Ankur jee, Kindly provide the access for editable of excel.
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?
Finally isle baad koi air video bhi aaegi because as u say this is it. So thank you for your services.
@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?
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.
Thank U Ankur for the Excel Sheet... It is very much helpful.
Great initiative sir. Thank you so much for helping me. I will follow.
Make video on how to choose small cap large cap mutual funds effectively for investments
Hi Sir, thank you so much for explaining it so well. This file is view only, kindly do share the editable version.
Please add a Column for EPF that we will get at retirement...Great Excel, Loved it!!
Very nice video .. thank you for your efforts
Sheet is awesome,
I would like to add insurance in this for me and parents as well
Thank you very much sir, for sharing valuable quality content.
An eye opener for any person.
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?
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.👍👍👍
You are amazing sir... Definitely changing many life's❤
GOD BLESS YOU ANKUR WARIKOO!! THANK YOU FOR THIS SHEET! ❤❤❤
superb Nice explain in Excel overall financial portfolio
Thanks for sharing and easy explanation sir.
Not able to download Excel sheet sir
Great content as usual 👍
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❤❤❤
Sir, do a video like say a person starting financial planning at the age of 40 and how he or she can retire at the age of 50? I know time plays a vital role in financial but still what to know about this sincerio how it works. Thank you.
Watched several times... Understand now...
Thanks sir
Hello sir, The sheet you shared is view only. So, Can you please allow the access to edit?
Bhai gazab, excel banake kuch bhi sikha rahe sir humare. Hum bhale paise na banaye, ye chacha bohot paise chaap rahe
Repititive , but it is what it is actually required in life - The Basics👌
Sir Sorry 😢
pata nhi kyu ye video thik se samajh me nahi aaya.
You are My Mentor & best financial Teacher ❤️❤️❤️❤️
Sir its awesome sheet. But i like to confirm where we will mention pf deduction ?
I hope i had such guidance once i started my professional career.
I am unable to use this sheet somebody help. After open Google chrome I can't edit anything or download this sheet
Go to file and click on make a copy then you can edit.
Amazing information 👍
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
Best Video so far😇
I filed the form for money matters last week Sunday. I'm Waiting
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.
Add a parallel investement in form of NPS for govt employees. As they are also being invested in market
Hello Sir, Thank you for sharing the sheet with us. I tried it and was happy to see the corpus at the end of it. Although, I was wondering if we can add a section that features the part wherein our income increases with some % as well and if we can also add an index that tells us what the abbreviation stands for.
Additionally, including a section with emergency fund, medical/term insurance, retirement fund(current amount), current amount in PF, PFF with their possible rate of growth and any additional assets owned etc.
I see there is a section that does reflect the value but doesn't account for the current savings that are already present.
Again, very much appreciated for the labor you had to put into it.😊
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?
Great video and explanation through excel sheet
Bahut khub sir thanks 🙏
Great efforts, Thanks 🙏
Ankur ji, i see the earnings you consider is more reasonable considering the majority population of the country. However one basic assumption is error prone: that a person works till 60 and steps ups his investments… in real world since mostly are working in private and unorganised sector, working till 60 is a rarity and often people are forced to change career path mid career in late 30s or 40s when they take a big salary cut, up skilling costs are also involved. That’s why i feel the step up plan is not feasible for most. The kind of youth joining the workforce every year or waiting is huge and that puts people in their mid or late career on their toes. It’s easy to ask to sharpen the axe, but not so easy for all. Your formula definitely works on the happy path scenario.
बहोत अच्छा लगा सर धन्यवाद
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.
Amazing information❤
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.
Sir u have become excel 🐯
Sir what if you use more in home loan than rent and at retirement your expense get reduced and can you help at what age for starting home loan
Much awaited. Thanks Ankur bhai!!!🙏
@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.
Sir, I love u. I've started the path, may be some daydown the line I wish to see you... .
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.
Love your calculation...❤
JUST SUPERB🎉🎉
Many thanks Ankur. There seems some issue under Tab "Financial Panning", Row 24 " planned expenses". The formula under this field is G25 either " earning" or "dead". May be "dead" shld be replaced with "retired".
Dead would not use the work sheet anyways :-). Please correct me if I am reading this erroneously.
I started using the sheet (I am a retired person) and see that the sheet is throwing error due to this...
Thanks a lot. It is very useful
Warikoo sahab, sheet chu Zabar, I like your videos about the financial literarcy
@warikoo
Q. Nowadays we have multiple categories in MF's for example - Large Cap, Mid Cap, Small Cap, Flexi Cap, Large Cap + Mid Cap etc how to manage the investment matrix as per those mutual funds w.r.t the age range?
Thank you.
Hi Ankur, thanks for the sheet!!
Can you add current investments to the sheet
What about emergency funds, u can't invest all your savings
Nice video. thank you