Retirement Planner Spreadsheet

Retirement Planner Spreadsheet – Do you know what you like to create a safe retirement? Use this calculator to create your retirement plan. Watch the balance of your retirement savings and distributions during each year until the end of your retirement. Social security is calculated according to the variable variables according to their level of income. By including a non-working spouse in your plan, social security benefits increase without exceeding the maximum

Retirement Plan Definitions

Current age
Your current age
Retirement age

Age at which you want to retire. This calculator assumes that you will not make any contribution to your retirement savings in the year in which you retire. Therefore, if you retire at the age of 65, your last contribution happens in the year you turn 64. This calculator also assumes that you make your full contribution at the end of each year.

Family income
Your total household income. If you are married you must include your spouse’s income.

Current pension savings
The total amount you have currently saved for your retirement. Includes all sources of retirement savings such as 401 (k), IRA, and Annuities.

Yield Before Retirement
The percentage of return that you anticipate earning on your investments before retiring. The actual percent yield will depend largely on the type of investment you choose. From January 1970 to December 2015 the weighted average yield per share for the S & P 500 index, including reinvestment of dividends, was approximately 10.5% per year. During these years the highest yield for a 12-month period was 61% while the lowest was -43%. Savings accounts in banks pay interest as low as 1% or less.
It is important to remember that the percent of future performance can not be predicted with certainty and that investments that pay a higher percent yield are subject to greater risk and volatility. The actual percent yield can vary widely throughout your life, especially in long-term investments, including a potential loss of principal on your investment.

Yield after retirement
The annual percentage you expect to receive on your investment after you retire. The actual percent yield will depend largely on the type of investment you choose. From January 1970 to December 2015 the weighted average yield per share for the S & P 500 index, including reinvestment of dividends, was approximately 10.5% per year. During these years the highest yield for a 12-month period was 61% while the lowest was -43%. Savings accounts in banks pay interest as low as 1% or less.
It is important to remember that the percent of future performance can not be predicted with certainty and that investments that pay a higher percent yield are subject to greater risk and volatility. The actual percent yield can vary widely throughout your life, especially in long-term investments, including a potential loss of principal on your investment.

Percentage of income to save
The percentage of your annual income you will save to meet your retirement goals.

Expected wage increase
Annual percentage increase expected in family income.

Years of pension
Number of years before retiring.

Company pension
Number of years during which you anticipate receiving your pension.

Percentage of income when retiring
The percentage of your family income generated during your working years that you feel necessary during retirement. This amount is based on your income earned during the last year that you will work. The pre-registered amount is 70%. You can change this amount to be as low as 50% and as high as 150%.

Are you married?
Select this option if you are married. Married couples have a higher Social Security maximum benefit compared to single people.

Do you want to include Social Security?
Select here if you would like to include social security benefits in your retirement planning. Social Security is based on a sliding scale based on your income, how long you work, and at what age you retire. Social Security benefits automatically increase every year based on increases in the Consumer Price Index. Including a spouse increases your Social Security benefits by 1.5 times the calculation of your individual benefit. Note that this calculator assumes that only one of the spouses works. The benefits could be different if your spouse has worked and earned a benefit that is more than half of their benefit. In the case of a marriage in which both spouses work, you may have to do the calculation twice – one for each spouse with their respective income. This calculator only provides a rough estimate of your benefits.

The FICA (Federal Social Security Contribution Act) income limit of $ 127,200 with a maximum annual Social Security benefit of $ 32,244 ($ 2,687 per month) for a single person is used in the calculations, and that amount multiplied by 1.5 for one marriage. To receive the maximum benefit, you would have to have earned the FICA maximum salary for most of your career. You would also have to start receiving benefits at your full retirement age of 66 or 67 (depending on your date of birth). This calculator rounds off your full retirement age to receive Social Security benefits the next full year. If your date of birth is between 1955 and 1959, Social Security believes that your full retirement age is 66 plus two months for each year after 1954. Your actual benefit may be lower or higher depending on your work history and Complete rules of compensation used by Social Security.

Rate of inflation
What Inflation Rate Do you expect on average for the long term?

Your spouse’s pension
This is the monthly pension benefit you expect to receive when you retire. This amount is not adjusted for inflation.

Your spouse’s pension
This is the monthly pension benefit your spouse expects to receive when you retire. This amount is not adjusted for inflation.

Retirement Planner Spreadsheet

Tags: