Scout333's TSP Contribution Spreadsheet

Sort by newest Sort by date
Scout, I gave you rep before because of your spreadsheet. But just had to push those rep scales again because of the upgrades. Thanks!

Maggie
 
Scout333 said:
Hello Happy, The SAFE column was just something I put in for a friend of mine. He was using a book by Robert Lichello "How to make a $ 1,000,000 in the stock market" I believe was the title, to rebalance his accounts. Basically if your stock funds increased by 10% or more move some to money market or bond funds (SAFE funds) if they decrease by 10% or more move some from the money market or bond funds back into stocks. Not sure how that works out in this extreme bear market climate. The SAFE column just adds up the C,S, & I funds and multipies by 10%. Hope that answers your question. Good luck! You're in the right place to learn. Lots of smart folks here! :)
Click to expand...

Scout,

I am new to this forum but have been studying Lichello's formula for quite some time. Are you familiar with his work? How is your friend that requested the SAFE column faring with following his methods?

As an aside, since the L funds rebalance every day to maintain their percentages, it is the equivalent of Lichello's system without the SAFE component. I have been testing that by tracking my L2050 performance daily. Please note:

Share Price Shares Value
02/09/11
10.28 963.6 9901.45
02/11/11
10.23 963.6 9862.13
02/14/11
10.28 963.6 9905.30

As you can see, the share price on the 9th and 14th are the same. The number of shares are the same, but because they rebalanced on the way down, when it came back up, the value increased by $4.

Interesting, huh?
 
It is interesting and I agree with his overall theory. Sort of skimming profits off the top on the way up and putting them back in on the way down. My buddy only followed the SAFE concept for a short while. He is stock picking individual stocks and doing well I understand in this bull market. Good luck with your investments!
 
So, why doesn't the spreadsheet use shares? It would seem to me that that would be more accurate... but, then again, I am a newbie...
 
Hello Real, My spreadsheet is used mainly to track dollars in the TSP and related return on investments by using the daily share prices for each fund since that is what most members are interested in. Why would you want to track the number of shares? Don't really think one method is more accurate than the other.:confused:
 
Scout333 said:
Hello Real, My spreadsheet is used mainly to track dollars in the TSP and related return on investments by using the daily share prices for each fund since that is what most members are interested in. Why would you want to track the number of shares? Don't really think one method is more accurate than the other.:confused:
Click to expand...

Mainly because when I put the $$, %%, and share prices in the spreadsheet, none of the dollar amounts added up. I will continue to take a look at it to see what I am missing. I started this whole thing late, so my returns on the website will be off a little.

I did 15%+ last year, so I am just trying to maximize it and still try to stay a little diversified and wanted a way to track it.

Thanks !!
 
RealMoneyIssues said:
Mainly because when I put the $$, %%, and share prices in the spreadsheet, none of the dollar amounts added up. I will continue to take a look at it to see what I am missing. I started this whole thing late, so my returns on the website will be off a little.

I did 15%+ last year, so I am just trying to maximize it and still try to stay a little diversified and wanted a way to track it.

Thanks !!
Click to expand...

Real, Take a look at the Tips tab. If you haven't made a lot of IFTs and/or changes in your % allocations this year it may be worth it to go back to the beginning of the year and start with 12-31-2010 fund balances. PM me if you have specific questions about how to enter $, share prices, etc. and I'll see if I can help.
 
Scout333, I wanted to say thank you for your spread sheet. I down loaded it last year but never got a "round toit".

One suggestion about the tips that is a little confusing.

"(1) Bi-weekly contributions- When you put in the bi-weekly contribution amounts put in the daily share prices first (for the day the contribution is posted) then drop down one line, use the same date and share prices, and enter the contribution in Column E for that line. The reason you have to do this is because the contributions are made after the share prices for that day are implemented. Enter the percentage going to each fund in Columns Z to AD. i.e. 20% to G would be entered .2 in Column Z. Contribution amounts will be allocated prorata among the TSP funds based on your allocation percentages."

You do say to drop down one line when entering the contribution but the statement about using the same date and share prices confuses at first. You are actually entering the contribution on the line for the next day. You explain it well in the next line.

Thanks again for the sheet. It does much more than mine which simply multiplies the number of shares times the price and then adds those totals up.

Is the 2012 Stk Funds (2) for playing "what if"?

You don't appear to have an "account talk" thread or I would have posted this there.
 
PessOptimist said:
Is the 2012 Stk Funds (2) for playing "what if"?
Click to expand...

Pess you're very welcome. The 2012 Stk Funds (2) is a backup in case something gets messed up in your main spreadsheet. Could be used for "what if" scenarios also or just copy it as another worksheet. If you have a better explanation for the "Bi-weekly contributions" part of the tips feel free to PM it to me and I will add it to tips for next year.
 
Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2012 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

Enjoy the spreadsheet!

http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
 
Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2013 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

Enjoy the spreadsheet!

http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
 
Scout333 said:
Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2013 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

Enjoy the spreadsheet!

http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
Click to expand...

If you haven't used the spreadsheet before suggest that you start with the tips tab! Enjoy!
 
Scout333 said:
Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2012 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

Enjoy the spreadsheet!

http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
Click to expand...
Hi Scout333, Thank you so much for the spreadsheet!! :)
 
Hello Fellow TSP'rs, The 2015 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2014 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year. If you haven't used the spreadsheet before I suggest you start with the Tips tab.

Enjoy the spreadsheet!

http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
 
You must log in or register to reply here.

Similar threads

RevShark
End-of-year tax planning notes - RevShark
Replies
2
Views
313
felinecrl
F
tsptalk
  • Article Article
TSP Talk - A rally, tariffs, and Apple earnings
Replies
0
Views
240
tsptalk
tsptalk
tsptalk
  • Article Article
TSP Talk - A late surge pushes the S&P 500 (C-fund) to new highs
Replies
0
Views
219
tsptalk
tsptalk
TommyIV
  • Article Article
TSP Talk AutoTracker Insights: An S-fund Preference
Replies
1
Views
416
tsptalk
tsptalk
tsptalk
  • Article Article
TSP Talk - Stocks face new policies, a debt ceiling, and liquidity
Replies
0
Views
208
tsptalk
tsptalk
Back
Top