Scribd
Upload
8 views3 pages

Early Retirement Savings Calculator

The 3-step early retirement calculator determines how much a user needs to save each month to retire at age 60. Step 1 has the user input assumptions like current age, retirement age, expenses, and expected returns. Step 2 calculates that the user will need ₹232,321,921 at retirement. Step 3 recommends a monthly SIP of ₹63,547 over 17 years to accumulate ₹42,444,346 which will grow to the needed ₹232,321,921 over 15 years of compounding.

Uploaded by

Ankur
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as ODS, PDF, TXT or read online on Scribd
8 views3 pages

Early Retirement Savings Calculator

The 3-step early retirement calculator determines how much a user needs to save each month to retire at age 60. Step 1 has the user input assumptions like current age, retirement age, expenses, and expected returns. Step 2 calculates that the user will need ₹232,321,921 at retirement. Step 3 recommends a monthly SIP of ₹63,547 over 17 years to accumulate ₹42,444,346 which will grow to the needed ₹232,321,921 over 15 years of compounding.

Uploaded by

Ankur
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as ODS, PDF, TXT or read online on Scribd

3-STEP EARLY RETIREMENT CALCULATOR

STEP 1- FILL IN YOUR ASSUMPTIONS:


Current Age 28
Age by which you want to finish saving for retirement 45
Retirement Age 60
Life Expectancy Age 90

Current Monthly Expenses ₹100,000

Expected Return pre-retirement 12%


Inflation pre-retirement 6%
STEP 2: THIS IS HOW MUCH YOU WILL NEEED AT RETIREMENT (at age 60)
Inflation adjusted monthly expense ₹645,339
Retirement Corpus needed ₹232,321,921
STEP 3: YOUR ACTION PLAN TO MEET YOUR RETIREMENT GOAL
Monthly SIP traget ₹63,547
No. of years to SIP 17
Principal Accumulated via SIP ₹42,444,346
No. of years Principal will compound 15
Retirement Corpus Reached ₹232,321,921
TIREMENT CALCULATOR
YOUR ASSUMPTIONS:

Exclude expenses you won't incur in retirement like


EMI/rent, child-care etc

WILL NEEED AT RETIREMENT (at age 60)

N TO MEET YOUR RETIREMENT GOAL

<---Accumulation Phase
<---Accumulated Principal
<---Compounding phase
<---VOILA YOU REACHED YOUR RETIREMENT CORPUS GOAL
References

References for formulas used in this Excel:


SIP amount needed for target corpus (formula) Source
Future Compounded Value = PV*(1+R)^N Source

Online Calculators to verify Excel Results:


Inflation-adjusted corpus needed calculator Source
Future Value calculator Source
One-time investment to reach target corpus calculator Source
SIP calculator Source
CAGR Returns % calculator Source

Page 3

You might also like