Balance Sheet Template

The following balance sheet template provides you with a foundation to build your own company’s financial statement showing the total assets, liabilities, and shareholders’ equity.

Here is a screenshot of the balance sheet template:

The balance sheet is based on the fundamental equation: Assets = Liabilities + Equity.

Using this template, you can add and remove line items under each of the buckets according to the business: current assets, long-term assets, current liabilities, long-term liabilities, and equity. You can then calculate different financial ratios to determine how well your company is performing, how liquid or solvent it is, and how efficient it is.

One of the biggest challenges in updating a balance sheet is to make sure the total assets and total liabilities & shareholder’s equity amounts match. Using the “Check” line, you can immediately detect imbalances between the total assets and total liabilities & shareholder’s equity amounts and fix the issue!

Build Your Financial Statement Skills

The balance sheet is one of three statements every analyst needs to master. Build a solid base with Accounting Fundamentals, then learn how it connects to the income statement and cash flow in 3-Statement Modeling. The FMVA® certification takes those skills all the way to valuation.

• Additional Resources

• What Is a Balance Sheet?
• The 3 Financial Statements
• How to Read a Balance Sheet

See all Accounting resources

See all Excel resources

See all Financial Modeling resources