{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Small Business Valuation"],"not_rendered":{"images":1,"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Small Business Valuation","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[42,2,42,6]]}
[]
[]
[null,null,"Small Business Valuation"]
[null,null,{"$f":"NOW()","v":"2010-04-19T20:21:51.240"}]
[]
[]
[]
[null,null,"Revenue for the year",{"v":250000,"d":"$250,000"}]
[]
[null,null,"Business Expenses for the Year"]
[]
[]
[null,null,"Advertising",{"v":1000,"d":"$1,000"},null,"Pension and profit sharing",{"v":0,"d":"$0"}]
[null,null,"Car and truck expenses",{"v":500,"d":"$500"},null,"Rent",{"v":0,"d":"$0"}]
[null,null,"Fees",{"v":2000,"d":"$2,000"},null,"Other leases",{"v":500,"d":"$500"}]
[null,null,"Depreciation",{"v":5000,"d":"$5,000"},null,"Repairs",{"v":0,"d":"$0"}]
[null,null,"Employee benefit programs",{"v":0,"d":"$0"},null,"Maintenance",{"v":0,"d":"$0"}]
[null,null,"Insurance (other than health)",{"v":2000,"d":"$2,000"},null,"Supplies",{"v":1000,"d":"$1,000"}]
[null,null,"Interest",{"v":0,"d":"$0"},null,"Taxes and licenses",{"v":0,"d":"$0"}]
[null,null,"Legal and professional",{"v":0,"d":"$0"},null,"Travel, meals, etc.",{"v":2000,"d":"$2,000"}]
[null,null,"Office Expense",{"v":0,"d":"$0"},null,"Utilities",{"v":2000,"d":"$2,000"}]
[null,null,"Wages",{"v":0,"d":"$0"},null,"Other",{"v":0,"d":"$0"}]
[]
[{"$nulls":5},"Total Expenses",{"$f":"IF(SUM(D13:D22,G13:G22),SUM(D13:D22,G13:G22),\"\")","v":{"v":16000,"d":"$16,000"}}]
[]
[]
[null,null,"Net Income or (Net Loss)",{"$nulls":3},{"$f":"IF(SUM(D8,G24),D8-G24,\"\")","v":{"v":234000,"d":"$234,000"}}]
[]
[null,null,"Business Valuation"]
[]
[null,null,"Percentage of Gross Sales",null,null,"Net Income Multiplier"]
[null,null,"Enter % of Gross Sales",{"v":0.75,"d":"75%"},null,"Enter Net Income Multiplier",{"v":2,"d":"2.00"}]
[null,null,"Business Value",{"$f":"IF(D32,D8*D32,\"\")","v":{"v":187500,"d":"$187,500"}},null,"Business Value",{"$f":"IF(G32,G27*G32,\"\")","v":{"v":468000,"d":"$468,000"}}]
[]
[null,null,"Monthly Sales Mutiplier",null,null,"FMV of Assets Plus % of Gross Sales"]
[null,null,"Monthly Sales",{"$f":"IF(D8,D8/12,\"\")","v":{"v":20833.333333333332,"d":"$20,833"}},null,"Fair Value: Inventory",{"v":100000,"d":"$100,000"}]
[null,null,"Monthly Sales Multiplier",{"v":8,"d":"8.00"},null,"Fair Value: Fixed Assets",{"v":50000,"d":"$50,000"}]
[null,null,"Business Value",{"$f":"IF(D37,D37*D36,\"\")","v":{"v":166666.66666666666,"d":"$166,667"}},null,"Enter % of Gross Sales",{"v":0.75,"d":"75%"}]
[{"$nulls":5},"Business Value",{"$f":"IF(SUM(G36:G37),SUM(G36:G37)+(G38*G27),\"\")","v":{"v":325500,"d":"$325,500"}}]