The EXCEL SHEET for a 6 CRORE Retirement Plan! | Ankur Warikoo Hindi
Published: 2024-09-18
Status:
Available
|
Analyzed
Published: 2024-09-18
Status:
Available
|
Analyzed
Predictions from this Video
Incorrect: 0
Prediction
Topic
Status
The government may increase capital gains tax to 30% in the long term.
"but there is a strong possibility that the government wants to make it at 30"
Pending
Income tax is assumed to be 30% for long-term financial planning.
"income tax at 30, all these green boxes are assumed to be 30"
Pending
The assumed rate of return for safe assets is 7% over the long term.
"I have assumed it to be around 7%."
Pending
The assumed rate of return for large cap mutual funds is 12% over the long term.
"Let's assume that it will return 12%."
Pending
The assumed rate of return for mid cap mutual funds is 15% on average over the long term.
"on an average, I've assumed that at 12%, we'll get 15% from large caps"
Pending
The assumed rate of return for small cap mutual funds is 18% on average over the long term.
"15% from large caps, 18% from mid caps"
Pending
The average long-term return from stock market investments for individuals aged 20-30 is projected to be 14.7%.
"on an average, this will give you a return of 14.7 over a long period of time."
Pending
The blended average rate of return, considering various investment splits, is projected to be 12.7%.
"your average rate of return will be 12.7"
Pending
It is assumed that monthly investments will increase by 5% annually.
"by how much can you increase it every year, let's assume it to be 5"
Pending
The projected retirement corpus at age 45 is 85 lakh rupees.
"By the time you reach the age of 45, you will have Rs 85 lakh."
Pending
The projected retirement corpus at age 45, after accounting for mid-life expenses, is 14 lakh rupees.
"you will be left with only Rs. 14 lakh."
Pending
The projected retirement corpus at age 60, under a specific savings scenario, is 85 lakh rupees.
"you will have Rs 85 lakh"
Pending
The projected retirement corpus at age 60, under a different savings scenario, is 6 crore 25 lakh rupees.
"you will have Rs 6 crore 25 lakh."
Pending
The projected retirement corpus at age 60, under a specific income and expense scenario, is approximately 5 crore 25 lakh rupees.
"at the age of 60 you will have approximately 5 crore 25 lakh rupees"
Pending
It is recommended not to plan for retirement until age 60 for individuals starting in their 20s or 25s.
"if you are just starting out in your 20s or 25s or within 90s, then please do not plan for retirement till 45. Go all the way up to 60"
Pending
In one financial planning scenario, the money is projected to be exhausted by age 50.
"you would have exhausted your money by the age of 50"
Pending
In another financial planning scenario, the money is projected to be exhausted by age 63.
"at the age of 63 our money gets exhausted."
Pending
With a specific expense reduction, money is projected to be exhausted by age 69.
"then by 69 your money will be gone."
Pending
In a scenario with a lower savings rate, money is projected to run out between the ages of 71 and 80.
"you will run out of money around 71, 79 or 80 years."
Pending
In a particular scenario, money is projected to be exhausted by age 80.
"at the age of 80, your money will be over."
Pending
With a specific expense increase, money is projected to be exhausted by age 75.
"at 75 it gets exhausted"
Pending
In a scenario where monthly withdrawals are increased, money is projected to be exhausted by age 80.
"at 80 you spend your money, it gets exhausted"
Pending
In a specific scenario with reduced expenses, money is projected to last at least until age 85.
"you will Not run out of money at least till 85 years."
Pending
With a specific savings and retirement age, money is projected to last until age 79.
"you will have money till 79"
Pending
By withdrawing a specific amount monthly and retiring at 60, funds are projected to last until age 85.
"you will be able to withdraw Rs. 0,000 every month from today's date. You will retire at the age of 60 and for the next 25 years till 85, you can withdraw that money from your savings only."
Pending
By withdrawing a certain amount monthly, funds are projected to remain in excess until at least age 85.
"you can withdraw 700 rupees per month and you can still be in the green, that is, in access."
Pending
At age 45, due to inflation, the annual post-tax income requirement is projected to be 19 lakh rupees.
"the same 6 lakh rupees will become 19 lakh rupees which means you will need ₹ lakh every year"
Pending
The estimated annual cost of living in retirement is around 4 lakh rupees in one scenario.
"Now, it will cost you around Rs 4 lakh per year."
Pending
The annual withdrawal amount from the retirement corpus starts at 6 lakh rupees and is expected to increase due to inflation.
"This Rs 6 lakh per year will keep increasing"
Pending
In a scenario with high expenses, the annual withdrawal from the retirement corpus is projected to be 28 lakh rupees.
"you are withdrawing 28 lakh rupees every year"
Pending
A monthly withdrawal of 50,000 rupees from savings is projected to be sustainable during retirement in one scenario.
"you can withdraw Rs. 0,000 every month from today's date."
Pending
A monthly withdrawal of 700 rupees from savings is projected to be sustainable and leave a surplus during retirement.
"you can withdraw 700 rupees per month"
Pending
A need for 5 lakh rupees is anticipated at the age of 35 for unspecified mid-life expenses.
"at the age of 35, I will need Rs. 5 lakh for what ever."
Pending
For individuals aged 20-30, 30% of stock market investments should be allocated to mid-cap mutual funds.
"at 20 to 30 years old, you'll be in large caps at 40%, mid caps at 30%, and small caps at 30%."
Pending
For individuals aged 20-30, 30% of stock market investments should be allocated to small-cap mutual funds.
"at 20 to 30 years old, you'll be in large caps at 40%, mid caps at 30%, and small caps at 30%."
Pending
For individuals aged 30-40, 40% of stock market investments should be allocated to large-cap mutual funds.
"at 40 you will invest in large caps"
Pending
For individuals aged 30-40, 30% of stock market investments should be allocated to mid-cap mutual funds.
"at 30 mid caps"
Pending
For individuals aged 30-40, 30% of stock market investments should be allocated to small-cap mutual funds.
"at 30 small caps"
Pending
For individuals above 40 years of age, 60% of stock market investments should be allocated to large-cap mutual funds.
"if you are above 40 years of age, then at 60 you will invest your stock market in large caps"
Pending
For individuals above 40 years of age, 30% of stock market investments should be allocated to mid-cap mutual funds.
"at 36 you will invest in mid caps only at 30"
Pending
For individuals above 40 years of age, 10% of stock market investments should be allocated to small-cap mutual funds.
"and in small caps only at 10"
Pending
After retirement, investments should be allocated 50% to fixed return assets and 50% to large-cap mutual funds.
"now we will invest 50% in fixed return, earn 7% and the remaining 50% we will invest in large cap mutual funds."
Pending
At age 25, 25% of savings should be invested in safe assets and 75% in the stock market.
"So since you are 25 right now, we will invest in safe assets at 25 and in the stock market at 75."
Pending
At age 40, 40% of savings should be invested in safe assets and 60% in the stock market.
"If you were 40 years old, you would invest in safe assets at 40 and the remaining in the stock market at 60."
Pending
For individuals 40 years and older, 40% of savings should be invested in safe assets and 60% in the stock market.
"If you were 40 years old, you would invest in safe assets at 40 and the remaining in the stock market at 60."
Pending
The assumed inflation rate for financial planning is 6% per year.
"so we will have to increase this 50000 by 6% every year"
Pending
Capital gains tax is assumed to be 20% for long-term financial planning, with a note on potential increase to 30%.
"it is assumed to be at 20, but there is a strong possibility that the government wants to make it at 30, let us assume 20"
Pending
Income tax is assumed to be 30% for long-term financial planning.
"income tax at 30, all these green boxes are assumed to be 30"
Pending