The Value Averaging Spreadsheet is another useful spreadsheet developed by AAII. Long-term investors are warned not to try to “time the market,” but investors will inevitably worry about entering the market at the top or exiting at the bottom. This spreadsheet was built to help individual investors reduce their timing risk.
Value averaging is a variation of dollar cost averaging. It offers investors an alternative to the “all-or-nothing” approach (either being in the market or on the sidelines). Value averaging allows investors to ease into the market over time, reducing timing risk. The premise of dollar cost averaging is very simple: invest a fixed amount at equal intervals over a period of time. Because the amount is fixed, investors using this strategy will buy more shares when prices are lower and fewer shares when prices are higher, theoretically lowering the average purchase cost.
Value averaging is a variation of dollar cost averaging where instead of investing a fixed dollar amount at each time interval, the amount invested varies so that the total value of the investment increases by a fixed sum or percentage each interval. If share prices alone increase the value of the investment above the planned amount, the investor must sell shares instead of adding to the investment. The value averaging spreadsheet allows users to input the dollar amount of the initial investment, the dollar amount of the desired increase each period, whether fractional shares can be purchase and whether shares can be sold. The output presented will provide you with the amount to purchase (or sell) in each investment period.
Value Averaging Spreadsheet
System Requirements: Application to edit Microsoft Excel document