{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Projected Balance Sheet"],"not_rendered":{"external_links":1,"defined_names":1,"comments":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Projected Balance Sheet","index":0,"n_rows":57,"n_cols":5,"rows_kept":57,"merged":[[0,0,0,4],[1,0,1,4]],"flags":["formulas_cached_only"]}
["PROJECTED BALANCE SHEET"]
["[Company Name]"]
[null,null,"Historical",null,"Projected"]
[null,null,"as of [date]",null,"as of [date]"]
["ASSETS"]
["Current Assets"]
["Cash in bank",null,0,null,0]
["Accounts receivable",null,0,null,0]
["Inventory",null,0,null,0]
["Prepaid expenses",null,0,null,0]
["Other current assets",null,0,null,0]
["Total Current Assets",null,0,null,0]
[]
["Fixed Assets"]
["Machinery and equipment",null,0,null,0]
["Furniture and fixtures",null,0,null,0]
["Leasehold improvements",null,0,null,0]
["Land and buildings",null,0,null,0]
["Other fixed assets",null,0,null,0]
["(LESS accumulated depreciation on all fixed assets)",null,0,null,0]
["Total Fixed Assets (net of depreciation)",null,0,null,0]
[]
["Other Assets"]
["Intangibles",null,0,null,0]
["Deposits",null,0,null,0]
["Goodwill",null,0,null,0]
["Other",null,0,null,0]
["Total Other Assets",null,0,null,0]
[]
["TOTAL Assets",null,0,null,0]
[]
["LIABILITIES AND EQUITY"]
["Current Liabilities"]
["Accounts payable",null,0,null,0]
["Interest payable",null,0,null,0]
["Taxes payable",null,0,null,0]
["Notes, short-term (due within 12 months)",null,0,null,0]
["Current part, long-term debt",null,0,null,0]
["Other current liabilities",null,0,null,0]
["Total Current Liabilities",null,0,null,0]
[]
["Long-Term Debt"]
["Bank loans payable",null,0,null,0]
["Notes payable to stockholders",null,0,null,0]
["LESS: Short-term portion",null,0,null,0]
["Other long-term debt",null,0,null,0]
["Total Long-Term Debt",null,0,null,0]
[]
["Total Liabilities",null,0,null,0]
[]
["Owners' Equity"]
["Invested capital",null,0,null,0]
["Retained earnings - beginning",null,0,null,0]
["Retained earnings - current",null,0,null,0]
["Total Owners' Equity",null,0,null,0]
[]
["Total Liabilities and Equity",null,0,null,0]