Building a Balance Sheet (2024)

The balance sheet provides investors with a summary of a company's financial position at a point in time. This accounting report contains a listing of assets owned and debts owed, thereby allowing the reader to understand the company's worth as well as the money borrowed from lenders and owed creditors.

In this article, we're going to provide a high-level overview of the process required to build a balance sheet. As part of that discussion, we'll first talk about the ways this report is used by financial analysts. Next, we'll walk through the three sections of this financial statement, and talk about the information appearing in each. Then we'll finish up with an example, including a spreadsheet that can be downloaded to illustrate these points.

Balance Sheet Basics

Also known as a net worth statement and a statement of financial position, the purpose of the balance sheet is to provide a report of the company's financial position at a point in time. Structurally, the balance sheet is divided into two sections. Assets tell the analyst how the company has been using its cash, while Liabilities and Owner's Equity provide insights into the sources of capital funding. This is why these two sections are sometimes described as Uses of Cash and Sources of Cash.

As the name implies, the Owes / Owns or Sources / Uses must always be in balance. As cash flows into a company (Liability / Owner's Equity), the company must account for the way it has been used (Assets). The equation used to demonstrate this relationship is as follows:

Assets = Liabilities + Owner's Equity

The balance sheet can also be used by analysts and creditors to determine the net worth of a company. This is sometimes referred to as the company's solvency. This relationship can be expressed using a variation of the above formula:

Owner's Equity (Net Worth) = Assets - Liabilities (or debt)

Liquidity and Solvency

When reading a balance sheet, creditors are focusing on two measures: liquidity and solvency. Liquidity is a measure of a company's ability to pay its debt obligations on time. Solvency is a term used to describe the ability of a company to meet its long-term fixed expenses, long-term expansion plans, and growth goals.

Financial Ratios

Three financial ratios that can help analysts understand a company's liquidity and solvency are the current ratio, quick ratio, and leverage (debt-to-worth).

Current Ratio

Also referred to as the liquidity ratio, the current ratio is a measure of a company's liquidity. It provides creditors with a measure of the company's ability to pay current liabilities with current assets. The calculation of the measure is:

Current Ratio = Current Assets / Current Liabilities

The higher the current ratio, the greater is the company's ability to pay its short-term debt obligations using short-term cash. If the current ratio falls below 1.0, the company might find it difficult to repay all its current liabilities.

Quick Ratio

A second measure of liquidity is the quick ratio. This measure removes some of the slightly less liquid current assets from the current ratio equation. The calculation of the quick ratio is:

Quick Ratio = (Cash + Marketable Securities + Accounts Receivable) / Current Liabilities

The higher the quick ratio, the greater is the company's ability to pay its short-term debt obligations using short-term cash. If the quick ratio falls below 1.0, the company might find it difficult to repay all its current liabilities.

Leverage Ratio

This third balance sheet measure helps analysts understand the solvency of the company. Also known as the debt-to-equity ratio and debt-to-worth ratio, the leverage ratio gives investors and creditors a good indication of the company's debt load relative to its net worth. The leverage ratio is calculated as:

Leverage Ratio = Total Liabilities / Net Worth (or Total Equity)

Leverage ratios will vary by industry. Generally, the ratio should be no higher than 2:1. This allows for liabilities to be twice the shareholder's equity. When the ratio goes above 2:1, the company may have trouble paying creditors, as well as obtaining additional long-term funding.

Assets, Liabilities, and Owner's Equity

Along with the statement of cash flows and income statement, the balance sheet is one of the three most important documents used by investors to understand the financial condition of a company. Structurally, the balance sheet is relatively simple in concept. Every company's balance sheet is comprised of three elements:

  • Assets: accounting rules allow assets to take two forms: Tangible Assets, which have a physical form, such as a building or a piece of machinery. Intangible Assets, which usually involve a legal right or claim such as a patent.

  • Liabilities: debts of the company, including long-term debt, notes payable, and accounts payable.

  • Equity: also referred to as owner's equity and shareholder's equity, these are the resources that have been invested by the owners of the company or the excess earnings retained by the company.

Assets

The assets appearing on a balance sheet are further subdivided into two broad categories: current assets and non-current assets, which are also referred to as fixed assets.

Current Assets

When an asset can be expected to be sold or used up in the near term (usually one year or operating cycle), it is categorized as a current asset. This class of assets includes:

Non-Current or Fixed Assets

This category of assets is those owned by the company which are not classified as current assets, including:

  • Plant, Property, and Equipment (PPE): these are physical assets and property that is not easily converted into cash.

  • Intangible Assets: these are non-physical assets, meaning they cannot be touched or seen, and usually cannot be turned into cash. The most common forms of intangible assets include copyrights, patents, trademarks, and goodwill.

  • Long-Term Investments: bonds with maturities greater than one year, as well as the holdings of any stocks of other companies. Long-term investments also include special accounts such as pension funds, sinking funds, and land held for speculative purposes.

Liabilities

A company's liabilities are debt obligations arising from transactions that have occurred in the past. The balance sheet subdivides liabilities into two broad categories: current liabilities and non-current liabilities, also known as long-term liabilities.

Current Liabilities

When a debt obligation is expected to be liquidated in the near term (usually one year or operating cycle), it is categorized as a current liability. This class of liabilities includes:

  • Accounts Payable: these are bills the company has received for goods or services but has not paid for yet.

  • Short-Term Debt: this is money the company borrowed for a term of 12 months or less.

Non-Current or Long-Term Liabilities

Non-current liabilities represent the money the company owes creditors with a term greater than 12 months. This class of liabilities includes:

  • Notes Payable: also referred to as promissory notes, these are written promises to pay money owed a creditor under terms that include payment due dates as well as the rate of interest charged on the money borrowed.

  • Long-Term Debt: this is money a company has borrowed, and is typically obtained through the issuing of bonds, with a repayment date that is frequently in the distant future.

Owner's Equity

Also referred to as shareholder's equity, or simply equity, this is the third major element of the balance sheet. Owner's equity is a liability that resides with the owners of the company. Owner's equity can be further subdivided into two broad categories: Retained Earnings and Treasury Stock.

Retained Earnings

The retained earnings of a company can be thought of as the total profits ever earned, minus all of the money paid to shareholders in the form of dividends. Since the value of retained earnings is cumulative, there can be instances where retained earnings are negative. When that occurs, this account is sometimes renamed as "accumulated deficit" or "retained losses."

Treasury Stock

If stock is issued, then subsequently repurchased by the company, it is held as treasury stock. Companies sometimes repurchase stock when they feel their shares are undervalued by the market.

Balance Sheet Template

Balance sheets, along with income statements, are key reports for the financial community as well as lenders such as banks, investors, and vendors who are considering how much credit to grant the firm.

Summarizing what appears in the above section; if we were to build a very simple balance sheet, it would look like the following:

Sample Balance Sheet

Company XYZ Balance Sheet As of 12/31/20XX

Assets

Current Assets

$340,500.00

Non-Current or Fixed Assets

$1,050,000.00

Intangible Assets

$80,000.00

Long-Term Investments

$200,000.00

Total Assets

$1,670,500.00

Liabilities and Owner's Equity

Current Liabilities

$140,500.00

Long-Term Liabilities

$1,225,000.00

Total Liabilities

$1,365,500.00

Owner's Equity

$305,000.00

Total Liabilities and Owner's Equity

$1,670,500.00

Balance Sheet Example

As promised earlier, we're going to provide a link to a balance sheet template. In this Excel workbook, there is example information that was used throughout this tutorial, including all the necessary calculations.

In addition to the information above, this example worksheet also contains categories such as:

  • Reserve for Bad Debt: an offset to Accounts Receivable, sometimes referred to as a contra asset. These are amounts owed, but expected to be uncollectible.

  • Accumulated Depreciation: another contra asset, this is the total depreciation expense claimed on the asset. For example, Equipment minus its Accumulated Depreciation will equal the Net Book Value of the company's Equipment.

This article completes a two part series, which also includes the article analyzing the balance sheet.

Additional Resources

Analyzing Income Statements

The income statement is an accounting report that allows a business, as well as investors, to understand if a company is operating successfully. The income statement is often used to help value a company's stock, and it's also used by credit rating agencies to determine its creditworthiness. In this article, we're going to first review some of the basic information that appears on an income statement. Then we're going to talk a little bit about the limitations, or weaknesses, of this report. Finally, we're going to summarize what we believe are the strengths of the income statement, and how this...

Moneyzine Editor

January 5th, 2024

Building an Income Statement

This is the final article in our income statement series. In the sections below, we're going to explain how to build an income statement. Understanding the concepts behind net income, profitability, or corporate earnings helps investors and creditors to gain a better understanding of a company's financial wellbeing.

Moneyzine Editor

January 9th, 2024

Simpson's Paradox and Investing

Investing oftentimes involves closely examining numbers. Investors rely on data, and trends in that data, to provide insights into what's happening with their investments. Numbers can sometimes look odd to analysts too; which is certainly true with Simpson's Paradox.

Moneyzine Editor

September 21st, 2023

The Rule of 72 and Compounding

Investing can often be a complex topic. Fortunately, every so often a shortcut comes along like the rule of 72, which is a way to estimate the time it takes to double an investment.

Moneyzine Editor

September 21st, 2023

Absolute Versus Relative Return

Investors often quote their returns in absolute terms. For example, they might say they earned an 8% return on their portfolio. But if we're really trying to measure the performance of an investment, then we need to understand absolute versus relative returns too.

Moneyzine Editor

December 12th, 2023

Financial versus Managerial Accounting

While managers are responsible for the efficient operation of a business, accountants are responsible for reporting the results of that effort to the investment community. With these two key points in mind, the difference between financial and managerial accounting is much easier to understand.

Moneyzine Editor

January 18th, 2024

Understanding the Cash Conversion Cycle

Investors have a wealth of financial ratios they can examine to better understand the health of a company. One of the most important measures of management efficiency is the cash conversion cycle, which tells the analyst how much cash the company has tied up in inventory, its ability to collect money owed from customers, as well as the time it takes to pay certain creditors.

Moneyzine Editor

September 21st, 2023

Building a Balance Sheet (2024)

FAQs

Building a Balance Sheet? ›

A business Balance Sheet has 3 components: assets, liabilities, and net worth or equity. The Balance Sheet is like a scale. Assets and liabilities (business debts) are by themselves normally out of balance until you add the business's net worth.

How do I create a balance sheet in Excel? ›

How to create a balance sheet in Excel
  1. Format your worksheet. You can create a balance sheet in Excel by first creating a title section and labels for your worksheet. ...
  2. Enter dollar amounts. Leave a column of space between your asset labels and the location in which you want to enter the dollar amounts. ...
  3. Add totals.
Feb 3, 2023

What are the 3 basic parts of a balance sheet? ›

A business Balance Sheet has 3 components: assets, liabilities, and net worth or equity. The Balance Sheet is like a scale. Assets and liabilities (business debts) are by themselves normally out of balance until you add the business's net worth.

What are the golden rules of balance sheet? ›

1) Debit what comes in - credit what goes out. 2) Credit the giver and Debit the Receiver. 3) Credit all income and debit all expenses.

