marko
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
- Joined
- Mar 16, 2011
- Messages
- 9,521
Profit Taking Question/Help
Here’s an investment portfolio question that may be hard to fully describe. I hope my friends here can help.
With the markets so volatile, DW has been wondering why we don’t ‘lock in’ our portfolio profits from time to time. That is, when the market has a nice run (like now) why don’t we take the PROFIT/GROWTH and turn it into a bond fund or cash and then if/when the market takes a dive we’d at least have that much in the bank. (yes, I’m accounting for ‘missing a rally’ and so on…I’m just looking at the general logic here).
I built an Excel model that shows there is little difference between banking profit or not and I’m wondering if there is some flaw in my model.
Essentially, if you bank the profit, you drop your ‘base’ back to the original level. Then in the event of a tanking, you drop from that lowered base level to a level lower so that even after adding in the ‘banked’ amount you’re at just about the same level than if you did nothing.
EX:
“Bank scenario”: 1000 in January X 5% = 1050. Bank 50; base goes back to 1000
Feb through Dec: Market loses 5%: 1000 X -5% = 950. 950 + banked 50 = 1000
“Do nothing scenario”: 1000 in January X 5% = 1050. Feb through Dec: Market loses 5%: 1050 X -5% = 998….Bank vs Do nothing: 1000 vs 998
In this example (and dozens of others that I’ve run) there is minimal benefit to warrant 1) the effort and 2) missing a rally.
Is there something wrong with my logic assumptions?
Here’s an investment portfolio question that may be hard to fully describe. I hope my friends here can help.
With the markets so volatile, DW has been wondering why we don’t ‘lock in’ our portfolio profits from time to time. That is, when the market has a nice run (like now) why don’t we take the PROFIT/GROWTH and turn it into a bond fund or cash and then if/when the market takes a dive we’d at least have that much in the bank. (yes, I’m accounting for ‘missing a rally’ and so on…I’m just looking at the general logic here).
I built an Excel model that shows there is little difference between banking profit or not and I’m wondering if there is some flaw in my model.
Essentially, if you bank the profit, you drop your ‘base’ back to the original level. Then in the event of a tanking, you drop from that lowered base level to a level lower so that even after adding in the ‘banked’ amount you’re at just about the same level than if you did nothing.
EX:
“Bank scenario”: 1000 in January X 5% = 1050. Bank 50; base goes back to 1000
Feb through Dec: Market loses 5%: 1000 X -5% = 950. 950 + banked 50 = 1000
“Do nothing scenario”: 1000 in January X 5% = 1050. Feb through Dec: Market loses 5%: 1050 X -5% = 998….Bank vs Do nothing: 1000 vs 998
In this example (and dozens of others that I’ve run) there is minimal benefit to warrant 1) the effort and 2) missing a rally.
Is there something wrong with my logic assumptions?
Last edited: