User:Grabiner/Investment resources

Here is a collection of spreadsheets I have written for investment tracking. The files are currently hosted on a public Google drive.

Tax lot tracking
These spreadsheets can be used for keeping track of lots and capital gains. They include example data which illustrates the types of transactions you can enter, such as partial sales of a lot, share class conversion (for a mutual fund), and stock splits (for a stock or ETF). You would use a separate copy of the sheet for every mutual fund or ETF you hold.


 * Spreadsheet for a stock or ETF


 * Spreadsheet for a mutual fund


 * Spreadsheet for a mutual fund with purchase and redemption fees

Asset Allocation
These worksheets can be used to keep track of your asset allocation over all accounts, both taxable and retirement. They can take into account tax-adjusted asset allocation; for example, you will be able to keep 100% of your Roth IRA, but if you retire in a 25% tax bracket, the IRS will take 25% of your traditional IRA.


 * Complete spreadsheet
 * Documentation
 * Simplified spreadsheet

Whether to switch out of a bad taxable fund
If you have a fund in your taxable account that you now realize is a bad deal, but you would have to pay capital-gains tax to switch, here is a spreadsheet which estimates the cost and break-even; it is discussed in Paying a tax cost to switch funds.

You only need to edit lines 2-3 to give current tax rates, and line 7 to list your current holdings in Funds A and B and their basis. The "Tax on distributions" is the total tax you pay, not the rate; the "Future" CG tax is the tax rate that will apply when you sell the funds.

The worksheet is currently set up to compare two funds which are identical except that Fund A has 0.5% higher expenses; both funds yield 2% in qualified dividends or long-term gains, and the tax rate is 15%. It takes eight years for this difference to make up for the 7.5% immediate tax loss for switching, because switching increases your tax basis.

The assumption made in the worksheet is that you will reinvest all distributions in Fund B, whether you sell your Fund A now or keep it, since you prefer Fund B. The after-tax value is the amount you will have left after a given number of years after selling the funds and paying the capital-gains tax; if you plan to sell the funds over a long time period (such as retirement), use the line which corresponds to the middle of retirement for the comparison.


 * Spreadsheet for deciding whether to sell a high-cost taxable fund

General disclaimer
These worksheets are not intended to provide financial or tax advice; consult a financial or tax advisor. Any calculations made with these worksheets which depend on future returns and taxes are only as accurate as the assumptions made about those returns and taxes. Past performance is no guarantee of future results.