Many Nigerian small business owners manage their operations solely by looking at their bank balance or monthly profit and loss statements.
While tracking monthly revenue is essential, a profitable business can still collapse if cash is trapped in unpaid invoices or unsold inventory.
Learning how to project your future assets and liabilities helps you predict liquidity bottlenecks before they threaten your survival.
This guide provides a straightforward framework for African founders and SME teams to project their financial health over the next year.
Why your profit statement is not enough
A profit and loss statement shows the revenues earned and expenses incurred over a period, but it does not show where your cash is tied up.
For example, a Lagos-based wholesale distributor may secure a major supply contract and record strong sales on paper.
If the supermarket clients demand 60-day credit terms while suppliers require cash on delivery, the distributor faces a severe cash squeeze.
A monthly balance sheet projection reveals this mismatch by showing how accounts receivable and inventory grow relative to available cash.
It acts as an early warning system, helping you negotiate overdraft facilities or adjust credit terms before cash reserves run dry.
Furthermore, local commercial banks and venture capital investors require a balance sheet forecast to assess your solvency and debt capacity.
Step-by-step guide to projecting your balance sheet
To build simple 12 month balance sheet forecast records, you must first gather your current balance sheet to serve as your opening balance.
You will also need your monthly profit and loss forecast and cash flow projections for the upcoming 12 months.
Step 1: Project your cash balance
The cash line on your monthly balance sheet must match the ending cash balance from your cash flow forecast for that specific month.
Do not estimate this figure independently; it must flow directly from your operational, investing, and financing cash flows.
Step 2: Estimate accounts receivable
Accounts receivable represent money owed to your business by customers who purchased items on credit.
Calculate this by multiplying your projected monthly credit sales by your average collection period in days, divided by 30.
If your monthly sales are 5 million Naira and customers take 30 days to pay, your accounts receivable balance remains 5 million Naira.
Step 3: Forecast your inventory levels
Estimate how much stock you need to hold to meet your sales targets without tying up excessive capital in warehouse shelves.
For retailers and manufacturers, this balance increases when you purchase raw materials or finished goods, and decreases when you make a sale.
Step 4: Calculate accounts payable
Accounts payable represent the money your business owes to suppliers for goods or services purchased on credit terms.
Use your planned purchases and your suppliers’ payment terms to estimate this liability for each of the next 12 months.
Step 5: Account for fixed assets and depreciation
Add any planned capital expenditures, such as purchasing a new delivery van or manufacturing equipment, to your fixed assets.
Remember to subtract monthly depreciation to reflect the wear and tear of these assets over the 12-month period.
Step 6: Update retained earnings
Retained earnings represent the cumulative profits kept in the business rather than distributed to the owners.
Each month, add your projected net profit after tax to the previous month’s retained earnings balance.
Common mistakes that disrupt SME forecasts
The most frequent error when building a forecast is failing to make the balance sheet balance.
By definition, your total assets must always equal the sum of your total liabilities and shareholders’ equity.
If the equation does not balance, the error usually lies in how you linked the cash flow statement to the balance sheet.
Another common pitfall is ignoring local tax schedules, such as Value Added Tax and Withholding Tax payments.
These taxes accumulate as liabilities on your balance sheet and cause sudden cash drops when paid to the Federal Inland Revenue Service.
SME owners also frequently overlook depreciation, which overstates the value of their equipment and distorts tax calculations.
How to use your forecast for better decisions
Once your monthly projection is complete, use it to calculate key financial ratios that banks look at closely.
Monitor your current ratio, which is total current assets divided by total current liabilities, to ensure it stays above 1.5.
A ratio below 1.0 indicates that your business may struggle to meet its short-term financial obligations over the coming year.
To begin today, open a spreadsheet and list all your current assets, liabilities, and expected capital purchases for the next year.
