Home Log In
When 2 Retire

Advertisements

Guest planner

Guest changes are temporary. Sign in to save scenarios and return to them later.

Scenario

Shared Assumptions

Guest

Taxable Income Streams

Current Balances

401K Contribution

Yearly Contribution

Investment Returns

Spouse

Taxable Income Streams

Current Balances

401K Contribution

Yearly Contribution

Investment Returns

Guest Social Security

Spouse Social Security

Tax Tables

Effective year State tax

Federal Tax - Single
Federal Tax - MFJ
Ohio State Tax
State tax
Single exemption
MFJ exemption

Income Reference Tables

RMD uniform lifetime table
Age Distribution period RMD (%)
73 26.5 3.77
74 25.5 3.92
75 24.6 4.07
76 23.7 4.22
77 22.9 4.37
78 22.0 4.55
79 21.1 4.74
80 20.2 4.95
81 19.4 5.15
82 18.5 5.41
83 17.7 5.65
84 16.8 5.95
85 16.0 6.25
86 15.2 6.58
87 14.4 6.94
88 13.7 7.30
89 12.9 7.75
90 12.2 8.20
91 11.5 8.70
92 10.8 9.26
93 10.1 9.90
94 9.5 10.53
95 8.9 11.24
96 8.4 11.90
97 7.8 12.82
98 7.3 13.70
99 6.8 14.71
100 6.4 15.63
101 6.0 16.67
102 5.6 17.86
103 5.2 19.23
104 4.9 20.41
105 4.6 21.74
106 4.3 23.26
107 4.1 24.39
108 3.9 25.64
109 3.7 27.03
110 3.5 28.57
111 3.4 29.41
112 3.3 30.30
113 3.1 32.26
114 3.0 33.33
115 2.9 34.48
116 2.8 35.71
117 2.7 37.04
118 2.5 40.00
119 2.3 43.48
120 2.0 50.00
2026 Capital Gains Tax table

Single

Income floor Rate (%)
$0.00 0.00
$49,450.00 15.00
$545,500.00 20.00

Married filing jointly

Income floor Rate (%)
$0.00 0.00
$98,900.00 15.00
$613,700.00 20.00
Social Security Taxability table

Single

Provisional income floor Max taxable SS (%)
$0.00 0.00
$25,000.00 50.00
$34,000.00 85.00

Married filing jointly

Provisional income floor Max taxable SS (%)
$0.00 0.00
$32,000.00 50.00
$44,000.00 85.00
2026 Medicare IRMAA table

Single

Income floor Part B Part D IRMAA
$0.00 $202.90 $0.00
$109,000.01 $284.10 $14.50
$137,000.01 $405.80 $37.50
$171,000.01 $527.50 $60.40
$205,000.01 $649.20 $83.30
$500,000.00 $689.90 $91.00

Married filing jointly

Income floor Part B Part D IRMAA
$0.00 $202.90 $0.00
$218,000.01 $284.10 $14.50
$274,000.01 $405.80 $37.50
$342,000.01 $527.50 $60.40
$410,000.01 $649.20 $83.30
$750,000.00 $689.90 $91.00

Savings projection summary

Final year: 35 Guest Spouse Household
Age Salary Future Value Today's Value Age Salary Future Value Today's Value Age Salary Future Value Today's Value
Balance 60.4 * Retired * $470,979.62 $203,418.61 * Retired * $470,979.62 $203,418.61
Contributions $0.00 $0.00 $0.00 $0.00
Earnings $37,697.10 $16,281.58 $37,697.10 $16,281.58

Savings projection detail

