Это калькулятор по опубликованной методике, не индивидуальная инвестиционная рекомендация. This calculator applies a published method. It is not personal investment advice.
A value averaging plan
Builds the account-value path from Michael Edleson's companion spreadsheets to Value Averaging (Wiley, 2006; the Russian edition is «Усреднение ценности»). Dollar-cost averaging — усреднение стоимости — is shown beside it. The tickers are examples for the price field, not a buy list.
Это калькулятор по опубликованной методике, не индивидуальная инвестиционная рекомендация. This calculator applies a published method. It is not personal investment advice.
Trade toward the next point on the path
- R = (r+g)/2, B10
- T, final index, B11
- t now, B12
- C, path parameter, B13
- r per month
- g per month
- First planned contribution
- Last planned contribution
- Sum of planned contributions
- DCA amount, D7
- Chapter 4 check, E13
- Goal check
| Month | Target | Planned contribution | Cost-averaging contribution | Value before trade | Trade | Shares | No-sell trade | Side fund | Side fund, no-sell |
|---|
This month: readjust the path
Enter the holding’s actual value and the price. The purchase is recomputed from sheet APPCHAP5: trade = Path(1) − that value. A negative number is a sale.
My plans
No account. The list stays in this browser’s localStorage. The share button puts the whole plan in the address, so the link opens anywhere.
One random return path
Chapter 7 appendix, sheet “Chap7 Simul”, pp. 129–134. This is not a contribution plan. One run: monthly return = 0.008 + 0.045 × a standard normal draw, the price index compounds, and the annualized return is (index after 12×years)^(1/years) − 1. The button stands in for Excel’s F9. The seed is an assumption; the sheet uses RAND().
Where the numbers come from
- Readjusted value path: R = (r+g)/2, T = n / (1 − (1+R)^n · V / G), t = T − n, C = G / (T · (1+R)^T), Path(k) = C · (t+k) · (1+R)^(t+k). Cells APPCHAP5!B10–B13 and column C. Path(0) is today’s value, Path(n) is the goal.
- The sheet rejects n ≤ 2, a per-period r or g outside [0, 0.2], or T < 0, t < 0, or C < 1 (“Inputs Too High! Too much money.”).
- The classic path is equation B15 with no time shift. It is the readjustment at a current value of zero.
- Dollar-cost averaging, Chapter 4: the first pot is V·(1+r)^n (D10); the second pot must make up the rest of the goal (D12). The future value of contributions C, C(1+g), … is formula D13. C is solved so D13 equals D12. Column G in the converted file is one growth step ahead of D13 and is not used for the plan.
- Trade = target − holding value. With no-sell, a negative trade is skipped and the surplus stays invested. The side fund receives the planned contribution and pays for the trade, at 0%. Those rules are not cells in the appendices; the note under the chart says so.