Financial Template---Balance Sheet Template

Balance Sheet Template with auto-calculated financial ratios www.bizminer.com The balance sheet line items and ratios in this template mirror the format of the industry-specific benchmarks in BizMiner's Financial Analysis Profile series. These measures are available for more than 10,000 lines of business in industry-wide, small business and startup versions at www.bizminer.com/financial-analysis.asp. BizMiner posts no-cost online resources to help you understand and apply your balance sheet and financial ratios: * Balance Sheet Glossary: www.bizminer.com/balance-sheet.asp * Financial Ratios Glossary: www.bizminer.com/financial-ratios.asp * Financial Analysis Edge white papers: www.bizminer.com/financial-analysis-edge.asp Input up to three years of your company's whole dollar balance sheet data or projections into the yellow boxes and your financial ratios will be automatically calculated. Altering the formulae in the blue boxes will change your results! Annual Average Sales & Income Statement Sales Cost of Sales Gross Profit Payroll Rent Taxes Interest Paid Amortization & Depreciation Adverstising Benefits-Pension Other SG&A Expense Net Profit Yr1 0 0 0 0 0 0 0 0 0 0 0 0 Yr2 0 0 0 0 0 0 0 0 0 0 0 0 Yr3 0 0 0 0 0 0 0 0 0 0 0 0 Yr1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Balance Sheet - dollar-based Assets Cash Accounts Receivable Notes Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Other Non-Current Assets Total Assets Liabilities Accounts Payable Bank Loans Notes Payable Other Current Liabilities Yr1 0 0 0 0 0 0 0 0 0 Yr1 0 0 0 0 Yr2 0 0 0 0 0 0 0 0 0 Yr2 0 0 0 0 Yr3 0 0 0 0 0 0 0 0 0 Yr3 0 0 0 0 Yr1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Current Liabilities Other Long Term Liabilities Deferred Credits Net Worth Total Liabilities and Net Worth 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Financial Ratios quick ratio current ratio current liabilities: net worth % total liabilities: net worth % current liabilities: inventory % fixed assets: net worth % return on assets (%) return on net worth (%) return on sales (%) accounts payable:sales (%) sales:net working capital assets:sales cash turnover (X) accounts receivable turnover (X) inventory turnover (X) current asset turnover (X) fixed asset turnover (X) total asset turnover (X) accounts payable turnover (X) Yr1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yr3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!