What is the basic layout of a balance sheet? ›

The left side of the balance sheet outlines all of a company's assets. On the right side, the balance sheet outlines the company's liabilities and shareholders' equity. The assets and liabilities are separated into two categories: current asset/liabilities and non-current (long-term) assets/liabilities.

Can I do a balance sheet in Excel? ›

For each balance sheet item, enter the financial data for each year in the respective cells of the worksheet. You might start by adding asset values under the "PY" column, then "AC," and so on. Repeat this for liabilities and shareholders' equity. This step lays the groundwork for your Excel balance sheet.

What is the formula for balance sheet format? ›

What Is the Balance Sheet Formula? A balance sheet is calculated by balancing a company's assets with its liabilities and equity. The formula is: total assets = total liabilities + total equity.

Can I create a balance sheet in QuickBooks? ›

To create a new balance sheet in QuickBooks, choose Reports in the left menu bar and then click on Balance Sheet under Business overview, as shown below. You can add your balance sheet or other frequently used or important reports to the Favorites tab for quick access in the future.

What does a healthy balance sheet look like? ›

A balance sheet should show you all the assets acquired since the company was born, as well as all the liabilities. It is based on a double-entry accounting system, which ensures that equals the sum of liabilities and equity. In a healthy company, assets will be larger than liabilities, and you will have equity.

