I also have an Excel spreadsheet where I do my calculations. Mine are based on the inflated dollars of future years. Each year of my 35 year retirement plan is represented by a row. I have a column for each of these:Dividends in taxable accounts, including mutual funds dividends that are capital gainsCorporate pension (not indexed for inflation)IRA withdrawalsSocial security (indexed for inflation)Sales for taxable accounts (just enough to raise any additional money needed to cover my spending budget and income taxes)Total income Personal exemption amountItemized deductionsThe basis in my taxable account, computed based on sales or purchases, and not indexed for inflation, since capital gains taxes are computed based on the fantasy that inflation does not occurThe amount of tax-free return of capital resulting from sales in my taxable account, assuming sales at average purchase priceRealized capital gainsMaximum income for 15% income tax rateMaximum income for 28% income tax rateMaximum income for 31% income tax rateMaximum income for 36% income tax rateThen, five columns of which only one has an entry other than zero, that shows an estimate of the income taxes for that year. The column that has a non-zero entry corresponds to my marginal income tax rate for that year on income other than capital gains. The fifth column corresponds to the 39.6% marginal tax rate. Finally, the estimated income tax for that year, which is just the sum of the tax on income other than capital gains and an assumed tax rate of 20% on the capital gains realized that year.Then, even after "finally" and because I'm curious, two columns to show the percentage of my income going to federal income tax and the percentage of my assets going to that tax.I also have some related graphs to show 1. the allocation of my income and unrealized capital gains to three accounts: spending, income taxes, and "saving" which is actually repair of the damage that inflation does to the purchasing power of the retirement assets. A pie chart with three sectors labeled with percentages, totalled over the 35 years, and a bar chart that shows the percentages for each year separately.2. a chart that shows income taxes, both in current dollars and inflation adjustedChips, who loves to crunch the numbers and hates to pay the taxes
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra