{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1040EZ answer key","W2 calculator","Form 1040 EZ calculator","W2 printer","Tax Rate Schedule","Freeware Agreement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1040EZ answer key","index":0,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Instructions:","Blue cells indicate places where changes can be made.",null,null,null,"Other cells are protected so formulas will not be erased."]
[null,"To add or delete rows, click on the appropriate button below. Macros must be enabled for the buttons to work."]
[null,"Clicking the buttons adds rows to the bottom of the list, and deletes them from the bottom of the list."]
[null,"In order for the Form 1040EZ calculator and W2 printer tabs to work properly, last names must be listed in alphabetical order."]
[null,"Once you've set names and gross incomes, copy their completed blue entries to Tax_W2.xls for use in preparing W-2 forms."]
[]
["withholding rate",7.0000000000000007E-2]
["interest",0.01,null,null,null,null,null,10000,35000,"($99,999 max)"]
["line 8a credit","n"]
["standard deduction",6350,null,null,"Adjusted","Standard","Taxable",null,"Earned"]
[null,null,"Gross Income","Interest","Gross","Deduction","Income","Withholding","Income Credit","Total Paid","Tax","Refund","Amount Due"]
["Last name","First name","Line 1","Line 2","Line 4","Line 5","Line 6","Line 7","Line 8a","Line 9","Line 10","Line 13a","Line 14","Adjusted"]
[1,"Student",13164,{"$f":"C13*ROUND($B$8,4)","v":131.64000000000001},{"$f":"+C13+D13","v":13295.64},{"$f":"$B$10","v":6350},{"$f":"IF(E13-F13>0,E13-F13,0)","v":6945.6399999999994},{"$f":"ROUND(C13*ROUND($B$7,4),2)","v":921.48},{"$f":"IF(AND(UPPER($B$9=\"Y\"), C13<13660),IF(K13<=506,K13,506),0)","v":0},{"$f":"H13+I13","v":921.48},{"$f":"ROUND(IF(G13>0,VLOOKUP(N13,TaxTable,3)+(VLOOKUP(N13,TaxTable,2)*(N13-VLOOKUP(N13,TaxTable,1))),0),0)","v":693},{"$f":"IF(J13>K13,J13-K13,\" \")","v":228.48000000000002},{"$f":"IF(K13>J13,K13-J13,\" \")","v":" "},{"$f":"TRUNC(G13,-2)+IF(MOD(G13,100)>50,75,25)","v":6925}]
[2,"Student",25083,{"$f":"C14*ROUND($B$8,4)","v":250.83},25333.83,6350,{"$f":"IF(E14-F14>0,E14-F14,0)","v":18983.830000000002},{"$f":"ROUND(C14*ROUND($B$7,4),2)","v":1755.81},{"$f":"IF(AND(UPPER($B$9=\"Y\"), C14<13660),IF(K14<=506,K14,506),0)","v":0},{"$f":"H14+I14","v":1755.81},{"$f":"ROUND(IF(G14>0,VLOOKUP(N14,TaxTable,3)+(VLOOKUP(N14,TaxTable,2)*(N14-VLOOKUP(N14,TaxTable,1))),0),0)","v":2380},{"$f":"IF(J14>K14,J14-K14,\" \")","v":" "},{"$f":"IF(K14>J14,K14-J14,\" \")","v":624.19000000000005},{"$f":"TRUNC(G14,-2)+IF(MOD(G14,100)>50,75,25)","v":18975}]
[3,"Student",24152,{"$f":"C15*ROUND($B$8,4)","v":241.52},24393.52,6350,{"$f":"IF(E15-F15>0,E15-F15,0)","v":18043.52},{"$f":"ROUND(C15*ROUND($B$7,4),2)","v":1690.64},0,{"$f":"H15+I15","v":1690.64},{"$f":"ROUND(IF(G15>0,VLOOKUP(N15,TaxTable,3)+(VLOOKUP(N15,TaxTable,2)*(N15-VLOOKUP(N15,TaxTable,1))),0),0)","v":2238},{"$f":"IF(J15>K15,J15-K15,\" \")","v":" "},{"$f":"IF(K15>J15,K15-J15,\" \")","v":547.3599999999999},18025]
[4,"Student",15894,158.94,16052.94,6350,9702.94,1112.58,0,1112.58,{"$f":"ROUND(IF(G16>0,VLOOKUP(N16,TaxTable,3)+(VLOOKUP(N16,TaxTable,2)*(N16-VLOOKUP(N16,TaxTable,1))),0),0)","v":993},119.57999999999993," ",9725]
[5,"Student",17722,177.22,17899.22,6350,11549.220000000001,1240.54,0,1240.54,1263," ",22.460000000000036,11525]
[6,"Student",32809,328.09000000000003,33137.089999999997,6350,26787.089999999997,2296.63,0,2296.63,3550," ",1253.3699999999999,26775]
[7,"Student",33389,333.89,33722.89,6350,27372.89,2337.23,0,2337.23,3640," ",1302.77,27375]
[8,"Student",25528,255.28,25783.279999999999,6350,19433.28,1786.96,0,1786.96,2448," ",661.04,19425]
[9,"Student",10882,108.82000000000001,10990.82,6350,4640.82,761.74,0,761.74,463,298.74," ",4625]
[10,"Student",11817,118.17,{"$f":"+C22+D22","v":11935.17},6350,5585.17,827.19,0,827.19,558,269.19000000000005," ",5575]
[11,"Student",23133,231.33,23364.33,6350,17014.330000000002,1619.31,0,1619.31,2088," ",468.69000000000005,17025]
[12,"Student",30113,301.13,30414.13,6350,24064.13,2107.91,0,2107.91,3145," ",1037.0900000000001,24075]
[13,"Student",25491,254.91,25745.91,6350,19395.91,1784.37,0,1784.37,2440," ",655.63000000000011,19375]
[14,"Student",30840,308.40000000000003,31148.400000000001,6350,24798.400000000001,2158.8000000000002,0,2158.8000000000002,3250," ",1091.1999999999998,24775]
[15,"Student",21465,214.65,21679.65,6350,15329.650000000001,1502.55,0,1502.55,1833," ",330.45000000000005,15325]
[16,"Student",14259,142.59,14401.59,6350,8051.59,998.13,0,998.13,808,190.13," ",8075]
[17,"Student",17625,176.25,17801.25,6350,11451.25,1233.75,0,1233.75,1255," ",21.25,11475]
[18,"Student",31646,316.45999999999998,31962.46,6350,25612.46,2215.2199999999998,0,2215.2199999999998,3378," ",1162.7800000000002,25625]
[19,"Student",14978,149.78,15127.78,6350,8777.7800000000007,1048.46,0,1048.46,878,170.46000000000004," ",8775]
[20,"Student",29170,291.7,{"$f":"+C32+D32","v":29461.7},6350,23111.7,2041.9,0,2041.9,3003," ",961.09999999999991,23125]
[21,"Student",31107,311.07,31418.07,6350,25068.07,2177.4899999999998,0,2177.4899999999998,3295," ",1117.5100000000002,25075]
[22,"Student",17355,173.55,17528.55,6350,11178.55,1214.8499999999999,0,1214.8499999999999,1210,4.8499999999999091," ",11175]
[23,"Student",25882,258.82,26140.82,6350,19790.82,1811.74,0,1811.74,2500," ",688.26,19775]
[24,"Student",28854,288.54000000000002,29142.54,6350,22792.54,2019.78,0,2019.78,2950," ",930.22,22775]
[25,"Student",33494,334.94,33828.94,6350,27478.940000000002,2344.58,0,2344.58,3655," ",1310.42,27475]
[26,"Student",28434,284.34000000000003,28718.34,6350,22368.34,1990.38,0,1990.38,2890," ",899.61999999999989,22375]
[27,"Student",20959,209.59,21168.59,6350,14818.59,1467.13,0,1467.13,1758," ",290.86999999999989,14825]
[28,"Student",29406,294.06,29700.06,6350,23350.06,2058.42,0,2058.42,3040," ",981.57999999999993,23375]
[29,"Student",11516,115.16,11631.16,6350,5281.16,806.12,0,806.12,528,278.12," ",5275]
[30,"Student",19046,190.46,{"$f":"+C42+D42","v":19236.46},6350,12886.46,1333.22,0,1333.22,1465," ",131.77999999999997,12875]
[31,"Student",21601,216.01,21817.01,6350,15467.009999999998,1512.07,0,1512.07,1855," ",342.93000000000006,15475]
[32,"Student",20732,207.32,20939.32,6350,14589.32,1451.24,0,1451.24,1720," ",268.76,14575]
[33,"Student",20236,202.36,20438.36,6350,14088.36,1416.52,0,1416.52,1645," ",228.48000000000002,14075]
[34,"Student",31713,317.13,32030.13,6350,25680.13,2219.91,0,2219.91,3385," ",1165.0900000000001,25675]
[35,"Student",18727,187.27,18914.27,6350,12564.27,1310.89,0,1310.89,1420," ",109.1099999999999,12575]
[36,"Student",32344,323.44,32667.439999999999,6350,26317.439999999999,2264.08,0,2264.08,3483," ",1218.92,26325]
[37,"Student",32892,328.92,33220.92,6350,26870.92,2302.44,0,2302.44,3565," ",1262.56,26875]
[38,"Student",31239,312.39,31551.39,6350,25201.39,2186.73,0,2186.73,3318," ",1131.27,25225]
[39,"Student",12530,125.3,12655.3,6350,6305.2999999999993,877.1,0,877.1,633,244.10000000000002," ",6325]
[40,"Student",30977,309.77,{"$f":"+C52+D52","v":31286.77},6350,{"$f":"IF(E52-F52>0,E52-F52,0)","v":24936.77},2168.39,0,2168.39,3273," ",1104.6100000000001,{"$f":"TRUNC(G52,-2)+IF(MOD(G52,100)>50,75,25)","v":24925}]

