Sponsored for you by: David E. Gardner, CPA
Who We Are
Services
Community
Financial
Focus
Tax Updates
Helpful Articles
Contact Us
Home
Retirement
Projected Retirement Income and Investment Needs
Name
Date:
I. Estimated Household Expenditures in Retirement:
A. Approximate number of years to retirement
B. Current level of annual household expenditures, excluding savings
C. Estimated household expenses in retirement as a percent of current expenses
D. Estimated annual household expenditures in retirement.
$ -
B. x C.
II Estimated Income in Retirement:
E. Social security, annual income
F. Company/employer pension plans, annual amounts
G. Other sources, annual amounts
H. Total annual income
$ -
sum E.F.G.
I. Additional required income, or annual shortfall
$ -
D. minus H.
III Inflation Factor:
J. Expected average annual rate of inflation over the period of retirement
%
K. Inflation factor: Based on X years to annual rate of inflation of X%
factor
L. Size of inflation-adjusted annual shortfall
I. x K.
IV. Funding the Shortfall:
M. Anticipated return on assets held after retirement
X%
N. Amount of retirement funds required
L./M.
O. Expected rate of return on investments prior to retirment
X%
P. Compound interest factor based on X years to retirement
and an expected rate of return on investments of X%
factor
Q. Annual savings required to fund retirement nest egg
N./P.
If you would like this spreadsheet in Excel format to use on your personal computer,
E-Mail us.
David E. Gardner, CPA
Call 406-436-2583 or
E-Mail Us