|
07-26-2021, 11:14 AM
|
#1
|
Dryer sheet wannabe
Join Date: May 2015
Posts: 20
|
TSP Estimation
I am trying to create a spreadsheet to examine my thrift savings plan trajectory for retirement (12/31/2044) planning. I can estimate my salary growth and contributions as a percentage of my income. How would I accommodate contributions plus yearly growth to update an estimated account balance from year to year?
|
|
|
|
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!
Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!
You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!
|
07-26-2021, 11:24 AM
|
#2
|
Full time employment: Posting here.
Join Date: Nov 2015
Posts: 685
|
You can't predict with any sort of accuracy 23 years out.
|
|
|
07-26-2021, 11:38 AM
|
#3
|
Dryer sheet wannabe
Join Date: May 2015
Posts: 20
|
Quote:
Originally Posted by teej1985
You can't predict with any sort of accuracy 23 years out.
|
I know that but I was just trying to extreme ballparks. Things were a little slow and I was just screwing around. Not looking to make investment decisions. Just trying the figure out even for two years from now how to incorporate contributions in with expected portfolio growth.
|
|
|
07-26-2021, 12:10 PM
|
#4
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,204
|
Assuming that the contributions are made throughout the year, the ending balance for each year would be beginning balance + contributions + [(beginning balance + contributions/2)* rate].
Rate is the rate of return and you could select that based on historical rates of return for your asset mix and then look at higher and lower rates of return.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|
|
|
07-26-2021, 12:35 PM
|
#5
|
Recycles dryer sheets
Join Date: Apr 2012
Posts: 216
|
Rather than using a spreadsheet, you could model your TSP using Firecalc. That would show you the possible range of ending balances in 2044.
|
|
|
07-26-2021, 01:27 PM
|
#6
|
Recycles dryer sheets
Join Date: Sep 2006
Location: clearwater
Posts: 439
|
Quote:
Originally Posted by behindthedimes
I am trying to create a spreadsheet to examine my thrift savings plan trajectory for retirement (12/31/2044) planning. I can estimate my salary growth and contributions as a percentage of my income. How would I accommodate contributions plus yearly growth to update an estimated account balance from year to year?
|
https://www.calculator.net/401k-calculator.html
there are any number of calculators that you can use to estimate with
|
|
|
07-26-2021, 02:18 PM
|
#7
|
Full time employment: Posting here.
Join Date: Nov 2017
Location: solomons
Posts: 848
|
dont worry about it!!!! Just let it grow at your AA, max out and when you hit 50, max out catch up !!! Its amazing where i'm at now after 23 years....
|
|
|
07-26-2021, 03:28 PM
|
#8
|
Thinks s/he gets paid by the post
Join Date: Jul 2007
Posts: 3,221
|
Are you maxing out your TSP contributions? If you are and plan to continue in the future then you don't need to factor in salary growth or percentage of income since the contribution limits have nothing to do with salary. Just start with current TSP balance on your spreadsheet, add in the current contribution limit, guesstimate how much the contribution limits might increase each year, maybe 2-3%, and use a reasonable rate of return (7%?). Excel has a FV (future value) function that would work for calculating the yearly balance based on the numbers above. The nice thing about spreadsheets is it's easy to make changes (rate of return) and see the impact.
|
|
|
07-26-2021, 04:51 PM
|
#9
|
Full time employment: Posting here.
Join Date: Aug 2019
Posts: 691
|
Quote:
Originally Posted by zinger1457
Are you maxing out your TSP contributions? If you are and plan to continue in the future then you don't need to factor in salary growth or percentage of income since the contribution limits have nothing to do with salary. Just start with current TSP balance on your spreadsheet, add in the current contribution limit, guesstimate how much the contribution limits might increase each year, maybe 2-3%, and use a reasonable rate of return (7%?). Excel has a FV (future value) function that would work for calculating the yearly balance based on the numbers above. The nice thing about spreadsheets is it's easy to make changes (rate of return) and see the impact.
|
This. Work to max out the contributions. Pick your funds/asset allocation. Don't check your balance too often. When the market correction comes, rebalance.
In 20 years, you'll have millions.
__________________
--At what age does spending less now in order to have more later stop making sense?
|
|
|
07-26-2021, 07:40 PM
|
#10
|
Moderator Emeritus
Join Date: Jan 2007
Location: New Orleans
Posts: 47,468
|
Like others here I maxed out my TSP contributions every single year. I always recommend that to those who can do the same.
In retirement I chose to put it all in "G Fund", which is guaranteed not to decrease in share value so it's sort of like cash. I regard access to the G Fund as part of my retirement benefits and I get equal monthly payments from it.
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.
Happily retired since 2009, at age 61. Best years of my life by far!
|
|
|
07-27-2021, 04:10 AM
|
#11
|
Recycles dryer sheets
Join Date: Jul 2015
Posts: 395
|
For pay raises, you can look up the historical values. I calculate the average since 1975 to be 3.3% and over the last 10 years to be 1.3%. You will also need to take promotions into account.
As far as TSP is concerned, it is recommended to use specific $$ values and not a percentage of salary. To each their own.
Year Salary Raise
1975 5.0
1976 4.8
1977 7.0
1978 5.5
1979 7.0
1980 9.1
1981 4.8
1982 4.0
1983 0.0
1984 4.0
1985 3.5
1986 0.0
1987 3.0
1988 2.0
1989 4.1
1990 3.6
1991 4.1
1992 4.2
1993 3.7
1994 4.0
1995 2.6
1996 2.4
1997 3.0
1998 2.9
1999 3.6
2000 4.8
2001 3.7
2002 4.6
2003 4.1
2004 4.1
2005 3.5
2006 3.1
2007 2.2
2008 3.5
2009 3.9
2010 2.0
2011 0.0
2012 0.0
2013 0.0
2014 1.0
2015 1.0
2016 1.6
2017 2.1
2018 1.9
2019 1.9
2020 3.1
3.3
10yr 1.3
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|