Balance Sheet

Items Year 1 Year 2 Year 3
Assets
Current assets
Cash
Petty cash
Inventory
Pre-paid expenses
Total Current Assets
Fixed Assets
Leasehold
Property & land
Renovations/improvements
Furniture & fitout
Vehicles
Equipment/tools
Computer equipment
Total Fixed Assets
Total assets
Liabilities
Current/short-term liabilities
Notes payable
Credit cards payable
Accounts payable
Interest payable
Accrued wages
Deffered Income tax
Total Current Liabilities
Long-term liabilities
Loans
Total Long term Liabilities
Total liabilities
Owner's contribution / equity
Retained earnings
Total Equity
Total Liabilities + Total Equity
Net Assets
Net Working Capital
Assumptions and notes:

All figures are GST inclusive.
Insert your currency symbol
Please do not use shaded cells

This balance sheet contains a list of suggested assets and liabilities a typical business may have. You can edit these items by removing or adding rows and typing in your own items. Don’t forget to enter the financial years in the columns provided.

Formulas

When you add your figures, the sheet will automatically calculate your totals and net assets at the bottom. If you are adding or removing rows please double-check your figures to ensure the calculations have been preserved.

Calculations

Net assets equals, Total assets minus Total liabilities.

Working capital equals, Curret assets minus Current liabilities.

This balance sheet is intended as a GUIDE ONLY and DOES NOT constitute financial advice, please always verify and discuss your financial statements with a qualified accountant, solicitor or financial advisor.

Notes payable: Are the amounts of the outstanding short term loans

The sum of total equity and total liabilities should be equal to total assets