Sign up to our webinar! ‘Future Planning for your clients... AND charging for it’
Register Now

Balance Sheet Projections Cheat sheet:

A balance sheet is a financial statement that reports company assets and liabilities and shareholder equity at a specific point in time. The information in the balance sheet provides an idea of what the business owns, owes, and how much investment shareholders have made.

The balance sheet is one of the key financial statements in fundamental analysis when doing a deep dive on an investment opportunity or looking at ratios.

4 key points to remember

  • A balance sheet is a financial summary that reports a company's assets, liabilities, and equity.
  • The income statement, balance sheet, and cash flow statement are used to evaluate a business.
  • A balance sheet is a business’s snapshot of its financial health.
  • Financial analysts use the balance sheet, along with other financial statements, to calculate ratios.

Setting up Balance Sheet Forecast

Typically, a balance sheet has its own dedicated worksheet or it will be part of a larger workbook with other major financial statements. We'll take a look at individual line items below in more detail, but before we do that there are some important things to know about the main sections you'll find on the balance sheet.

  1. Two years of historical data: In order for the model to be useful, it is necessary to input at least two years of historical data. Historical data should be entered in columns starting from the left and going to the right.
  2. Reclassify GAAP to suit you: Balance sheets often lump together line items with different drivers. For example, groups of items may be combined even though they should not have been. In these cases, the line items need to be broken out and a forecasting approach tailored to the nature of each type. Conversely, GAAP requires that some line items be broken out into current and long-term components (such as deferred taxes and deferred revenue). For forecasting purposes, they can be combined because their forecast is based on the same drivers.
  3. Use supporting schedules: Forecasting is a technique for predicting the performance of certain business activities, and it should be calculated on its own worksheet. The consolidated balance sheet pulls the finished product, the forecasts, into one figure to show a complete picture.

Forecasting Balance Sheet

In preparing a financial forecast, the first step is to forecast the revenues and operating costs. The next step is forecasting the operating assets required to generate them; excluding the financing items on the balance sheet for now. Accordingly, we will only include accounts receivable, inventories, and accounts payable in our analysis.

Balance Sheet Items


  • Other Current Assets
  • PP&E
  • Accounts Receivables
  • Inventory
  • Other Long-Term Assets


  • Accounts Payables
  • Long-term Debt


  • Retained Earnings
  • Shareholder Capital

Income Statement

An income statement is one of the three important financial statements used for reporting a company's financial performance over a specific accounting period, with the other two key statements being the balance sheet and the statement of cash flow. The income statement primarily focuses on a company's revenue and expense over a particular period.

The income statement focuses on four key items—revenue, expenses, gains, and losses. It does not differentiate between cash and non-cash receipts (sales in cash versus sales on credit) or cash versus non-cash payments/disbursements. A balance sheet is designed to provide a snapshot of the financial health of a company. Specifically, it shows how revenue is turned into net income (profit or loss) over time.

Net income

Net income is synonymous with accounting for a company's profit over an allotted period of time. In this sense, net income includes all of the expenses and costs that the company incurred for themselves which are subtracted from their revenue during that time. Net income is often referred to as "the bottom line" due to its position on an organization's earnings statement.

Net income, which is often shown on a company's earnings statement or income statement, is typically derived by the following:

  • Operating expenses
  • Interest on debt and loans
  • Overhead or selling, general and administrative expense (SG&A)
  • Income taxes
  • Depreciation (long term commitment to paying for intangible assets)

Watch the Webinar Recording

Start Your Free Trial

Let informed predictions and powerful reporting guide your business. Be ahead of the curve with Futrli.

Get business advice here

Our blog holds tips, how to’s and general business advice.

Futrli News

Futrli's February 2024 Release

This is some text inside of a div block.


Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat.

Futrli News

Futrli's February 2024 Release


3 Apps to beat accounting blues and scale your firm

Chris Downing catches up with three accounting app innovators to discuss the apps that they have developed that directly help accountants.


Where most prediction software falls short

Tread carefully when looking for prediction software. Find out how to dig deeper into your predictions with the tools that count.

Small Businesses

Cash is King! 4 ways to keep your cash flow healthy.

Cash flow is essential to your business’ survival. Read our top 4 tips for taking control of your cash flow.

Small Businesses

10 Common Cash Flow Forecast Hurdles

If there’s one thing that all small and medium-sized enterprises should prioritise, it’s their cash flow. Read on to find out the top 10 most common issues.


Empowering Accountants: How to Embrace Uncertainty with Futrli

The future is far from certain. Find out how Futrli helps accountants wade their way through murky, grey, “This might happen”-type scenarios.

Small Businesses

Inflation affecting your hospitality business? Take back control with these three steps.

Acting quickly is key to ensure you can ride out the incoming storm. Find out more in this article.

Small Businesses

Why cash flow forecasting helps businesses survive downturns in trade

Learn how cash flow forecasting is crucial for surviving slower trading periods.


The 7 reasons why SMEs struggle with cash flow management

Find out the 7 major reasons why your clients’ businesses struggle to achieve a positive, healthy, consistent cash flow.


Take clients from compliance to scenario planning in five steps

Scenario planning helps your clients imagine different environments or realities in the future, guiding the plans and decisions your clients make.


Flash reports and why to build them

This short guide covers what Flash Reports are and how you could use them as a speedy solution for your clients’ reporting needs.

Small Businesses

Head of Accounting and Futrli COO discuss challenges and solutions for small businesses.

Read Dan and Helen’s thoughts on how SMEs can protect themselves during what is set to be a challenging year.