Guest Spouse Household
Age Salary Cont % 401K Roth 401K IRA Roth IRA SEP HSA Taxable Future Value Today's Value Age Salary Cont % 401K Roth 401K IRA Roth IRA SEP HSA Taxable Future Value Today's Value Age Salary Cont % 401K Roth 401K IRA Roth IRA SEP HSA Taxable Future Value Today's Value
Balance 26.4 $16,000.00 7.00% $640.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100.00 $740.00 $740.00 $16,000.00   $640.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100.00 $740.00 $740.00
Contributions $1120.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,120.00 $1,120.00 $1120.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,120.00 $1,120.00
Earnings $51.20 $0.00 $0.00 $0.00 $0.00 $0.00 $9.00 $60.20 $60.20 $51.20 $0.00 $0.00 $0.00 $0.00 $0.00 $9.00 $60.20 $60.20
Balance 27.4 $16,480.00 8.00% $1811.20 $0.00 $0.00 $0.00 $0.00 $0.00 $109.00 $1,920.20 $1,873.37 $16,480.00   $1811.20 $0.00 $0.00 $0.00 $0.00 $0.00 $109.00 $1,920.20 $1,873.37
Contributions $1318.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,318.40 $1,286.24 $1318.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,318.40 $1,286.24
Earnings $144.90 $0.00 $0.00 $0.00 $0.00 $0.00 $9.81 $154.71 $150.93 $144.90 $0.00 $0.00 $0.00 $0.00 $0.00 $9.81 $154.71 $150.93
Balance 28.4 $16,974.40 9.00% $3274.50 $0.00 $0.00 $0.00 $0.00 $0.00 $118.81 $3,393.31 $3,229.80 $16,974.40   $3274.50 $0.00 $0.00 $0.00 $0.00 $0.00 $118.81 $3,393.31 $3,229.80
Contributions $1527.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,527.70 $1,454.08 $1527.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,527.70 $1,454.08
Earnings $261.96 $0.00 $0.00 $0.00 $0.00 $0.00 $10.69 $272.65 $259.51 $261.96 $0.00 $0.00 $0.00 $0.00 $0.00 $10.69 $272.65 $259.51
Balance 29.4 $17,483.63 10.00% $5064.15 $0.00 $0.00 $0.00 $0.00 $0.00 $129.50 $5,193.65 $4,822.82 $17,483.63   $5064.15 $0.00 $0.00 $0.00 $0.00 $0.00 $129.50 $5,193.65 $4,822.82
Contributions $1748.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,748.36 $1,623.53 $1748.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,748.36 $1,623.53
Earnings $405.13 $0.00 $0.00 $0.00 $0.00 $0.00 $11.66 $416.79 $387.03 $405.13 $0.00 $0.00 $0.00 $0.00 $0.00 $11.66 $416.79 $387.03
Balance 30.4 $18,008.14 11.00% $7217.65 $0.00 $0.00 $0.00 $0.00 $0.00 $141.16 $7,358.81 $6,666.71 $18,008.14   $7217.65 $0.00 $0.00 $0.00 $0.00 $0.00 $141.16 $7,358.81 $6,666.71
Contributions $1980.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,980.90 $1,794.59 $1980.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,980.90 $1,794.59
Earnings $577.41 $0.00 $0.00 $0.00 $0.00 $0.00 $12.70 $590.12 $534.62 $577.41 $0.00 $0.00 $0.00 $0.00 $0.00 $12.70 $590.12 $534.62
Balance 31.4 $18,548.39 12.00% $9775.95 $0.00 $0.00 $0.00 $0.00 $0.00 $153.86 $9,929.82 $8,776.51 $18,548.39   $9775.95 $0.00 $0.00 $0.00 $0.00 $0.00 $153.86 $9,929.82 $8,776.51
Contributions $2225.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,225.81 $1,967.29 $2225.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,225.81 $1,967.29
Earnings $782.08 $0.00 $0.00 $0.00 $0.00 $0.00 $13.85 $795.92 $703.48 $782.08 $0.00 $0.00 $0.00 $0.00 $0.00 $13.85 $795.92 $703.48
Balance 32.4 $19,104.84 13.00% $12783.84 $0.00 $0.00 $0.00 $0.00 $0.00 $167.71 $12,951.55 $11,168.08 $19,104.84   $12783.84 $0.00 $0.00 $0.00 $0.00 $0.00 $167.71 $12,951.55 $11,168.08
Contributions $2483.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,483.63 $2,141.63 $2483.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,483.63 $2,141.63
Earnings $1022.71 $0.00 $0.00 $0.00 $0.00 $0.00 $15.09 $1,037.80 $894.89 $1022.71 $0.00 $0.00 $0.00 $0.00 $0.00 $15.09 $1,037.80 $894.89
Balance 33.4 $19,677.98 14.00% $16290.17 $0.00 $0.00 $0.00 $0.00 $0.00 $182.80 $16,472.98 $13,858.14 $19,677.98   $16290.17 $0.00 $0.00 $0.00 $0.00 $0.00 $182.80 $16,472.98 $13,858.14
Contributions $2754.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,754.92 $2,317.62 $2754.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,754.92 $2,317.62
Earnings $1303.21 $0.00 $0.00 $0.00 $0.00 $0.00 $16.45 $1,319.67 $1,110.19 $1303.21 $0.00 $0.00 $0.00 $0.00 $0.00 $16.45 $1,319.67 $1,110.19
Balance 34.4 $20,268.32 15.00% $20348.30 $0.00 $0.00 $0.00 $0.00 $0.00 $199.26 $20,547.56 $16,864.34 $20,268.32   $20348.30 $0.00 $0.00 $0.00 $0.00 $0.00 $199.26 $20,547.56 $16,864.34
Contributions $3040.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,040.25 $2,495.27 $3040.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,040.25 $2,495.27
Earnings $1627.86 $0.00 $0.00 $0.00 $0.00 $0.00 $17.93 $1,645.80 $1,350.78 $1627.86 $0.00 $0.00 $0.00 $0.00 $0.00 $17.93 $1,645.80 $1,350.78
Balance 35.4 $20,876.37 15.00% $25016.42 $0.00 $0.00 $0.00 $0.00 $0.00 $217.19 $25,233.61 $20,205.26 $20,876.37   $25016.42 $0.00 $0.00 $0.00 $0.00 $0.00 $217.19 $25,233.61 $20,205.26
Contributions $3131.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,131.46 $2,507.45 $3131.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,131.46 $2,507.45
Earnings $2001.31 $0.00 $0.00 $0.00 $0.00 $0.00 $19.55 $2,020.86 $1,618.16 $2001.31 $0.00 $0.00 $0.00 $0.00 $0.00 $19.55 $2,020.86 $1,618.16
Balance 36.4 $21,502.66 15.00% $30149.19 $0.00 $0.00 $0.00 $0.00 $0.00 $236.74 $30,385.92 $23,737.43 $21,502.66   $30149.19 $0.00 $0.00 $0.00 $0.00 $0.00 $236.74 $30,385.92 $23,737.43
Contributions $3225.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,225.40 $2,519.68 $3225.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,225.40 $2,519.68
Earnings $2411.93 $0.00 $0.00 $0.00 $0.00 $0.00 $21.31 $2,433.24 $1,900.84 $2411.93 $0.00 $0.00 $0.00 $0.00 $0.00 $21.31 $2,433.24 $1,900.84
Balance 37.4 $22,147.74 15.00% $35786.52 $0.00 $0.00 $0.00 $0.00 $0.00 $258.04 $36,044.56 $27,471.17 $22,147.74   $35786.52 $0.00 $0.00 $0.00 $0.00 $0.00 $258.04 $36,044.56 $27,471.17
Contributions $3322.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,322.16 $2,531.97 $3322.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,322.16 $2,531.97
Earnings $2862.92 $0.00 $0.00 $0.00 $0.00 $0.00 $23.22 $2,886.15 $2,199.66 $2862.92 $0.00 $0.00 $0.00 $0.00 $0.00 $23.22 $2,886.15 $2,199.66
Balance 38.4 $22,812.17 15.00% $41971.60 $0.00 $0.00 $0.00 $0.00 $0.00 $281.27 $42,252.87 $31,417.37 $22,812.17   $41971.60 $0.00 $0.00 $0.00 $0.00 $0.00 $281.27 $42,252.87 $31,417.37
Contributions $3421.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,421.83 $2,544.32 $3421.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,421.83 $2,544.32
Earnings $3357.73 $0.00 $0.00 $0.00 $0.00 $0.00 $25.31 $3,383.04 $2,515.48 $3357.73 $0.00 $0.00 $0.00 $0.00 $0.00 $25.31 $3,383.04 $2,515.48
Balance 39.4 $23,496.54 15.00% $48751.16 $0.00 $0.00 $0.00 $0.00 $0.00 $306.58 $49,057.74 $35,587.48 $23,496.54   $48751.16 $0.00 $0.00 $0.00 $0.00 $0.00 $306.58 $49,057.74 $35,587.48
Contributions $3524.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,524.48 $2,556.73 $3524.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,524.48 $2,556.73
Earnings $3900.09 $0.00 $0.00 $0.00 $0.00 $0.00 $27.59 $3,927.68 $2,849.22 $3900.09 $0.00 $0.00 $0.00 $0.00 $0.00 $27.59 $3,927.68 $2,849.22
Balance 40.4 $24,201.44 15.00% $56175.73 $0.00 $0.00 $0.00 $0.00 $0.00 $334.17 $56,509.90 $39,993.59 $24,201.44   $56175.73 $0.00 $0.00 $0.00 $0.00 $0.00 $334.17 $56,509.90 $39,993.59
Contributions $3630.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,630.22 $2,569.20 $3630.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,630.22 $2,569.20
Earnings $4494.06 $0.00 $0.00 $0.00 $0.00 $0.00 $30.08 $4,524.13 $3,201.85 $4494.06 $0.00 $0.00 $0.00 $0.00 $0.00 $30.08 $4,524.13 $3,201.85
Balance 41.4 $24,927.48 15.00% $64300.00 $0.00 $0.00 $0.00 $0.00 $0.00 $364.25 $64,664.25 $44,648.44 $24,927.48   $64300.00 $0.00 $0.00 $0.00 $0.00 $0.00 $364.25 $64,664.25 $44,648.44
Contributions $3739.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,739.12 $2,581.73 $3739.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,739.12 $2,581.73
Earnings $5144.00 $0.00 $0.00 $0.00 $0.00 $0.00 $32.78 $5,176.78 $3,574.39 $5144.00 $0.00 $0.00 $0.00 $0.00 $0.00 $32.78 $5,176.78 $3,574.39
Balance 42.4 $25,675.30 15.00% $73183.13 $0.00 $0.00 $0.00 $0.00 $0.00 $397.03 $73,580.16 $49,565.43 $25,675.30   $73183.13 $0.00 $0.00 $0.00 $0.00 $0.00 $397.03 $73,580.16 $49,565.43
Contributions $3851.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,851.30 $2,594.33 $3851.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,851.30 $2,594.33
Earnings $5854.65 $0.00 $0.00 $0.00 $0.00 $0.00 $35.73 $5,890.38 $3,967.91 $5854.65 $0.00 $0.00 $0.00 $0.00 $0.00 $35.73 $5,890.38 $3,967.91
Balance 43.4 $26,445.56 15.00% $82889.07 $0.00 $0.00 $0.00 $0.00 $0.00 $432.76 $83,321.83 $54,758.70 $26,445.56   $82889.07 $0.00 $0.00 $0.00 $0.00 $0.00 $432.76 $83,321.83 $54,758.70
Contributions $3966.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,966.83 $2,606.98 $3966.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,966.83 $2,606.98
Earnings $6631.13 $0.00 $0.00 $0.00 $0.00 $0.00 $38.95 $6,670.07 $4,383.54 $6631.13 $0.00 $0.00 $0.00 $0.00 $0.00 $38.95 $6,670.07 $4,383.54
Balance 44.4 $27,238.93 15.00% $93487.03 $0.00 $0.00 $0.00 $0.00 $0.00 $471.71 $93,958.74 $60,243.14 $27,238.93   $93487.03 $0.00 $0.00 $0.00 $0.00 $0.00 $471.71 $93,958.74 $60,243.14
Contributions $4085.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,085.84 $2,619.70 $4085.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,085.84 $2,619.70
Earnings $7478.96 $0.00 $0.00 $0.00 $0.00 $0.00 $42.45 $7,521.42 $4,822.48 $7478.96 $0.00 $0.00 $0.00 $0.00 $0.00 $42.45 $7,521.42 $4,822.48
Balance 45.4 $28,056.10 15.00% $105051.83 $0.00 $0.00 $0.00 $0.00 $0.00 $514.17 $105,566.00 $66,034.46 $28,056.10   $105051.83 $0.00 $0.00 $0.00 $0.00 $0.00 $514.17 $105,566.00 $66,034.46
Contributions $4208.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,208.41 $2,632.48 $4208.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,208.41 $2,632.48
Earnings $8404.15 $0.00 $0.00 $0.00 $0.00 $0.00 $46.27 $8,450.42 $5,285.97 $8404.15 $0.00 $0.00 $0.00 $0.00 $0.00 $46.27 $8,450.42 $5,285.97
Balance 46.4 $28,897.78 15.00% $117664.39 $0.00 $0.00 $0.00 $0.00 $0.00 $560.44 $118,224.84 $72,149.18 $28,897.78   $117664.39 $0.00 $0.00 $0.00 $0.00 $0.00 $560.44 $118,224.84 $72,149.18
Contributions $4334.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,334.67 $2,645.32 $4334.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,334.67 $2,645.32
Earnings $9413.15 $0.00 $0.00 $0.00 $0.00 $0.00 $50.44 $9,463.59 $5,775.35 $9413.15 $0.00 $0.00 $0.00 $0.00 $0.00 $50.44 $9,463.59 $5,775.35
Balance 47.4 $29,764.71 15.00% $131412.21 $0.00 $0.00 $0.00 $0.00 $0.00 $610.88 $132,023.09 $78,604.74 $29,764.71   $131412.21 $0.00 $0.00 $0.00 $0.00 $0.00 $610.88 $132,023.09 $78,604.74
Contributions $4464.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,464.71 $2,658.23 $4464.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,464.71 $2,658.23
Earnings $10512.98 $0.00 $0.00 $0.00 $0.00 $0.00 $54.98 $10,567.96 $6,292.02 $10512.98 $0.00 $0.00 $0.00 $0.00 $0.00 $54.98 $10,567.96 $6,292.02
Balance 48.4 $30,657.65 15.00% $146389.90 $0.00 $0.00 $0.00 $0.00 $0.00 $665.86 $147,055.76 $85,419.49 $30,657.65   $146389.90 $0.00 $0.00 $0.00 $0.00 $0.00 $665.86 $147,055.76 $85,419.49
Contributions $4598.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,598.65 $2,671.19 $4598.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,598.65 $2,671.19
Earnings $11711.19 $0.00 $0.00 $0.00 $0.00 $0.00 $59.93 $11,771.12 $6,837.43 $11711.19 $0.00 $0.00 $0.00 $0.00 $0.00 $59.93 $11,771.12 $6,837.43
Balance 49.4 $31,577.38 15.00% $162699.74 $0.00 $0.00 $0.00 $0.00 $0.00 $725.79 $163,425.52 $92,612.79 $31,577.38   $162699.74 $0.00 $0.00 $0.00 $0.00 $0.00 $725.79 $163,425.52 $92,612.79
Contributions $4736.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,736.61 $2,684.22 $4736.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,736.61 $2,684.22
Earnings $13015.98 $0.00 $0.00 $0.00 $0.00 $0.00 $65.32 $13,081.30 $7,413.14 $13015.98 $0.00 $0.00 $0.00 $0.00 $0.00 $65.32 $13,081.30 $7,413.14
Balance 50.4 $32,524.71 15.00% $180452.32 $0.00 $0.00 $0.00 $0.00 $0.00 $791.11 $181,243.43 $100,205.03 $32,524.71   $180452.32 $0.00 $0.00 $0.00 $0.00 $0.00 $791.11 $181,243.43 $100,205.03
Contributions $4878.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,878.71 $2,697.32 $4878.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,878.71 $2,697.32
Earnings $14436.19 $0.00 $0.00 $0.00 $0.00 $0.00 $71.20 $14,507.39 $8,020.78 $14436.19 $0.00 $0.00 $0.00 $0.00 $0.00 $71.20 $14,507.39 $8,020.78
Balance 51.4 $33,500.45 15.00% $199767.22 $0.00 $0.00 $0.00 $0.00 $0.00 $862.31 $200,629.52 $108,217.68 $33,500.45   $199767.22 $0.00 $0.00 $0.00 $0.00 $0.00 $862.31 $200,629.52 $108,217.68
Contributions $5025.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,025.07 $2,710.47 $5025.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,025.07 $2,710.47
Earnings $15981.38 $0.00 $0.00 $0.00 $0.00 $0.00 $77.61 $16,058.98 $8,662.07 $15981.38 $0.00 $0.00 $0.00 $0.00 $0.00 $77.61 $16,058.98 $8,662.07
Balance 52.4 $34,505.46 15.00% $220773.66 $0.00 $0.00 $0.00 $0.00 $0.00 $939.92 $221,713.58 $116,673.38 $34,505.46   $220773.66 $0.00 $0.00 $0.00 $0.00 $0.00 $939.92 $221,713.58 $116,673.38
Contributions $5175.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,175.82 $2,723.70 $5175.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,175.82 $2,723.70
Earnings $17661.89 $0.00 $0.00 $0.00 $0.00 $0.00 $84.59 $17,746.49 $9,338.82 $17661.89 $0.00 $0.00 $0.00 $0.00 $0.00 $84.59 $17,746.49 $9,338.82
Balance 53.4 $35,540.62 15.00% $243611.37 $0.00 $0.00 $0.00 $0.00 $0.00 $1024.51 $244,635.88 $125,595.99 $35,540.62   $243611.37 $0.00 $0.00 $0.00 $0.00 $0.00 $1024.51 $244,635.88 $125,595.99
Contributions $5331.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,331.09 $2,736.98 $5331.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,331.09 $2,736.98
Earnings $19488.91 $0.00 $0.00 $0.00 $0.00 $0.00 $92.21 $19,581.12 $10,052.94 $19488.91 $0.00 $0.00 $0.00 $0.00 $0.00 $92.21 $19,581.12 $10,052.94
Balance 54.4 $36,606.84 15.00% $268431.37 $0.00 $0.00 $0.00 $0.00 $0.00 $1116.71 $269,548.09 $135,010.65 $36,606.84   $268431.37 $0.00 $0.00 $0.00 $0.00 $0.00 $1116.71 $269,548.09 $135,010.65
Contributions $5491.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,491.03 $2,750.33 $5491.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,491.03 $2,750.33
Earnings $21474.51 $0.00 $0.00 $0.00 $0.00 $0.00 $100.50 $21,575.01 $10,806.45 $21474.51 $0.00 $0.00 $0.00 $0.00 $0.00 $100.50 $21,575.01 $10,806.45
Balance 55.4 $37,705.05 15.00% $295396.91 $0.00 $0.00 $0.00 $0.00 $0.00 $1217.22 $296,614.13 $144,943.83 $37,705.05   $295396.91 $0.00 $0.00 $0.00 $0.00 $0.00 $1217.22 $296,614.13 $144,943.83
Contributions $5655.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,655.76 $2,763.75 $5655.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,655.76 $2,763.75
Earnings $23631.75 $0.00 $0.00 $0.00 $0.00 $0.00 $109.55 $23,741.30 $11,601.45 $23631.75 $0.00 $0.00 $0.00 $0.00 $0.00 $109.55 $23,741.30 $11,601.45
Balance 56.4 $38,836.20 15.00% $324684.42 $0.00 $0.00 $0.00 $0.00 $0.00 $1326.77 $326,011.19 $155,423.45 $38,836.20   $324684.42 $0.00 $0.00 $0.00 $0.00 $0.00 $1326.77 $326,011.19 $155,423.45
Contributions $5825.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,825.43 $2,777.23 $5825.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,825.43 $2,777.23
Earnings $25974.75 $0.00 $0.00 $0.00 $0.00 $0.00 $119.41 $26,094.16 $12,440.20 $25974.75 $0.00 $0.00 $0.00 $0.00 $0.00 $119.41 $26,094.16 $12,440.20
Balance 57.4 $40,001.29 15.00% $356484.60 $0.00 $0.00 $0.00 $0.00 $0.00 $1446.18 $357,930.78 $166,478.91 $40,001.29   $356484.60 $0.00 $0.00 $0.00 $0.00 $0.00 $1446.18 $357,930.78 $166,478.91
Contributions $6000.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6,000.19 $2,790.78 $6000.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6,000.19 $2,790.78
Earnings $28518.77 $0.00 $0.00 $0.00 $0.00 $0.00 $130.16 $28,648.92 $13,325.04 $28518.77 $0.00 $0.00 $0.00 $0.00 $0.00 $130.16 $28,648.92 $13,325.04
Balance 58.4 $41,201.32 15.00% $391003.57 $0.00 $0.00 $0.00 $0.00 $0.00 $1576.33 $392,579.90 $178,141.20 $41,201.32   $391003.57 $0.00 $0.00 $0.00 $0.00 $0.00 $1576.33 $392,579.90 $178,141.20
Contributions $6180.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6,180.20 $2,804.39 $6180.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6,180.20 $2,804.39
Earnings $31280.29 $0.00 $0.00 $0.00 $0.00 $0.00 $141.87 $31,422.16 $14,258.45 $31280.29 $0.00 $0.00 $0.00 $0.00 $0.00 $141.87 $31,422.16 $14,258.45
Balance 59.4 $42,437.36 15.00% $428464.05 $0.00 $0.00 $0.00 $0.00 $0.00 $1718.20 $430,182.25 $190,442.96 $42,437.36   $428464.05 $0.00 $0.00 $0.00 $0.00 $0.00 $1718.20 $430,182.25 $190,442.96
Contributions $6365.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6,365.60 $2,818.07 $6365.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6,365.60 $2,818.07
Earnings $34277.12 $0.00 $0.00 $0.00 $0.00 $0.00 $154.64 $34,431.76 $15,243.04 $34277.12 $0.00 $0.00 $0.00 $0.00 $0.00 $154.64 $34,431.76 $15,243.04
Balance 60.4 * Retired * * $469106.78 $0.00 $0.00 $0.00 $0.00 $0.00 $1872.84 $470,979.62 $203,418.61 * Retired *   $469106.78 $0.00 $0.00 $0.00 $0.00 $0.00 $1872.84 $470,979.62 $203,418.61
Contributions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Earnings $37528.54 $0.00 $0.00 $0.00 $0.00 $0.00 $168.56 $37,697.10 $16,281.58 $37528.54 $0.00 $0.00 $0.00 $0.00 $0.00 $168.56 $37,697.10 $16,281.58

