Warning: The author is neither a tax professional nor a retirement advisor. Any statements contained within this document do not constitute legal, tax, or investment advice.
Long-term investors try to keep a mix of asset types in proportions that match their risk preferences. Over time, prices fluctuate and the actual worth of assets will inevitably change. This tool calculates the optimal way to invest a fixed sum of money so that each asset type's value is as close as possible to its desired ratio of the whole portfolio.
Broadly, this tool provides a means of "staying the course" through regular contributions into the right mutual funds.
Just clone and cargo run to see a demonstration with a real GnuCash database:
$ git clone [email protected]:DavidCain/stay-the-course.git
$ cd stay-the-course
$ cargo run
Using default example configuration. Write to config.toml for real use.
-----------------------------------------------------------------------
International stocks: $8,861 (🎯 32.15%)
- VTIAX (VTIAX): $8861.10 (273.7445 x $32.37)
US bonds: $6,851 (🎯 19.62%)
- VBTLX (VBTLX): $6850.79 (1151.3937 x $5.95)
US total market: $5,894 (🎯 26.52%)
- FZROX (FZROX): $5202.48 (274.3919 x $18.96)
- VTSAX (VTSAX): $691.13 (5.2905 x $130.63)
US small + mid cap: $4,000 (🎯 13.66%)
- VSMAX (VSMAX): $4000.00 (38.2409 x $104.60)
REIT: $3,080 (🎯 8.03%)
- VGSLX (VGSLX): $3080.26 (26.1438 x $117.82)
Portfolio total: $28,686
Worth at retirement (Assuming 7% growth):
- 39: $28,686 SWR: $1,147
- 50: $58,391 SWR: $2,336
- 55: $81,893 SWR: $3,276
- 60: $114,875 SWR: $4,595
- 65: $161,111 SWR: $6,444
After-tax income: $49,700
Charitable giving: $5,000 (10% of after-tax income)
Minimum to bring all assets to target: $9,635
How much to contribute or withdraw?
3000
Contribute the following amounts:
- US total market: $2083.11
20.54% -> 25.17% (🎯 26.52%) Δ [22.5% -> 5.0%]
- International stocks: $807.65
30.89% -> 30.51% (🎯 32.15%) Δ [3.9% -> 5.0%]
- US small + mid cap: $109.22
13.94% -> 12.96% (🎯 13.66%) Δ [-2.0% -> 5.0%]
- US bonds: $0.00
23.88% -> 21.62% (🎯 19.62%) Δ [-21.7% -> -10.1%]
- REIT: $0.00
10.73% -> 9.72% (🎯 8.03%) Δ [-33.5% -> -20.9%]
In example/ are two (identical) sample files in XML and sqlite3 format. Each
may be opened with GnuCash 3. The transactions, security prices, and
account balances contained within are the basis of rebalancing logic:
The tool accepts a few key inputs:
- The path to a GnuCash data file (in either XML or SQLite format)
- The desired target allocation per asset type
- The amount of money the investor intends to invest
With that information supplied, the tool will:
- Use the contained price database to calculate the current worth of each investment fund
- Classify each fund into an asset type
- Sum up asset values by asset type, calculate the ratio of each asset class to the total portfolio value
- Sequentially identify asset classes which have deviated most from their target, invest into those asset classes until they are as close to their target as the next furthest asset class (repeat until the desired contribution amount has been fully allocated to all funds)
- Output the optimal contributions
I'm using the AlphaVantage free API. To use it, make sure that:
ALPHAVANTAGE_API_KEYis an available env var. (Get an API key first)update_prices = trueis set in[gnucash]withinconfig.toml
When configured, this ensures that the latest stock prices per fund are incorporated into the allocation recommendations.
Asset allocation is the process of reconciling one's risk preferences and investment goals with a long-term strategy.
Stocks are generally understood to grant higher returns in the long run, at the risk of greater volatility in the short run. Conversely, many consider bonds a source of stable income, with lessened potential for long-term growth. Some asset classes (such as TIPS) may provide some insurance against changing economic conditions, while other funds provide broad exposure to varied economic sectors (adding diversity to a portfolio).
Any long-term investment strategy should be tailored to the risk preferences of the investor. A young professional will likely desire a riskier portfolio than somebody nearing retirement: The young professional is able to tolerate short-term volatility in the hopes of greater returns. The retiree needs a steady stream of income, and is willing to forego greater returns in exchange for stability.
Rebalancing can be expensive. When selling taxable funds, an investor must realize capital gains (or losses) in order to move money from one investment to another. If shares have not been held for a sufficiently long period of time, short-term capital gains may even be realized (at a potentially higher tax rate).
For residents of California, capital gains are taxed as normal income. If the investor plans to retire in another state, they may desire to postpone the realization of capital gains.
Selling shares adds some complexity to annual tax returns, since capital gains must be reported to the IRS. A buy-and-hold investor may instead be able to go years without selling any assets, avoiding the need to report realized gains.
Regular re-investment may be sufficient to keep asset allocation in line with targets. However, a number of scenarios might cause the ratio of various asset classes to deviate too far from targets:
- Significant market changes (e.g. domestic or international expansion/contraction)
- Change in risk preferences (changing target weights for stocks, bonds, TIPS, etc.)
- Regular contributions being too small a fraction of the overall portfolio.
Only an individual investor can decide when their portfolio's composition has deviated too far from its targets. At that time, it may become necessary to sell overweighted assets and direct the proceeds to an underweighted asset class.
Taking dividends in cash (rather than automatically re-investing into the originating fund) can help alleviate the need for rebalancing. The dividends from overweighted funds may be transferred into underweighted funds. Additionally, receiving dividends this way can help avoid a "wash sale" if the investor plains to perform tax loss harvesting.
- While this algorithm can handle any number of funds and corresponding asset classes,
we do assume that the user employs a "lazy portfolio"
strategy (a portfolio in which desired allocations are spread across a small
number of asset classes and underlying mutual funds). The GnuCash integration
only considers assets whose underlying commodities are of type
FUND. - Current values are based on the last known price. The user must keep their price database current within GnuCash in order to get current estimates.
- No differentiation is made between taxable and tax-advantaged accounts. It is up to the user to manage efficient fund placement and direct funds to the appropriate accounts.
- No consideration is made of minimum investments: Investing in a new mutual fund often requires a minimum investment, but this tool does not account for that. The included example files show an investor building a diverse portfolio first before working towards bringing their various funds in line with target ratios.
This project is very much a work in progress. Some key outstanding tasks:
- Optimize XML parsing (currently takes a couple seconds on a 20MB file)
- Command line interface
- Return Result instead of just panicking on error conditions
- Optimal rebalancing (archive): Though it has since
been taken down (it lived at
http://optimalrebalancing.tk, now spam), this was an excellent web tool by Albert H. Mao. It provided a textual interface to lazily rebalance. rebalance-appby Alberto Leal: another Rust implementation based off Optimal rebalancing, but without GnuCash integration and relying on a different underlying type libraries. Probably better suited for people who don't make use of GnuCash. Also includes some features not present in this project!