{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Balance Sheet"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Balance Sheet","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[33,2,33,8]]}
[null,"BALANCE SHEET TEMPLATE"]
[]
[null,"Company Name"]
[]
[null,"Assets",null,2017,2016,null,"Liabilities and Owner's Equity",null,2017,2016]
[null,"Current Assets",{"$nulls":4},"Current Liabilities"]
[null,null,"Cash",{"v":11874,"d":"$11,874"},0,null,null,"Accounts Payable",{"v":8060,"d":"$8,060"},0]
[null,null,"Accounts Receivable",0,0,null,null,"Short-Term Loans",0,0]
[null,null,"Inventory",0,0,null,null,"Income Taxes Payable",{"v":3145,"d":"$3,145"},0]
[null,null,"Prepaid Expenses",0,0,null,null,"Accrued Salaries and Wages",0,0]
[null,null,"Short-Term Investments",0,0,null,null,"Unearned Revenue",0,0]
[null,null,"Total Current Assets",{"$f":"SUM(D7:D11)","v":{"v":11874,"d":"$11,874"}},{"$f":"SUM(E7:E11)","v":0},null,null,"Current Portion of Long-Term Debt",0,0]
[null,"Fixed (Long-Term) Assets",{"$nulls":5},"Total Current Liabilities",{"$f":"SUM(I7:I12)","v":{"v":11205,"d":"$11,205"}},{"$f":"SUM(J7:J12)","v":0}]
[null,null,"Long-Term Investments",{"v":1208,"d":"$1,208"},0,null,"Long-Term Liabilities"]
[null,null,"Property, Plant, and Equipment",{"v":15340,"d":"$15,340"},0,null,null,"Long-Term Debt",{"v":3450,"d":"$3,450"},0]
[null,null,"(Less Accumulated Depreciation)",{"v":-2200,"d":"$(2,200)"},0,null,null,"Deferred Income Tax",0,0]
[null,null,"Intangible Assets",0,0,null,null,"Other",0,0]
[null,null,"Total Fixed Assets",{"$f":"SUM(D14:D17)","v":{"v":14348,"d":"$14,348"}},{"$f":"SUM(E14:E17)","v":0},null,null,"Total Long-Term Liabilities",{"$f":"SUM(I15:I17)","v":{"v":3450,"d":"$3,450"}},{"$f":"SUM(J15:J17)","v":0}]
[null,"Other Assets",{"$nulls":4},"Owner's Equity"]
[null,null,"Deferred Income Tax",0,0,null,null,"Owner's Investment",{"v":7178,"d":"$7,178"},0]
[null,null,"Other",0,0,null,null,"Retained Earnings",{"v":4389,"d":"$4,389"},0]
[null,null,"Total Other Assets",{"$f":"SUM(D20:D21)","v":0},{"$f":"SUM(E20:E21)","v":0},null,null,"Other",0,0]
[{"$nulls":7},"Total Owner's Equity",{"$f":"SUM(I20:I22)","v":{"v":11567,"d":"$11,567"}},{"$f":"SUM(J20:J22)","v":0}]
[null,"Total Assets",null,{"$f":"D12+D18+D22","v":{"v":26222,"d":"$26,222"}},{"$f":"E12+E18+E22","v":0}]
[{"$nulls":6},"Total Liabilities and Owner's Equity",null,{"$f":"I13+I18+I23","v":{"v":26222,"d":"$26,222"}},{"$f":"J13+J18+J23","v":0}]
[{"$nulls":4},"{42}"]
[null,"Common Financial Ratios",null,2017,2016]
[null,"Debt Ratio (Total Liabilities / Total Assets)",null,{"$f":"IF(D24=0,\"\",(I13+I18)/D24)","v":{"v":0.558881854930974,"d":"0.56"}},{"$f":"IF(E24=0,\"\",(J13+J18)/E24)","v":""}]
[null,"Current Ratio (Current Assets / Current Liabilities)",null,{"$f":"IF(I13=0,\"\",D12/I13)","v":{"v":1.0597054886211512,"d":"1.06"}},{"$f":"IF(J13=0,\"\",E12/J13)","v":""}]
[null,"Working Capital (Current Assets / Current Liabilities)",null,{"$f":"D12-I13","v":669},{"$f":"E12-J13","v":0}]
[null,"Assets-to-Equity Ratio (Total Assets / Owner's Equity)",null,{"$f":"IF(I23=0,\"\",D24/I23)","v":{"v":2.2669663698452496,"d":"2.27"}},{"$f":"IF(J23=0,\"\",E24/J23)","v":""}]
[null,"Debt-to-Equity Ratio (Total Liabilities / Owner's Equity)",null,{"$f":"IF(I23=0,\"\",(I13+I18)/I23)","v":{"v":1.2669663698452494,"d":"1.27"}},{"$f":"IF(J23=0,\"\",(J13+J18)/J23)","v":""}]
[]
[null,null,"CLICK HERE TO CREATE BALANCE SHEET TEMPLATES IN SMARTSHEET"]