Projected Balance Sheet: A Beginner’s Guide

A projected balance sheet forecasts what you will own and owe at a future date. It is the least produced of the three forecast statements and the most useful as a check, because it is where an inconsistent model reveals itself.

Why it validates everything else

A P&L forecast and a cash forecast can each look plausible while contradicting each other. The balance sheet is where they have to reconcile: profit flows into equity, and the changes in receivables, payables, inventory, debt and assets must explain the difference between forecast profit and forecast cash.

If your projected balance sheet does not balance, one of the other two forecasts is wrong. That is the single best reason to build it.

How to build it

• Start from the current balance sheet, reconciled
• Add forecast profit to equity, and subtract planned drawings or distributions
• Project receivables from forecast revenue and your actual collection days
• Project payables from forecast costs and your actual payment days
• Project inventory from forecast activity, if you carry stock
• Add planned capital purchases to fixed assets, and add the depreciation charge to accumulated depreciation
• Adjust debt for planned draws and scheduled principal repayments
• Cash becomes the balancing figure, which should agree with your cash forecast

That last point is the whole test

Cash calculated as the balancing figure on the projected balance sheet must equal the closing cash on your cash flow forecast. Where they differ, something has been double counted or omitted, and finding it is the value of the exercise.

Use your own ratios, not assumptions

Project receivables using your actual days sales outstanding rather than your stated terms. Project payables using how you actually pay. Using contractual terms produces a forecast that is optimistic in a predictable direction.

What lenders look at

• Whether working capital grows with revenue, and whether it is funded
• The current ratio and its trend
• Debt levels relative to equity
• Whether drawings are consistent with earnings
• Whether capital spending is funded from operations or borrowing

A projection showing revenue doubling without receivables and payables growing is the clearest signal that the model was typed rather than built, and experienced readers spot it immediately.

Start with a controlled opening date

Choose a month-end or quarter-end date with a reconciled balance sheet. Tie cash to bank reconciliations, receivables and payables to their aging reports, loans to lender statements, payroll and tax liabilities to supporting records, and fixed assets to a schedule. Record unresolved differences before forecasting. A model built on an unexplained opening balance will carry that difference into every future period.

Preserve the opening statement as a locked reference. Put forecast assumptions on a separate schedule with an owner, source, effective date, and last update. This makes it possible to distinguish a changed business assumption from a damaged formula.

Build connected supporting schedules

Do not type future balance-sheet totals directly. Build receivables from forecast credit sales and expected collection timing. Build payables from purchases, expenses, and payment timing. Roll inventory from opening units or value, purchases, cost of sales, and adjustments. Roll fixed assets from opening cost, planned purchases, disposals, and depreciation. Roll debt from draws, principal payments, and any other documented changes.

Equity should carry opening balances, forecast profit or loss, contributions, distributions, and other defined movements. Each ending schedule should feed one balance-sheet line. When a reviewer can trace every material balance to a schedule, troubleshooting becomes much faster.

Use a working-capital bridge

Revenue growth rarely becomes cash on the same day. A working-capital bridge shows how receivables, inventory, deposits, and payables absorb or release cash. Forecast collection and payment behavior from recent operating history, adjusted for known changes, rather than relying only on contract terms.

For example, if forecast credit sales increase while collection timing stays constant, receivables should normally increase too. If the model doubles sales but leaves receivables unchanged, the projection assumes an unexplained improvement in collections. Make that assumption visible or correct the schedule.

Connect profit, cash, and the balance sheet

Forecast profit changes retained earnings or another appropriate equity line. Noncash charges such as depreciation reduce profit without directly using current-period cash. Capital purchases use cash but are not normally recorded as an immediate operating expense. Debt principal uses cash without reducing operating profit, while interest is treated separately.

The cash-flow forecast should explain the movement from opening cash to ending cash. That same ending cash should appear on the projected balance sheet. Assets must equal liabilities plus equity. These two checks test whether the three statements tell one consistent story.

Diagnose a model that does not balance

Begin with the first period that fails, not the final period. Compare the size of the difference with known transactions. A difference equal to forecast profit suggests an equity roll-forward problem. A difference equal to principal repayment may mean debt changed without the matching cash movement. A growing difference can point to a repeated formula or sign error.

Check retained earnings, owner activity, depreciation, capital spending, debt, receivables, payables, inventory, and cash. Do not insert an unexplained balancing line. A plug can make the equation work while hiding the missing business event.

Add decision checks

Review projected liquidity, debt maturities, borrowing availability, customer concentration, and the share of assets tied up in receivables or inventory. Compare a base case with a defined downside case. The downside should change related drivers, such as slower collections, lower sales, delayed hiring, or higher direct costs, rather than changing one total in isolation.

Assign an action to each important threshold. If projected cash falls below the operating buffer, decide which collections, spending, purchasing, or financing steps must begin and who owns them. The projection becomes useful when it changes a dated decision.

Review checklist

• Opening balances reconcile to supporting records
• Receivables, payables, inventory, assets, and debt have schedules
• Profit flows into equity
• Capital spending and debt principal appear in cash
• Ending cash agrees with the cash forecast
• Assets equal liabilities plus equity in every period
• Assumptions have sources, owners, and dates
• Downside thresholds have named actions

Review the projection period by period

Review changes from the prior period before reviewing ending totals. For each material movement, identify the operating event and the supporting schedule. Receivables should connect with sales and collections, payables with purchases and payments, fixed assets with capital activity, debt with the financing schedule, and equity with profit and owner transactions. Then compare the projected statement with historical common-size percentages and key ratios. A large shift may be intentional, but it should have a named cause. Finally, review whether later periods contain formula extensions, copied assumptions, or hard-coded values that differ from the controlled pattern. This period-by-period movement review can find a model error before the balance equation identifies it.

Retain the approved projection and compare it with actual balance-sheet movements after each close. Explain material differences before rolling the forecast forward, so changed assumptions remain distinguishable from posting errors and delayed transactions.