NTTC Full Answer Sheet.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	2024 Workbook Using Practice Lab 2024	Line #	Allman	Allman (2)	Baxter	Baxter (2)	Caramel	Caramel(2)	Davis	Davis (2)	Egret	Egret (2)
2			Core	Core	Core	Core	Core	Core	Core	Core	Core	Core

3	Filing status		S	S	S	S	MFJ	MFJ	HOH	HOH	MFJ	S
4	Wages, etc.	1z	61,686	61,686	27,567	27,567	0	0	25,000	25,000	0	0
5	Tax-Exempt Interest	2a	0	0	0	100	0	0	0	0	0	0
6	Taxable Interest	2b	0	116	0	3,200	0	0	0	0	1	0
7	Qualified Dividends	3a	0	120	0	0	0	0	0	0	0	0
8	Ordinary Dividends	3b	0	120	0	0	0	0	0	0	0	0
9	IRA Distributions	4a	0	0	0	0	0	0	0	12,000	0	12,000
10	Taxable IRA Distributions	4b	0	0	0	0	0	0	0	0	0	12,000
11	Pensions and Annuities	5a	0	0	0	0	0	25,800	0	0	0	22,097
12	Taxable Pensions & Annuities	5b	0	0	0	0	0	25,800	0	0	0	20,001
13	Social Security	6a	0	0	0	0	43,240	43,240	26,000	26,000	26,000	26,000
14	Taxable Social Security	6b	0	0	0	0	0	9,332	7,900	7,900	0	13,851
15	Capital Gain or (Loss)	7	0	0	0	0	0	500	0	0	0	0
16	*Sch 1 line 10 Additional Income	8	0	0	0	7,500	0	1,500	0	0	0	0	from Sch 1 line 10
17	Total Income	9	61,686	61,922	27,567	38,267	0	37,132	32,900	32,900	1	45,852	calculated
18	*Sch 1 line 26 Adjustments	10	0	2,500	0	20	0	1,500	0	0	0	0	from Sch 1 line 26
19	AGI	11	61,686	59,422	27,567	38,247	0	35,632	32,900	32,900	1	45,852	calculated
20	Standard/ Itemized Deductions	12	14,600	14,600	14,600	14,600	33,850	33,850	23,850	23,850	30,750	22,700
21	Qualified Business Income Ded	13	0	0	0	0	0	0	0	0	0	0
22	Taxable income	15	47,086	44,822	12,967	23,647	0	1,782	9,050	9,050	0	23,152	calculated
23	Tax	16	5,417	5,135	1,325	2,603	0	179	908	908	0	2,549
24	Excess APTC (Sch 2)	17	0	0	0	0	0	0	0	0	0	0
25	Child/dependent tax credits	19	0	0	0	0	0	0	908	778	0	0
26	*Sch 3 Nonrefundable Credits	20	0	300	200	500	0	0	0	130	0	0	from Sch 3 line 8
27	*Sch 2 line 21 Other Taxes	23	0	0	0	0	0	212	0	0	0	0	from Sch 2 line 21
28	Total tax	24	5,417	4,835	1,125	2,103	0	391	0	0	0	2,549	calculated
29	Federal Tax Withheld	25d	5,236	5,236	1,400	2,150	120	120	500	500	0	600
30	Estimated tax payments	26	0	0	0	0	0	300	0	0	0	0
31	EIC	27	0	0	0	0	0	0	2,582	2,582	0	0
32	Additional Child Tax Credit	28	0	0	0	0	0	0	1,092	1,222	0	0
33	American Opportunity Credit	29	0	0	0	0	0	0	0	0	0	0
34	*Sch 3 Credits/Payments	31	0	0	0	0	0	0	0	297	0	0	from Sch 3 line 15
35	Total payments	33	5,236	5,236	1,400	2,150	120	420	4,174	4,601	0	600	calculated
36	Amount Overpaid(Refund)	34		401	275	47	120	29	4,174	4,601			calculated
37	Amount You Want Refunded	35a	0	401	275	47	120	29	4,174	4,601	0	0
38	Amount You Owe	37	-181								0	-1,949	calculated
39	*Sch 1 Taxable Refund	S1-1	0	0	0	0	0	0	0	0	0	0
40	Alimony received	S1-2a	0	0	0	0	0	0	0	0	0	0
41	Schedule C	S1-3	0	0	0	0	0	1,500	0	0	0	0
42	Sch. C Expenses	S1-3	0	0	0	0	0	500	0	0	0	0
43	Rent, royalty	S1-5	0	0	0	0	0	0	0	0	0	0
44	Unemployment	S1-7	0	0	0	7,500	0	0	0	0	0	0
45	Other income (total line 8)	S1-9	0	0	0	0	0	0	0	0	0	0
46	Total Additional Income	S1-10	0	0	0	7,500	0	1,500	0	0	0	0	calculated
47	Educator Expense	S1-11	0	0	0	0	0	0	0	0	0	0
48	Health Savings Account Ded	S1-13	0	0	0	0	0	0	0	0	0	0
49	Ded Part of SE tax	S1-15	0	0	0	0	0	106	0	0	0	0	calculated
50	Self Employment Health Ins	S1-17	0	0	0	0	0	1,394	0	0	0	0
51	Penalty early withdrawal	S1-18	0	0	0	0	0	0	0	0	0	0
52	Alimony paid	S1-19a	0	0	0	0	0	0	0	0	0	0
53	IRA deduction	S1-20	0	0	0	20	0	0	0	0	0	0
54	Student Loan Interest	S1-21	0	2,500	0	0	0	0	0	0	0	0
55	Jury duty pay to employer	S1-24a	0	0	0	0	0	0	0	0	0	0
56	Total Adjustments	S1-26	0	2,500	0	20	0	1,500	0	0	0	0	calculated
57	*Sch 2 Self Employment Tax	S2-4	0	0	0	0	0	212	0	0	0	0	calculated
58	Unreported SS tax	S2-5	0	0	0	0	0	0	0	0	0	0
59	Additional Tax on IRAs, etc.	S2-8	0	0	0	0	0	0	0	0	0	0
60	Repayment of FTHBC	S2-10	0	0	0	0	0	0	0	0	0	0
61	Total other taxes	S2-21	0	0	0	0	0	212	0	0	0	0	calculated
62	*Sch 3 Foreign Tax Credit	S3-1	0	0	0	0	0	0	0	0	0	0
63	Child & Dependent Care	S3-2	0	0	0	0	0	0	0	130	0	0
64	Education Credit - F8863	S3-3	0	0	0	300	0	0	0	0	0	0
65	Retirement Savings Credit	S3-4	0	0	200	200	0	0	0	0	0	0
66	Residential energy Credits	S3-5b	0	300	0	0	0	0	0	0	0	0
67	Other nonrefundable credits	S3-7	0	0	0	0	0	0	0	0	0	0
68	Total nonrefundable credits	S3-8	0	300	200	500	0	0	0	130	0	0	calculated
69	Net Premium Tax Credit	S3-9	0	0	0	0	0	0	0	297	0	0
70	Other payments, credits	S3, 10-14	0	0	0	0	0	0	0	0	0	0
71	Total other pymts/refundable credits	S3-15	0	0	0	0	0	0	0	297	0	0	calculated
72	*Schedule A Medical	S A 4	0	0	0	0	4,192	126	0	0	2,096	0
73	Taxes you paid	S A 7	4,470	4,470	900	900	0	0	250	250	0	10,000
74	Interest	S A 10	0	0	0	0	0	0	0	0	0	7,500
75	Gifts to charity	S A 14	0	0	0	0	0	0	0	0	0	5,200
76	Other Itemized Deductions	S A 16	0	0	0	0	0	0	0	0	0	0
77	Total Itemized Deductions	Sch A 17	4,470	4,470	900	900	4,192	126	250	250	2,096	22,700	calculated
78											2023 sales tax zip 28145
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100