A balance sheet projection is an estimate of a company’s future assets, liabilities, and shareholders’ equity. It is usually prepared monthly, quarterly, or annually as part of a financial model.
The projection helps answer practical questions: How much cash could the business have? Will customers take longer to pay? How much inventory will it need? Can the company meet its short-term obligations? Will additional debt or equity funding be required?
A balance sheet presents a company’s financial position at a specific date. Its three sections are assets, liabilities, and shareholders’ equity.
Ready to build connected financial statements in Excel? Explore the Financial Modelling Course in Bangalore at Arivu Skills.
Assets = Liabilities + Shareholders’ Equity
This equation must remain true in every projected period.
What Is a Projected Balance Sheet Used For?
- Business planning and budgeting
- Investment banking and valuation models
- Equity research and credit analysis
- Loan applications and cash flow planning
- Merger and acquisition analysis
- Startup fundraising and working capital management
A projected income statement shows whether the company expects to earn a profit. The projected balance sheet goes further by showing what the company may own, owe, and retain at the end of the period.
Balance Sheet Projection vs Balance Sheet Forecast
The terms are often used interchangeably. A forecast generally represents management’s best estimate based on current expectations. A projection may show what could happen under a specific set of assumptions.
- A forecast may use the company’s expected sales growth of 8%.
- A projection may model an alternative scenario in which sales grow by 15%.
In practical financial modelling, both involve estimating future line items from operational assumptions.
How the Three Financial Statements Are Connected
A balance sheet should not be projected in isolation. It is linked to both the income statement and the cash flow statement.
- Net income increases retained earnings.
- Depreciation reduces fixed assets.
- Capital expenditure increases fixed assets.
- Credit sales increase accounts receivable.
- Credit purchases increase accounts payable.
- Debt repayments reduce borrowings.
- New loans increase debt and cash.
- Closing cash comes from the cash flow statement.
How to Project a Balance Sheet Step by Step
Step 1: Collect Historical Financial Data
Start with at least three years of historical financial statements, if available. More history helps when the business has seasonal or volatile working capital.
- Income statements
- Balance sheets
- Cash flow statements
- Notes to accounts
- Debt and fixed asset schedules
- Management guidance or budgets
Confirm that each historical balance sheet satisfies the accounting equation before building the forecast.
Step 2: Identify the Drivers of Each Line Item
Every major balance sheet account needs a logical projection method. Some items move with revenue. Others depend on expenses, capital expenditure, repayment schedules, or management decisions.
| Balance Sheet Item | Common Projection Driver |
|---|---|
| Accounts receivable | Revenue and receivable days |
| Inventory | Cost of goods sold and inventory days |
| Accounts payable | Cost of goods sold and payable days |
| Fixed assets | Capital expenditure and depreciation |
| Debt | Borrowing and repayment schedule |
| Retained earnings | Opening balance, net income, and dividends |
| Cash | Cash flow statement |
Avoid applying one growth percentage to every item. Accounts receivable and debt, for example, respond to very different business conditions.
Step 3: Project Accounts Receivable
Accounts receivable represents money owed by customers for credit sales. A common method is to calculate days sales outstanding, also called receivable days.
Receivable Days = (Average Accounts Receivable ÷ Revenue) × 365
Projected Accounts Receivable = (Projected Revenue × Receivable Days) ÷ 365
Example: projected annual revenue is ₹12 crore and expected receivable days are 45.
(₹12 crore × 45) ÷ 365 = ₹1.48 crore
If customers begin paying more slowly, receivables rise and operating cash flow falls.
Step 4: Project Inventory
Inventory is commonly forecast using inventory holding days.
Inventory Days = (Average Inventory ÷ Cost of Goods Sold) × 365
Projected Inventory = (Projected COGS × Inventory Days) ÷ 365
If projected cost of goods sold is ₹7 crore and inventory days are 60:
(₹7 crore × 60) ÷ 365 = ₹1.15 crore
Use cost of goods sold rather than revenue because inventory is recorded at cost.
Step 5: Project Other Current Assets
Prepaid expenses, advances, recoverable taxes, and other current assets can be projected using a percentage of revenue, a percentage of operating expenses, a historical average, management guidance, or a separate contractual schedule.
Material items should have their own drivers. Small and stable items may be grouped and projected using historical averages.
Step 6: Project Property, Plant, and Equipment
Fixed assets are linked to capital expenditure, depreciation, disposals, and acquisitions.
Closing Net Fixed Assets = Opening Net Fixed Assets + Capital Expenditure − Depreciation − Net Book Value of Disposals
Example: opening fixed assets of ₹5 crore, capital expenditure of ₹1.2 crore, depreciation of ₹0.7 crore, and disposals of ₹0.1 crore result in closing fixed assets of ₹5.4 crore.
Capital expenditure appears under investing activities in the cash flow statement. Depreciation is an income statement expense and is added back in operating cash flow because it is non-cash.
Step 7: Project Accounts Payable
Accounts payable represents amounts owed to suppliers.
Payable Days = (Average Accounts Payable ÷ Cost of Goods Sold) × 365
Projected Accounts Payable = (Projected COGS × Payable Days) ÷ 365
If projected COGS is ₹7 crore and payable days are 50, projected accounts payable is ₹0.96 crore. Longer payment terms may support cash flow, but an unrealistic rise in payable days can make a projection look stronger than the business actually is.
Step 8: Project Other Liabilities
Accrued expenses, tax liabilities, deferred revenue, employee benefits, and other obligations should be forecast according to their underlying cause.
- Tax payable follows the tax expense and payment schedule.
- Deferred revenue follows advanced customer collections.
- Accrued expenses may be linked to operating costs.
- Lease liabilities should follow the lease repayment schedule.
Step 9: Build the Debt Schedule
Debt should be projected through a separate schedule covering opening debt, new borrowings, principal repayments, interest, closing debt, and current versus non-current portions.
Closing Debt = Opening Debt + New Borrowings − Principal Repayments
Interest expense flows to the income statement. Borrowings and principal repayments appear in financing cash flows. If debt depends on a cash shortfall and interest depends on debt, use a revolving credit facility, controlled iteration, or a clearly designed cash sweep.
Step 10: Project Shareholders’ Equity
Retained earnings form the main link between the income statement and the balance sheet.
Closing Retained Earnings = Opening Retained Earnings + Net Income − Dividends
Share capital changes when the company issues or repurchases shares. Other reserves should follow the accounting treatment relevant to each reserve.
Learn to forecast balance sheets, cash flows, and company performance through practical financial modelling course in Chennai.
Step 11: Calculate the Closing Cash Balance
Closing Cash = Opening Cash + Cash From Operations + Cash From Investing + Cash From Financing
Link the closing cash figure back to the balance sheet. Using cash as an unexplained plug can hide errors. If a balancing item is required, model a revolving credit facility or another explicit source of funding.
Step 12: Add a Balance Check
Balance Check = Total Assets − Total Liabilities − Total Equity
The result should be zero. A small difference may come from rounding. A large difference usually indicates a missing link, incorrect sign, or incomplete cash flow adjustment.
Projected Balance Sheet Example
| Projected Assets | ₹ Crore |
|---|---|
| Cash | 1.20 |
| Accounts receivable | 1.48 |
| Inventory | 1.15 |
| Other current assets | 0.30 |
| Net fixed assets | 5.40 |
| Total assets | 9.53 |
| Projected Liabilities and Equity | ₹ Crore |
|---|---|
| Accounts payable | 0.96 |
| Other liabilities | 0.57 |
| Debt | 3.00 |
| Share capital | 2.00 |
| Retained earnings | 3.00 |
| Total liabilities and equity | 9.53 |
₹9.53 crore = ₹9.53 crore
Common Balance Sheet Projection Methods
Historical Ratio Method
This method uses receivable days, inventory days, or a line item as a percentage of revenue. It works well for stable companies, but historical averages should be adjusted when business conditions change.
Revenue-Based Method
Certain operating assets and liabilities can be projected as a percentage of revenue. Use it only when the line item has a genuine relationship with revenue.
Detailed Schedule Method
Large or important items are projected through separate schedules. Debt, fixed assets, leases, and taxes usually need this approach. Detailed schedules take longer but make the model easier to audit.
Scenario-Based Method
A strong model includes base, upside, and downside cases. Vary revenue growth, collection periods, inventory requirements, supplier terms, capital expenditure, and debt funding.
Common Balance Sheet Projection Mistakes
Using One Growth Rate for Every Item
Growing every balance sheet item at the same rate ignores its individual driver. Debt does not automatically rise with revenue, and fixed assets do not always follow working capital.
Ignoring Average Balances
Working capital ratios often use average opening and closing balances. Using only the closing balance can distort results, especially when the company grows quickly.
Forgetting the Cash Flow Statement
A model may show correct profits but an incorrect cash balance when working capital movements, capital expenditure, debt repayments, or dividends are missing.
Leaving Retained Earnings Unlinked
Retained earnings should include current-period net income and dividends. Hardcoding it breaks the connection between the statements.
Using an Unexplained Cash Plug
Forcing cash to make the model balance can conceal mistakes. A sound projection explains how the company generates or raises the required cash.
Relying Only on Historical Trends
Historical ratios are a starting point, not a rule. Customer terms, supply chains, expansion plans, financing arrangements, and accounting policies can change.
How to Check Whether Your Projection Is Reasonable
- Confirm that assets equal liabilities plus equity.
- Compare working capital days with historical results.
- Check whether cash movements match the cash flow statement.
- Confirm that closing debt matches the debt schedule.
- Verify that interest expense reflects projected debt.
- Link retained earnings to net income and dividends.
- Review current and non-current classifications.
- Test base, upside, and downside assumptions.
- Investigate sudden changes that lack a business explanation.
Ratios such as the current ratio, quick ratio, debt-to-equity ratio, and return on equity can also reveal unrealistic assumptions.
Final Takeaway
A good balance sheet projection is built around business relationships rather than guessed growth rates. Receivables follow sales and collection terms. Inventory follows costs and holding periods. Fixed assets follow capital expenditure and depreciation. Debt follows funding requirements and repayment plans. Retained earnings follow profits and dividends.
When these connections are modelled correctly, the balance sheet shows whether the company’s growth plan is financially workable.
FAQs
Projected Assets = Projected Liabilities + Projected Shareholders’ Equity. Individual accounts are forecast using their operating drivers, schedules, or historical ratios.
Accounts receivable and some other current assets are often linked to revenue. Inventory and accounts payable are more commonly linked to cost of goods sold.
A detailed operating model may use monthly projections for 12 to 24 months and annual projections for three to five years. Valuation models commonly use five years, although the right period depends on the company and purpose.
Common causes include an incorrect cash link, a missing retained earnings movement, an incomplete debt schedule, sign errors, omitted capital expenditure, or incorrect working capital calculations.
Cash can be the residual result of the cash flow statement, but it should not be inserted merely to remove an unexplained difference. Funding shortfalls should be handled through a properly modelled debt or equity assumption.
A projection is an estimate, not a guarantee. Its usefulness depends on the quality of the assumptions, historical data, business drivers, and links between the three statements.
