Can i retire worksheet

However, if you want to save the data for longer, you can register and create an account. That way, it'll all be here when you come back another day, for up to a year. Find out how to register by clicking here. Remember, these worksheets will give you an estimate, not guaranteed numbers. Regard it as a starting point that will provide a big clue in taking the mystery out of your retirement planning.

Start with the General Information Worksheet, where you enter information that will be used in the following worksheets. Enter your current age and the number of expected years until you will retire. We are assuming that you are between 50 and 70 years old and that you will retire by age This worksheet will calculate how many years you will live in retirement, assuming you live to age While life expectancy varies based on individual circumstances, this assumption will help you avoid outliving your income.

It helps you to plan your investments to get the desired retirement corpus at the time of retirement. The retirement planning calculator will serve two primary purposes. It shows you the amount of money you need to maintain your current lifestyle after retirement. The retirement planning calculator has a formula box where you select your present age, the age at which you plan to retire, the life expectancy, and the monthly income you will need in retirement.

The retirement planning calculator will show you the annual income you require at retirement, the additional amount you must acquire for your retirement, and the monthly savings to accumulate the retirement corpus you desire. The retirement planning calculator will estimate the amount you require in retirement.

It will also calculate the corpus, which will generate the income you need in retirement. Suppose you require a monthly income of Rs 35, in retirement. You are presently 35 years old and plan to retire at 60 years of age. We will calculate the retirement corpus to generate an annual income of Rs 18,02, at the start of the retirement period. Life Expectancy of 80 years — Age of Retirement of 60 years.

Use an Excel Calculator to calculate the retirement corpus by using the PV function. You must calculate the monthly savings to accumulate the retirement corpus of Rs 3,00,48, using the PMT function in Excel.

You get Rs 31, which are the monthly savings to accumulate the requisite retirement corpus. The ClearTax Retirement Planning Calculator is a handy tool that shows the annual income you need at retirement, to maintain the current lifestyle in seconds. Products IT. About us Help Center. Log In Sign Up. Monthly Deposit Amount Optional. If your portfolio consists of index funds, then you can look at historical annualized returns to get a sense of what you can expect.

If you have a fixed-income portfolio, then that's even easier because you know exactly what you're expected to receive from those investments. The Flexible Retirement Planner. Financial Architects. Tax Software Inc. The Ultimate Estate Planner, Inc. Actively scan device characteristics for identification.

Use precise geolocation data. Select personalised content. Create a personalised content profile. Measure ad performance. Select basic ads. Create a personalised ads profile. Select personalised ads. Apply market research to generate audience insights. Measure content performance. Develop and improve products. List of Partners vendors. Investing Retirement Planning. Table of Contents Expand. Table of Contents. Ultimate Estate Planner. By Dana Anspach. Dana Anspach is a Certified Financial Planner and an expert on investing and retirement planning.

Learn about our editorial policies. Reviewed by David Kindness.