Originally Posted by
david.alan.williams
I think I know what you are saying. Column V is not in use so I assume you are talking about columns O and P.
If so, you can just add the percentages the way you would normally think.
This spreadsheet, like TSPTalk.com and TSP.gov calculates annualized returns.
Annualized Return = (100*(1+P26)*(1+O27)-100)/100
To prove that it works, go to E28 and plugin COB Fridays S Fund share price. (Which was 21.9685) The sheet will tell you that your YTD total is 3.41% which is exactly what is listed on the TSPTalk main page for the S Fund - 3.41%.
Maybe someone else can explain it better but calculating annualized returns is different than just adding the percentages together.
If I misunderstood what you were saying, please let me know.
D
Bookmarks