If it’s publicly held, this calculation may become more complicated depending on the various types of stock issued. 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). Fill out your balance sheet template to calculate your business equity in minutes. With the balance sheet template Google Sheets provides, you’ll be filling in fields with ease.

Retained earnings are the net earnings a company either reinvests in the business or uses to pay off debt. The remaining amount is distributed to shareholders in the form of dividends. Some liabilities are considered off the balance sheet, meaning they do not appear on the balance sheet. After enrolling in a program, you may request a withdrawal with refund (minus a $100 nonrefundable enrollment fee) up until 24 hours after the start of your program. Please review the Program Policies page for more details on refunds and deferrals. Our easy online application is free, and no special documentation is required.

How to Use an Excel Template for Financial Statements?

Once you download the free balance sheet template in your chosen format, you have many ways to customize it to your needs. Add your business name, logo, contact information, income, expenses and more. You have access to even more customization with FreshBooks accounting software. By using a balance sheet template in either Excel spreadsheets or Google Sheets spreadsheets, you can easily balance your numbers and create an organized and accurate professional financial statement.

When it comes to accounting, creating financial reports with errors isn’t typically something you want to do. Good news is, the balance sheet templates from FreshBooks are here to help you out. When you follow a template, you’ll be sure to include the numbers you need. Lastly, there must be a section for financial ratios, which are said to be the dessert in a balance sheet. They are calculated after listing all your assets, liabilities, and equity. The ratios indicate whether your enterprise has good liquidity, can pay its obligations, and how much profit the company earns.

Basic Balance Sheet Template

Once completed, you can identify where to make adjustments to improve profit and net worth. This balance sheet also reports Apple’s liabilities and equity, each with its own section in the lower half of the report. The liabilities section is broken out similarly as the assets section, with current liabilities and non-current liabilities reporting balances by account. The total shareholder’s equity section reports common stock value, retained earnings, and accumulated other comprehensive income. Apple’s total liabilities increased, total equity decreased, and the combination of the two reconcile to the company’s total assets. Understanding the components of a balance sheet is crucial for gaining insights into a company’s financial standing.

In order to help you advance your career, CFI has compiled many resources to assist you along the path. The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed.