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!
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
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.
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
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 🙏🏻❤️
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
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.
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
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.
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.
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.
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.
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.
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
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!🙂
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!!!!
@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
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?
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.
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)
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.
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
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?
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.
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.
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.
@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.
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.👍👍👍
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.
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.
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❤❤❤
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 .
@warikoo i would say for a change do excel sheet for 40 yr old and above .. who have started late and how they can go for it using this excel sheet.. focus 2-3 such videos like this one for PPL above 36 or 40 yr old
Seems like Ankur ji is also responsible for low cars sales 😊People have started savings and investing rather than putting money on depreciating assets.
@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.
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
Sir please make video on education loan .2024 for mbbs students . Which expenses are covered . Expenses covered other than tuition fees and college fees . The other expenses like traveling books laptop etc
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.
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.😊
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...
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.
One thing comes to my mind. The expenses which occurs once in a while, for example, buying a bed or AC, but after a while some expenses needed by some family members. How to record those.
Sir, mere pita ji ka January 2025 main retirement hai . Financial burden main Bhai ka education loan h So can you make video on that .. jiss kuch help h because unhone koi planing nhi ki h
I haven’t looked at the formulae clearly, but I think you still have the tax calculated incorrectly in your financial planning sheet. I think you are using this sheet from another video where I pointed the same error.
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
I think instead of step up you can invest in a new MF. Step up will yield less compared to if you invest flat rate. Also you can track the market and invest during dip on mutual funds. It will give you more yield.
Good excel sheet. One Query - After 60, how can be make smallcap and midcap investment as zero? If you withdraw the whole smallcap and midcap investment, don't we need to pay huge tax? Please suggest.
Looking at Indian markets I believe in making money out of small cap Mutual funds ONLY As India market has been growing like anything Worst scenario will be like market be stagnant for quite some time so small caps will also be stagnanat but markets going down is impossible now From nifty 18000+ I have been hearing that now market crash will happen but no-where it is going to happen
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!
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
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
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.
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
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
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
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.
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!
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
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?
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.
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?
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.
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 👍
Very good calculations Sir, but one thing is to be added. that is rental income and other income after retierement. Please add if possible.
Sir aap jo baat karte hai bahot accha sidha Dil par asar Karti hai 🎉❤❤❤❤❤
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?
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!🙂
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. 😊
Make video on how to choose small cap large cap mutual funds effectively for investments
Excellent sheet! This sorts most of the crucial decisions in life! Thank you for sharing!
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 ❤️❤️❤️❤️
@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?
Aap ek bahut hi accha kam kar rahe ho 🎉🎉❤❤
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?
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.
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
Please add a Column for EPF that we will get at retirement...Great Excel, Loved it!!
Finally isle baad koi air video bhi aaegi because as u say this is it. So thank you for your services.
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.
Please make financial planning of middle class to rich by assuming a person in different levels of life and steps to be taken
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
Outstanding Video Sir. I really get very good idea about FIRE. It is one of my best video watched on RUclips.🙏🙏🙏✍
Ankur jee, Kindly provide the access for editable of excel.
Sheet is awesome,
I would like to add insurance in this for me and parents as well
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?
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.
Hello sir, The sheet you shared is view only. So, Can you please allow the access to edit?
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.
I filed the form for money matters last week Sunday. I'm Waiting
Watched several times... Understand now...
Thanks sir
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.
@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.
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.👍👍👍
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.
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?
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❤❤❤
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 .
I hope i had such guidance once i started my professional career.
@warikoo i would say for a change do excel sheet for 40 yr old and above .. who have started late and how they can go for it using this excel sheet.. focus 2-3 such videos like this one for PPL above 36 or 40 yr old
Seems like Ankur ji is also responsible for low cars sales 😊People have started savings and investing rather than putting money on depreciating assets.
Repititive , but it is what it is actually required in life - The Basics👌
@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.
Thank U Ankur for the Excel Sheet... It is very much helpful.
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
Sir please make video on education loan .2024 for mbbs students . Which expenses are covered . Expenses covered other than tuition fees and college fees . The other expenses like traveling books laptop etc
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.
Great initiative sir. Thank you so much for helping me. I will follow.
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.😊
Nice share,having a peaceful retirement after I had a really rough start all thanks to Allah and big gratitude to arnold Jackson for his help
Arnold
1899
Telegram
That’s his user,name and where to find him
Thanks for helping out and keeping your video more interesting ❤️
Great sheet with a simple approach 😊😊 love it❤
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...
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.
You are amazing sir... Definitely changing many life's❤
Bhai gazab, excel banake kuch bhi sikha rahe sir humare. Hum bhale paise na banaye, ye chacha bohot paise chaap rahe
Can you make video on Diversifying money which is already invested in single stock?
Please make the return percentage editable in the Excel sheet so we can adjust it according to our country's return rates.
One thing comes to my mind. The expenses which occurs once in a while, for example, buying a bed or AC, but after a while some expenses needed by some family members. How to record those.
Sir, I love u. I've started the path, may be some daydown the line I wish to see you... .
Thank you very much sir, for sharing valuable quality content.
Sir, mere pita ji ka January 2025 main retirement hai .
Financial burden main Bhai ka education loan h
So can you make video on that .. jiss kuch help h because unhone koi planing nhi ki h
Sir its awesome sheet. But i like to confirm where we will mention pf deduction ?
I haven’t looked at the formulae clearly, but I think you still have the tax calculated incorrectly in your financial planning sheet. I think you are using this sheet from another video where I pointed the same error.
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
Warikoo sahab, sheet chu Zabar, I like your videos about the financial literarcy
superb Nice explain in Excel overall financial portfolio
बहोत अच्छा लगा सर धन्यवाद
Thanks for sharing and easy explanation sir.
Not able to download Excel sheet sir
Bahut Bahut Bahut helpful 💖💖💖💖💖💞💞💖💖💖💖
Very nice video .. thank you for your efforts
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
Can you Make a video for Government officials/employees regarding investment
A great way to make this sheet is what-if analysis feature in excel
I think instead of step up you can invest in a new MF. Step up will yield less compared to if you invest flat rate. Also you can track the market and invest during dip on mutual funds. It will give you more yield.
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.
Good excel sheet. One Query - After 60, how can be make smallcap and midcap investment as zero? If you withdraw the whole smallcap and midcap investment, don't we need to pay huge tax? Please suggest.
Looking at Indian markets I believe in making money out of small cap Mutual funds ONLY
As India market has been growing like anything
Worst scenario will be like market be stagnant for quite some time so small caps will also be
stagnanat but markets going down is impossible now
From nifty 18000+ I have been hearing that now market crash will happen but no-where it is going to happen
Thank you for sharing the excel sheet! This is very useful.
Bhai kaha se download kiye
Edit kese kar pa rahe please suggest
This is just amazing Ankur Sir... One sheet for everything... SIP, SWP sab include ho gya
Best Video so far😇
Much awaited. Thanks Ankur bhai!!!🙏
Excellent works, thanks for the Excel