What is the most important thing on a balance sheet? ›

Many experts believe that the most important areas on a balance sheet are cash, accounts receivable, short-term investments, property, plant, equipment, and other major liabilities.

What is the correct order for the balance sheet? ›

What is the balance sheet order? The order of the balance sheet is as follows: Current Asset, Non-Current Assets, Current Liabilities, Non-Current Liabilites, Owner's Equity, Offsets on the Balance Sheet and also in the order of their liquidy, with the most liquid terms (those closest to cash) first.

What are the four steps you must take to create a personal balance sheet? ›

How to create your own balance sheet in 4 easy steps
  • Step 1: Pick a date and list your assets. The first step in creating a balance sheet is picking the date you are taking a snapshot of. ...
  • Step 2: List all liabilities. ...
  • Step 3: Calculate owners' equity. ...
  • Step 4: Double-check and reconcile.
Dec 21, 2023

How do you create a list of assets and liabilities? ›

How to create a personal balance sheet
  1. Step 1: Make a list of your ASSETS and where to get the most current values. ...
  2. Step 2: Make a list of your DEBTS and where to get the most current values. ...
  3. Step 3: Compile the information. ...
  4. Step 4: Categorize your total assets. ...
  5. Step 5: Categorize your total liabilities / debts.
Aug 21, 2020

