A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
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 A26 | COLOR LEGEND: | IMPORTANT! | |||||||
5 | 2. Enter the ticker symbols for the funds or ETFs in B14 to B26 | Only change fields that are yellow | Copy 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 C26 | Follow the steps that are green | ||||||||
7 | 4. Enter your desired asset allocation in F14 to F26 | DON'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 below | STEP 2: Enter the ticker symbols below | STEP 3: CHANGE VALUES BELOW! | STEP 4: ENTER YOUR DESIRED ALLOCATION | STEP 5: CHECK IF YOU NEED TO BUY OR SELL SHARES | |||||
13 | Asset Description | Ticker | Current Value | Current % | Target Value | Reallocation Target % | Funds to transfer | Direction | ||
14 | Total US Stock Market Index ETF | VTI | $8,900.00 | 55% | $7,245.00 | 45% | -$1,655.00 | Sell | ||
15 | Total International (ex-US) Stock Index ETF | VXUS | $1,000.00 | 6% | $4,830.00 | 30% | $3,830.00 | Buy | ||
16 | Total Bond Market Index ETF | BND | $5,000.00 | 31% | $2,415.00 | 15% | -$2,585.00 | Sell | ||
17 | US Treasury Inflation-Protected Securities ETF | VTIP | $400.00 | 2% | $805.00 | 5% | $405.00 | Buy | ||
18 | Cash | Cash | $800.00 | 5% | $805.00 | 5% | $5.00 | Buy | ||
19 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
20 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
21 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
22 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
23 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
24 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
25 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
26 | $0.00 | 0% | $0.00 | $0.00 | Sell | |||||
27 | Total Investments: | $16,100.00 | $16,100.00 | 100% | $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 |