11.4.  Balance Sheet Projections

The Guide > 11.  Financial Projections > 11.4.  Balance Sheet Projections

When presenting projected balance sheets, you will need to include an opening balance sheet that has been based on audited figures (for last year) or estimated data (for current year). If your business is a pure start-up, its opening balance sheet may contain no values.

Here is an example of a projected balance sheet table and commentary:

The following table presents summary opening and five-year balance sheets for Any Company Inc.:

This table was "pasted in" as a picture from Exl-Plan, PlanWare's Excel-based financial planner.
It is fully-integrated and linked to cashflow forecasts and projected income statements.
See Using Exl-Plan with Free-Plan.
 

These summary balance sheets show that:
 

Note that the projected balance sheets must link back into the projected income statements and cashflow projections. The owners' equity should reflect the transfers to reserves in 11.2. Income (P&L) Projections and the cash movements and balances must tie in with the cash flow projections in 11.3. Cashflow Projections.

For help with producing linked financial projections, see Financial Projections with Exl-Plan.