pro forma balance sheet sample

Pro Forma Balance Sheet Sample

By Anthony Lewis
AD

When creating or analyzing financial statements, you often come across a pro forma balance sheet. This term, translating to 'as a matter of form', refers to a hypothetical balance sheet that projects future financials based on certain assumptions. It's an essential tool for investors, analysts, and corporate strategists to assess potential impacts of future transactions or events.

A pro forma balance sheet sample can provide valuable insights, but it's crucial to understand that it's not official financial reporting. It's a what-if scenario, allowing companies to preview the potential effects of decisions yet to be made. Let's dive into the details, including a sample for better comprehension.

Components of a Pro Forma Balance Sheet

The pro forma balance sheet includes the same components as a regular balance sheet but presents them in a hypothetical scenario. It typically consists of assets, liabilities, and equity snapshots at two different points in time, with changes shown between them.

AD
Free Balance Sheet Templates — Multiple Formats | Smartsheet
Free Balance Sheet Templates — Multiple Formats | Smartsheet
In an LBO model, here's how I adjust the balance sheet to complete the transaction in 7 steps 👇 ~~~
In an LBO model, here's how I adjust the balance sheet to complete the transaction in 7 steps 👇 ~~~
Balance Sheet Template Excel Famous Pro forma Excel Template 10 Free Excel Documents Of 33 Pr...
Balance Sheet Template Excel Famous Pro forma Excel Template 10 Free Excel Documents Of 33 Pr...

Key aspects include:

  • Current assets and liabilities
  • Non-current assets and liabilities
  • Equity (share capital, retained earnings, and other reserves)
  • Opening and closing balances
  • Changes due to transactions, events, or assumptions

Assets

A pro forma balance sheet might show assets such as cash, inventory, accounts receivable, plant and equipment, and intellectual property. The changes in these assets are often based on assumed events like sales, purchases, or depreciation.

What Is Pro Forma Balance Sheet? - Free Sample, Example & Format Templates
What Is Pro Forma Balance Sheet? - Free Sample, Example & Format Templates
a balance sheet with the numbers and percentages for each item in this table,
a balance sheet with the numbers and percentages for each item in this table,
an invoice sheet with the words free for financial and accounting templates
an invoice sheet with the words free for financial and accounting templates

For instance, if a company assumes it will sell a piece of machinery, the change would be reflected in the reduction of plant and equipment and an increase in cash (from the sale).

Liabilities

Liabilities can include accounts payable, loans, bank overdrafts, and deferred tax liabilities. Changes in liabilities reflect assumed events such as taking out a loan or paying off debt. For example, a loan increase would appear as an increase in loans payable and an increase in cash.

AD

Creating a Pro Forma Balance Sheet Sample

Now that we understand the components, let's create a simple pro forma balance sheet sample. Assume Company A wants to evaluate a potential investment in new equipment.

Pro Forma Balance Sheet Template
Pro Forma Balance Sheet Template
Pro Forma Budget Excel Template - Free Sample, Example & Format Templates
Pro Forma Budget Excel Template - Free Sample, Example & Format Templates
Pro Forma Balance Sheet Template Excel
Pro Forma Balance Sheet Template Excel
an image of a balance sheet with the words pro - forma income statement on it
an image of a balance sheet with the words pro - forma income statement on it
What Is A Pro Forma Template Excel? - Free Sample, Example & Format Templates
What Is A Pro Forma Template Excel? - Free Sample, Example & Format Templates
Balance Sheet Format In Excel Sheet Free Download - Free Sample, Example & Format Templates
Balance Sheet Format In Excel Sheet Free Download - Free Sample, Example & Format Templates

Company A's current balance sheet ( comedzec) is as follows:

AssetsLiabilitiesEquity
Opening$500K$200K$300K

Assumptions

  • Company A purchases new equipment for $100K, financed by a loan.
  • The equipment has a useful life of 5 years with no salvage value.
  • Company A assumes depreciation expense will be $20K per year.

Pro Forma Balance Sheet

After these assumptions:

AD
AssetsLiabilitiesEquity
Opening$500K$200K$300K
Equipment Purchase (-200K, +100K loan)$500K$300K$200K
Annual Depreciation (-20K)$480K$300K$220K
Closing$480K$300K$220K

Here, the purchase of equipment increased Company A's assets and liabilities, while depreciation reduced the value of the equipment and had a corresponding effect on retained earnings.

Pro Forma Template Excel - Free Sample, Example & Format Templates
Pro Forma Template Excel - Free Sample, Example & Format Templates

Pro forma balance sheets are powerful tools for exploratory analysis, but they're only as good as the assumptions behind them. Always remember to validate assumptions and continually reassess as new information becomes available.

AD