What a projected balance sheet should show
A projected balance sheet is a forecast of assets, liabilities and owners' funds on a future date. To prepare one for a bank loan, start from reconciled opening balances and roll forward the transactions in your operating, investment and funding plan. It is a forecast, not a replacement for historical accounts.
- Carry forward fixed assets after additions, disposals and depreciation.
- Estimate inventory, receivables and payables from the operating cycle.
- Reduce each loan by scheduled principal repayments.
- Update owners' funds for contributions, retained profit and withdrawals or distributions as applicable.
- Derive closing cash from the cash flow, then check that assets equal liabilities plus owners' funds.
If the forecast needs additional borrowing to avoid negative cash, identify that funding requirement explicitly. Do not insert unexplained cash or capital merely to make both sides equal. Use the lender's requested classification and confirm the projection years before submitting.
A projected balance sheet estimates a business's assets, liabilities and owners' funds at a future reporting date. For a bank loan, it explains where the proposed finance will go and how the financial position may change as the business earns profit, buys assets and repays debt. It must agree with the projected profit and loss account, cash flow and repayment schedules.
A historical statement records an actual closing position. A provisional statement uses current books that may still require final adjustments. A projection uses assumptions about future activity. Label each year clearly so a lender can distinguish evidence from estimates. Confirm the required number of years and reporting dates before preparing the file; requirements vary by bank and facility.
A practical presentation format
Use headings suitable for the entity and the lender's appraisal format. A company may require Schedule III presentation, while a proprietorship uses proprietor's capital rather than share capital. Do not describe an adapted format for a non-company as a statutory company filing. Keep detailed schedules behind the main statement even when the bank accepts a shorter summary.
| Section | Typical items |
|---|---|
| Owners' funds | Capital or contribution, reserves and accumulated profit or loss |
| Non-current liabilities | Long-term borrowing and other long-term obligations |
| Current liabilities | Working capital borrowing, trade creditors, accruals and current debt maturities |
| Non-current assets | Fixed assets net of depreciation and other long-term assets |
| Current assets | Inventory, receivables, cash and eligible short-term advances |
Add columns for the relevant actual years, the provisional year and each projected year. Show the amount unit prominently, such as Rs lakh, and use it consistently. Separate the current portion of a term loan from the non-current portion where the chosen presentation requires it.
Step 1: establish a reliable opening position
Start with the latest reconciled balance sheet and supporting trial balance. Match bank balances to reconciliations, confirm customer and supplier balances, review stock quantities and valuation, and obtain outstanding loan statements. Identify personal balances, disputed receivables and items that require separate disclosure before carrying them forward.
For a new business, begin with the opening capital, proposed asset purchases and the dates funds will be introduced. Avoid creating opening reserves simply to make the statement balance. Each opening item should arise from an actual transaction or an explicitly identified proposed transaction.
Step 2: project sales and operating results
Calculate revenue using operating drivers: units sold multiplied by selling price, billable hours multiplied by rate, or another business-specific basis. Check that the forecast fits production capacity, staffing and the start date. Separate growth from price increases and volume increases so the bank can understand the assumption.
Build purchases, wages, overheads, interest, depreciation and tax assumptions into the profit and loss projection. Net profit then feeds owners' funds, subject to drawings, distributions and other movements. Revenue is not the same as cash receipts; the balance sheet must capture the credit period given to customers.
Step 3: estimate working capital balances
Project receivables using expected credit sales and collection days. If annual credit sales are Rs 120 lakh and a simplified closing estimate assumes 60 days outstanding, receivables are approximately Rs 19.73 lakh using a 365-day year. State that basis and adjust for seasonal closing conditions where needed.
Estimate inventory from purchasing and production needs using the appropriate cost base, not automatically from sales value. Project trade creditors from credit purchases and supplier terms. Include accruals, advances and taxes separately. A business with seasonal peaks may need a monthly cash forecast because its year-end balance does not reveal the highest funding requirement.
Step 4: roll forward fixed assets and loans
Closing net fixed assets = Opening net fixed assets + Additions - Depreciation - Net book value of disposals. Link additions to quotations and installation timing. Use a clearly stated depreciation basis and ensure depreciation also appears in the profit projection. Do not deduct the sale proceeds as though they were the disposed asset's book value.
Closing loan principal = Opening principal + Disbursements - Principal repayments. Interest belongs in the operating result and cash flow; it does not reduce principal. Split each instalment into principal and interest and identify when repayments start. Show a planned loan as proposed until it is sanctioned rather than implying funds are already available.
Step 5: reconcile capital and cash
For a proprietor, closing capital can be traced as opening capital plus fresh contribution plus profit, less drawings and other applicable adjustments. Companies and partnerships require their own equity schedules. Keep owner withdrawals separate from operating expenses so both the profit calculation and the capital movement remain understandable.
Derive closing cash from opening cash plus receipts less payments, including capital introduced, borrowing, asset purchases, interest and principal. If the result is negative, disclose a funding shortfall or revise the documented financing plan. Cash must not become an unexplained balancing amount that conceals insufficient finance.
Worked year-end example
Consider a simplified proprietor's projection, with all figures in Rs lakh. Opening capital is 20, fresh contribution is 5, projected profit is 6 and drawings are 2, giving closing capital of 29. A term loan opens at 20, receives a further disbursement of 10 and has principal repayment of 4, leaving 26 outstanding.
| Assets | Rs lakh | Capital and liabilities | Rs lakh |
|---|---|---|---|
| Net fixed assets | 40 | Closing capital | 29 |
| Inventory | 12 | Term loan, total outstanding | 26 |
| Receivables | 18 | Cash credit outstanding | 10 |
| Cash and bank | 5 | Trade creditors | 8 |
| Other current assets | 3 | Other current liabilities | 5 |
| Total | 78 | Total | 78 |
The fixed-asset schedule could show opening net assets of 30 plus additions of 15 less depreciation of 5, producing 40. The cash-flow schedule must independently support cash of 5. Split the term loan's current maturity in the final detailed presentation. This example illustrates reconciliation, not an acceptable borrowing level for every applicant.
Checks before sending the projection
- Confirm assets equal capital and liabilities in every year.
- Reconcile profit, depreciation, capital additions and loan balances across schedules.
- Explain collection days, stock holding and supplier credit assumptions.
- Test slower sales and delayed collections without hiding the resulting funding gap.
- Label proposed funding, assumptions and provisional figures consistently.
Finxora's balance sheet software supports audited, provisional and projected years with related schedules. A broader investment proposal can be prepared through its project report software. Compare the sample reports with the bank's checklist and review the supporting evidence before submission.