What is step 5 in the preparation of financial statements? ›

Step 5: Prepare an adjusted trial balance

Once you've posted all of your adjusting entries, it's time to create another trial balance, this time taking into account all of the adjusting entries you've made.

What six steps are followed in preparing a balance sheet? ›

How to prepare a balance sheet in six steps
  • Choose your balance sheet reporting date. ...
  • List out your assets. ...
  • Record your current and long-term liabilities. ...
  • Detail shareholders' equity. ...
  • Format the balance sheet for easy reading. ...
  • Ensure the balance sheet balances.
Feb 21, 2024

What are the 5 purposes of the balance sheet? ›

Purpose of a balance sheet
  • Determine the company's ability to pay obligations. ...
  • Gauge credit and risk management. ...
  • Identify asset value . ...
  • Evaluate the ability to pay dividends. ...
  • Calculate the company's net worth. ...
  • Develop various ratio analyses and measure liquidity and solvency. ...
  • Attract and retain talent.
Oct 17, 2023

Top Articles
Latest Posts
Article information

Author: Aracelis Kilback

Last Updated:

Views: 6212

Rating: 4.3 / 5 (64 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Aracelis Kilback

Birthday: 1994-11-22

Address: Apt. 895 30151 Green Plain, Lake Mariela, RI 98141

Phone: +5992291857476

Job: Legal Officer

Hobby: LARPing, role-playing games, Slacklining, Reading, Inline skating, Brazilian jiu-jitsu, Dance

Introduction: My name is Aracelis Kilback, I am a nice, gentle, agreeable, joyous, attractive, combative, gifted person who loves writing and wants to share my knowledge and understanding with you.