Joseph from New York posted over 3 years ago:

The Value Averaging Spreadsheet appears to be what I needed, so I downloaded it. I want to value average into a mutual fund over the next 20+ months. The initial investment was $3000 dollars and subsequent investments are set at the fund's $1000 minimum investment. Because the NAV of the fund is high, this months amount to invest calls for a dollar amount of $125.00; since this month's amount to invest is well below the $1000 minimum the fund requires how do I handle this? Do I ignore the spreadsheet's amounts to invest that are below the funds minimum or do I just forget using this spreadsheet?

Dave from Washington posted over 2 years ago:

To make this spreadsheet work with a mutual fund investment that has a high minimum like $1000, I would suggest that you set "Dollar amount to increase" in cell A6 to at least 2 times the min. investment or in your case $2000. Though with value investing you can not predict how long it will take to become "fully invested" in your case you could increase the investment interval to one and a half months instead of the original one month. When you get numbers that are less than $1000, I would suggest if the number is > than $500 then go ahead and invest $1000. If less than $500 then invest zero for that time frame.

Dave from Washington posted over 2 years ago:

One problem with this spreadsheet is that if you add anything to column D, it will tend to overstate your IRR calculation. To correct this you would need to add a column to capture the purchase price of the acquired shares and add that to the calculation of the "periodic investment" in column K.

john from Ohio posted about 1 year ago:

the spreadsheet works for small amount of investments. How can I use the spreadsheet if say my starting investment was $200,000 and I wanted to invest $2000 a month using a total stock market index fund as an investment vehicle? Should I define my expected portfolio value as an addition of $2000/month i.e 202000,204000,206000..... or should I use a certain expected rate of annual return say 6% or the historical stock market return of 9% ?

Zachariah Tripp from New Hampshire posted about 1 year ago:

I have been value averaging in my 401k for some time. I have my direct deposits go into the money market and even month I move to correct amount to the funds based on my value path. Last month (Jan-2013) I took profits in 3 of 5 funds. Felt good to have a plan and know when the value is above average so I can take profits and buy more when the return is below average.

John from Ohio, If I was you, I would make you own spreadsheet, it is not too difficult. Find the average monthly return of the fund in question and put together a excel file by month with that return and your monthly addition, that will be your path. Make installations accordingly.

If you want some help, post an email address here.

Sorry, you cannot add comments while on a mobile device or while printing.