Google
 
TSP Talk Market Comments TSP AutoTracker Premiums Site Map TSP Funds Forum Returns

TSP | Thrift Savings Plan - Talk


Quotes, Charts, Info


TSP Share Prices & Returns
Fund Index Quotes

Popular Charts
Market Futures Quotes
Earnings Reports
Economic Calendar
 

 

Sponsors

 


 

Help and Resources

Site Map
FAQ
FAQ - Premium Services
FAQ for Alerts
Reader Testimonials
How to Make a Transfer
How to Make an IFT (Video)
Report Problems / Errors
Contact Us

TSP - What is it?
Who Is TSP Talk?
What Can We Do For You?
Want More Help?

TSP Talk Toolbar

Mug Shots
Classified Ads -
New
TSP Talk User Map
Tell a friend or co-worker
Recent Forum Activity
Video & Image Library

Market Analysis Videos
TSP.gov Home Page
My Federal Retirement
Ocean's ETF Blog

Mobile Options

- Android Forum App
- iPhone Forum App
- TSP Talk Mobile Version

 

 
Returns Calculator Instructions
 
Returns Calculator Instructions:
 
This utility uses Microsoft Excel. 

- Open up the Returns Calculator by clicking here.
- When the spreadsheet opens,  go to "File", then "Save as" to save it to your PC.

Under “Fund Price”, the first price entry for each fund should be the final share prices of
each fund just before you start tracking.  In the example below (marked "A") I am starting
at the beginning of 2006, so the final share prices for 2005 (Dec. 30) will go in that first row. 
These prices can be found on www.tsp.gov.  More on that below.  This 2005 fund price row
stays
constant all year as we use these numbers to get our return for the year. 

Once you have the prices in place you want to add the starting date. In the example below we're using Jan 3 ("B").
Then enter your starting allocation in the yellow cells (marked "C"). 
Now you will manually enter your current
account allocation in the yellow highlighted section.  Let's assume our first allocation is 25% F, 25% C, and 50% S.
Enter "25" in the F column, "25" in the C column, and "50" in the S column. The "%" will fill in automatically.





Now we need to get the first updated share prices.  To get the current fund prices, you need
to go to www.tsp.gov.  On the main page, click on "Share Prices".





Once in the Share Prices page, highlight and copy the G fund through I fund share prices...





... a
nd paste them under the "Fund Prices" column in the current row.  You will also input the current date in the
"End Date" column. 
 


You will notice a couple of things.  All of the share prices below the one you entered were automatically
updated to the current share price as well.  Also notice in the orange area above that the fund returns also
filled in automatically, as well as your return on the far right for the current allocation and for the year (not shown).

As long as you have not made any new interfund transfers, any time you want to check your current return, get the
current share from www.tsp.gov, input the current date and share prices in that row and you will be all set.


To see how your allocation compares to the individual funds, scroll down toward the bottom of the spreadsheet.

- To include the L-funds into your
comparison, simply copy and paste
the current L-fund prices from
www.tsp.gov into the corresponding
cells (Marked "B").

- The 2005 prices ("A") will be the final
L-fund share prices from 2005 also
found at www.tsp.gov.

- The figures in the blue box will be
updated automatically.

- A positive number indicates your
return > other allocation.

- A negative number indicates your
return < other allocation.

Now let's make an interfund transfer...

Let's say that on February 9th we make an interfund transfer before the 12:00 noon ET deadline.
At the end of the day you'll want to insert the 9-FEB-06 date in the "End Date" column along with
the closing share prices of that date. 

Start another row with transaction #2, enter the starting date (10-FEB-06 in this case), and enter
your new allocation in the "Fund Allocation" columns.  In this example it is 50% G, 50% C fund.



You will continue to update the End Date and share prices in Trans #2 row until
you make another interfund transfer where you will start on Trans #3. 

I hope this helps.  If you still have any questions, please email me

Thanks,
Tom

Free e-mail alerts

Enter e-mail Address:
For Email Marketing you can trust

[more info]
Join the 17,108 on the list

 
TSP Talk Toolbar!
Download the Toolbar
 

Premium Services

 

Sponsor's Links

S&P 500 (C fund)
[Chart]
1d  5d  3m  6m  1y  2y
Dow Completion (S fund)
[Chart]
1d  5d  3m  6m 
EFA (I fund)
[Chart]
1d  5d  3m  6m  1y  2y
Bonds (F fund)
[Chart]
1d  5d  3m  6m  1y  2y
20min. delay http://finance.yahoo.com

TSP Talk does not guarantee the accuracy or completeness of this report, nor does TSPtalk.com assume any liability for any loss that may result from reliance by any person upon any such information or opinions. Such information and opinions are subject to change without notice and are for general information only. 

The information contained on this website is for educational purposes only and not intended to be recommendations, and may not be published, broadcast, rewritten or otherwise distributed without prior written consent from TSPtalk.com. Full Disclaimer


Copyright © 2003 - 2014
Buy Low Sell High, Inc.
TSPtalk.com® is a trademark of Buy Low Sell High, Inc.
All Rights Reserved

Buy Low Sell High, Inc., P.O. Box 13213, Ogden UT 84412

 

TSP Talk Market Comments TSP AutoTracker Premiums Site Map TSP Funds Forum Returns