{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Business Structure","Tax Calculations"],"not_rendered":{"macros":1,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Business Structure","index":0,"n_rows":56,"n_cols":6,"rows_kept":56,"flags":["formulas_cached_only"]}
["[Company Name]"]
["Business Structure Selector"]
["[Date]"]
[]
["[Company Name] CONFIDENTIAL"]
["Gray cells will be calculated for you. You do not need to enter anything in them."]
["Planned number of owners",2]
["Required protection from personal liability","Low"]
["Net income for business",{"v":350000,"d":"$350,000"}]
["Owner's share of income",{"v":175000,"d":"$175,000"}]
["Salary received from business",{"v":50000,"d":"$50,000"}]
["Owner's other income subject to self-employment tax",{"v":25000,"d":"$25,000"}]
["Owner's marginal tax rate",{"v":0.28,"d":"28%"}]
["State income tax rate on individual income",{"v":0.05,"d":"5.00%"}]
["State income tax rate on business income",{"v":0.08,"d":"8.00%"}]
[]
[null,"Sole Proprietorship","Partnership","Corporation","S Corporation","Limited Liability Corporation (LLC)"]
["Option available?","No","Yes","Yes","Yes","Yes"]
["If no, reason option not available","Number of planned owners","",null,""]
["Election to be treated as corporation? (Yes/No)",{"$nulls":4},"Yes"]
["Business tax return required","None","Form 1065","Form 1120","Form 1120S","Form 1120"]
["Protection from personal liability","Low","Low","High","High","High"]
[]
["Estimated Tax Liability Caused by Business"]
["Salary from business","N/A",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
["Business income currently taxable to owners","N/A",{"v":175000,"d":"$175,000"},{"v":0,"d":"$0"},{"v":175000,"d":"$175,000"},{"v":0,"d":"$0"}]
["Percent that is self-employment income","N/A",{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"}]
[]
["Income from business subject to self-employment tax","N/A",{"v":175000,"d":"$175,000"},{"v":0,"d":"$0"},{"v":87500,"d":"$87,500"},{"v":0,"d":"$0"}]
["Business income taxable to business","N/A","N/A",{"v":175000,"d":"$175,000"},"N/A",{"v":175000,"d":"$175,000"}]
[]
["Individual Tax"]
["FICA tax withheld from salary","N/A",{"v":3825,"d":"$3,825"},{"v":3825,"d":"$3,825"},{"v":3825,"d":"$3,825"},{"v":3825,"d":"$3,825"}]
["Tax on individual tax return:"]
["   Federal income tax","N/A",{"v":63000.00000000001,"d":"$63,000"},{"v":14000.000000000002,"d":"$14,000"},{"v":63000.00000000001,"d":"$63,000"},{"v":14000.000000000002,"d":"$14,000"}]
["   Self-employment tax","N/A",{"v":11127.020625000001,"d":"11,127"},0,{"v":9890.685000000001,"d":"9,891"},0]
["   Tax saved on self-employment tax deduction","N/A",{"v":-1557.7828875000002,"d":"-1,558"},0,{"v":-1384.6959000000004,"d":"-1,385"},0]
["   State income tax","N/A",{"v":11250,"d":"11,250"},{"v":2500,"d":"2,500"},{"v":11250,"d":"11,250"},{"v":2500,"d":"2,500"}]
["      Total individual tax","N/A",{"v":87644.2377375,"d":"$87,644"},{"v":20325,"d":"$20,325"},{"v":86580.9891,"d":"$86,581"},{"v":20325,"d":"$20,325"}]
[]
["Business Tax"]
["FICA tax withheld from wages","N/A",{"v":3825,"d":"$3,825"},{"v":3825,"d":"$3,825"},{"v":3825,"d":"$3,825"},{"v":3825,"d":"$3,825"}]
["Tax on business return:"]
["   Federal income tax","N/A","N/A",{"v":59500,"d":"59,500"},"N/A",{"v":59500,"d":"59,500"}]
["   State income tax","N/A","N/A",{"v":10000,"d":"10,000"},"N/A",{"v":10000,"d":"$10,000"}]
["      Total tax paid by business","N/A",{"v":3825,"d":"$3,825"},{"v":73325,"d":"$73,325"},{"v":3825,"d":"$3,825"},{"v":73325,"d":"$73,325"}]
[]
["Tax on future year dividend on personal return:"]
["   Federal income tax","N/A","N/A",{"v":49000.00000000001,"d":"49,000"},"N/A",{"v":49000.00000000001,"d":"49,000"}]
["   State income tax","N/A","N/A",{"v":6250,"d":"6,250"},"N/A",{"v":6250,"d":"6,250"}]
["Total tax on individual income","N/A",{"v":91469.2377375,"d":"$91,469"},{"v":79400,"d":"$79,400"},{"v":90405.9891,"d":"$90,406"},{"v":79400,"d":"$79,400"}]
["Total tax on business income",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":69500,"d":"$69,500"},{"v":0,"d":"$0"},{"v":69500,"d":"$69,500"}]
["Total tax on combined income","N/A",{"v":91469.2377375,"d":"$91,469"},{"v":148900,"d":"$148,900"},{"v":90405.9891,"d":"$90,406"},{"v":148900,"d":"$148,900"}]
["Effective tax rate — individual income","N/A",{"v":0.40652994550000005,"d":"40.65%"},{"v":0.35288888888888886,"d":"35.29%"},{"v":0.401804396,"d":"40.18%"},{"v":0.35288888888888886,"d":"35.29%"}]
["Effective tax rate — business income","N/A","N/A",{"v":0.39714285714285713,"d":"39.71%"},"N/A",{"v":0.39714285714285713,"d":"39.71%"}]
["Effective tax rate — combined income","N/A",{"v":0.40652994550000005,"d":"40.65%"},{"v":0.8508571428571429,"d":"85.09%"},{"v":0.401804396,"d":"40.18%"},{"v":0.8508571428571429,"d":"85.09%"}]

{"sheet":"Tax Calculations","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"merged":[[14,0,14,1],[18,0,18,1],[18,3,18,4],[18,5,18,6],[19,0,19,1],[19,3,19,4],[19,5,19,6],[20,0,20,1],[20,3,20,4],[20,5,20,6],[21,0,21,1],[21,3,21,4],[21,5,21,6],[22,0,22,1],[22,3,22,4],[22,5,22,6],[23,0,23,1],[23,3,23,4],[23,5,23,6],[24,0,24,1],[24,3,24,4],[24,5,24,6],[25,0,25,1],[25,3,25,4],[25,5,25,6],[26,0,26,1],[26,3,26,4],[26,5,26,6],[28,0,28,1],[33,0,33,8],[34,3,34,5],[43,0,43,6]],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Tax Calculations"]
["[Date]"]
[]
["[Company Name] CONFIDENTIAL"]
["Gray cells will be calculated for you. You do not need to enter anything into them."]
["Individual Income Tax Rates"]
[{"v":0.35,"d":"35%"}]
[{"v":0.33,"d":"33%"}]
[{"v":0.28,"d":"28%"}]
[{"v":0.25,"d":"25%"}]
[{"v":0.15,"d":"15%"}]
[{"v":0.1,"d":"10%"}]
[]
["Self-Employment (SE) Tax"]
["Maximum earnings",{"v":90000,"d":"$90,000"}]
["Social security tax rate",{"v":0.124,"d":"12.40%"}]
["Medicare tax rate",{"v":0.029,"d":"2.90%"}]
[null,null,"Sole Proprietorship","Partnership",null,"S Corporation",null,"Limited Liability Corporation"]
["SE income from business",null,{"v":0,"d":"$0"},{"v":175000,"d":"$175,000"},null,{"v":87500,"d":"$87,500"},null,{"v":0,"d":"$0"}]
["Other SE income",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},null,{"v":25000,"d":"25,000"},null,{"v":25000,"d":"25,000"}]
["Total SE income",null,{"v":25000,"d":"25,000"},{"v":200000,"d":"200,000"},null,{"v":112500,"d":"112,500"},null,{"v":25000,"d":"25,000"}]
["Taxable social security income",null,{"v":23087.5,"d":"23,088"},{"v":83115,"d":"83,115"},null,{"v":83115,"d":"83,115"},null,{"v":23087.5,"d":"23,088"}]
["Social security tax",null,{"v":2862.85,"d":"2,863"},{"v":10306.26,"d":"10,306"},null,{"v":10306.26,"d":"10,306"},null,{"v":2862.85,"d":"2,863"}]
["Medicare tax",null,{"v":669.5375,"d":"670"},{"v":2410.335,"d":"2,410"},null,{"v":2410.335,"d":"2,410"},null,{"v":669.5375,"d":"670"}]
["Total SE tax",null,{"v":3532.3875,"d":"3,532"},{"v":12716.595000000001,"d":"12,717"},null,{"v":12716.595000000001,"d":"12,717"},null,{"v":3532.3875,"d":"3,532"}]
["SE tax from [Company Name]",null,0,{"v":11127.020625000001,"d":"11,127"},null,{"v":9890.685000000001,"d":"9,891"},null,0]
[]
["FICA Tax for Employees and Businesses"]
["Maximum earnings",{"v":90000,"d":"$90,000"}]
["Social security tax rate",{"v":0.062,"d":"6.20%"}]
["Medicare tax rate",{"v":0.0145,"d":"1.45%"}]
[]
["Corporate Tax Rate Schedule"]
["If taxable income is ","Over ","But not over","Tax is",null,null,"Of the \namount over ","Total \ncorporate tax","Owner's share"]
[null,{"v":0,"d":"$0"},{"v":50000,"d":"$50,000"},null,null,{"v":0.15,"d":"15%"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,{"v":50000,"d":"$50,000"},{"v":75000,"d":"$75,000"},{"v":7500,"d":"$7,500"},"+",{"v":0.25,"d":"25%"},{"v":50000,"d":"$50,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,{"v":75000,"d":"$75,000"},{"v":100000,"d":"$100,000"},{"v":13750,"d":"$13,750"},"+",{"v":0.34,"d":"34%"},{"v":75000,"d":"$75,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,{"v":100000,"d":"$100,000"},{"v":335000,"d":"$335,000"},{"v":22250,"d":"$22,250"},"+",{"v":0.39,"d":"39%"},{"v":100000,"d":"$100,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,{"v":335000,"d":"$335,000"},{"v":10000000,"d":"$10,000,000"},{"v":113900,"d":"$113,900"},"+",{"v":0.34,"d":"34%"},{"v":335000,"d":"$335,000"},{"v":119000,"d":"$119,000"},{"v":59500,"d":"$59,500"}]
[null,{"v":10000000,"d":"$10,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":3400000,"d":"$3,400,000"},"+",{"v":0.35,"d":"35%"},{"v":10000000,"d":"$10,000,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,{"v":15000000,"d":"$15,000,000"},{"v":18333333,"d":"$18,333,333"},{"v":5159000,"d":"$5,159,000"},"+",{"v":0.38,"d":"38%"},{"v":15000000,"d":"$15,000,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,{"v":18333333,"d":"$18,333,333"},"———",null,null,{"v":0.35,"d":"35%"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Total",{"$nulls":6},{"v":119000,"d":"$119,000"},{"v":59500,"d":"$59,500"}]