Rate of Return
Moderator: Aitrus
Rate of Return
For the smart people out there. How does one calculate the percent (%) of gain / loss for a specific period. I'm looking for the formula to get my TSP rate of return for 2022. Assuming my beginning balance on January 1, 2022 was $300,000, and my ending balance on December 31, 2022 is $250,000, how do I do it? Does the formula require subtracting contributions? I'm still making contributions. Thanks in advance.
Re: Rate of Return
It's easy for me, because I have two TSP accounts, and I always make the exact same changes to both. My old military account hasn't had any type of contributions or withdraws for at least the last 6 years, so don't have to figure in anything but my gains or losses of whatever funds I am in over time. Otherwise, I can't hardly make heads or tails of how to figure out such on this new TSP.gov website.
Re: Rate of Return
This is how I would calculate it.
Starting balance =$300000
Contributions over the yr = $10,000
Ending balance = $250,000
Formula = ((Ending balance - contributions)-Starting balance) / Starting balance
($250000-$10000) = $240000
$240000-$300000 = -$60000
-$60000/$300000 = -0.20 x 100 = -20%
Starting balance =$300000
Contributions over the yr = $10,000
Ending balance = $250,000
Formula = ((Ending balance - contributions)-Starting balance) / Starting balance
($250000-$10000) = $240000
$240000-$300000 = -$60000
-$60000/$300000 = -0.20 x 100 = -20%
Re: Rate of Return
But what throws things off a bit, contributions made during the year earn at different rates, depending on when they were made. For example take this year for most folks, contributions made earlier in the year probably made less earnings than those contributions made later in the year. I think the easiest thing is to open a fantasy account here and make changes to it that exactly match your real account. That's what I do.
Re: Rate of Return
That makes sense to me. I am only looking for a ballpark figure, so this works. Thank you!jimmyk wrote: ↑Wed Dec 14, 2022 7:53 am This is how I would calculate it.
Starting balance =$300000
Contributions over the yr = $10,000
Ending balance = $250,000
Formula = ((Ending balance - contributions)-Starting balance) / Starting balance
($250000-$10000) = $240000
$240000-$300000 = -$60000
-$60000/$300000 = -0.20 x 100 = -20%
Re: Rate of Return
Sure. Jimcasada is correct though. There is error based on the return produced by contributions. What I posted was back of the envelope and ballpark.
- Scarfinger
- Posts: 749
- Joined: Mon Jan 30, 2012 12:00 am
Re: Rate of Return
I took my year end balance for 2021 and my current balance today and put it in a % calculator
https://percentagecalculator.net/
I used the "What is the percentage increase/decrease" part of the calculator.
I am currently at (-) 4.9% for the year. Mainly because of contributions padding the loss. Otherwise I would be down closer to (-) 13% for the year.
https://percentagecalculator.net/
I used the "What is the percentage increase/decrease" part of the calculator.
I am currently at (-) 4.9% for the year. Mainly because of contributions padding the loss. Otherwise I would be down closer to (-) 13% for the year.
I am just an average Joe. I have no clue to what the market will do.
Paul Merriman 2 fund strat: (age - 25) x2.5 = TDF + balance into S fund or variation ofTimboSlice wrote: "People really need to stop overthinking this."
Re: Rate of Return
For most of us who are already retired it's definately not been a nice market this year, and not being able to add more funds to offset the drops makes it painful. Something to be prepared for and think about before retiring, the market doesn't always go up each year.
Let's go Brandon.
Let's go Brandon.
In investing, what is comfortable is rarely profitable.
-Robert Arnott
-Robert Arnott
Fund Prices2023-03-22
Fund | Price | Day | YTD |
G | $17.38 | 0.01% | 0.87% |
F | $18.80 | 1.01% | 3.27% |
C | $60.64 | -1.64% | 2.95% |
S | $62.03 | -2.64% | 0.82% |
I | $35.64 | 0.10% | 5.00% |
L2065 | $12.68 | -1.16% | 3.42% |
L2060 | $12.68 | -1.16% | 3.42% |
L2055 | $12.68 | -1.16% | 3.42% |
L2050 | $26.31 | -0.89% | 3.17% |
L2045 | $12.11 | -0.82% | 3.06% |
L2040 | $44.64 | -0.77% | 2.93% |
L2035 | $11.92 | -0.70% | 2.78% |
L2030 | $40.10 | -0.64% | 2.61% |
L2025 | $11.66 | -0.38% | 2.05% |
Linc | $23.23 | -0.22% | 1.67% |