{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Comparative Taxable Income"],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Comparative Taxable Income","index":0,"n_rows":46,"n_cols":9,"rows_kept":46,"merged":[[48,1,48,8]]}
[]
[]
[null,"Comparative Taxable Income"]
[null,"For the years 2006 - 2009"]
[]
[null,"Income",{"$nulls":3},2006,{"$f":"IF(SUM(F6),SUM(F6)+1,\"\")","v":2007},{"$f":"IF(SUM(G6),SUM(G6)+1,\"\")","v":2008},{"$f":"IF(SUM(H6),SUM(H6)+1,\"\")","v":2009}]
[null,null,"Wages and salaries",null,null,{"v":100000,"d":"$100,000"},{"v":110000,"d":"$110,000"},{"v":120000,"d":"$120,000"},{"v":125000,"d":"$125,000"}]
[null,null,"Dividends and Interest",null,null,{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"v":1200,"d":"$1,200"},{"v":1300,"d":"$1,300"}]
[null,null,"Taxable refunds",null,null,{"v":500,"d":"$500"},{"v":600,"d":"$600"},{"v":700,"d":"$700"},{"v":800,"d":"$800"}]
[null,null,"Alimony received"]
[null,null,"Net business income (Loss)",null,null,{"v":11000,"d":"$11,000"},{"v":12000,"d":"$12,000"},{"v":13000,"d":"$13,000"},{"v":14000,"d":"$14,000"}]
[null,null,"Net capital gain (Loss)",null,null,{"v":2000,"d":"$2,000"},{"v":3000,"d":"$3,000"},{"v":4000,"d":"$4,000"},{"v":5000,"d":"$5,000"}]
[null,null,"Net rent income (Loss)"]
[null,null,"Net partnership income (Allowable Loss)"]
[null,null,"Other income (Loss)"]
[null,null,"Total Income",null,null,{"$f":"IF(SUM(F7:F15),SUM(F7:F15),\"\")","v":{"v":114500,"d":"$114,500"}},{"$f":"IF(SUM(G7:G15),SUM(G7:G15),\"\")","v":{"v":126600,"d":"$126,600"}},{"$f":"IF(SUM(H7:H15),SUM(H7:H15),\"\")","v":{"v":138900,"d":"$138,900"}},{"$f":"IF(SUM(I7:I15),SUM(I7:I15),\"\")","v":{"v":146100,"d":"$146,100"}}]
[]
[null,"Adjustments to gross income"]
[null,null,"IRA deduction",null,null,{"v":2000,"d":"$2,000"}]
[null,null,"Spouse's IRA deductions",null,null,{"v":2000,"d":"$2,000"}]
[null,null,"Moving expenses"]
[null,null,"1/2 of Self-employment tax",null,null,{"v":900,"d":"$900"},{"v":1000,"d":"$1,000"},{"v":1200,"d":"$1,200"},{"v":1400,"d":"$1,400"}]
[null,null,"Self-employed health insurance"]
[null,null,"Keogh plan payments"]
[null,null,"SEP contribution",null,null,{"v":1000,"d":"$1,000"},{"v":1100,"d":"$1,100"},{"v":1200,"d":"$1,200"},{"v":1300,"d":"$1,300"}]
[null,null,"Alimony paid"]
[null,null,"Other adjustments"]
[null,null,"Total Adjustments",null,null,{"$f":"IF(SUM(F19:F27),SUM(F19:F27),\"\")","v":{"v":5900,"d":"$5,900"}},{"$f":"IF(SUM(G19:G27),SUM(G19:G27),\"\")","v":{"v":2100,"d":"$2,100"}},{"$f":"IF(SUM(H19:H27),SUM(H19:H27),\"\")","v":{"v":2400,"d":"$2,400"}},{"$f":"IF(SUM(I19:I27),SUM(I19:I27),\"\")","v":{"v":2700,"d":"$2,700"}}]
[]
[null,"Adjusted gross income",{"$nulls":3},{"$f":"IF(SUM(F28,F16),F16-F28,\"\")","v":{"v":108600,"d":"$108,600"}},{"$f":"IF(SUM(G28,G16),G16-G28,\"\")","v":{"v":124500,"d":"$124,500"}},{"$f":"IF(SUM(H28,H16),H16-H28,\"\")","v":{"v":136500,"d":"$136,500"}},{"$f":"IF(SUM(I28,I16),I16-I28,\"\")","v":{"v":143400,"d":"$143,400"}}]
[]
[null,"Itemized deductions"]
[null,null,"Medical",null,null,{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":500,"d":"$500"}]
[null,null,"Income taxes",null,null,{"v":5000,"d":"$5,000"},{"v":5100,"d":"$5,100"},{"v":5200,"d":"$5,200"},{"v":5300,"d":"$5,300"}]
[null,null,"Property taxes",null,null,{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"}]
[null,null,"Mortgage Interest Paid",null,null,{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"}]
[null,null,"Charitable Contributions",null,null,{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":500,"d":"$500"}]
[null,null,"Casualty and Theft Losses"]
[null,null,"Unreimbursed Moving Expenses"]
[null,null,"Unreimbursed Employee Business Expenses",null,null,{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":500,"d":"$500"}]
[null,null,"Miscellaneous Deductions"]
[null,null,"Total Itemized Deductions",null,null,{"$f":"IF(SUM(F34:F41),SUM(F34:F41),\"\")","v":{"v":10500,"d":"$10,500"}},{"$f":"IF(SUM(G34:G41),SUM(G34:G41),\"\")","v":{"v":10600,"d":"$10,600"}},{"$f":"IF(SUM(H34:H41),SUM(H34:H41),\"\")","v":{"v":10700,"d":"$10,700"}},{"$f":"IF(SUM(I34:I41),SUM(I34:I41),\"\")","v":{"v":10800,"d":"$10,800"}}]
[null,null," Allowable Exemptions",null,null,{"v":7800,"d":"$7,800"},{"v":8200,"d":"$8,200"},{"v":8400,"d":"$8,400"},{"v":9000,"d":"$9,000"}]
[null,null,"Total Deductions and Exemptions",null,null,{"$f":"IF(SUM(F42:F43),SUM(F42:F43),\"\")","v":{"v":18300,"d":"$18,300"}},{"$f":"IF(SUM(G42:G43),SUM(G42:G43),\"\")","v":{"v":18800,"d":"$18,800"}},{"$f":"IF(SUM(H42:H43),SUM(H42:H43),\"\")","v":{"v":19100,"d":"$19,100"}},{"$f":"IF(SUM(I42:I43),SUM(I42:I43),\"\")","v":{"v":19800,"d":"$19,800"}}]
[]
[null,"Taxable Income",{"$nulls":3},{"$f":"IF(SUM(F16,F30,F42),F30-F44,\"\")","v":{"v":90300,"d":"$90,300"}},{"$f":"IF(SUM(G16,G30,G42),G30-G44,\"\")","v":{"v":105700,"d":"$105,700"}},{"$f":"IF(SUM(H16,H30,H42),H30-H44,\"\")","v":{"v":117400,"d":"$117,400"}},{"$f":"IF(SUM(I16,I30,I42),I30-I44,\"\")","v":{"v":123600,"d":"$123,600"}}]