Overview
This Balance Sheet Excel Template provides an example of what a balanced statement in excel looks like and is a great foundation to start with in constructing a three statement model or a complete financial model.

What is a Balance Sheet?

Balance sheet, which is also sometimes referred to as Statement of Financial Position, shows a summary of a companies' assets, liabilities, and shareholder equities. It tells about the total assets owned by the company and how they are financed, either through debt or equity. The Statement of Financial Position should always satisfy the following accounting equation: Assets = Liabilities + Shareholders' Equity The Balance Sheet has two sides, with assets on the left side and liabilities and shareholders' equity on the right side. All line items are typically grouped into categories based on liquidity. For example, more liquid accounts on the assets side such as cash, inventory, and accounts payable are grouped under current assets. They are then followed by the illiquid accounts such as property, plant and equipment (PP&E) and goodwill, which are commonly categorized as non-current assets. On the right side, there are current liabilities, non-current liabilities, and shareholders' equity.

Common Balance Sheet Accounts

There are minor differences between the Balance Sheets of various organizations and industries, but there are a couple of frequently used line items which are always included. Below is a list of the most common items you would find on a Statement of Financial Position:
  • Cash and Equivalents
  • Accounts Receivable
  • Inventory
  • Plant, Property, and Equipment (PP&E)
  • Accounts Payable
  • Current Portion of Long-Term Debt
  • Bonds Payable
  • Long-Term Debt
  • Share Capital
  • Retained Earnings

Useful Resources

To learn more about Balance Sheet, feel free to check out CFI's complete guide which covers the definition and real-life examples of the Statement of Financial Position. CFI Marketplace also has the other two statements of the important three financial statements, which are free to download:
Share
Reviews Add a review
Avatar
dharevila

i like this balance sheet and i wanted to use it for my work

Avatar
Simra Atkins

I like this balance sheet layout, hope you add some more templates for different types of companies

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Energy Industry Comps Template Energy Industry Comps Template
712
44
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
1,311
57
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
967
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
1,109
80
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
953
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
1,264
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
See All