Switch To Product Links Languages Themes Feedback Sign Up Now
Loading...
Updating...
Please wait to edit...
Ready for editing X
Non-Deductible IRA Or Taxable by thefinancebuff  635 views
Print Embed in Website/Blog
    $ Macros
 
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
Non-Deductible IRA vs. Taxable Account
Copyright: The Finance Buff
Assumptions
Marginal Tax Rate at Withdrawal28%This spreadsheet compares a non-deductible IRA with a taxable account.
Capital Gains Tax Rate at Withdrawal20%Cells under "Assumptions" in blue are inputs. Feel free to change to your own situation.
Tax Rate on Distributions28%Other cells are calculated. For more info, see
Investment Return8.0%
Distributions in Taxable Account2.0%A Non-Deductible IRA Is Worth It For Me
Number of Years Until Withdrawal30
Calculated FieldsSummary
Return in Taxable after tax on distributions7.4%Advantage of Non-Deductible IRA Over Taxable1.9%
Investment100If this number is positive, a non-deductible IRA is better.
If this number is negative, a taxable account is better.
Non-Deductible IRA
Value at withdrawal, before tax1,006.27
Cost Basis100.00
Taxable amount on withdrawal906.27
Income tax on withdrawal(253.75)
Value at withdrawal, after tax752.51
Taxable Account
Value at Retirement, before capital gains tax860.95
Cost Basis247.28
Capital Gains613.67
Capital gains tax(122.73)
Value at withdrawal, after capital gains tax738.22