## Constructing a VA Readjustment Spreadsheet

The following spreadsheet shows the solution to the value averaging readjustment problem from Chapter 5, page 90. Start with 6,500, with 17 years 204 months to attain a 100,000 goal, and add other inputs as shown. What would the value path look like for monthly value averaging Put in the 5 inputs you know, and the spreadsheet does all the rest. The outputs are calculated in cells B9-B12, with the value path formula in cell B14. The solution involves an artificial time index as described in the...