ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Today's Date
2
4/7/2026
3
4
Current Market Value of Funds
52 WK Low Price
5
Fund Ticker Market Value Date/ Price
6
VWO (ETF)$53.73$39.53
7
VBR (ETF)$219.35$160.25
8
VTSAX (MUTUAL)*$158.322/09 - 45.59
9
* Mutual Funds: Price shown is yesterday's closing price
10
11
Price of Funds at Close, Yesterday
12
Ticker / Price Ticker / Price Ticker / Price
13
VWOVBRVTSAX*
14
54.01219.454.48
15
* Price as of the day before yesterday. "Current Price" of mutual funds reflects yesterday's price.
16
17
Cost Basis & Market Value of Portfolio
18
Fund Ticker Price PaidCurrent Market ValueGain/LossTotal Shares Avg Cost/Share
19
Settlement Account$2,362.85$2,362.852362,85$1.00
20
VWO$4,476.66$6,897.43$2,420.77128.37$34.87
21
VBR$3,923.29$8,498.72$4,575.4338.75$101.26
22
VTSAX$12,694.24$40,815.69$28,121.45257.81$49.24
23
Total Contributed$23,457.04$58,574.68$35,117.64
24
Total Purchases*$22,317.94$36,256.74
25
Increase %*162.46%
26
* Without respect to dividends reinvested
27
28
Contributions
29
Market Value Today$58,574.68
30
Remaining Contributions$0.00
31
Projected Total$58,574.68
32
33
34
Asset Allocation
35
Fund TickerAA of CurrentAA of Projected TotalAA IdealAmount NeededTo Invest
36
Settlement Account4.03%4.03%0.00%$0.00
37
VWO11.78%11.78%18.00%$10,543.44$3,646.02
38
VBR14.51%14.51%18.00%$10,543.44$2,044.73
39
VTSAX69.68%69.68%64.00%$37,487.80-$3,327.89
40
Total100.00%100.00%100.00%$58,574.68
41
42
43
Share Purchase Testing
44
Fund TickerNew Shares Market Value SharesTotalNew Cost/ Share
45
Settlement Account-$2,362.85
46
VWO0$53.73$0.00$34.87
47
VBR0$219.35$0.00$101.26
48
VTSAX44.067$158.32$6,976.69$49.95
49
Total$4,613.84
50
Contributions Rem. After -$4,613.84
51
52
*Beige colored box indicates that a manual entry is required*
53
*The "Market Value" row starting on Line B5 is programmed to automatically update stocks share price*
54
55
1. Edit Function(FX) for "Market Value" and "Price Yesterday" Alter the funds ticker name (in the function) to display price;
56
Manually change the name of funds in row A.
57
2. From brokerage data/ website, input the "Total Price Paid" for each fund and the number of "Total Shares" owned per fund;
58
3. Input remaining IRA contributions for current contribution period (January 1 through April 18);
59
If funds are in settlement account but are not allocated to the funds, do not include that amount.
60
4. Input desired asset allocation (%AA Desired); The total should add up to 100%;
61
5. The "To Invest" row reflects the amount needed to reach desired asset allocation;
62
6. Under "New Shares" you can test the exact amount needed for whole share ETF purchases, to arrive at ideal AA;
63
ETF funds must be purchased as whole shares when using Vanguard Personal Investments
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