estimated-tax

	A	B	C	D
1	Instructions to use the spreadsheet
2
3	Click file of the google sheets (not of the browser).
4	Select “make a copy”.
5	Edit the “name”.
6	Select “folder” where to be copied.
7	Use the copy
8
9	Input
10
11	Filing status	Married filing separately	Nonresidents cannot file jointly or as head of household
12	Residency	Nonresident
13	Gross income	$127,530	Add all of your w-2's box 1 amounts
14	Itemized deduction amount		Only when it is greater than the standard deduction
15	Credit		Chid credit etc. Put 0 if you do not know.
16	Total withholding	78793	Add all of your w-2's box 2 amounts
17
18	Output
19
20	Standard deduction	$0
21	Greater of the standard deduction and itemization deduction	$0
22	Taxable income	$127,530
23	Tax table range	A53:C59
24	Tax bracket level	4
25	Last dollar tax rate (maximum or marginal)	24%
26	Bottom of of the tax bracket	$103,350
27	Base tax amount on income at the lower bound of taxable income bracket	$17,651
28	Total tax	$23,454
29	The bottom line: tax owed (+) or refund (-)	-$55,339
30
31	Schedule X -- If your filing status is Single	$15,000	Standard deduction for the status
32	Rate	Bottom of bracket	Base amount	Additional amount = Rate x (Taxable Income - Bottom of bracket)
33	10%	$0	$0.00	plus 10% of the excess over $0
34	12%	$11,925	$1,192.50	plus 12% of the excess over $11,925
35	22%	$48,475	$5,578.50	plus 22% of the excess over $48,475
36	24%	$103,350	$17,651.00	plus 24% of the excess over $103,350
37	32%	$197,300	$40,199.00	plus 32% of the excess over $197,300
38	35%	$250,525	$57,231.00	plus 35% of the excess over $250,525
39	37%	$626,350	$188,769.75	plus 37% of the excess over $626,350
40
41	Schedule Y-1 -- If your filing status is Married filing jointly or Qualifying widow(er)	$30,000	Standard deduction for the status
42	Rate	Bottom of bracket	Base amount	Additional amount = Rate x (Taxable Income - Bottom of bracket)
43	10%	$0	$0.00	plus 10% of the excess over $0
44	12%	$23,850	$2,385.00	plus 12% of the excess over $23,850
45	22%	$96,950	$11,157.00	plus 22% of the excess over $96,950
46	24%	$206,700	$35,302.00	plus 24% of the excess over $206,700
47	32%	$394,600	$80,398.00	plus 32% of the excess over $394,600
48	35%	$501,050	$114,462.00	plus 35% of the excess over $501,050
49	37%	$751,600	$202,154.50	plus 37% of the excess over $751,600
50
51	Schedule Y-2 -- If your filing status is Married filing separately	$15,000	Standard deduction for the status
52	Rate	Bottom of bracket	Base amount	Additional amount = Rate x (Taxable Income - Bottom of bracket)
53	10%	$0	$0.00	plus 10% of the excess over $0
54	12%	$11,925	$1,192.50	plus 12% of the excess over $11,925
55	22%	$48,475	$5,578.50	plus 22% of the excess over $48,475
56	24%	$103,350	$17,651.00	plus 24% of the excess over $103,350
57	32%	$197,300	$40,199.00	plus 32% of the excess over $197,300
58	35%	$250,525	$57,231.00	plus 35% of the excess over $250,525
59	37%	$365,600	$97,507.25	plus 37% of the excess over $365,600
60
61	Schedule Z -- If your filing status is Head of household	$22,500	Standard deduction for the status
62	Rate	Bottom of bracket	Base amount	Additional amount = Rate x (Taxable Income - Bottom of bracket)
63	10%	$0	$0.00	plus 10% of the excess over $0
64	12%	$17,000	$1,700.00	plus 12% of the excess over $17,000
65	22%	$64,850	$7,442.00	plus 22% of the excess over $64,850
66	24%	$103,350	$15,912.00	plus 24% of the excess over $103,350
67	32%	$197,300	$38,460.00	plus 32% of the excess over $197,300
68	35%	$250,500	$55,484.00	plus 35% of the excess over $250,500
69	37%	$609,350	$181,081.50	plus 37% of the excess over $609,350
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