{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Liquidity","LOOKUPS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Liquidity","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,12],[4,11,4,12],[4,3,4,7],[8,2,8,6],[9,2,9,6],[32,2,39,11],[28,2,28,6],[11,3,11,5],[4,1,4,2],[15,2,15,6],[16,2,16,6],[10,2,10,6],[17,2,17,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[27,2,27,6],[26,2,26,6]]}
[null," Liquidity Worksheet"]
[]
[null,"Determine business liquidity using S Corporation or Partnership tax returns and entering the applicable line items below.\n\nIn general:  \n   - Use the Current Ratio for a business that doesn’t rely on inventory to generate its income\n   - Use the Quick Ratio for a business that relies heavily on inventory to generate its income\n\nTypically, a result of 1.00 or greater for either ratio demonstrates adequate liquidity.  However, it’s important to use the most appropriate ratio, based on how the business operates.  Investor guidelines may vary and other liquidity methods may apply.  FOLLOW INVESTOR GUIDELINES.\n\nNOTE:  If there are no business liabilities, results will reflect N/A, indicating adequate liquidity."]
[]
[null,"Business Name:   ",null,null,null,null,null,null,null,null,null,"Annualization date: "]
[]
[null,"Schedule L - Assets",null,null,null,"Select the Years:"]
[]
[null,1,"Cash: Line 1, Column d"]
[null,2,"Trade notes and accounts receivable, less bad debt: Line 2b, Column d"]
[null,3,"Inventories: Line 3, Column d"]
[null,4,"Other:"]
[null,5,"Total Current Assets:",null,null,null,null,{"$f":"SUM(H9:H12)","v":0},null,null,{"$f":"SUM(K9:K12)","v":0}]
[null,"Schedule L - Liabilities",null,null,null,null,null,{"$f":"IF(ISNUMBER($H$7),$H$7,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$7),$K$7,\"\")","v":""}]
[]
[null,6,"Accounts Payable: Form 1120S Line 16/Form 1065 Line 15, Column d"]
[null,7,"Mortgages, notes, bonds payable < 1 year: Form 1120S Line 17/Form 1065 Line 16, Column d"]
[null,8,"Other current liabilities: Form 1120S Line 18/Form 1065 Line 17, Column d"]
[null,9,"Total Current Liabilities:",null,null,null,null,{"$f":"SUM(H16:H18)","v":0},null,null,{"$f":"SUM(K16:K18)","v":0}]
[]
[null,"Current Ratio",null,null,null,null,null,{"$f":"IF(ISNUMBER($H$7),$H$7,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$7),$K$7,\"\")","v":""}]
[null,null,"Total Current Assets: Row 5 - Assets above",null,null,null,null,{"$f":"$H$13","v":0},null,null,{"$f":"$K$13","v":0}]
[null,null,"Total Current Liabilities: Row 9 - Liabilities above",null,null,null,null,{"$f":"$H$19","v":0},null,null,{"$f":"$K$19","v":0}]
[null,null,"Current Ratio: In general, a ratio ≥ 1 demonstrates adequate liquidity",null,null,null,null,{"$f":"IFERROR(H22/H23,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(K22/K23,\"N/A\")","v":"N/A"}]
[]
[null,"Quick Ratio",null,null,null,null,null,{"$f":"IF(ISNUMBER($H$7),$H$7,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$7),$K$7,\"\")","v":""}]
[null,null,"  Cash, notes, accounts receivable (less bad debt) & other: Rows 1, 2 & 4 - Assets above",null,null,null,null,{"$f":"$H$9+$H$10+$H$12","v":0},null,null,{"$f":"$K$9+$K$10+$K$12","v":0}]
[null,null,"Total Current Liabilities: Row 9 - Liabilities above",null,null,null,null,{"$f":"H19","v":0},null,null,{"$f":"K19","v":0}]
[null,null,"Quick Ratio: In general, a ratio ≥ 1 demonstrates adequate liquidity",null,null,null,null,{"$f":"IFERROR(H27/H28,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(K27/K28,\"N/A\")","v":"N/A"}]
[]
[]
[null,null,"Comments / Notes  (For a new line, hold Alt and press Enter)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]

{"sheet":"LOOKUPS","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["VIRGIN_WBK","LKP_YEAR","MILEAGE_RATE","LKP_MONTHS","HAS_DATA_PROMPT","HAS_DATA_DEL",null,"SUMM_DATA_VALIDATION"]
[true,2017,0.25,0,true,true]
[null,2018,0.25,1]
[null,2019,0.26,2]
[null,2020,0.25,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]