Budget

How to use this budget

Edit the detail and subtotal descriptions as needed. Each budget row automatically copies its amounts from left to right across future age columns. Enter a value in the leftmost numeric column to set the starting amount, then only enter new values when the amount changes. If you delete a value, the row will continue using the previous amount.

Ages
26 30 40 50 60 62 65 67 70 80 90+
Income - Yearly $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,240.00 $75,240.00 $75,240.00 $75,240.00 $95,844.00 $95,844.00 $95,844.00
Income - Monthly
$6,250.00 $6,250.00 $6,250.00 $6,250.00 $6,270.00 $6,270.00 $6,270.00 $6,270.00 $7,987.00 $7,987.00 $7,987.00
$3,750.00 $3,750.00 $3,750.00 $3,750.00 $4,400.00 $4,400.00 $4,400.00 $4,400.00 $5,144.00 $5,144.00 $5,144.00
$2,500.00 $2,500.00 $2,500.00 $2,500.00 $1,870.00 $1,870.00 $1,870.00 $1,870.00 $2,843.00 $2,843.00 $2,843.00
Expenses - Yearly $72,480.00 $72,480.00 $72,480.00 $72,480.00 $70,572.00 $66,372.00 $61,812.00 $61,812.00 $49,812.00 $49,812.00 $49,812.00
Expenses - Monthly
$6,040.00 $6,040.00 $6,040.00 $6,040.00 $5,881.00 $5,531.00 $5,151.00 $5,151.00 $4,151.00 $4,151.00 $4,151.00
Expenses - Essential
$5,677.00 $5,677.00 $5,677.00 $5,677.00 $5,168.00 $4,818.00 $4,438.00 $4,438.00 $3,438.00 $3,438.00 $3,438.00
$1,198.00 $1,198.00 $1,198.00 $1,198.00 $678.00 $678.00 $678.00 $678.00 $678.00 $678.00 $678.00
$805.00 $805.00 $805.00 $805.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$1,365.00 $1,365.00 $1,365.00 $1,365.00 $1,365.00 $1,365.00 $1,365.00 $1,365.00 $365.00 $365.00 $365.00
$1,070.00 $1,070.00 $1,070.00 $1,070.00 $1,070.00 $720.00 $720.00 $720.00 $720.00 $720.00 $720.00
$264.00 $264.00 $264.00 $264.00 $1,080.00 $1,080.00 $700.00 $700.00 $700.00 $700.00 $700.00
$340.00 $340.00 $340.00 $340.00 $340.00 $340.00 $340.00 $340.00 $340.00 $340.00 $340.00
$420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00
$115.00 $115.00 $115.00 $115.00 $115.00 $115.00 $115.00 $115.00 $115.00 $115.00 $115.00
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Expenses - Discretionary
$363.00 $363.00 $363.00 $363.00 $713.00 $713.00 $713.00 $713.00 $713.00 $713.00 $713.00
$263.00 $263.00 $263.00 $263.00 $613.00 $613.00 $613.00 $613.00 $613.00 $613.00 $613.00
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Monthly Over/(Short) $210.00 $210.00 $210.00 $210.00 $389.00 $739.00 $1,119.00 $1,119.00 $3,836.00 $3,836.00 $3,836.00

