Balance Sheet This template is a financial report for businesses. It is primarily used to report the financial condition of the firm to the owners. It is also presented to lenders to obtain financing. Please note that "accumulated depreciation" and "doubtful accounts" must be entered as negative numbers. The Retained Earnings figure for each year is calculated, to insure that Assets equal Liabilities plus Equity. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next. Balance Sheet <--Enter the date of the balance sheet in cell to the left (all numbers in $000) ASSETS LIABILITIES Current Assets Current Liabilities Cash Accounts payable Accounts receivable Short-term notes (less doubtful accounts) Current portion of long-term notes Inventory Interest payable Temporary investment Taxes payable Prepaid expenses Accrued payroll Total Current Assets Total Current Liabilities Fixed Assets Long-term Liabilities Long-term investments Mortgage Land Other long-term liabilities Buildings Total Long-term Liabilities (less accumulated depreciation) Plant & equipment (less accumulated depreciation) Shareholders' Equity Furniture & fixtures Capital stock (less accumulated depreciation) Retained earnings Total Net Fixed Assets Total Shareholders' Equity TOTAL ASSETS TOTAL LIABILITIES & EQUITY