{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Quick Ratio Template"]
[]
[null,"Company XYZ Balance Sheet "]
[]
[null,"Current assets"]
[null,"Accounts receivable",null,null,40000]
[null,"Marketable securities ",null,null,5000]
[null,"Cash and cash equivalents",null,null,5000]
[null,"Inventory",null,null,100000]
[null,"Prepaid expenses",null,null,2200]
[]
[null,"Total current assets",null,null,{"$f":"SUM(E6:E10)","v":152200}]
[]
[null,"Current liabilities"]
[null,"Accounts payable",null,null,25000]
[null,"Debt falling due within one year",null,null,10000]
[null,"Accruals and other liabilities",null,null,2500]
[]
[null,"Total current liabilities",null,null,{"$f":"SUM(E15:E17)","v":37500}]
[]
[null,null,null,"Quick ratio = ",{"$f":"(E6+E7+E8)/E19","v":1.3333333333333333}]