{"sheet":"W2 calculator","index":1,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Instructions:","The contents of cells with blue backgrounds",null,null,"can be changed. Other cells are protected."]
[null,"To add or delete rows, use the buttons on the 1040EZ answer key tab."]
[]
["state tax rate",0.04]
["FICA rate",6.2E-2]
["Medicare rate",1.4500000000000001E-2]
["SDI rate",6.0000000000000001E-3]
[null,null,null,null,null,null,null,null,"Net Income"]
["Last name","First name","Gross","FICA","Medicare","Fed Tax","State Tax","SDI","Yearly","Monthly","Weekly","Daily"]
[{"$f":"'1040EZ answer key'!A13","v":1},{"$f":"'1040EZ answer key'!B13","v":"Student"},{"$f":"'1040EZ answer key'!C13","v":13164},{"$f":"$C10*ROUND($B$5,4)","v":816.16800000000001},{"$f":"$B$6*ROUND(C10,4)","v":190.87800000000001},{"$f":"C10*'1040EZ answer key'!$B$7","v":921.48000000000013},{"$f":"$C10*ROUND($B$4,4)","v":526.56000000000006},{"$f":"$C10*ROUND($B$7,4)","v":78.983999999999995},{"$f":"C10-SUM(D10:H10)","v":10629.93},{"$f":"I10/12","v":885.82749999999999},{"$f":"J10/4","v":221.456875},{"$f":"K10/7","v":31.63669642857143}]
[{"$f":"'1040EZ answer key'!A14","v":2},{"$f":"'1040EZ answer key'!B14","v":"Student"},{"$f":"'1040EZ answer key'!C14","v":25083},{"$f":"$C11*ROUND($B$5,4)","v":1555.146},{"$f":"$B$6*ROUND(C11,4)","v":363.70350000000002},{"$f":"C11*'1040EZ answer key'!$B$7","v":1755.8100000000002},{"$f":"$C11*ROUND($B$4,4)","v":1003.32},{"$f":"$C11*ROUND($B$7,4)","v":150.49799999999999},20254.522499999999,{"$f":"I11/12","v":1687.8768749999999},421.96921874999998,{"$f":"K11/7","v":60.281316964285715}]
[{"$f":"'1040EZ answer key'!A15","v":3},{"$f":"'1040EZ answer key'!B15","v":"Student"},{"$f":"'1040EZ answer key'!C15","v":24152},{"$f":"$C12*ROUND($B$5,4)","v":1497.424},{"$f":"$B$6*ROUND(C12,4)","v":350.20400000000001},{"$f":"C12*'1040EZ answer key'!$B$7","v":1690.64},{"$f":"$C12*ROUND($B$4,4)","v":966.08},{"$f":"$C12*ROUND($B$7,4)","v":144.91200000000001},19502.739999999998,{"$f":"I12/12","v":1625.2283333333332},406.30708333333331,{"$f":"K12/7","v":58.043869047619047}]
[{"$f":"'1040EZ answer key'!A16","v":4},{"$f":"'1040EZ answer key'!B16","v":"Student"},{"$f":"'1040EZ answer key'!C16","v":15894},985.428,230.46300000000002,{"$f":"C13*'1040EZ answer key'!$B$7","v":1112.5800000000002},635.76,95.364000000000004,12834.404999999999,1069.5337499999998,267.38343749999996,38.19763392857142]
[{"$f":"'1040EZ answer key'!A17","v":5},{"$f":"'1040EZ answer key'!B17","v":"Student"},{"$f":"'1040EZ answer key'!C17","v":17722},1098.7639999999999,256.96899999999999,{"$f":"C14*'1040EZ answer key'!$B$7","v":1240.5400000000002},708.88,106.33200000000001,14310.514999999999,{"$f":"I14/12","v":1192.5429166666665},298.13572916666664,42.590818452380951]
[{"$f":"'1040EZ answer key'!A18","v":6},{"$f":"'1040EZ answer key'!B18","v":"Student"},{"$f":"'1040EZ answer key'!C18","v":32809},2034.1579999999999,475.73050000000001,{"$f":"C15*'1040EZ answer key'!$B$7","v":2296.63},1312.3600000000001,196.85400000000001,26493.267499999998,2207.7722916666667,551.94307291666667,78.849010416666673]
[{"$f":"'1040EZ answer key'!A19","v":7},{"$f":"'1040EZ answer key'!B19","v":"Student"},{"$f":"'1040EZ answer key'!C19","v":33389},2070.1179999999999,484.14050000000003,{"$f":"C16*'1040EZ answer key'!$B$7","v":2337.23},1335.56,200.334,26961.6175,{"$f":"I16/12","v":2246.8014583333334},561.70036458333334,80.242909226190477]
[{"$f":"'1040EZ answer key'!A20","v":8},{"$f":"'1040EZ answer key'!B20","v":"Student"},{"$f":"'1040EZ answer key'!C20","v":25528},1582.7359999999999,370.15600000000001,{"$f":"C17*'1040EZ answer key'!$B$7","v":1786.9600000000003},1021.12,153.16800000000001,20613.86,1717.8216666666667,429.45541666666668,61.350773809523808]
[{"$f":"'1040EZ answer key'!A21","v":9},{"$f":"'1040EZ answer key'!B21","v":"Student"},{"$f":"'1040EZ answer key'!C21","v":10882},674.68399999999997,157.78900000000002,{"$f":"C18*'1040EZ answer key'!$B$7","v":761.74000000000012},435.28000000000003,65.292000000000002,8787.2150000000001,{"$f":"I18/12","v":732.26791666666668},183.06697916666667,26.152425595238096]
[{"$f":"'1040EZ answer key'!A22","v":10},{"$f":"'1040EZ answer key'!B22","v":"Student"},{"$f":"'1040EZ answer key'!C22","v":11817},732.654,171.34650000000002,{"$f":"C19*'1040EZ answer key'!$B$7","v":827.19},472.68,70.902000000000001,9542.2275000000009,795.18562500000007,198.79640625000002,28.399486607142858]
[{"$f":"'1040EZ answer key'!A23","v":11},{"$f":"'1040EZ answer key'!B23","v":"Student"},{"$f":"'1040EZ answer key'!C23","v":23133},1434.2460000000001,335.42850000000004,{"$f":"C20*'1040EZ answer key'!$B$7","v":1619.3100000000002},925.32,138.798,18679.897499999999,{"$f":"I20/12","v":1556.6581249999999},389.16453124999998,55.594933035714284]
[{"$f":"'1040EZ answer key'!A24","v":12},{"$f":"'1040EZ answer key'!B24","v":"Student"},{"$f":"'1040EZ answer key'!C24","v":30113},1867.0060000000001,436.63850000000002,{"$f":"C21*'1040EZ answer key'!$B$7","v":2107.9100000000003},1204.52,180.678,24316.247499999998,2026.3539583333331,506.58848958333328,72.369784226190475]
[{"$f":"'1040EZ answer key'!A25","v":13},{"$f":"'1040EZ answer key'!B25","v":"Student"},{"$f":"'1040EZ answer key'!C25","v":25491},1580.442,369.61950000000002,{"$f":"C22*'1040EZ answer key'!$B$7","v":1784.3700000000001},1019.64,152.946,20583.982499999998,{"$f":"I22/12","v":1715.3318749999999},428.83296874999996,61.261852678571422]
[{"$f":"'1040EZ answer key'!A26","v":14},{"$f":"'1040EZ answer key'!B26","v":"Student"},{"$f":"'1040EZ answer key'!C26","v":30840},1912.08,447.18,{"$f":"C23*'1040EZ answer key'!$B$7","v":2158.8000000000002},1233.6000000000001,185.04,24903.3,2075.2750000000001,518.81875000000002,74.116964285714289]
[{"$f":"'1040EZ answer key'!A27","v":15},{"$f":"'1040EZ answer key'!B27","v":"Student"},{"$f":"'1040EZ answer key'!C27","v":21465},1330.83,311.24250000000001,{"$f":"C24*'1040EZ answer key'!$B$7","v":1502.5500000000002},858.6,128.79,17332.987499999999,{"$f":"I24/12","v":1444.4156249999999},361.10390624999997,51.586272321428567]
[{"$f":"'1040EZ answer key'!A28","v":16},{"$f":"'1040EZ answer key'!B28","v":"Student"},{"$f":"'1040EZ answer key'!C28","v":14259},884.05799999999999,206.75550000000001,{"$f":"C25*'1040EZ answer key'!$B$7","v":998.13000000000011},570.36,85.554000000000002,11514.1425,959.51187500000003,239.87796875000001,34.268281250000001]
[{"$f":"'1040EZ answer key'!A29","v":17},{"$f":"'1040EZ answer key'!B29","v":"Student"},{"$f":"'1040EZ answer key'!C29","v":17625},1092.75,255.5625,{"$f":"C26*'1040EZ answer key'!$B$7","v":1233.7500000000002},705,105.75,14232.1875,{"$f":"I26/12","v":1186.015625},296.50390625,42.357700892857146]
[{"$f":"'1040EZ answer key'!A30","v":18},{"$f":"'1040EZ answer key'!B30","v":"Student"},{"$f":"'1040EZ answer key'!C30","v":31646},1962.0519999999999,458.86700000000002,{"$f":"C27*'1040EZ answer key'!$B$7","v":2215.2200000000003},1265.8399999999999,189.876,25554.145,2129.5120833333335,532.37802083333338,76.054002976190489]
[{"$f":"'1040EZ answer key'!A31","v":19},{"$f":"'1040EZ answer key'!B31","v":"Student"},{"$f":"'1040EZ answer key'!C31","v":14978},928.63599999999997,217.18100000000001,{"$f":"C28*'1040EZ answer key'!$B$7","v":1048.46},599.12,89.867999999999995,12094.735000000001,{"$f":"I28/12","v":1007.8945833333333},251.97364583333334,35.996235119047618]
[{"$f":"'1040EZ answer key'!A32","v":20},{"$f":"'1040EZ answer key'!B32","v":"Student"},{"$f":"'1040EZ answer key'!C32","v":29170},1808.54,422.96500000000003,{"$f":"C29*'1040EZ answer key'!$B$7","v":2041.9},1166.8,175.02,23554.774999999998,1962.8979166666666,490.72447916666664,70.103497023809524]
[{"$f":"'1040EZ answer key'!A33","v":21},{"$f":"'1040EZ answer key'!B33","v":"Student"},{"$f":"'1040EZ answer key'!C33","v":31107},1928.634,451.05150000000003,{"$f":"C30*'1040EZ answer key'!$B$7","v":2177.4900000000002},1244.28,186.642,25118.9025,{"$f":"I30/12","v":2093.2418750000002},523.31046875000004,74.758638392857151]
[{"$f":"'1040EZ answer key'!A34","v":22},{"$f":"'1040EZ answer key'!B34","v":"Student"},{"$f":"'1040EZ answer key'!C34","v":17355},1076.01,251.64750000000001,{"$f":"C31*'1040EZ answer key'!$B$7","v":1214.8500000000001},694.2,104.13,14014.162499999999,1167.846875,291.96171874999999,41.70881696428571]
[{"$f":"'1040EZ answer key'!A35","v":23},{"$f":"'1040EZ answer key'!B35","v":"Student"},{"$f":"'1040EZ answer key'!C35","v":25882},1604.684,375.28900000000004,{"$f":"C32*'1040EZ answer key'!$B$7","v":1811.7400000000002},1035.28,155.292,20899.715,{"$f":"I32/12","v":1741.6429166666667},435.41072916666667,62.201532738095239]
[{"$f":"'1040EZ answer key'!A36","v":24},{"$f":"'1040EZ answer key'!B36","v":"Student"},{"$f":"'1040EZ answer key'!C36","v":28854},1788.9480000000001,418.38300000000004,{"$f":"C33*'1040EZ answer key'!$B$7","v":2019.7800000000002},1154.1600000000001,173.124,23299.605,1941.63375,485.40843749999999,69.344062499999993]
[{"$f":"'1040EZ answer key'!A37","v":25},{"$f":"'1040EZ answer key'!B37","v":"Student"},{"$f":"'1040EZ answer key'!C37","v":33494},2076.6280000000002,485.66300000000001,{"$f":"C34*'1040EZ answer key'!$B$7","v":2344.5800000000004},1339.76,200.964,27046.404999999999,{"$f":"I34/12","v":2253.8670833333331},563.46677083333327,80.495252976190471]
[{"$f":"'1040EZ answer key'!A38","v":26},{"$f":"'1040EZ answer key'!B38","v":"Student"},{"$f":"'1040EZ answer key'!C38","v":28434},1762.9079999999999,412.29300000000001,{"$f":"C35*'1040EZ answer key'!$B$7","v":1990.38},1137.3600000000001,170.60400000000001,22960.454999999998,1913.3712499999999,478.34281249999998,68.334687500000001]
[{"$f":"'1040EZ answer key'!A39","v":27},{"$f":"'1040EZ answer key'!B39","v":"Student"},{"$f":"'1040EZ answer key'!C39","v":20959},1299.4580000000001,303.90550000000002,{"$f":"C36*'1040EZ answer key'!$B$7","v":1467.13},838.36,125.754,16924.392499999998,{"$f":"I36/12","v":1410.3660416666664},352.59151041666661,50.370215773809512]
[{"$f":"'1040EZ answer key'!A40","v":28},{"$f":"'1040EZ answer key'!B40","v":"Student"},{"$f":"'1040EZ answer key'!C40","v":29406},1823.172,426.387,{"$f":"C37*'1040EZ answer key'!$B$7","v":2058.42},1176.24,176.43600000000001,23745.345000000001,1978.7787500000002,494.69468750000004,70.670669642857149]
[{"$f":"'1040EZ answer key'!A41","v":29},{"$f":"'1040EZ answer key'!B41","v":"Student"},{"$f":"'1040EZ answer key'!C41","v":11516},713.99199999999996,166.982,{"$f":"C38*'1040EZ answer key'!$B$7","v":806.12000000000012},460.64,69.096000000000004,9299.17,{"$f":"I38/12","v":774.93083333333334},193.73270833333333,27.676101190476192]
[{"$f":"'1040EZ answer key'!A42","v":30},{"$f":"'1040EZ answer key'!B42","v":"Student"},{"$f":"'1040EZ answer key'!C42","v":19046},1180.8520000000001,276.16700000000003,{"$f":"C39*'1040EZ answer key'!$B$7","v":1333.22},761.84,114.276,15379.645,1281.6370833333333,320.40927083333332,45.772752976190475]
[{"$f":"'1040EZ answer key'!A43","v":31},{"$f":"'1040EZ answer key'!B43","v":"Student"},{"$f":"'1040EZ answer key'!C43","v":21601},1339.2619999999999,313.21450000000004,{"$f":"C40*'1040EZ answer key'!$B$7","v":1512.0700000000002},864.04,129.60599999999999,17442.807499999999,{"$f":"I40/12","v":1453.5672916666665},363.39182291666663,51.913117559523805]
[{"$f":"'1040EZ answer key'!A44","v":32},{"$f":"'1040EZ answer key'!B44","v":"Student"},{"$f":"'1040EZ answer key'!C44","v":20732},1285.384,300.61400000000003,{"$f":"C41*'1040EZ answer key'!$B$7","v":1451.2400000000002},829.28,124.392,16741.09,1395.0908333333334,348.77270833333336,49.824672619047625]
[{"$f":"'1040EZ answer key'!A45","v":33},{"$f":"'1040EZ answer key'!B45","v":"Student"},{"$f":"'1040EZ answer key'!C45","v":20236},1254.6320000000001,293.42200000000003,{"$f":"C42*'1040EZ answer key'!$B$7","v":1416.5200000000002},809.44,121.416,16340.57,{"$f":"I42/12","v":1361.7141666666666},340.42854166666666,48.632648809523808]
[{"$f":"'1040EZ answer key'!A46","v":34},{"$f":"'1040EZ answer key'!B46","v":"Student"},{"$f":"'1040EZ answer key'!C46","v":31713},1966.2059999999999,459.83850000000001,{"$f":"C43*'1040EZ answer key'!$B$7","v":2219.9100000000003},1268.52,190.27799999999999,25608.247499999998,2134.0206249999997,533.50515624999991,76.215022321428563]
[{"$f":"'1040EZ answer key'!A47","v":35},{"$f":"'1040EZ answer key'!B47","v":"Student"},{"$f":"'1040EZ answer key'!C47","v":18727},1161.0740000000001,271.54150000000004,{"$f":"C44*'1040EZ answer key'!$B$7","v":1310.89},749.08,112.36200000000001,15122.0525,{"$f":"I44/12","v":1260.1710416666667},315.04276041666668,45.006108630952383]
[{"$f":"'1040EZ answer key'!A48","v":36},{"$f":"'1040EZ answer key'!B48","v":"Student"},{"$f":"'1040EZ answer key'!C48","v":32344},2005.328,468.988,{"$f":"C45*'1040EZ answer key'!$B$7","v":2264.0800000000004},1293.76,194.06399999999999,26117.78,2176.4816666666666,544.12041666666664,77.731488095238092]
[{"$f":"'1040EZ answer key'!A49","v":37},{"$f":"'1040EZ answer key'!B49","v":"Student"},{"$f":"'1040EZ answer key'!C49","v":32892},2039.3040000000001,476.93400000000003,{"$f":"C46*'1040EZ answer key'!$B$7","v":2302.44},1315.68,197.352,26560.29,{"$f":"I46/12","v":2213.3575000000001},553.33937500000002,79.048482142857139]
[{"$f":"'1040EZ answer key'!A50","v":38},{"$f":"'1040EZ answer key'!B50","v":"Student"},{"$f":"'1040EZ answer key'!C50","v":31239},1936.818,452.96550000000002,{"$f":"C47*'1040EZ answer key'!$B$7","v":2186.73},1249.56,187.434,25225.4925,2102.1243749999999,525.53109374999997,75.075870535714287]
[{"$f":"'1040EZ answer key'!A51","v":39},{"$f":"'1040EZ answer key'!B51","v":"Student"},{"$f":"'1040EZ answer key'!C51","v":12530},776.86,181.685,{"$f":"C48*'1040EZ answer key'!$B$7","v":877.10000000000014},501.2,75.180000000000007,10117.975,{"$f":"I48/12","v":843.16458333333333},210.79114583333333,30.113020833333334]
[{"$f":"'1040EZ answer key'!A52","v":40},{"$f":"'1040EZ answer key'!B52","v":"Student"},{"$f":"'1040EZ answer key'!C52","v":30977},1920.5740000000001,449.16650000000004,{"$f":"C49*'1040EZ answer key'!$B$7","v":2168.3900000000003},1239.08,185.86199999999999,{"$f":"C49-SUM(D49:H49)","v":25013.927499999998},{"$f":"I49/12","v":2084.493958333333},{"$f":"J49/4","v":521.12348958333325},{"$f":"K49/7","v":74.44621279761904}]

{"sheet":"Form 1040 EZ calculator","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Select the last name of the student whose answer sheet you want to see"]
[" by clicking the blue drop down box, then clicking on the name you want."]
[]
[null,{"$f":"VLOOKUP(B5,Gross,2)","v":"Student"}]
[null,1]
[]
["1040EZ"]
["Line #"]
[1,"Total wages from W-2 box 1",{"$f":"VLOOKUP($B$5,Gross,3)","v":13164}]
[2,"Interest income",{"$f":"VLOOKUP($B$5,DataTable,4)","v":131.64000000000001}]
[3,"Unemployment compensation"]
[4,"Adjusted gross income",{"$f":"SUM(C9:C11)","v":13295.64}]
[5,"Standard deduction",{"$f":"'1040EZ answer key'!B10","v":6350}]
[6,"Taxable income",{"$f":"IF(C12-C13>0,C12-C13,0)","v":6945.6399999999994}]
[7,"Fed tax withheld (W-2 box 2)",{"$f":"VLOOKUP($B$5,DataTable,8)","v":921.48}]
["8a","Earned income credit",{"$f":"VLOOKUP($B$5,DataTable,9)","v":0}]
[9,"Total payments",{"$f":"SUM(C15:C15)","v":921.48}]
[10,"Tax",{"$f":"VLOOKUP($B$5,DataTable,11)","v":693}]
["13a","Refund",{"$f":"IF(C17>C18,C17-C18,\" \")","v":228.48000000000002}]
[14,"Amount due",{"$f":"IF(C18>C17,C18-C17,\" \")","v":" "}]
[]
["W-2 Data (withholding totals)"]
[null,"Federal Income Tax",{"$f":"VLOOKUP($B$5,W2Info,6)","v":921.48000000000013}]
[null,"FICA",{"$f":"VLOOKUP($B$5,W2Info,4)","v":816.16800000000001}]
[null,"MediCare",{"$f":"VLOOKUP($B$5,W2Info,5)","v":190.87800000000001}]
[null,"State Income Tax",{"$f":"VLOOKUP($B$5,W2Info,7)","v":526.56000000000006}]
[null,"SDI (State Disability Income)",{"$f":"VLOOKUP($B$5,W2Info,8)","v":78.983999999999995}]
[]
["Net Income (take home pay)"]
[null,"Yearly",{"$f":"VLOOKUP($B$5,W2Info,9)","v":10629.93}]
[null,"Monthly",{"$f":"VLOOKUP($B$5,W2Info,10)","v":885.82749999999999}]
[null,"Weekly",{"$f":"VLOOKUP($B$5,W2Info,11)","v":221.456875}]
[null,"Daily",{"$f":"VLOOKUP($B$5,W2Info,12)","v":31.63669642857143}]

{"sheet":"W2 printer","index":3,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,26,2],[12,1,12,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2]]}
["Instructions: pick a student's last name from the drop down box in A14."]
["Type your school and class information in boxes A7, A8 and A9."]
[]
["FOR USE IN CLASS ASSIGNMENTS ONLY"]
[]
["c Employer's Name","1 Wages, tips, other       compensation","2 Federal Income Tax Withheld"]
["Type Your Class Name Here",{"$f":"VLOOKUP($A$14,W2Info,3)","v":13164},{"$f":"VLOOKUP($A$14,W2Info,6)","v":921.48000000000013}]
["Type Your School Name Here","3 Social Security Wages","4 Social Security Tax Withheld"]
["City, State Zip",{"$f":"VLOOKUP($A$14,W2Info,3)","v":13164},{"$f":"VLOOKUP($A$14,W2Info,4)","v":816.16800000000001}]
["b Student's social security number","17 State Income Tax Withheld","19 State Disability Insurance"]
["     123-45-6789",{"$f":"VLOOKUP($A$14,W2Info,7)","v":526.56000000000006},{"$f":"VLOOKUP($A$14,W2Info,8)","v":78.983999999999995}]
["d Student's Name"]
[{"$f":"VLOOKUP(A14,Gross,2)","v":"Student"},"This is a simplified version of FORM W2"]
[1,"OMB No. 1545-0008                                   BPR125A 10/93"]
["SIMPLIFIED FORM W2 2017","Wage and Tax Statement"]
["              COPY B"]
[null,"Would be filed with the student's Federal Tax Return"]
[null,"Department of the Treasury - IRS"]
[null,"This information would be furnished to the IRS and appropriate State officials"]
["BOX - CONTENT EXPLANATIONS"]
[]
["1 - This is the total amount of money you \"earned\" as a student in the class in 2017."]
["2 - We would have taken this amount from what you earned, and paid it to the federal government instead of you.  The law requires that this be done to make sure that you don't spend what you'll owe in taxes at the end of the year.  This process is called WITHHOLDING."]
["3 - This is the amount of your overall wages subject to Social Security taxes. The maximum is currently $127,200 per year."]
["4 - We would have \"withheld\" this amount from your paycheck and paid part of it to the federal government to go into the SOCIAL SECURITY TRUST FUND. After paying into this fund for several years, you (and/or your family) are entitled to collect retirement and/or disability benefits when you become eligible. In addition, because you'd pay the remaining withholding in this category to the MEDICARE trust fund, you will become eligible to collect MEDICARE benefits should you ever need them. As an employer, we would have to send an amount equal to your withholding for both trust funds as an additional contribution to your account."]
["17 - This amount is withheld from your pay and sent to the state government to go toward any state income tax you might owe at the end of the year."]
["19 - This amount is withheld from your pay and sent to the state government's DISABILITY INSURANCE FUND, often called WORKER'S COMPENSATION.  Workers injured on the job, who are paying into this fund, can draw from it to help cover their expenses while they are unable to work."]

{"sheet":"Tax Rate Schedule","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["2017 Tax Rate Schedule for Single Taxpayers"]
[]
["Taxable Income"]
[0,0.1,0]
[9325,0.15,932.5]
[37951,0.25,5226.25]
[91901,0.28000000000000003,18713.75]
[191651,0.33,46643.75]
[416701,0.35,120910.25]

{"sheet":"Freeware Agreement","index":5,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["This workbook is distributed free of charge by classroomtools.com."]
[]
["You may make copies for colleagues, but are specifically prohibited from"]
[null,"1 - charging for such copies"]
[null,"2 - removing the classroomtools.com copyright line(s) from the original "]
[null,"    or copies you make"]
[null,"3 - modifying formulas, protected text, macros or the general look of "]
[null,"    the sheets that make up this workbook"]
[]
["I have tested this workbook as thoroughly as possible.  Nevertheless, as with"]
["all computer software, it is possible that anomolies could appear under"]
["circumstances found on your particular system.  Should you see something that"]
["appears incorrect, please report it by e-mail to:   BillChapman@classroomtools.com"]
[]
["copyright © 1998-2018 classroomtools.com"]
["last modified: Tuesday, February 6, 2018"]