Rebalancing Example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
This spreadsheet was used to derive the calculations for the portfolio-rebalancing example in my blog post http://minetopics.blogspot.com/2013/02/rebalancing-your-liquid-assets.html
2
Read-only --- download a copy (File --> Download as...) to edit.
3
4
%BTC target:25.00%<-- Play around with this to see the results changeFor Value of Portfolio Measured in USD:For Value of Portfolio Measured in BTC:
5
ActionUSD HoldingsBTC HoldingsBTCUSD PriceValue of Portfolio in USDValue of Portfolio in BTCOverall Wealth Gain (x)Overall Wealth Gain (+%)Overall Wealth Gain (+$)Overall Wealth Gain (x)Overall Wealth Gain (+%)Overall Wealth Gain (+BTC)Notes:
6
Initially:$400.000.00 BTC$10.00$400.0040.00 BTC1.00 x0.00%$0.001.00 x0.00%0.00 BTC
7
Rebalance:$300.0010.00 BTC$10.00$400.0040.00 BTC1.00 x0.00%$0.001.00 x0.00%0.00 BTC
8
Price rises:$300.0010.00 BTC$100.00$1,300.0013.00 BTC3.25 x225.00%$900.000.33 x-67.50%-27.00 BTC
9
Rebalance:$975.003.25 BTC$100.00$1,300.0013.00 BTC3.25 x225.00%$900.000.33 x-67.50%-27.00 BTC
10
Price falls:$975.003.25 BTC$10.00$1,007.50100.75 BTC2.52 x151.88%$607.502.52 x151.88%60.75 BTCEnd of cycle 1
11
Rebalance:$755.6325.19 BTC$10.00$1,007.50100.75 BTC2.52 x151.88%$607.502.52 x151.88%60.75 BTC
12
Price rises:$755.6325.19 BTC$100.00$3,274.3832.74 BTC8.19 x718.59%$2,874.380.82 x-18.14%-7.26 BTC
13
Rebalance:$2,455.788.19 BTC$100.00$3,274.3832.74 BTC8.19 x718.59%$2,874.380.82 x-18.14%-7.26 BTC
14
Price falls:$2,455.788.19 BTC$10.00$2,537.64253.76 BTC6.34 x534.41%$2,137.646.34 x534.41%213.76 BTCEnd of cycle 2
15
Rebalance:$1,903.2363.44 BTC$10.00$2,537.64253.76 BTC6.34 x534.41%$2,137.646.34 x534.41%213.76 BTC
16
Price rises:$1,903.2363.44 BTC$100.00$8,247.3382.47 BTC20.62 x1961.83%$7,847.332.06 x106.18%42.47 BTC
17
Rebalance:$6,185.5020.62 BTC$100.00$8,247.3382.47 BTC20.62 x1961.83%$7,847.332.06 x106.18%42.47 BTC
18
Price falls:$6,185.5020.62 BTC$10.00$6,391.68639.17 BTC15.98 x1497.92%$5,991.6815.98 x1497.92%599.17 BTCEnd of cycle 3
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1