Tax and investment strategies example

	A	B	C	D	E	F	G	H	I	J	K	L
1	Not bundling
2	Year	Income	charity	Retirement	itemized deduction	Standard deduction	Taxable income	Taxes paid			Total taxes paid	Additional available to donate
3	1	140,000	14,000	10,000	24,000	24,800	115,200	44,185
4	2	140,000	14,000	10,000	24,000	24,800	115,200	44,185
5	3	140,000	14,000	10,000	24,000	24,800	115,200	44,185
6											132,555	0
7
8
9	Bundling
10	Year	Income	charity	Retirement	itemized deduction	Standard deduction	Taxable income	Taxes paid			Total taxes paid
11	1	140,000	0	10,000	10,000	24,800	115,200	44,185
12	2	140,000	0	10,000	10,000	24,800	115,200	44,185
13	3	140,000	42,000	10,000	52,000	24,800	88,000	16,985
14											105,355	27,200
15
16
17	Bundling + investing
18	Year	Income	Amount invested	Investment growth	charity (amount invested)	Retirement	itemized deduction	Standard deduction	Taxable income	Taxes paid	Total taxes paid
19	1	140,000	14,000	7%	0	10,000	10,000	24,800	115,200	44,185
20	2	140,000	14,000	7%	0	10,000	10,000	24,800	115,200	44,185
21	3	140,000	14,000	7%	44,940	10,000	54,940	24,800	85,060	14,045
22											102,415	30,140
23
24
25
26
27
28
29
30
31
32
33
34
35
36
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