Page 2 of 6 FirstFirst 1234 ... LastLast
Results 13 to 24 of 61

Thread: Scout333's TSP Contribution Spreadsheet

  1. #13

    Default Re: Scout333's TSP Contribution Spreadsheet

    Thanks for sharing the spreadsheet.
    Last edited by p3a; 12-23-2008 at 07:08 PM. Reason: Mistake

  2.  
  3. #14

    Default Re: Scout333's TSP Contribution Spreadsheet

    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor and this is not investment advice. Please do your own due diligence.

  4.  
  5. #15

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by tsptalk View Post
    Thanks Tom, A fresh start for the New Year with the 2009 version!

  6.  
  7. #16

    Default Re: Scout333's TSP Contribution Spreadsheet

    Thank you Scout! This is a great utility for those who want a more precise personal return than the autotracker can give.
    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor and this is not investment advice. Please do your own due diligence.

  8.  
  9. #17

    Default Re: Scout333's TSP Contribution Spreadsheet

    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 2009 version. I did add 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 paydate and the calculator gives you return on investment %s including the matching contributions.

    1-5-2010 Version: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

    Enjoy the spreadsheet!

  10.  
  11. #18

    Default Re: Scout333's TSP Contribution Spreadsheet

    A new version of Scout333's Spreadsheet has been posted on the Utilities Page for 2011:

    http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

    Thanks Scout333!!
    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor and this is not investment advice. Please do your own due diligence.


  12.  
  13. #19

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by tsptalk View Post
    A new version of Scout333's Spreadsheet has been posted on the Utilities Page for 2011:

    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 2010 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 paydate 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!

  14.  
  15. #20

    Join Date
    Feb 2007
    Location
    San Diego, CA
    Posts
    6,999

    Default Re: Scout333's TSP Contribution Spreadsheet

    Scout333, YOU JUST ROCK!
    THIS IS WHERE I WOULD PUT SOMETHING TO REPRESENT MY THINKING, BUT THEN THEY SHOW UP!
    Tracker =
    Check my position

  16.  
  17. #21

    Default Re: Scout333's TSP Contribution Spreadsheet

    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
    "When asked if my cup is half full or half empty, my only response is that I am thankful I have a cup." -Sam Lefkowitz

  18.  
  19. #22

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    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!
    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?

  20.  
  21. #23

    Default Re: Scout333's TSP Contribution Spreadsheet

    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!

  22.  
  23. #24

    Join Date
    Feb 2011
    Location
    Washington
    Posts
    9,583

    Default Re: Scout333's TSP Contribution Spreadsheet

    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...
    Rules:
    - Trade what you see, not what you believe
    - Don't put stuff in your signature that a Mod doesn't like

    "Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle

    Great Tools:
    http://www.CreditKarma.com
    http://www.Mint.com
    http://www.SaveUp.com/r/nmJ

  24.  
Page 2 of 6 FirstFirst 1234 ... LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes