{"text_format":"1","workbook":"xls","n_sheets":5,"sheets":["Input","Tax Savings from Deduction","Tax on Sale","Supporting Tables","Breakeven Chart"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Breakeven Chart","index":4,"reason":"not_a_worksheet"}],"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","formulas":"cached_only"}

{"sheet":"Input","index":0,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[ Name]"]
[null,"Home Office Tax Benefits Comparison—Input "]
[null,"[Date]"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything into them."]
[]
[null,"Basis (Homeowners only)"]
[null,"Purchase price of house",150000]
[null,"Land included in purchase price",50000]
[null,"Permanent improvements",10000]
[null,"Month started using office (1-12)",6]
[null,"Year started using office",2004]
[null,"Fair market value on date started",230000]
[null,"Land included in fair market value",75000]
[null,"Total basis in house",110000]
[]
[null,"Business Percentage"]
[null,"Square footage of house",2500]
[null,"Square footage of office",250]
[null,"Number of rooms in house",11]
[null,"Number of rooms in office",1]
[null,"Business percentage",0.1]
[]
[]
[null,"Estimate of Annual Indirect Expenses","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"Mortgage interest",3000,3000,3000,3000,3000,3000,3000,3000,3000,3000]
[null,"Real estate taxes",1700,1700,1700,1700,1700,1700,1700,1700,1700,1700]
[null,"Homeowner's insurance",250,250,250,250,250,250,250,250,250,250]
[null,"Mortgage insurance",200,200,200,200,200,200,200,200,200,200]
[null,"Repairs and maintenance",400,400,400,400,400,400,400,400,400,400]
[null,"Rent (Non-homeowners only)",0,0,0,0,0,0,0,0,0,0]
[null,"Utilities",850,850,850,850,850,850,850,850,850,850]
[null,"Casualty loss",0,0,0,0,0,0,0,0,0,0]
[null,"Other expenses",0,0,0,0,0,0,0,0,0,0]
[]
[null,"Estimate of Annual Direct Expenses"]
[null,"Repairs and maintenance",800]
[null,"Other"]
[]
[null,"Estimate of Annual Business Income"]
[null,"Business income",5000,10000,20000,40000,50000,60000,70000,75000,75000,75000]
[null,"Business expenses other than office",7000,9000,5000,5000,7000,8000,9000,9000,9000,9000]
[null,"Net business income before office",-2000,1000,15000,35000,43000,52000,61000,66000,66000,66000]
[]
[null,"Estimate of Other Annual Earned Income"]
[null,"Earned income as employee",40000,40000,0,0,0,0,0,0,0,0]
[null,"Income tax rate",0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[]
[null,"House","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"Sales value of house",150000,160000,165000,170000,175000,180000,185000,190000,195000,200000]

{"sheet":"Tax Savings from Deduction","index":1,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Name]"]
[null,"Estimated Tax Savings from Home Office Deduction"]
[null,"[Date]"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything into them."]
[null," "]
[null,"Indirect Expenses","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"Mortgage interest",3000,3000,3000,3000,3000,3000,3000,3000,3000,3000]
[null,"Real estate taxes",1700,1700,1700,1700,1700,1700,1700,1700,1700,1700]
[null,"Insurance",450,450,450,450,450,450,450,450,450,450]
[null,"Repairs and maintenance",400,400,400,400,400,400,400,400,400,400]
[null,"Utilities",850,850,850,850,850,850,850,850,850,850]
[null,"Casualty loss",0,0,0,0,0,0,0,0,0,0]
[null,"Other expenses",0,0,0,0,0,0,0,0,0,0]
[null,"Total indirect office expenses",6400,6400,6400,6400,6400,6400,6400,6400,6400,6400]
[]
[null,"Business percentage",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"Deduction for indirect expenses",640,640,640,640,640,640,640,640,640,640]
[]
[null,"Direct expenses",800,0,0,0,0,0,0,0,0,0]
[]
[null,"Total expenses before depreciation",1440,640,640,640,640,640,640,640,640,640]
[]
[null,"Depreciation",153.01000000000002,282.04,282.04,282.04,282.04,282.04,282.04,282.04,282.04,282.04]
[]
[null,"Total business use of home expense",1593.01,922.04,922.04,922.04,922.04,922.04,922.04,922.04,922.04,922.04]
[null,"Carryover from prior year",null,1123.01,575.05,0,0,0,0,0,0,0]
[]
[]
[null,"Net income before business use of home",-2000,1000,15000,35000,43000,52000,61000,66000,66000,66000]
[]
[null,"Allowed business use of home deduction",0,1000,1497.09,922.04,922.04,922.04,922.04,922.04,922.04,922.04]
[null,"Net business income",-2000,0,13502.91,34077.96,42077.96,51077.96,60077.96,65077.96,65077.96,65077.96]
[]
[null,"Deduction not allowed",1593.01,1045.05,0,0,0,0,0,0,0,0]
[null,"Interest and taxes allowed as itemized deduction",470,470,0,0,0,0,0,0,0,0]
[null,"Carryover of business use of home expenses",1123.01,575.05,0,0,0,0,0,0,0,0]
[]
[null,"Tax savings from business use of home"]
[null,"Income tax",0,150,224.56349999999998,138.30599999999998,138.30599999999998,138.30599999999998,138.30599999999998,138.30599999999998,138.30599999999998,138.30599999999998]
[null,"Self-employment tax",0,0,229.05477,141.07211999999998,141.07211999999998,141.07211999999998,141.07211999999998,141.07211999999998,141.07211999999998,141.07211999999998]
[null,"Total tax savings",0,150,453.61826999999994,279.37811999999997,279.37811999999997,279.37811999999997,279.37811999999997,279.37811999999997,279.37811999999997,279.37811999999997]
[]
[null,"Less: tax savings allowed on interest and taxes",70.5,70.5,70.5,70.5,70.5,70.5,70.5,70.5,70.5,70.5]
[null,"True tax savings",0,79.5,383.11826999999994,208.87811999999997,208.87811999999997,208.87811999999997,208.87811999999997,208.87811999999997,208.87811999999997,208.87811999999997]
[]
[null,"Cumulative tax savings",0,79.5,462.61826999999994,671.4963899999999,880.3745099999999,1089.25263,1298.1307499999998,1507.0088699999997,1715.8869899999995,1924.7651099999994]

{"sheet":"Tax on Sale","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Name]"]
[null,"Estimated Tax Due on Sale of House "]
[null,"[Date]"]
[]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"Selling price",150000,160000,165000,170000,175000,180000,185000,190000,195000,200000]
[null,"Original cost",100000,100000,100000,100000,100000,100000,100000,100000,100000,100000]
[null,"Depreciation claimed",153.01000000000002,435.05000000000007,717.0900000000001,999.1300000000001,1281.17,1563.21,1845.25,2127.29,2409.33,2691.37]
[null,"Basis",99846.99,99564.95,99282.91,99000.87,98718.83,98436.79,98154.75,97872.71,97590.67,97308.63]
[null,"Gain on sale",50153.009999999995,60435.05,65717.09,70999.13,76281.17,81563.21,86845.25,92127.29,97409.33,102691.37]
[null,"Business percent",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"Taxable gain",5015.3009999999995,6043.505000000001,6571.709,7099.9130000000005,7628.117,8156.321000000001,8684.525,9212.729,9740.933,10269.137]
[null,"Tax on sale",752.2951499999999,906.5257500000001,985.7563499999999,1064.98695,1144.21755,1223.4481500000002,1302.6787499999998,1381.90935,1461.13995,1540.37055]

{"sheet":"Supporting Tables","index":3,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,1,8,1],[7,2,7,13],[18,1,18,2],[21,1,21,2],[19,1,19,2],[20,1,20,2]],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Supporting Tables "]
[null,"[Date]"]
[]
[null,"Nonresidential Real Property Mid-Month Convention"]
[null,"Straight-Line—39 Years"]
[]
[null,"Year","Month Property Placed in Service"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,1,0.02461,0.02247,0.02033,0.01819,0.01605,0.01391,0.01177,0.00963,0.00749,0.00535,0.00321,0.00107]
[null,"2 - 39",0.02564,0.02564,0.02564,0.02564,0.02564,0.02564,0.02564,0.02564,0.02564,0.02564,0.02564,0.02564]
[null,40,0.00107,0.00321,0.00535,0.00749,0.00963,0.01177,0.01391,0.01605,0.01819,0.02033,0.02247,0.02461]
[]
[]
[null,"Rate used in year 1:"]
[null,0.01391]
[null,0]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"Maximum self-employment income for SS",null,87900,87900,87900,87900,87900,87900,87900,87900,87900,87900]
[null,"Self-employment income",null,38000,40000,13502.91,34077.96,42077.96,51077.96,60077.96,65077.96,65077.96,65077.96]
[null,"Earned income as employee",null,40000,40000,0,0,0,0,0,0,0,0]
[null,"Taxable self-employment income",null,0,0,12469.937385,31470.996059999998,38858.99606,47170.49606,55481.99606,60099.49606,60099.49606,60099.49606]