Assets And Liabilities Template Free Download

Download a sample Balance Sheet for Microsoft Excel® - by Jon Wittwer

The balance sheet is a very important financial statement that summarizes a company's assets (what it owns) and liabilities (what it owes). A balance sheet is used to gain insight into the financial strength of a company. You can also see how the company resources are distributed and compare the information with similar companies.

No balance sheet statement is complete (in my opinion) without an income statement to go along with it. As a small business owner, I find the income statement to be more useful in the general operation of the business, but the balance sheet is still a critical accounting tool that provides a key piece of information.

Declaration of Assets and Liabilities free download and preview, download free printable template samples in PDF, Word and Excel formats. A simple printable balance sheet with prefilled fields for various business assets and liabilities. Free to download and print. (Free!) This Printable Business Form Template is available to download for free, or you can download the entire collection for only $47.

The balance sheet informs company owners about the net worth of the company at a specific point in time. This is done by subtracting the total liabilities from the total assets to calculate the owner's equity, also known as shareholder's equity (for corporations) or simply the net worth.

Blank assets and liabilities form

Download

Free
OR
BundleGet this template bundled with 6 other templates.

Other Versions

Template Details

License: Private Use
(not for distribution or resale)

'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer

Description

Download our free Balance Sheet template, designed for the small-business owner. It includes common financial ratios and works well for a two-year comparison. See below for more information on the different asset and liability categories.

Balance Sheet Essentials

The Accounting Equation: Assets = Liabilities + Owner's Equity

Current Assets

The term current in a balance sheet generally means 'short-term' which is usually one year or less. Common current assets includes cash (cash, coin, balances in checking and savings accounts), accounts receivable (amounts owed to your business by your customers usually within 10-60 days), inventory (goods for sale), and prepaid expenses (e.g. insurance and rent).

Free assets and liabilities worksheet

Long-Term Assets

These assets include long-term investments, cost of property and equipment (e.g. land, buildings, equipment, tools, furniture, computers, vehicles, etc.) offset by accumulated depreciation, intangible assets (e.g. patents, contracts, trademarks, copyrights, and goodwill), and other assets (like deferred income tax arising from the loss of value of property that cannot be reported as a tax deduction until the property is sold).

Current Liabilities

These include the obligations to be paid within one year, including accounts payable, short-term loans, income taxes payable, wages, unearned revenue (e.g. service contracts), and the current portion of long-term debt (e.g. mortgage payments payable within 12 months).

Long-Term Liabilities

These include long-term debt (e.g. notes, mortgages), capital lease obligations (e.g. leases structured as loans), and deferred income tax (e.g. the tax due on the increase in value of an investment security that isn't paid until the security is sold).

Owner's Equity (or Stockholders' Equity for corporations)

Template

This is basically the amount left over when you subtract Total Liabilities from Total Assets. In includes the owner's investment(s) and retained earnings (the portion of the profits reinvested in the business). For corporations, there are usually more categories (see the references below).

Balance Sheet References


  • Financial Accounting: Reporting and Analysis by M.A. Diamond, E. K. Slice, and J.D. Slice., 2000.
  • Balance Sheet, Fixed Assets, Intangible Assets, Deferred Tax, Shareholders' Equity at wikipedia.org
Disclaimer: This balance sheet spreadsheet and the information on this page is for illustrative and educational purposes only. We do not guarantee the results or the applicability to your financial situation. You should seek the advice of qualified professionals regarding financial decisions.

Assets And Liabilities Template Free Download Free

Related Content