ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
www.MSOfficeGeek.com
3
Traditional IRA Calculator
4
(Excel, OpenOffice Calc & Google Sheet)
5
6
Span of IRATraditiona IRA Contribution
7
Current Age (Years):53Yearly:$1,500.00
8
Retirement Age (Years):65Monthly:$125.00
9
IRA Duration (Years):12Rate of Return:10%
10
Withdrawal Years:5Tax Rate During Retirement:20%
11
Traditioan IRA Calculations
12
Value at the end of Conribution Period:$35,284.07Yearly Taxes On IRA Withdrawal:$1,692.34
13
Yearly Withdrawal Amount:$8,461.68Net IRA amount received Yearly:$6,769.34
14
15
Traditional IRA ScheduleTraditional IRA Summary
16
YearContributionInterestBalanceTotal Contribution:$18,000.00
17
0$0.00$0.00$0.00Total Interest Earned:$24,308.40
18
1$1,500.00$150.00$1,650.00Total IRA Amount:$42,308.40
19
2$1,500.00$315.00$3,465.00Total Taxes During Withdrawal:$8,461.68
20
3$1,500.00$496.50$5,461.50Net IRA Amount:$33,846.72
21
4$1,500.00$696.15$7,657.65
22
5$1,500.00$915.77$10,073.42
23
6$1,500.00$1,157.34$12,730.76
24
7$1,500.00$1,423.08$15,653.83
25
8$1,500.00$1,715.38$18,869.22
26
9$1,500.00$2,036.92$22,406.14
27
10$1,500.00$2,390.61$26,296.75
28
11$1,500.00$2,779.68$30,576.43
29
12$1,500.00$3,207.64$35,284.07
30
Traditional IRA Withdrawal Schedule
31
1-$8,461.68$2,682.24$29,504.63
32
2-$8,461.68$2,104.29$23,147.24
33
3-$8,461.68$1,468.56$16,154.12
34
4-$8,461.68$769.24$8,461.68
35
5-$8,461.68$0.00$0.00
36
5
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100