Income projection summary

Column selection
Timeline
Assets
HSA
Returns
Income
Income Streams
Income Less SS
Social Security
Withdrawals
RMD + Conversion
Taxes
Tax Tables
Tax Details
Medical
Ending Assets
Summary Timeline Assets HSA Returns Income Income Streams Income Less SS Social Security Withdrawals RMD + Conversion Taxes Tax Tables Tax Details Medical Ending Assets
Year Guest Age Cumulative Inflation (%) Traditional Investments Taxable Basis 401K/IRA Balance ROTH 401K/IRA Balance Guest HSA Balance Guest HSA Withdrawal Guest HSA Returns Ending Guest HSA Traditional Investment Returns 401K/IRA Returns ROTH 401K/IRA Returns Planned Income/Spending Actual Income/Spending Actual Income After Tax & Med Total Adjusted Social Security Earned Income Qualified Annuity Payout Pension Income Rental Net Income Planned Income Less Soc Sec Actual Income Less Soc Sec Guest Social Security Investments Withdrawal Capital Gains QCD Charitable Distributions 401K/IRA Withdrawal ROTH Withdrawal ROTH Funded Extra Expense 401K/IRA Funded Extra Expense Portfolio Withdrawal (%) 401K/IRA to
ROTH Conv		 401K/IRA RMD Federal + OH Total Taxes Fed + OH Tax Today's Value Maximum Federal Tax (%) Top Tax Bracket Full (%) Average Federal Tax (%) Average ROTH Conv Tax (%) MFJ Federal Tax Deduction Single Federal Tax Deduction MFJ OH Tax Exemption Single OH Tax Exemption Federal + OH Base Taxes Capital Gains Tax 401K/IRA to ROTH Taxes Yearly Medical Insurance Cost Private Medical Insurance Medicare B+D Total Premium Medigap Insurance Medicare B+D IRMAA (Each) IRMAA from Roth Conv Ending Investments Ending 401K/IRA Ending ROTH Ending Balance
Problem year Income below target 2062 62.4 243.25 $2,225.13 $100.00 $154,213.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,545.04 $0.00 $183,023.96 $34,811.94 $32.58 $0.00 $0.00 $0.00 $0.00 $0.00 $183,023.96 $34,811.94 $0.00 $2,225.13 $2,125.13 $0.00 $32,586.81 $0.00 $0.00 $0.00 7.39 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $78,325.00 $39,175.00 $11,675.00 $5,850.00 $0.00 $0.00 $0.00 $34,779.36 $2,898.28 $0.00 $0.00 $0.00 No $0.00 $132,171.81 $0.00 $132,171.81
Final year 2089 89.4 473.81 $0.00 $0.00 $251,165.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20,539.63 $0.00 $356,494.04 $63,716.34 $52,180.02 $49,455.84 $0.00 $0.00 $0.00 $0.00 $307,038.20 $14,260.50 $49,455.84 $0.00 $0.00 $0.00 $14,260.50 $0.00 $0.00 $0.00 3.03 $0.00 $19,470.16 $0.00 $0.00 10.00 0.00 0.00 0.00 $167,725.00 $83,875.00 $22,750.00 $11,375.00 $0.00 $0.00 $0.00 $11,536.32 $0.00 $961.36 $0.00 $0.00 No $0.00 $257,444.25 $0.00 $257,444.25
Scenario totals Projection Years Final Guest Age Highest Cumulative Inflation (%) Investments as of Today's Value Final Taxable Basis 401K/IRA as of Today's Value ROTH as of Today's Value Guest HSA as of Today's Value Guest HSA Withdraw Total Guest HSA Returns Total Ending Guest HSA Traditional Investment Returns Total 401K/IRA Returns Total ROTH 401K/IRA Returns Total Ending Income as of Today's Value Total Actual Income Total After Tax & Med Income Total Adjusted Social Security Total Earned Income Annuity Payout Total Pension Income Total Rental Net Income Total Total Planned Income Less Soc Sec Total Actual Income Less Soc Sec Total Guest Social Security Investments Withdraw Total Capital Gains Total Total Charitable Distributions 401K/IRA Withdraw Total ROTH Withdraw Total ROTH Total Extra Expenses 401K/IRA Total Extra Expenses Highest Portfolio Withdrawal (%) 401K/IRA ROTH
Conv Total		 Total 401K/IRA RMD Total Taxes Total Taxes Today's Value Highest Max Fed Tax (%) Highest Top Tax Bracket Full (%) Highest Avg Fed Tax (%) Highest Avg ROTH Conv Tax (%) Final MFJ Federal Tax Deduction Final Single Federal Tax Deduction Final MFJ OH Tax Exemption Final Single OH Tax Exemption Total Taxes From Income Capital Gains Tax Total Taxes From ROTH Conv Total Medical Insurance Cost Private Medical Insurance Total Medicare B+D Total Premium Medigap Insurance Total Medicare B+D IRMAA Total IRMAA from Roth Conv Ending Investments Ending 401K/IRA Ending ROTH Ending Balance
Total 2060-2089 89.4 473.81 $0.00 $0.00 $54,334.91 $0.00 $0.00 $0.00 $0.00 $0.00 $352.29 $458,194.82 $0.00 $75,239.87 $1,462,332.01 $1,026,587.53 $790,249.53 $0.00 $0.00 $0.00 $0.00 $6,857,813.63 $672,082.48 $790,249.53 $2,225.13 $2,125.13 $0.00 $669,857.35 $0.00 $0.00 $0.00 37.91 $0.00 $195,231.41 $43,832.64 $18,697.82 22.00 15.81 10.27 0.00 $43,832.64 $0.00 $0.00 $391,911.84 $0.00 $257,444.25 $0.00 $257,444.25

