What the template includes
- Assets: cash, receivables, inventory, fixed assets (cost and accumulated depreciation), intangible assets.
- Liabilities: payables, tax liabilities, short- and long-term loans.
- Equity: charter capital and retained earnings.
- Check row: turns red if assets do not equal liabilities plus equity.
- Ratios: current ratio, quick ratio, debt to equity, working capital.
How to read the ratios
- If the current ratio is below 1, current liabilities exceed current assets: payment difficulties are likely. Between 1.5 and 2 is usually a comfortable level.
- The quick ratio excludes inventory, because it is hard to turn into cash quickly.
- Debt to equity shows how much the company is financed with debt. Banks look at this ratio.
For a forecast balance sheet: financial model template. Terms: finance glossary.