税金見積もりテンプレート

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	2022 Federal tax params (joint)				2022 Federal tax params (separate)				2021 CA tax params (joint)				2021 CA tax params (separate)
2	From	Rate	Base		From	Rate	Base		From	Rate	Base		From	Rate	Base
3	0	10.00%	0		-1	10.00%	0		0	1.00%	0		0	1.00%	0
4	20550	12.00%	2055		10275	12.00%	1027.6		18650	2.00%	186.5		9325	2.00%	93.25
5	83550	22.00%	9615		41775	22.00%	4807.6		44214	4.00%	697.78		22107	4.00%	348.89
6	178150	24.00%	30427		89075	24.00%	15213.6		69784	6.00%	1720.58		34892	6.00%	860.29
7	340100	32.00%	69295		170050	32.00%	34647.6		96870	8.00%	3345.74		48435	8.00%	1672.87
8	431900	35.00%	98671		215950	35.00%	49335.6		122428	9.30%	5390.38		61214	9.30%	2695.19
9	647850	37.00%	174253.5		539900	37.00%	162718.1		625372	10.30%	52164.17		312686	10.30%	26082.09
10									750442	11.30%	65046.38		375221	11.30%	32523.19
11	STD deduction	25900			STD deduction	12950			1250738	12.30%	121579.83		625369	12.30%	60789.92
12
13	AMT Table								STD deduction	9606			STD deduction	4803
14	From	Rate	Base		From	Rate	Base		Exemption Credit	258			Exemption Credit	129
15	0	26.00%	0		0	26.00%	0		Ex Credit PhOut	424581			Ex Credit PhOut	212288
16	206100	28.00%	53586		103050	28.00%	26793
17
18	LTCG tax table
19	From	Rate	Base		From	Rate	Base
20	0	0.00%	0		-1	0.00%	0
21	83350	15.00%	0		41675	15.00%	0
22	517200	20.00%	65077.5		258600	20.00%	32539
23
24	AMT exemption	118100			AMT exemption	75900
25
26		Wage	ODiv/Int/STCG	QFD-Div/LTCG	Other I/L	Pretax Contrib	AGI	Item'd deduction	Actual Deduction	Taxable Income	Marginal Rate	Credit	AMT income-exe	AnlMedTax/NIIT	LTCG M'nl Rate	LTCG Tax	CA Credit
27	Alice	230400	1000	0		32800	198600	5000	12950	185650	32.00%	2000	122700	987	15.00%	0	129
28	Bob	5000	10000	30000		0	45000	577	12950	2050	10.00%	0	0	0	0.00%	0	129
29	joint	N/A	11000	30000	N/A	N/A	243600	10000	25900	187700	24.00%	2000	125500	0	15.00%	2000	258
30
31	Tax estimate
32		Fed Tax joint	Fed AMT joint	Fed Tax separate	Fed AMT separate		CA adjustment	CA Marginal Rate	CA tax joint	CA tax separate		Fed effective rate	CA effective rate	Effective Rate
33	Alice	N/A	N/A	38626	31282		7300	9.30%	N/A	15575		16.69%	6.73%	23.42%
34	Bob	N/A	N/A	205	0			6.00%	N/A	1050		0.46%	2.33%	2.79%
35	joint	32719	24830	38831	N/A		7300	9.30%	16187	16625		11.84%	5.86%	17.69%
36		49344
37	Withholding estimate
38		Remaining Pays	2017 Tax	Fed Needed	Fed WH YTD	Fed WH Base	Fed WH added	Fed WH est	Fed WH to add
39	Alice	12		36502	20648	1724	0	41332	0
40	Bob	12		-835	3868	322	0	7735	0
41	joint	N/A	69300	30919	N/A	N/A	N/A	49068	0
42
43		Remaining Pays	2017 Tax	CA Needed	CA WH YTD	CA WH Base	CA WH added	CA WH est	CA WH to add
44	Alice	12		14719	10245	854	0	20490	0
45	Bob	12		577	2715	226	0	5430	0
46	joint	N/A	27500	15711	N/A	N/A	N/A	25920	0
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