Sample 1041 Tax Calculations

Location: http://www.mvps.org/dmcritchie/excel/tax1041.htm Home page: http://www.mvps.org/dmcritchie/excel/excel.htm [View without Frames]

An example of calculating US Federal Tax for rough approximation. You will have to fix the tables to current tax table, and it may or may not work for you. My own intention was to estimate and double check with with the tables afterwards. It worked each time I think this was for 1996 taxes. Fictitious amounts. http://www.mvps.org/dmcritchie/rexx03/tax1041.htm David McRitchie

	A	B	C	D	E	F	G	H	I
214			using midpoint=	midpoint	24,425.00				= INT(E211/50)*50+25
215	*Tax Table		For Single Taxpayer
216	*Tax Table		PCT in bracket	Lower Limit	+Plus amt.				+Plus amt.
217			.01700	0.00	0.00				0
218	*Tax Table		.02125	20,000.00	(85.00)				-85
219	*Tax Table		.04250	35,000.00	(828.75)				-828.75
220	*Tax Table		.06013	40,000.00	(1,533.95)				-1533.95
221	*Tax Table		0.0658	75,000.00	(1,959.20)				-1959.2
222	*Tax Table			99,999,999.00
223				PCT in use	Tax for Single				Tax for Single
224	*Tax Table		If taxable in 1.7% bracket	*	*				=IF($E$214=D217,INT(E217+C217($E$214)),""),"")
225	*Tax Table		If taxable in 2.125% bracket	1.7000%	434.00				=IF($E$214=D218,INT(E218+C218($E$214)),""),"")
226	*Tax Table		If taxable in 4.250% bracket	**	**				=IF($E$214=D219,INT(E219+C219($E$214)),""),"")
227	*Tax Table		If taxable in 6.6013% bracket	**	**				=IF($E$214=D220,INT(E220+C220($E$214)),""),"")
228	*Tax Table		If taxable in 6.580% bracket	**	**				=IF($E$214=D221,INT(E221+C221($E$214)),""),"")
229	*Tax Table		=IF(taxable=D140,INT(E140+C140(taxable+D140)),""),"")						=IF(E219>=D222&E219<D225,INT(E222+0.28*(E219-D222)),"")
230
231	*Tax Table		For Married Taxpayers
232	*Tax Table		PCT in bracket	Lower Limit	+Plus amt.				+Plus amt.
233	*Tax Table		.02375	20,000.00	(95.00)				-95
234	*Tax Table		.03325	50,000.00	(570.00)				-570
235	*Tax Table		.04750	70,000.00	(1,567.50)				-1567.5
236	*Tax Table		.06175	80,000.00	(2,707.50)				-2707.5
237	*Tax Table		.06650	150,000.00	(3,420.00)				-3420
238	*Tax Table		Design upper limit	99,999,999.00
239				PCT in use	Tax for Married				Tax for Married
240	*Tax Table		If taxable in 2.375% bracket	0.02375	485.00				=IF($E$214=D233,INT(E233+C233($E$214)),""),"")
241	*Tax Table		If taxable in 3.325% bracket	**	**				=IF($E$214=D234,INT(E234+C234($E$214)),""),"")
242	*Tax Table		If taxable in 4.750% bracket	**	**				=IF($E$214=D235,INT(E235+C235($E$214)),""),"")
243	*Tax Table		If taxable in 6.175% bracket	**	**				=IF($E$214=D236,INT(E236+C236($E$214)),""),"")
244	*Tax Table		If taxable in 6.650% bracket	**	**				=IF($E$214=D237,INT(E237+C237($E$214)),""),"")
245	*Tax Table		=IF(taxable=D140,INT(E140+C140(taxable+D140)),""),"")						=IF(E235>=D238&E235<D240,INT(E238+0.28*(E235-D238)),"")
246		single or married tax based on number of exemptions		Single Filer	434.00				=IF(E194=1,MAX(E224:E228),MAX(E240:E245))

XL2HTMLx placed your HTML code seen here in c:\temp\XL2tstx.htm
Intended use is to copy generated lines to another HTML document
Extra space in table use xtra=1, to remove use xtra=0

Please send your comments concerning this web page to: David McRitchie send email comments