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
restructuring financial model template preview 1 Restructuring Financial Model Template
209
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
320
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
301
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
901
239
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
722
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
424
106
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…