SpreadsheetBalance Sheet & Financial PositionFree
Balance Sheet
Assets, liabilities and equity for this year and last, with the balance check and key ratios.
Shown with sample data
Colour
Balance Sheet
Assets, liabilities and equity for this year and last, with the balance check and key ratios.
- Total assets
- $240,700
- Difference
- $0
- Must be zero
- Working capital
- $80,700
- Current ratio
- 2.5
- Above 1.5 is comfortable for most
- Equity$139,700
- Current assets$133,700
- Non-current assets$107,000
- Current liabilities$53,000
- Non-current liabilities$48,000
How to use it
- 1Replace the lines with those from your trial balance.
- 2Enter balances for this year and last year as positive numbers.
- 3Check the Difference figure is zero.
- 4Read the ratios with your accountant or lender.
In this workbook
About this template
A balance sheet shows what the business owns and owes on one date. Enter each line for this year and last; the sheet totals current and non-current sections, proves that assets equal liabilities plus equity and calculates working capital, the current ratio and debt-to-equity.
Who it’s for
- Year-end accounts
- Loan applications
- Comparing two year ends
What’s included
- Balance sheet sheet: Each balance sheet line.
- By section sheet: This year and Last year and the number of entries for each section.
How to use it
- 1Replace the lines with those from your trial balance.
- 2Enter balances for this year and last year as positive numbers.
- 3Check the Difference figure is zero.
- 4Read the ratios with your accountant or lender.
Related searchesbalance sheetstatement of financial positionassets and liabilitiesworking capitalfinancial statements
Details
- Format
- Spreadsheet
- Sheets
- 2
- Setup
- 10 min
- Level
- Beginner
- Price
- Free
Download a copy
Downloads need a free account.