Page 5 of 5 FirstFirst ... 345
Results 49 to 58 of 58

Thread: Scout333's TSP Contribution Spreadsheet

  1. #49

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    Hello Fellow TSP'rs! OK Here we go again! The Updated 2017 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. Thanks to MadMike 61 there are modifications to the formulas affecting the contributions into the spreadsheet. Very nice! Otherwise it is very similar to the 2016 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. Hopefully this link will work.

    http://www.tsptalk.com/utilities/Sco...ed-Version.xls

    TSP Calculator - Thrift Savings Plan

    Note. The original 2017 spreadsheet did not have the updated formula modifications so Tom has been kind enough to re-post the Spreadsheet. The one you want to use is the one titled Scouts_Spreadsheet-2017-Updated Version.xls. MadMike61 has some information regarding the modifications and suggestions for those who would rather update the formulas in their original Spreadsheet. See below. The contribution is entered on the same date as noted by TSP. With the modified formula there is no need to create a second line for the same date. So you enter the total contribution amount in column E for the pay date. No need to ever create a duplicate date line. Fund CSIGF amount are as advertised by TSP for that date. Note, for those who have already started the report for the year, they can start a new spreadsheet or use the new formulas and copy that formula to the rest of their fields in the column. The way to do that is to paste each fund formula into the row 8 then extend that formula to each subsequent date. You do that by highlighting the cell and moving your pointer to the bottom right of the cell until a “+” sign is displayed. Then right click with your mouse and drag the formula down to subsequent cells. The formula will automatically update for each subsequent cell. Modified formulas are shown below.

    Below are the primer formulas for the 5 funds for line 8 on the Scouts 2017 tracker.

    =IF((E8=0)=TRUE,+B7*W8,(E8*AB7)+(B7*W8)) C Fund - Column B

    =IF((E8=0)=TRUE,+C7*X8,(E8*AC7)+(C7*X8)) S Fund - Column C

    =IF((E8=0)=TRUE,+D7*Y8,(E8*AD7)+(D7*Y8)) I Fund - Column D

    =IF((E8=0)=TRUE,+H7*U8,(E8*Z7)+(H7*U8)) G Fund - Column H

    =IF((E8=0)=TRUE,+I7*V8,(E8*AA7)+(I7*V8)) F Fund - Column I


    Thanks again to MadMike61 for his contribution to the Spreadsheet!
    Frixxxx, Noticed you had responded to the posting of the original 2017 spreadsheet. Thought you may want to try the Updated Version. See link above.

  2.  
  3. #50

    Default Re: Scout333's TSP Contribution Spreadsheet

    Hello Fellow TSP'rs! OK Here we go again! The Updated 2018 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. Thanks to MadMike 61 there are modifications to the formulas affecting the contributions into the spreadsheet. Very nice! Otherwise it is very similar to the 2017 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. Hopefully this link will work.
    http://www.tsptalk.com/utilities/Sco...ed-Version.xls

  4.  
  5. #51

    Default Re: Scout333's TSP Contribution Spreadsheet

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

    I am not a Registered Investment Advisor. Do your own due diligence.

  6.  
  7. #52

    Default Re: Scout333's TSP Contribution Spreadsheet

    Reminder, all of the spreadsheets and instructions can be found here...

    TSP Calculator - Thrift Savings Plan
    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor. Do your own due diligence.

  8.  
  9. #53

    Default Re: Scout333's TSP Contribution Spreadsheet

    Scout333's Spreadsheets have been updated for 2019 and posted on...

    TSP Calculator - Thrift Savings Plan

    Code:
    http://www.tsptalk.com/utilities.html
    Thanks AGAIN Scout333!

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

    I am not a Registered Investment Advisor. Do your own due diligence.

  10.  
  11. #54

    Default Re: Scout333's TSP Contribution Spreadsheet

    Hello Fellow TSP'rs! OK Here we go again! The Updated 2019 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. Thanks to MadMike 61 there are modifications to the formulas affecting the contributions into the spreadsheet. Very nice! Otherwise it is very similar to the 2018 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. Hopefully this link will work.

    TSP Calculator - Thrift Savings Plan


  12.  
  13. #55

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    Hello Fellow TSP'rs! OK Here we go again! The Updated 2019 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. Thanks to MadMike 61 there are modifications to the formulas affecting the contributions into the spreadsheet. Very nice! Otherwise it is very similar to the 2018 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. Hopefully this link will work.

    TSP Calculator - Thrift Savings Plan
    http://www.tsptalk.com/utilities/Sco...heet-2019.xlsx

  14.  
  15. #56

    Default Re: Scout333's TSP Contribution Spreadsheet

    Hello Fellow TSP'rs! OK Here we go again! The Updated 2020 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. Thanks to MadMike 61 there are modifications to the formulas affecting the contributions into the spreadsheet. Very nice! Otherwise it is very similar to the 2019 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. Then open the 2020 Stk Funds Tab. Hopefully this link will work. TSP Calculator - Thrift Savings Plan



    http://www.tsptalk.com/utilities/Sco...heet-2020.xlsx

  16.  
  17. #57

    Default Re: Scout333's TSP Contribution Spreadsheet

    Hello Fellow TSP'rs! OK Here we go again! The Updated 2021 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. Thanks to MadMike 61 there are modifications to the formulas affecting the contributions into the spreadsheet. Very nice! Otherwise it is very similar to the 2020 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. Then open the 2021 Stk Funds Tab. Hopefully this link will work.
    TSP Calculator - Thrift Savings Plan
    Last edited by Scout333; 01-07-2021 at 09:23 PM.

  18.  
  19. #58

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    Hello Fellow TSP'rs! OK Here we go again! The Updated 2021 version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. Thanks to MadMike 61 there are modifications to the formulas affecting the contributions into the spreadsheet. Very nice! Otherwise it is very similar to the 2020 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. Then open the 2021 Stk Funds Tab. Hopefully this link will work.
    TSP Calculator - Thrift Savings Plan
    http://www.tsptalk.com/utilities/Sco...heet-2021.xlsx

  20.  
Page 5 of 5 FirstFirst ... 345

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
  •  
SPY (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