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

View only
 
ABCDEFGHIJ
1
PORTFOLIO EINSTEIN'S REBALANCING WORKSHEET
2
PORTFOLIOEINSTEIN.COM
3
5 STEPS TO DO >>>>>>>>>>>
4
1. Enter your funds or ETFs that are in your portfolio in A14 to A26COLOR LEGEND:IMPORTANT!
5
2. Enter the ticker symbols for the funds or ETFs in B14 to B26Only change fields that are yellowCopy this worksheet to your own drive by going to "File > Make a copy" so you can make changes!
6
3. Enter the current value of your funds or ETFs in C14 to C26Follow the steps that are green
7
4. Enter your desired asset allocation in F14 to F26DON'T touch grey fields :-) They only contain information
8
5. Inspect G14 to G26 to see what you need to buy and sell to rebalance. Make the trades at your broker
9
6. Sit back and relax :)
10
11
12
STEP 1: Enter your funds belowSTEP 2: Enter the ticker symbols belowSTEP 3: CHANGE VALUES BELOW!STEP 4: ENTER YOUR DESIRED ALLOCATIONSTEP 5: CHECK IF YOU NEED TO BUY OR SELL SHARES
13
Asset DescriptionTickerCurrent ValueCurrent %Target Value Reallocation Target %Funds to transferDirection
14
Total US Stock Market Index ETFVTI$8,900.0055%$7,245.0045%-$1,655.00Sell
15
Total International (ex-US) Stock Index ETFVXUS$1,000.006%$4,830.0030%$3,830.00Buy
16
Total Bond Market Index ETFBND$5,000.0031%$2,415.0015%-$2,585.00Sell
17
US Treasury Inflation-Protected Securities ETFVTIP$400.002%$805.005%$405.00Buy
18
CashCash$800.005%$805.005%$5.00Buy
19
$0.000%$0.00$0.00Sell
20
$0.000%$0.00$0.00Sell
21
$0.000%$0.00$0.00Sell
22
$0.000%$0.00$0.00Sell
23
$0.000%$0.00$0.00Sell
24
$0.000%$0.00$0.00Sell
25
$0.000%$0.00$0.00Sell
26
$0.000%$0.00$0.00Sell
27
Total Investments:$16,100.00$16,100.00100%$0.00
28
29
30
31
Error checks:Current value equals Target value:
32
Percentage totals 100%:
33
Net difference is zero:
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
Loading...