Income projection detail

2060 60.4 231.53 $1,872.84 $100.00 $469,106.78 $0.00 $0.00 $0.00 $0.00 $0.00 $168.56 $25,568.00 $0.00 $174,204.84 $174,204.84 $119,776.92 $0.00 $0.00 $0.00 $0.00 $0.00 $174,204.84 $174,204.84 $0.00 $0.00 $0.00 $0.00 $174,204.84 $0.00 36.99 $0.00 $0.00 $21,645.00 $9,348.59 22.00 15.81 10.26 0.00 $74,550.00 $37,275.00 $9,950.00 $4,975.00 $21,645.00 $0.00 $0.00 $32,782.92 $2,731.91 $0.00 $0.00 $0.00 No $2,041.40 $320,469.94 $0.00 $322,511.34
2061 61.4 237.32 $2,041.40 $100.00 $320,469.94 $0.00 $0.00 $0.00 $0.00 $0.00 $183.73 $12,303.60 $0.00 $178,559.96 $178,559.96 $122,606.00 $0.00 $0.00 $0.00 $0.00 $0.00 $178,559.96 $178,559.96 $0.00 $0.00 $0.00 $0.00 $178,559.96 $0.00 37.91 $0.00 $0.00 $22,187.64 $9,349.23 22.00 15.81 10.27 0.00 $76,425.00 $38,200.00 $10,200.00 $5,100.00 $22,187.64 $0.00 $0.00 $33,766.32 $2,813.86 $0.00 $0.00 $0.00 No $2,225.13 $154,213.58 $0.00 $156,438.71
2062 62.4 243.25 $2,225.13 $100.00 $154,213.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,545.04 $0.00 $183,023.96 $34,811.94 $32.58 $0.00 $0.00 $0.00 $0.00 $0.00 $183,023.96 $34,811.94 $0.00 $2,225.13 $2,125.13 $0.00 $32,586.81 $0.00 7.39 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $78,325.00 $39,175.00 $11,675.00 $5,850.00 $0.00 $0.00 $0.00 $34,779.36 $2,898.28 $0.00 $0.00 $0.00 No $0.00 $132,171.81 $0.00 $132,171.81
2063 63.4 249.33 $0.00 $0.00 $132,171.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,808.67 $0.00 $187,599.56 $7,504.38 $-28,318.38 $0.00 $0.00 $0.00 $0.00 $0.00 $187,599.56 $7,504.38 $0.00 $0.00 $0.00 $0.00 $7,504.38 $0.00 1.59 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $80,275.00 $40,150.00 $11,975.00 $5,975.00 $0.00 $0.00 $0.00 $35,822.76 $2,985.23 $0.00 $0.00 $0.00 No $0.00 $135,476.10 $0.00 $135,476.10
2064 64.4 255.57 $0.00 $0.00 $135,476.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,078.88 $0.00 $192,289.55 $7,691.98 $-29,205.38 $0.00 $0.00 $0.00 $0.00 $0.00 $192,289.55 $7,691.98 $0.00 $0.00 $0.00 $0.00 $7,691.98 $0.00 1.63 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $82,300.00 $41,150.00 $12,275.00 $6,125.00 $0.00 $0.00 $0.00 $36,897.36 $3,074.78 $0.00 $0.00 $0.00 No $0.00 $138,863.00 $0.00 $138,863.00
2065 65.4 261.96 $0.00 $0.00 $138,863.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,355.86 $0.00 $197,096.79 $7,884.28 $1,506.16 $0.00 $0.00 $0.00 $0.00 $0.00 $197,096.79 $7,884.28 $0.00 $0.00 $0.00 $0.00 $7,884.28 $0.00 1.67 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $92,725.00 $46,375.00 $12,575.00 $6,275.00 $0.00 $0.00 $0.00 $6,378.12 $0.00 $531.51 $0.00 $0.00 No $0.00 $142,334.58 $0.00 $142,334.58
2066 66.4 268.51 $0.00 $0.00 $142,334.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,639.75 $0.00 $202,024.21 $8,081.39 $1,543.79 $0.00 $0.00 $0.00 $0.00 $0.00 $202,024.21 $8,081.39 $0.00 $0.00 $0.00 $0.00 $8,081.39 $0.00 1.72 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $95,050.00 $47,525.00 $12,900.00 $6,450.00 $0.00 $0.00 $0.00 $6,537.60 $0.00 $544.80 $0.00 $0.00 No $0.00 $145,892.94 $0.00 $145,892.94
2067 67.4 275.22 $0.00 $0.00 $145,892.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,930.75 $0.00 $207,074.82 $8,283.42 $1,582.38 $0.00 $0.00 $0.00 $0.00 $0.00 $207,074.82 $8,283.42 $0.00 $0.00 $0.00 $0.00 $8,283.42 $0.00 1.76 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $97,425.00 $48,725.00 $13,200.00 $6,600.00 $0.00 $0.00 $0.00 $6,701.04 $0.00 $558.42 $0.00 $0.00 No $0.00 $149,540.27 $0.00 $149,540.27
2068 68.4 282.10 $0.00 $0.00 $149,540.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,229.01 $0.00 $212,251.69 $8,490.51 $1,621.95 $0.00 $0.00 $0.00 $0.00 $0.00 $212,251.69 $8,490.51 $0.00 $0.00 $0.00 $0.00 $8,490.51 $0.00 1.80 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $99,875.00 $49,925.00 $13,550.00 $6,775.00 $0.00 $0.00 $0.00 $6,868.56 $0.00 $572.38 $0.00 $0.00 No $0.00 $153,278.77 $0.00 $153,278.77
2069 69.4 289.15 $0.00 $0.00 $153,278.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,534.74 $0.00 $217,557.98 $8,702.77 $1,662.49 $0.00 $0.00 $0.00 $0.00 $0.00 $217,557.98 $8,702.77 $0.00 $0.00 $0.00 $0.00 $8,702.77 $0.00 1.85 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $102,350.00 $51,175.00 $13,875.00 $6,950.00 $0.00 $0.00 $0.00 $7,040.28 $0.00 $586.69 $0.00 $0.00 No $0.00 $157,110.74 $0.00 $157,110.74
2070 70.4 296.38 $0.00 $0.00 $157,110.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,848.11 $0.00 $222,996.93 $39,856.34 $32,640.02 $30,936.00 $0.00 $0.00 $0.00 $0.00 $192,060.93 $8,920.34 $30,936.00 $0.00 $0.00 $0.00 $8,920.34 $0.00 1.89 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $104,925.00 $52,450.00 $14,225.00 $7,125.00 $0.00 $0.00 $0.00 $7,216.32 $0.00 $601.36 $0.00 $0.00 No $0.00 $161,038.51 $0.00 $161,038.51
2071 71.4 303.79 $0.00 $0.00 $161,038.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13,169.31 $0.00 $228,571.85 $40,852.75 $33,456.07 $31,709.40 $0.00 $0.00 $0.00 $0.00 $196,862.45 $9,143.35 $31,709.40 $0.00 $0.00 $0.00 $9,143.35 $0.00 1.94 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $107,550.00 $53,775.00 $14,575.00 $7,300.00 $0.00 $0.00 $0.00 $7,396.68 $0.00 $616.39 $0.00 $0.00 No $0.00 $165,064.47 $0.00 $165,064.47
2072 72.4 311.39 $0.00 $0.00 $165,064.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13,498.54 $0.00 $234,286.15 $41,874.07 $34,292.47 $32,502.14 $0.00 $0.00 $0.00 $0.00 $201,784.01 $9,371.93 $32,502.14 $0.00 $0.00 $0.00 $9,371.93 $0.00 1.99 $0.00 $0.00 $0.00 $0.00 10.00 0.00 0.00 0.00 $110,225.00 $55,125.00 $14,950.00 $7,475.00 $0.00 $0.00 $0.00 $7,581.60 $0.00 $631.80 $0.00 $0.00 No $0.00 $169,191.08 $0.00 $169,191.08
2073 73.4 319.17 $0.00 $0.00 $169,191.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13,836.01 $0.00 $240,143.30 $42,920.91 $35,149.71 $33,314.69 $0.00 $0.00 $0.00 $0.00 $206,828.61 $9,606.22 $33,314.69 $0.00 $0.00 $0.00 $9,606.22 $0.00 2.04 $0.00 $6,384.57 $0.00 $0.00 10.00 0.00 0.00 0.00 $112,975.00 $56,500.00 $15,325.00 $7,650.00 $0.00 $0.00 $0.00 $7,771.20 $0.00 $647.60 $0.00 $0.00 No $0.00 $173,420.87 $0.00 $173,420.87
2074 74.4 327.15 $0.00 $0.00 $173,420.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14,181.91 $0.00 $246,146.88 $43,993.95 $36,028.47 $34,147.56 $0.00 $0.00 $0.00 $0.00 $211,999.32 $9,846.39 $34,147.56 $0.00 $0.00 $0.00 $9,846.39 $0.00 2.09 $0.00 $6,800.82 $0.00 $0.00 10.00 0.00 0.00 0.00 $115,800.00 $57,900.00 $15,700.00 $7,850.00 $0.00 $0.00 $0.00 $7,965.48 $0.00 $663.79 $0.00 $0.00 No $0.00 $177,756.39 $0.00 $177,756.39
2075 75.4 335.33 $0.00 $0.00 $177,756.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14,536.45 $0.00 $252,300.55 $45,093.79 $36,929.23 $35,001.24 $0.00 $0.00 $0.00 $0.00 $217,299.31 $10,092.55 $35,001.24 $0.00 $0.00 $0.00 $10,092.55 $0.00 2.14 $0.00 $7,225.87 $0.00 $0.00 10.00 0.00 0.00 0.00 $118,700.00 $59,350.00 $16,100.00 $8,050.00 $0.00 $0.00 $0.00 $8,164.56 $0.00 $680.38 $0.00 $0.00 No $0.00 $182,200.29 $0.00 $182,200.29
2076 76.4 343.71 $0.00 $0.00 $182,200.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14,899.87 $0.00 $258,608.06 $46,221.13 $37,852.45 $35,876.28 $0.00 $0.00 $0.00 $0.00 $222,731.78 $10,344.85 $35,876.28 $0.00 $0.00 $0.00 $10,344.85 $0.00 2.20 $0.00 $7,687.78 $0.00 $0.00 10.00 0.00 0.00 0.00 $121,675.00 $60,825.00 $16,500.00 $8,250.00 $0.00 $0.00 $0.00 $8,368.68 $0.00 $697.39 $0.00 $0.00 No $0.00 $186,755.31 $0.00 $186,755.31
2077 77.4 352.30 $0.00 $0.00 $186,755.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15,272.36 $0.00 $265,073.26 $47,376.67 $38,798.83 $36,773.18 $0.00 $0.00 $0.00 $0.00 $228,300.08 $10,603.49 $36,773.18 $0.00 $0.00 $0.00 $10,603.49 $0.00 2.25 $0.00 $8,155.25 $0.00 $0.00 10.00 0.00 0.00 0.00 $124,725.00 $62,350.00 $16,900.00 $8,450.00 $0.00 $0.00 $0.00 $8,577.84 $0.00 $714.82 $0.00 $0.00 No $0.00 $191,424.18 $0.00 $191,424.18
2078 78.4 361.11 $0.00 $0.00 $191,424.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15,654.17 $0.00 $271,700.09 $48,561.07 $39,768.79 $37,692.51 $0.00 $0.00 $0.00 $0.00 $234,007.58 $10,868.56 $37,692.51 $0.00 $0.00 $0.00 $10,868.56 $0.00 2.31 $0.00 $8,701.10 $0.00 $0.00 10.00 0.00 0.00 0.00 $127,825.00 $63,925.00 $17,325.00 $8,675.00 $0.00 $0.00 $0.00 $8,792.28 $0.00 $732.69 $0.00 $0.00 No $0.00 $196,209.79 $0.00 $196,209.79
2079 79.4 370.14 $0.00 $0.00 $196,209.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16,045.53 $0.00 $278,492.59 $49,775.10 $40,762.98 $38,634.82 $0.00 $0.00 $0.00 $0.00 $239,857.77 $11,140.28 $38,634.82 $0.00 $0.00 $0.00 $11,140.28 $0.00 2.37 $0.00 $9,299.04 $0.00 $0.00 10.00 0.00 0.00 0.00 $131,025.00 $65,525.00 $17,775.00 $8,875.00 $0.00 $0.00 $0.00 $9,012.12 $0.00 $751.01 $0.00 $0.00 No $0.00 $201,115.04 $0.00 $201,115.04
2080 80.4 379.39 $0.00 $0.00 $201,115.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16,446.66 $0.00 $285,454.90 $51,019.49 $41,782.01 $39,600.70 $0.00 $0.00 $0.00 $0.00 $245,854.20 $11,418.79 $39,600.70 $0.00 $0.00 $0.00 $11,418.79 $0.00 2.42 $0.00 $9,956.19 $0.00 $0.00 10.00 0.00 0.00 0.00 $134,300.00 $67,150.00 $18,200.00 $9,100.00 $0.00 $0.00 $0.00 $9,237.48 $0.00 $769.79 $0.00 $0.00 No $0.00 $206,142.91 $0.00 $206,142.91
2081 81.4 388.88 $0.00 $0.00 $206,142.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16,857.83 $0.00 $292,591.27 $52,294.97 $42,826.61 $40,590.71 $0.00 $0.00 $0.00 $0.00 $252,000.56 $11,704.26 $40,590.71 $0.00 $0.00 $0.00 $11,704.26 $0.00 2.49 $0.00 $10,625.92 $0.00 $0.00 10.00 0.00 0.00 0.00 $137,675.00 $68,825.00 $18,675.00 $9,325.00 $0.00 $0.00 $0.00 $9,468.36 $0.00 $789.03 $0.00 $0.00 No $0.00 $211,296.48 $0.00 $211,296.48
2082 82.4 398.60 $0.00 $0.00 $211,296.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17,279.28 $0.00 $299,906.05 $53,602.34 $43,897.22 $41,605.48 $0.00 $0.00 $0.00 $0.00 $258,300.57 $11,996.86 $41,605.48 $0.00 $0.00 $0.00 $11,996.86 $0.00 2.55 $0.00 $11,421.43 $0.00 $0.00 10.00 0.00 0.00 0.00 $141,100.00 $70,550.00 $19,125.00 $9,575.00 $0.00 $0.00 $0.00 $9,705.12 $0.00 $808.76 $0.00 $0.00 No $0.00 $216,578.90 $0.00 $216,578.90
2083 83.4 408.56 $0.00 $0.00 $216,578.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17,711.26 $0.00 $307,403.70 $54,942.41 $44,994.65 $42,645.62 $0.00 $0.00 $0.00 $0.00 $264,758.08 $12,296.79 $42,645.62 $0.00 $0.00 $0.00 $12,296.79 $0.00 2.61 $0.00 $12,236.10 $0.00 $0.00 10.00 0.00 0.00 0.00 $144,625.00 $72,325.00 $19,600.00 $9,800.00 $0.00 $0.00 $0.00 $9,947.76 $0.00 $828.98 $0.00 $0.00 No $0.00 $221,993.37 $0.00 $221,993.37
2084 84.4 418.78 $0.00 $0.00 $221,993.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18,154.04 $0.00 $315,088.79 $56,315.97 $46,119.57 $43,711.76 $0.00 $0.00 $0.00 $0.00 $271,377.03 $12,604.21 $43,711.76 $0.00 $0.00 $0.00 $12,604.21 $0.00 2.68 $0.00 $13,213.89 $0.00 $0.00 10.00 0.00 0.00 0.00 $148,250.00 $74,125.00 $20,100.00 $10,050.00 $0.00 $0.00 $0.00 $10,196.40 $0.00 $849.70 $0.00 $0.00 No $0.00 $227,543.20 $0.00 $227,543.20
2085 85.4 429.25 $0.00 $0.00 $227,543.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18,607.89 $0.00 $322,966.01 $57,723.86 $47,272.58 $44,804.55 $0.00 $0.00 $0.00 $0.00 $278,161.46 $12,919.31 $44,804.55 $0.00 $0.00 $0.00 $12,919.31 $0.00 2.74 $0.00 $14,221.45 $0.00 $0.00 10.00 0.00 0.00 0.00 $151,950.00 $75,975.00 $20,600.00 $10,300.00 $0.00 $0.00 $0.00 $10,451.28 $0.00 $870.94 $0.00 $0.00 No $0.00 $233,231.78 $0.00 $233,231.78
2086 86.4 439.98 $0.00 $0.00 $233,231.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $19,073.09 $0.00 $331,040.16 $59,166.96 $48,454.32 $45,924.67 $0.00 $0.00 $0.00 $0.00 $285,115.49 $13,242.29 $45,924.67 $0.00 $0.00 $0.00 $13,242.29 $0.00 2.81 $0.00 $15,344.20 $0.00 $0.00 10.00 0.00 0.00 0.00 $155,750.00 $77,875.00 $21,125.00 $10,550.00 $0.00 $0.00 $0.00 $10,712.64 $0.00 $892.72 $0.00 $0.00 No $0.00 $239,062.58 $0.00 $239,062.58
2087 87.4 450.98 $0.00 $0.00 $239,062.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $19,549.92 $0.00 $339,316.16 $60,646.14 $49,665.66 $47,072.78 $0.00 $0.00 $0.00 $0.00 $292,243.38 $13,573.36 $47,072.78 $0.00 $0.00 $0.00 $13,573.36 $0.00 2.88 $0.00 $16,601.57 $0.00 $0.00 10.00 0.00 0.00 0.00 $159,650.00 $79,825.00 $21,650.00 $10,825.00 $0.00 $0.00 $0.00 $10,980.48 $0.00 $915.04 $0.00 $0.00 No $0.00 $245,039.14 $0.00 $245,039.14
2088 88.4 462.25 $0.00 $0.00 $245,039.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20,038.66 $0.00 $347,799.06 $62,162.28 $50,907.36 $48,249.60 $0.00 $0.00 $0.00 $0.00 $299,549.46 $13,912.68 $48,249.60 $0.00 $0.00 $0.00 $13,912.68 $0.00 2.95 $0.00 $17,886.07 $0.00 $0.00 10.00 0.00 0.00 0.00 $163,650.00 $81,825.00 $22,200.00 $11,100.00 $0.00 $0.00 $0.00 $11,254.92 $0.00 $937.91 $0.00 $0.00 No $0.00 $251,165.12 $0.00 $251,165.12
2089 89.4 473.81 $0.00 $0.00 $251,165.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20,539.63 $0.00 $356,494.04 $63,716.34 $52,180.02 $49,455.84 $0.00 $0.00 $0.00 $0.00 $307,038.20 $14,260.50 $49,455.84 $0.00 $0.00 $0.00 $14,260.50 $0.00 3.03 $0.00 $19,470.16 $0.00 $0.00 10.00 0.00 0.00 0.00 $167,725.00 $83,875.00 $22,750.00 $11,375.00 $0.00 $0.00 $0.00 $11,536.32 $0.00 $961.36 $0.00 $0.00 No $0.00 $257,444.25 $0.00 $257,444.25