Spreadsheet: 817044d1675965041-vlookup-not-grabbing-table-irmaa-tax-analysis
Sheet: Roth 5 Yr

 | Enter year and Age B1 & B2 | To utilize this spreadsheet, save a copy of it by selecting File > Make a Copy |  |  |  |  |  |  | Light [NAME] contain calculations/formulas - avoid data entry unless you want to make the value permanent.
 | Analysis | Federal |  | State |  | Total Tax |  | Portfolio |  | Net
 | Constraints | 22% Bracket, State Tax?, IRMAA based upon MAGI @ 63, Possible Tax increase in 2026?
 | Assumptions | Stock return 6% bond return 2%. Tax deferred 70/30, [NAME] and Taxable 100% stock. RMDs go to taxable. Need to account for money coming out of taxable to pay the taxes?
 | Year | 2021
 | Ages | 64
FORM 1040 | Desired Income $XXXX
1 | My Salary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | Their Salary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3b | Dividends | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4b | My Roth Conversion | 314000 | 26100 | 457000 | 286000 | 286000 | 286000 | 285000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4b | My Rollover IRA distribution |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RMD Divisor |  |  |  |  |  |  |  |  | 27.4 | 26.5 | 25.5 | 24.6 | 23.7 | 22.9 | 22 | 21.1 | 20.2 | 19.4 | 18.5 | 17.7 | 16.8 | 16 | 15.2 | 14.4 | 13.7 | 12.9
4b | My RMD
 | Inherited RMD Divisor | 25.6
4b | My Inherited IRA RMD | 0
4b | My Inherited IRA Distribution | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5b | My Pension | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5b | Their Pension | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | My Taxable Distribution | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | My Roth Distribution | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | My HSA distribution | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6b | My SS | 0 | 0 | 0 | 52000
6b | Their SS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | Other income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | Total Income
10 | Adjustments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Non-taxable Income
11 | AGI
12 | Standard Deduction | 25900
 | HSA Contribution | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | Taxable Income
 | 15% Income
 | Ordinary Income
 | Marginal Rate
 | Federal Tax
 | Effective Tax Rate
 | State Tax(MO 6%) | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06
 | State Tax Owed
 |  | Portfolio  Growth |  | Stock Allocation | Bond Allocation | Stock Growth | Bond Growth | <<Input growth assumptions |  |  | Portfolio  Growth |  | Stock Allocation | Bond Allocation | Stock Growth | Bond Growth | <<Input alternative growth assumptions
 | INPUT ACCOUNT BALANCES > |  |  | 0.6 | 0.4 | 0.06 | 0.015 |  |  |  |  |  | 0.5 | 0.5 | 0.06 | 0.02
 | My Taxable | 27985
 | My Rollover IRA | 1723875
 | My Roth IRA | 60618
 | My Inherited IRA | 0
 | My HSA | 0
 | TOTAL
 |  | SINGLE |  |  | MARRIED FILING JOINT |  |  | CAPITAL GAINS AND DIVIDENDS
 |  | Taxable Income | Marginal Tax Rate | Base Tax | Taxable Income | Marginal Tax Rate | Base Tax
 | MARRIEDJOINT | -12550 | 0.1 | 0 | -25100 | 0 | 0 | Status | 0 | 0.15 | 0.2 | IRMAA TIERS |  |  |  | ACA |  |  | Taxation of SS
 |  | 0 | 0.1 | 0 | 0 | 0.1 | 0 |  |  |  |  | Based upon AGI 2 years prior |  |  |  | Family Size | Lower Limit | Upper Limit | Income | None of SS is Taxable | Up to 50% of SS is Taxable | 85% of SS is Taxable
 |  | 9950 | 0.12 | 995 | 19900 | 0.12 | 1990 | Single | 40400 | 445850 | Above | Tier | S | MFJ | MFS | 1
 |  | 40250 | 0.22 | 4664 | 81050 | 0.22 | 9328 | MFJ | 80800 | 501600 | Above | 1 | 91000 | 182000 | 91000 | 2 |  |  | Income + 50% of Social Security | <$34,000 | <$44,000 | >$44,000
 |  | 86375 | 0.24 | 14751 | 172750 | 0.24 | 29502 | MFS |  |  |  | 2 | 114000 | 228000 | N/A | 3
 |  | 164925 | 0.32 | 33603 | 329850 | 0.32 | 67206 | HOH | 54100 | 473750 | Above | 3 | 142000 | 284000 | N/A | 4
 |  | 209425 | 0.35 | 47843 | 418850 | 0.35 | 95686 | Spreadsheet does not calculate the tax on CG&DIV. |  |  |  | 4 | 170000 | 340000 | 91000-409000 | 5
 | S |  | 12550 |  |  | 25100 |  |  |  |  |  | 5 | 500000 | 750000 | >$409,000 | 6
Conversion YR | Part B Annual Cost | Part D Additional Premium |  |  | IRMAA TIERS
2023 |  |  |  |  | Based upon AGI 2 years prior
2024 |  |  |  |  | Tier | S | MFJ | MFS | Part B Premium |  | Part D Additional Premium
2025 |  |  |  |  | 0 | 0 | 0 | 0 | 164.9 |  | 0
2026 |  |  |  |  | 1 | 91000 | 194000 | 91000 | 230.8 |  | 12.2
2027 |  |  |  |  | 2 | 114000 | 246000 | N/A | 329.7 |  | 31.5
2028 |  |  |  |  | 3 | 142000 | 306000 | N/A | 428.6 |  | 50.7
2029 |  |  |  |  | 4 | 170000 | 366000 | $91000-409000 | 527.5 |  | 70
2030 |  |  |  |  | 5 | 500000 | 750000 | >$409,000 | 560.5 |  | 76.4
2031
 | Total Tax Payments