{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Balance Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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"}

{"sheet":"Balance Sheet","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,5,4,6],[5,0,5,2],[5,4,5,6],[6,0,6,1],[6,4,6,5],[0,0,0,1],[0,4,0,5],[2,1,2,2],[2,5,2,6],[3,1,3,2],[3,5,3,6]]}
["[Company Name] Balance Sheet ",null,null,null,"For the Period Ending [End Date]"]
[]
["Current ratio  [A/B]",{"$f":"IF(ISERROR(IF(B16=0,\"-\",B16/F16)),\"\",(IF(B16=0,\"-\",B16/F16)))","v":"-"},null,null,"Working capital  [A-B]",{"$f":"(B16-F16)*1000","v":0}]
["Quick ratio  [(A-C)/B]",{"$f":"IF(ISERROR(IF(B16=0,\"-\",(B16-B13)/F16)),\"\",(IF(B16=0,\"-\",(B16-B13)/F16)))","v":"-"},null,null,"Debt-to-equity ratio  [(G+H)/F]",{"$f":"IF(F30=0,\"-\",(F10+F19)/F30)","v":"-"}]
["Cash ratio  [D/B]",{"$f":"IF(ISERROR(IF(B16=0,\"-\",B10/F16)),\"\",(IF(B16=0,\"-\",B10/F16)))","v":"-"},null,null,"Debt ratio  [(G+H)/E]",{"$f":"IF(B29=0,\"-\",(F10+F19)/B29)","v":"-"}]
["Stated in 000s"]
["ASSETS",null,"% of ASSETS",null,"LIABILITIES & OWNERS' EQUITY",null,"% of ASSETS"]
[]
["Current assets",null,null,null,"Current liabilities","  "]
["Cash and cash equivalents  [D]",null,{"$f":"IF($B$29=0,\"-\",B10/$B$29)","v":"-"},null,"Loans payable and current portion long-term debt  [H]",null,{"$f":"IF($B$29=0,\"-\",F10/$B$29)","v":"-"}]
["Short-term investments",null,{"$f":"IF($B$29=0,\"-\",B11/$B$29)","v":"-"},null,"Accounts payable and accrued expenses",null,{"$f":"IF($B$29=0,\"-\",F11/$B$29)","v":"-"}]
["Accounts receivable  [I]",null,"-",null,"Income taxes payable",null,{"$f":"IF($B$29=0,\"-\",F12/$B$29)","v":"-"}]
["Inventories  [C]",null,"-",null,"Accrued retirement and profit-sharing contributions",null,{"$f":"IF($B$29=0,\"-\",F13/$B$29)","v":"-"}]
["Deferred income taxes",null,"-"]
["Prepaid expenses and other current assets",null,"-"]
["Total current assets  [A]",{"$f":"SUM(B10:B15)","v":0},"-",null,"Total current liabilities  [B]",{"$f":"SUM(F10:F15)","v":0},{"$f":"IF($B$29=0,\"-\",F16/$B$29)","v":"-"}]
[]
["Fixed assets",null,null,null,"Other liabilities"]
["Property, plant and equipment at cost",null,{"$f":"IF($B$29=0,\"-\",B19/$B$29)","v":"-"},null,"Long-term debt  [G]",null,{"$f":"IF($B$29=0,\"-\",F19/$B$29)","v":"-"}]
["Less accumulated depreciation",null,{"$f":"IF($B$29=0,\"-\",B20/$B$29)","v":"-"},null,"Accrued retirement costs",null,{"$f":"IF($B$29=0,\"-\",F20/$B$29)","v":"-"}]
["Total fixed assets",{"$f":"B19+B20","v":0},{"$f":"IF($B$29=0,\"-\",B21/$B$29)","v":"-"},null,"Deferred income taxes",null,{"$f":"IF($B$29=0,\"-\",F21/$B$29)","v":"-"}]
[null,null,null,null,"Deferred credits and other liabilities",null,{"$f":"IF($B$29=0,\"-\",F22/$B$29)","v":"-"}]
["Other assets"]
["Long-term cash investments",null,{"$f":"IF($B$29=0,\"-\",B24/$B$29)","v":"-"}]
["Equity investments",null,"-"]
["Deferred income taxes",null,"-"]
["Other assets",null,"-"]
["Total other assets",{"$f":"SUM(B24:B27)","v":0},"-",null,"Total other liabilities ",{"$f":"SUM(F19:F27)","v":0},{"$f":"IF($B$29=0,\"-\",F28/$B$29)","v":"-"}]
["Total assets  [E]",{"$f":"B16+B21+B28","v":0},"-",null,"Total liabilities",{"$f":"F16+F28","v":0},{"$f":"IF($B$29=0,\"-\",F29/$B$29)","v":"-"}]
[null,null,null,null,"Total owners' equity  [F]",{"$f":"B29-F29","v":0},{"$f":"IF($B$29=0,\"-\",F30/$B$29)","v":"-"}]
[null,null,null,null,"Total liabilities + owners' equity",{"$f":"F29+F30","v":0},{"$f":"IF($B$29=0,\"-\",F31/$B$29)","v":"-"}]