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

{"sheet":"Balance Sheet","index":0,"n_rows":56,"n_cols":3,"rows_kept":56,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[22,0,22,1],[23,0,23,2],[24,0,24,2],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,2],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[43,0,43,1],[44,0,44,2],[45,0,45,2],[46,0,46,2],[47,0,47,1],[48,0,48,2],[49,0,49,1],[50,0,50,2],[51,0,51,1],[52,0,52,2],[53,0,53,1],[54,0,54,2],[55,0,55,1],[56,0,56,2]]}
["Your Company Name"]
["Balance Sheet as on dd/mm/yyyy"]
["ASSETS"]
["1. CURRENT ASSETS",null,2016]
["CASH",null,{"v":118740,"d":"118,740"}]
["ACCOUNTS RECEIVABLE"]
["INVENTORY"]
["PREPAID EXPENSES"]
["SHORT TERM INVESTMENTS"]
["TOTAL CURRENT ASSETS",null,{"$f":"SUM(C5:C9)","v":{"v":118740,"d":"118,740"}}]
["2. LONG TERM FIXED ASSETS"]
["LONG-TERM INVESTMENTS",null,{"v":12080,"d":"12,080"}]
["PROPERTY, PLANT, AND EQUIPMENT",null,{"v":153400,"d":"153,400"}]
["(LESS ACCUMULATED DEPRECIATION)",null,{"v":-22000,"d":"(22,000)"}]
["INTANGIBLE ASSETS"]
["TOTAL FIXED ASSETS",null,{"$f":"SUM(C12:C15)","v":{"v":143480,"d":"143,480"}}]
["3. OTHERS"]
["DEFERRED INCOME TAX"]
["OTHER"]
["TOTAL OTHER ASSETS",null,{"$f":"SUM(C18:C19)","v":0}]
[]
["TOTAL (1+2+3)",null,{"$f":"C10+C16+C20","v":{"v":262220,"d":"262,220"}}]
[]
["LIABILITIES AND OWNER'S EQUITY"]
["1. CURRENT LIABILITIES"]
["ACCOUNTS PAYABLE",null,{"v":80600,"d":"80,600"}]
["SHORT-TERM LOANS"]
["INCOME TAXES PAYABLE",null,{"v":31450,"d":"31,450"}]
["ACCRUED SALARIES AND WAGES"]
["UNEARNED REVENUE"]
["CURRENT PORTION OF LONG-TERM DEBT"]
["TOTAL CURRENT LIABILITIES",null,{"$f":"SUM(C26:C31)","v":{"v":112050,"d":"112,050"}}]
["2. LONG-TERM LIABILITIES"]
["LONG-TERM DEBT",null,{"v":34500,"d":"34,500"}]
["DEFERRED INCOME TAX"]
["OTHER"]
["TOTAL LONG-TERM LIABILITIES",null,{"$f":"SUM(C34:C36)","v":{"v":34500,"d":"34,500"}}]
["3. OWNER'S EQUITY"]
["OWNER'S INVESTMENT",null,{"v":71780,"d":"71,780"}]
["RETAINED EARNINGS",null,{"v":43890,"d":"43,890"}]
["OTHER"]
["TOTAL OWNER'S EQUITY",null,{"$f":"SUM(C39:C41)","v":{"v":115670,"d":"115,670"}}]
[]
["TOTAL (1+2+3)",null,{"$f":"C32+C37+C42","v":{"v":262220,"d":"262,220"}}]
[]
["FINANCIAL RATIOS"]
[]
["DEBT RATIO (TOTAL LIABILITIES / TOTAL ASSETS)",null,{"$f":"IF(C22=0,\"\",(C32+C37)/C22)","v":{"v":0.558881854930974,"d":"0.56"}}]
[]
["CURRENT RATIO (CURRENT ASSETS / CURRENT LIABILITIES)",null,{"$f":"IF(C32=0,\"\",C10/C32)","v":{"v":1.0597054886211512,"d":"1.06"}}]
[]
["WORKING CAPITAL (CURRENT ASSETS - CURRENT LIABILITIES)",null,{"$f":"C10-C32","v":{"v":6690,"d":"6,690"}}]
[]
["ASSETS-TO-EQUITY RATIO (TOTAL ASSETS / OWNER'S EQUITY)",null,{"$f":"IF(C42=0,\"\",C22/C42)","v":{"v":2.2669663698452496,"d":"2.27"}}]
[]
["DEBT-TO-EQUITY RATIO (TOTAL LIABILITIES / OWNER'S EQUITY)",null,{"$f":"IF(C42=0,\"\",((C32+C37)/C42))","v":{"v":1.2669663698452494,"d":"1.27"}}]