{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Balance Sheet","Caclulations"],"not_rendered":{"charts":2,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Balance Sheet","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"merged":[[45,2,45,3]]}
[]
[null,null,"O P E N I N G  D A Y"]
[null,null,"BALANCE SHEET"]
[]
[null,null,"TOTAL ASSETS",{"$nulls":4},"TOTAL LIABILITIES"]
{"$rows_empty":7}
[null,null,"CURRENT ASSETS"," ",null,null,"CURRRENT LIABILITIES"," "]
[null,null,"Cash in Bank",{"v":45000,"d":"$45,000"},null,null,"Accounts Payable",{"v":30000,"d":"$30,000"}]
[null,null,"Inventory",{"v":0,"d":"$0"},null,null,"Taxes Payable",{"v":0,"d":"$0"}]
[null,null,"Prepaid Expenses",{"v":0,"d":"$0"},null,null,"Notes Payable (due within 12 months)",{"v":0,"d":"$0"}]
[null,null,"Other",{"v":0,"d":"$0"},null,null,"Current Portion Long-term Debt",{"v":0,"d":"$0"}]
[null,null,"TOTAL",{"$f":"SUM(D14:D17)","v":{"v":45000,"d":"$45,000"}},null,null,"Other current liabilities (specify)",{"v":0,"d":"$0"}]
[{"$nulls":6},"TOTAL",{"$f":"SUM(H14:H18)","v":{"v":30000,"d":"$30,000"}}]
[]
[null,null,"FIXED ASSETS"," "]
[null,null,"Machinery & Equipment",{"v":0,"d":"$0"},null,null,"LONG-TERM LIABILITIES"," "]
[null,null,"Furniture & Fixtures",{"v":0,"d":"$0"},null,null,"Bank Loans Payable (greater than 12 months)",{"v":0,"d":"$0"}]
[null,null,"Leasehold Improvements",{"v":0,"d":"$0"},null,null,"Less: Short-term Portion ",{"v":0,"d":"$0"}]
[null,null,"Real Estate / Buildings",{"v":0,"d":"$0"},null,null,"Notes Payable to Stockholders",{"v":0,"d":"$0"}]
[null,null,"Other",{"v":0,"d":"$0"},null,null,"Other long-term debt (specify)",{"v":0,"d":"$0"}]
[null,null,"TOTAL",{"$f":"SUM(D22:D26)","v":{"v":0,"d":"$0"}},null,null,"TOTAL",{"$f":"SUM(H23:H26)","v":{"v":0,"d":"$0"}}]
[]
[]
[null,null,"OTHER ASSETS"," ",null,null,"OTHER LIBILITIES"]
[null,null,"Specify",{"v":0,"d":"$0"},null,null,"Specify",{"v":0,"d":"$0"}]
[null,null,"Specify",{"v":0,"d":"$0"},null,null,"Specify",{"v":0,"d":"$0"}]
[null,null,"Specify",{"v":0,"d":"$0"},null,null,"Specify",{"v":0,"d":"$0"}]
[null,null,"TOTAL",{"$f":"SUM(D31:D33)","v":{"v":0,"d":"$0"}},null,null,"TOTAL",{"$f":"SUM(H31:H33)","v":{"v":0,"d":"$0"}}]
[]
[]
[]
[]
[]
[]
[null,null,"OWNERS EQUITY (NET WORTH)",{"$nulls":4},{"$f":"Caclulations!D8-Caclulations!D11","v":{"v":15000,"d":"$15,000"}}]
[]
[null,null,"TOTAL LIABILITIES & NET WORTH",{"$nulls":4},{"$f":"SUM(Caclulations!D11,H41)","v":{"v":45000,"d":"$45,000"}}]

{"sheet":"Caclulations","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"hidden":true}
["*** This sheet to remain hidden. ***"]
[]
[]
[]
[]
[{"$nulls":3},"Value","Padding"]
[]
[null,null,"Total Assets",{"$f":"SUM('Balance Sheet'!D18,'Balance Sheet'!D27,'Balance Sheet'!D34)","v":{"v":45000,"d":"$45,000"}},{"$f":"PadReference-TotalAssets","v":3600}]
[]
[]
[null,null,"Total Liabilities",{"$f":"SUM('Balance Sheet'!H19,'Balance Sheet'!H27,'Balance Sheet'!H34)","v":{"v":30000,"d":"$30,000"}},{"$f":"PadReference-TotalLiabilities","v":18600}]
[]
[]
[]
[]
[]
[]
[null,null,"Max",{"$f":"MAX(TotalAssets,TotalLiabilities)","v":45000}]
[null,null,"Pad Factor",{"v":0.08,"d":"8%"}]
[null,null,"Pad Reference",{"$f":"MaxTAL+MaxTAL*PadFactor","v":48600}]