The EXCEL SHEET for a 6 CRORE Retirement Plan! | Ankur Warikoo Hindi

  Рет қаралды 411,070

warikoo

warikoo

Күн бұрын

Пікірлер: 707
@warikoo
@warikoo Ай бұрын
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.
@mrsumitmukherji
@mrsumitmukherji Ай бұрын
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
@GaneshDebbarma-kt2zn
@GaneshDebbarma-kt2zn Ай бұрын
Yeh lwk laisa kaise kamana ow nehi shikhata hain internet pe raaj kar raha hain ow amir joke wariko bodha horahah hain
@GaneshDebbarma-kt2zn
@GaneshDebbarma-kt2zn Ай бұрын
​@@mrsumitmukherjiYeh lwk laisa kaise kamana ow nehi shikhata hain internet pe raaj kar raha hain ow amir joke wariko bodha horahah hain
@mrsumitmukherji
@mrsumitmukherji Ай бұрын
@@GaneshDebbarma-kt2zn bro paisa kamana khud se shikna padhta hai
@BikerDaDInt650
@BikerDaDInt650 Ай бұрын
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
@VickkyTekale
@VickkyTekale 12 күн бұрын
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!
@theredbaron28
@theredbaron28 Ай бұрын
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
@beditz1591
@beditz1591 Ай бұрын
I am not able to edit that sheet
@HHedge30
@HHedge30 Ай бұрын
Don't edit that sheet. Make a copy and edit the copy
@chaitanyaagn4508
@chaitanyaagn4508 Ай бұрын
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.
@Nehaprashantparashar
@Nehaprashantparashar Ай бұрын
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
@parikshitbiswas02
@parikshitbiswas02 Ай бұрын
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.
@syedsohailahmed5332
@syedsohailahmed5332 Ай бұрын
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
@AdarshRaj-t5u Ай бұрын
26k rupees per month? If yes then your education isn't that strong.
@syedsohailahmed5332
@syedsohailahmed5332 Ай бұрын
@@AdarshRaj-t5u I am from mechanical engineering, joined startup as full stack dev with almost 2yr exp , I wfh that's enough for now
@afsaanofficial
@afsaanofficial Ай бұрын
27 now with 50k salary still confused for the future
@rudrachatterjee2614
@rudrachatterjee2614 Ай бұрын
Are your parents depended on your salary?
@afsaanofficial
@afsaanofficial Ай бұрын
@@rudrachatterjee2614 Yea
@Kumar_karan_
@Kumar_karan_ Ай бұрын
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 🙏🏻❤️
@stockstrend9072
@stockstrend9072 13 күн бұрын
Very good keep going i m from union bank of india
@sachinsk1802
@sachinsk1802 6 күн бұрын
Bhai mai toh 32 ka hun aur abhi tk unemployed....
@Rehanxindian
@Rehanxindian 5 күн бұрын
Bro aapka in hand salary kitna hai as a sbi po
@himage6540
@himage6540 Күн бұрын
​@@sachinsk1802 rassi kharidne ke paise hai?
@sachinsk1802
@sachinsk1802 Күн бұрын
@@himage6540 hn bhai
@fnbstrader1026
@fnbstrader1026 20 күн бұрын
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!👏.
@abhaynadgir1256
@abhaynadgir1256 Ай бұрын
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
@ytb.addict
@ytb.addict Ай бұрын
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.
@ytb.addict
@ytb.addict Ай бұрын
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.
@shivam456456
@shivam456456 11 күн бұрын
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.
@arnoldchatterjee4293
@arnoldchatterjee4293 Ай бұрын
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
@mohammadmujtaba2151
@mohammadmujtaba2151 Ай бұрын
you are not a waste! You have room to grow no matter what age you are at!
@bucky3300
@bucky3300 Ай бұрын
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.
@thezealoticshow5741
@thezealoticshow5741 Ай бұрын
You could add these emi in the needs section
@PankajKhandelwal
@PankajKhandelwal Ай бұрын
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.
@bhushanshitole9124
@bhushanshitole9124 Ай бұрын
Correct. However, it can be replaced by any other such expense, so ultimately, it has covered pretty much everything
@Mr.Arpitk
@Mr.Arpitk Ай бұрын
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.
@ghoshpaul
@ghoshpaul 25 күн бұрын
is the excel file read only? can it not be edited?
@swaksharbasu3580
@swaksharbasu3580 17 күн бұрын
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.
@rghoshutube
@rghoshutube Ай бұрын
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.
@navdeep983879
@navdeep983879 Ай бұрын
Yes
@ghoshpaul
@ghoshpaul 25 күн бұрын
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
@ankurforwin
@ankurforwin 10 күн бұрын
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.
@shavalyrics2439
@shavalyrics2439 Ай бұрын
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 👍
@rajupanchal3365
@rajupanchal3365 Ай бұрын
Very good calculations Sir, but one thing is to be added. that is rental income and other income after retierement. Please add if possible.
@statuspalace1011
@statuspalace1011 Ай бұрын
Sir aap jo baat karte hai bahot accha sidha Dil par asar Karti hai 🎉❤❤❤❤❤
@anjujain5122
@anjujain5122 Ай бұрын
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
@ghoshpaul
@ghoshpaul 25 күн бұрын
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
@ashishchougule7094
@ashishchougule7094 4 күн бұрын
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!🙂
@shaileshsahu9551
@shaileshsahu9551 Ай бұрын
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!!!!
@jaydeeppatel8063
@jaydeeppatel8063 Ай бұрын
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. 😊
@24tmotivation45
@24tmotivation45 23 күн бұрын
Make video on how to choose small cap large cap mutual funds effectively for investments
@sohilgupta2009
@sohilgupta2009 21 күн бұрын
Excellent sheet! This sorts most of the crucial decisions in life! Thank you for sharing!
@abhijitpardeshi6559
@abhijitpardeshi6559 Ай бұрын
One of the best financial advice with very simplistic way. ❤
@abhishekverma2764
@abhishekverma2764 Ай бұрын
Sir Sorry 😢 pata nhi kyu ye video thik se samajh me nahi aaya. You are My Mentor & best financial Teacher ❤️❤️❤️❤️
@vaibhavbansal1143
@vaibhavbansal1143 Ай бұрын
@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
@ghoshpaul
@ghoshpaul 25 күн бұрын
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
@queenchaudhary9822
@queenchaudhary9822 Ай бұрын
Aap ek bahut hi accha kam kar rahe ho 🎉🎉❤❤
@ArchanaPatnaik-t4i
@ArchanaPatnaik-t4i Ай бұрын
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?
@pratapmarkande4148
@pratapmarkande4148 Ай бұрын
Sir, actully financial freedom mindset comes after 42-43 yrs..... So plz make video on calculating this age.....
@RamkuvarMarkande-ul8fk
@RamkuvarMarkande-ul8fk Ай бұрын
True
@shettigarrammohan2201
@shettigarrammohan2201 Ай бұрын
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.
@MashudTalukdar-cc4hk
@MashudTalukdar-cc4hk Ай бұрын
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)
@guruspark4245
@guruspark4245 Ай бұрын
Thanks Sir i think this need to be updated as mentioned above
@TalaashEZaykatalaashezayka
@TalaashEZaykatalaashezayka Ай бұрын
Please add a Column for EPF that we will get at retirement...Great Excel, Loved it!!
@madhusudansingh9472
@madhusudansingh9472 Ай бұрын
Finally isle baad koi air video bhi aaegi because as u say this is it. So thank you for your services.
@manishalive
@manishalive Ай бұрын
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.
@shajitha...
@shajitha... Ай бұрын
Please make financial planning of middle class to rich by assuming a person in different levels of life and steps to be taken
@Ssuyashjadhav
@Ssuyashjadhav Ай бұрын
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??❤
@Beautywithsana_
@Beautywithsana_ Ай бұрын
You can do it from groww
@mynk_rjput
@mynk_rjput Ай бұрын
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
@SujeetBane-cc4ii
@SujeetBane-cc4ii Ай бұрын
Outstanding Video Sir. I really get very good idea about FIRE. It is one of my best video watched on KZbin.🙏🙏🙏✍
@smrutiranjanrout1299
@smrutiranjanrout1299 26 күн бұрын
Ankur jee, Kindly provide the access for editable of excel.
@mayurbhosale9981
@mayurbhosale9981 Ай бұрын
Sheet is awesome, I would like to add insurance in this for me and parents as well
@TusharTheJoker
@TusharTheJoker 11 күн бұрын
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?
@vijaykumarPal01
@vijaykumarPal01 Ай бұрын
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.
@hardik6sense833
@hardik6sense833 10 күн бұрын
Hello sir, The sheet you shared is view only. So, Can you please allow the access to edit?
@parthtrivedi8233
@parthtrivedi8233 Ай бұрын
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.
@meganathankns6375
@meganathankns6375 Ай бұрын
I filed the form for money matters last week Sunday. I'm Waiting
@Saswati_me
@Saswati_me Ай бұрын
Watched several times... Understand now...
@Saswati_me
@Saswati_me Ай бұрын
Thanks sir
@sumit10000001
@sumit10000001 Ай бұрын
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.
@adityajain6630
@adityajain6630 Ай бұрын
@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.
@mohdmerajalikhan
@mohdmerajalikhan 16 күн бұрын
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.👍👍👍
@patnibasant
@patnibasant Ай бұрын
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.
@thedo0411
@thedo0411 Ай бұрын
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.
@ghoshpaul
@ghoshpaul 25 күн бұрын
is the excel file read only? can it not be edited? can you pls help me with an editable copy of the excel file?
@manamtamang2468
@manamtamang2468 Ай бұрын
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❤❤❤
@HaseebKhan1597
@HaseebKhan1597 Ай бұрын
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 .
@marmikparekh4991
@marmikparekh4991 Ай бұрын
I hope i had such guidance once i started my professional career.
@samratbhowmick2781
@samratbhowmick2781 Ай бұрын
@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
@007arnov
@007arnov Ай бұрын
Seems like Ankur ji is also responsible for low cars sales 😊People have started savings and investing rather than putting money on depreciating assets.
@savvykind-yt
@savvykind-yt Ай бұрын
Repititive , but it is what it is actually required in life - The Basics👌
@shubhanshusingh742
@shubhanshusingh742 Ай бұрын
@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.
@savvykind-yt
@savvykind-yt Ай бұрын
Thank U Ankur for the Excel Sheet... It is very much helpful.
@IamSrijanSingh
@IamSrijanSingh Ай бұрын
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.....
@vipulsingh14a
@vipulsingh14a Ай бұрын
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
@RMK-m4f
@RMK-m4f Ай бұрын
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
@pankajbhandari647
@pankajbhandari647 Ай бұрын
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.
@mynk_rjput
@mynk_rjput Ай бұрын
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?
@pankajbhandari647
@pankajbhandari647 Ай бұрын
​@@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.
@worldofsprinkles797
@worldofsprinkles797 Ай бұрын
Great initiative sir. Thank you so much for helping me. I will follow.
@pratibhasingh6190
@pratibhasingh6190 Ай бұрын
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.😊
@akshatshiva6516
@akshatshiva6516 Ай бұрын
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
@akshatshiva6516
@akshatshiva6516 Ай бұрын
Arnold 1899
@akshatshiva6516
@akshatshiva6516 Ай бұрын
Telegram
@akshatshiva6516
@akshatshiva6516 Ай бұрын
That’s his user,name and where to find him
@praveen19031991
@praveen19031991 Ай бұрын
Thanks for helping out and keeping your video more interesting ❤️
@abhishekjain4673
@abhishekjain4673 Ай бұрын
Great sheet with a simple approach 😊😊 love it❤
@madhusudhanarao-or4nk
@madhusudhanarao-or4nk Ай бұрын
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...
@chiki1303
@chiki1303 Ай бұрын
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.
@bishaldash1997
@bishaldash1997 Ай бұрын
Yes this should be considered
@mynk_rjput
@mynk_rjput Ай бұрын
Bro who's asking to invest your whole salary?
@shettigarrammohan2201
@shettigarrammohan2201 Ай бұрын
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.
@amitkumarrai6127
@amitkumarrai6127 Ай бұрын
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
@chiki1303
@chiki1303 Ай бұрын
@@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.
@Rajesh_SoftLoc
@Rajesh_SoftLoc Ай бұрын
You are amazing sir... Definitely changing many life's❤
@RishabhYadav-o6w
@RishabhYadav-o6w Ай бұрын
Bhai gazab, excel banake kuch bhi sikha rahe sir humare. Hum bhale paise na banaye, ye chacha bohot paise chaap rahe
@rahchaudhary
@rahchaudhary Ай бұрын
Can you make video on Diversifying money which is already invested in single stock?
@mustufayousuf2954
@mustufayousuf2954 Ай бұрын
Please make the return percentage editable in the Excel sheet so we can adjust it according to our country's return rates.
@susantakumarsahoo186
@susantakumarsahoo186 Ай бұрын
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.
@Modern_home_decors
@Modern_home_decors Ай бұрын
Sir, I love u. I've started the path, may be some daydown the line I wish to see you... .
@NirajTrivedi-j7b
@NirajTrivedi-j7b Ай бұрын
Thank you very much sir, for sharing valuable quality content.
@aakratijaiswal1643
@aakratijaiswal1643 Ай бұрын
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
@naval6k
@naval6k 20 күн бұрын
Sir its awesome sheet. But i like to confirm where we will mention pf deduction ?
@rbChats
@rbChats Ай бұрын
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.
@gaganob
@gaganob Ай бұрын
An uncle from Gurugram is always criticizing your excel sheets
@cadarsh80
@cadarsh80 Ай бұрын
😂
@themboys304
@themboys304 Ай бұрын
Wo real estate wala ? 😂😂😂
@gaganob
@gaganob Ай бұрын
@@themboys304 woh all in one hai, 4 youtube channels hain uske
@GurpreetSingh-it9sy
@GurpreetSingh-it9sy Ай бұрын
😂
@AbhishekSingh-xf1lg
@AbhishekSingh-xf1lg Ай бұрын
how to edit it
@sudhirkoul7984
@sudhirkoul7984 Ай бұрын
Warikoo sahab, sheet chu Zabar, I like your videos about the financial literarcy
@sameerkute1676
@sameerkute1676 Ай бұрын
superb Nice explain in Excel overall financial portfolio
@yuvrajgangurde1478
@yuvrajgangurde1478 Ай бұрын
बहोत अच्छा लगा सर धन्यवाद
@skyfar5428
@skyfar5428 Ай бұрын
Thanks for sharing and easy explanation sir.
@skyfar5428
@skyfar5428 Ай бұрын
Not able to download Excel sheet sir
@mrrickr121
@mrrickr121 Ай бұрын
Bahut Bahut Bahut helpful 💖💖💖💖💖💞💞💖💖💖💖
@GauravSingh-cj9ek
@GauravSingh-cj9ek Ай бұрын
Very nice video .. thank you for your efforts
@sakshijaiswal3918
@sakshijaiswal3918 Ай бұрын
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
@harshitpatil3573
@harshitpatil3573 Ай бұрын
Can you Make a video for Government officials/employees regarding investment
@mainakjana6903
@mainakjana6903 Ай бұрын
A great way to make this sheet is what-if analysis feature in excel
@Mano-z7t
@Mano-z7t 24 күн бұрын
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.
@Sougatamakal
@Sougatamakal Ай бұрын
I am unable to use this sheet somebody help. After open Google chrome I can't edit anything or download this sheet
@arpitvasani
@arpitvasani Ай бұрын
Go to file and click on make a copy then you can edit.
@josesamuel6781
@josesamuel6781 Ай бұрын
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.
@vikash121sk
@vikash121sk Ай бұрын
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
@ToluniKe-u1q
@ToluniKe-u1q Ай бұрын
Thank you for sharing the excel sheet! This is very useful.
@tafseer.khan.9551
@tafseer.khan.9551 Ай бұрын
Bhai kaha se download kiye
@aayushbhalavi5029
@aayushbhalavi5029 Ай бұрын
Edit kese kar pa rahe please suggest
@vkrmahi
@vkrmahi Ай бұрын
This is just amazing Ankur Sir... One sheet for everything... SIP, SWP sab include ho gya
@SauravRoyLKO
@SauravRoyLKO Ай бұрын
Best Video so far😇
@kavishahuja6976
@kavishahuja6976 Ай бұрын
Much awaited. Thanks Ankur bhai!!!🙏
@arnabdutta3884
@arnabdutta3884 Ай бұрын
Excellent works, thanks for the Excel
1, 2, 3, 4, 5, 6, 7, 8, 9 🙈⚽️
00:46
Celine Dept
Рет қаралды 73 МЛН
Wait… Maxim, did you just eat 8 BURGERS?!🍔😳| Free Fire Official
00:13
Garena Free Fire Global
Рет қаралды 9 МЛН
PIZZA or CHICKEN // Left or Right Challenge
00:18
Hungry FAM
Рет қаралды 12 МЛН
小丑揭穿坏人的阴谋 #小丑 #天使 #shorts
00:35
好人小丑
Рет қаралды 44 МЛН
Power of ₹5,000 SIP - ₹5 Crores Net Worth
17:41
Wint Wealth
Рет қаралды 387 М.
How to GROW your PORTFOLIO Fast! (5 key Strategies!) | Akshat Shrivastava
20:07
Is There a Formula for Financial Independence? [Asking The Expert]
16:31
From ₹10/day to ₹5 Crores Net Worth?
16:25
Wint Wealth
Рет қаралды 1,5 МЛН
1, 2, 3, 4, 5, 6, 7, 8, 9 🙈⚽️
00:46
Celine Dept
Рет қаралды 73 МЛН