Value Averaging Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
VALUE AVERAGINGDOLLAR COST AVERAGINGPORTFOLIO VARIABLES
2
Months
PortfolioPortfolioBuyingBuying or selling
3
FromValue
Portfolio
Amount
Value After
Portfolio
Amount
Value After
18
Number of months to value average
4
DateNowPathReturnValueto BuyBuyingValueTo BuyBuying$250,000
If buying, total value to target
5
Aug-190$0 $0$0 $0$0$0 $0$250,000
If selling, starting portfolio value
6
Sep-191$13,889 0.3%$0$13,889 $13,889$0$13,889 $13,889
7
Oct-192$27,778 -1.6%$13,661$14,116 $27,778$13,661$13,889 $27,550RETURN VARIABLES
8
Nov-193$41,667 1.4%$28,161$13,506 $41,667$27,930$13,889 $41,819US Stocks (VTSMX)
Asset class for random monthly returns
9
Dec-194$55,556 -9.0%$37,916$17,640 $55,556$38,055$13,889 $51,9435.0%
If random return, annual mean
10
Jan-205$69,444 4.2%$57,902$11,543 $69,444$54,137$13,889 $68,02620.0%
If random return, standard deviation
11
Feb-206$83,333 2.1%$70,894$12,440 $83,333$69,446$13,889 $83,335
12
Mar-207$97,222 0.6%$83,813$13,409 $97,222$83,814$13,889 $97,703BASELINE
13
Apr-208$111,111 7.5%$104,527$6,584 $111,111$105,044$13,889 $118,933$13,889
Baseline portfolio increase (when buying) or decrease (when selling)
14
May-209$125,000 3.4%$114,844$10,156 $125,000$122,929$13,889 $136,818
15
Jun-2010$138,889 -1.7%$122,861$16,028 $138,889$134,476$13,889 $148,365STATS
16
Jul-2011$152,778 3.0%$143,043$9,734 $152,778$152,803$13,889 $166,692VA AllocationsDCA Allocations
17
Aug-2012$166,667 -2.0%$149,754$16,913 $166,667$163,393$13,889 $177,282$214,740 $250,000
18
Sep-2013$180,556 5.4%$175,635$4,921 $180,556$186,821$13,889 $200,710
19
Oct-2014$194,444 4.7%$189,012$5,433 $194,444$210,110$13,889 $223,999VA End BalanceDCA End Balance
20
Nov-2015$208,333 3.7%$201,660$6,673 $208,333$232,311$13,889 $246,200$250,000$287,393
21
Dec-2016$222,222 -2.3%$203,494$18,729 $222,222$240,480$13,889 $254,369
22
Jan-2117$236,111 4.4%$231,947$4,164 $236,111$265,501$13,889 $279,390VA ReturnDCA Return
23
Feb-2118$250,000 -2.1%$231,137$18,863 $250,000$273,504$13,889 $287,39316.42%14.96%
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
Loading...