Begin with a reconciled opening position
A five-year projected balance sheet supports an Indian bank's assessment of how a business will grow and fund that growth. In a Credit Monitoring Arrangement, or CMA, data pack, it connects the operating statement with working capital, net worth and borrowing. It should explain where the projected assets come from and which liabilities or owner funds finance them. Agreement between totals is necessary, but it is only the first check.
Begin with the latest reliable balance sheet and reconcile its closing balances to the books. Mark audited, provisional and projected periods clearly. Confirm cash, bank borrowing, receivables, inventory, creditors, fixed assets and capital. If the opening figures are incomplete, record the limitation and obtain evidence. Do not insert an unexplained reserve or miscellaneous asset to make the starting position agree.
Agree the horizon and classification with the bank
Five projected years can help explain an expansion or term-loan proposal, but they are not a universal requirement for every facility. Ask the lender which historical periods, current estimates and future years it needs. Confirm its preferred classification and appraisal schedules. Requirements vary by bank and by the purpose of the borrowing.
Use consistent reporting dates and units throughout the file. Separate current and non-current items appropriately, and identify current maturities where relevant. Statutory financial-statement presentation and bank appraisal classifications may require a mapping between them. Keep that mapping visible so that a reviewer can reconcile the CMA figures with the underlying accounts.
Build the operating projection first
Sales, production, purchases and expenses influence the closing balance sheet. Prepare a credible operating forecast before forecasting individual assets and liabilities. Explain sales through capacity, demand, price and operating months. Explain margins through purchase costs, direct expenses and overhead behaviour. Compare the resulting forecast with historical performance and the promoter's evidence.
A uniform growth rate applied to every balance-sheet line rarely captures business behaviour. Receivables respond to credit sales and collection periods; machinery follows the investment plan; borrowings follow funding and repayment. Write these relationships down as assumptions. The five-year model should remain understandable when a lender asks why one balance grows faster than another.
Forecast receivables, inventory and creditors
Use holding levels that reflect the business cycle. A receivable-days calculation should use a consistent sales base and period convention. Inventory holding should distinguish relevant categories such as raw materials and finished goods when material. Trade creditors should relate to credit purchases or the cost base appropriate to the working, rather than automatically using sales.
For illustration, annual credit sales of Rs 120 lakh and a 60-day collection assumption imply approximately Rs 19.73 lakh of receivables using 365 days. That figure is only an estimate: seasonality, taxes, opening balances and the actual sales pattern may require adjustment. State the convention and reconcile it with the treatment used elsewhere in the CMA.
- Compare projected collection days with recent customer behaviour.
- Separate old or disputed receivables from ordinary trade balances.
- Check stock against capacity and procurement requirements.
- Support supplier-credit assumptions with actual terms.
- Explain material improvements rather than assuming them silently.
Roll forward fixed assets and depreciation
Prepare an asset schedule showing opening balances, additions, disposals and depreciation. Capital expenditure should match the project implementation plan and the cash flow. Do not show a machine producing revenue before the assumed acquisition and operating date without an explanation. The closing asset figure should reconcile to the schedule rather than grow by an arbitrary percentage.
Keep accounting depreciation and any tax depreciation working distinct where their treatment differs. Asset sales can affect both cash and profit, and the closing asset balance must reflect the disposal. Review whether planned expansion requires related spending on installation, premises or supporting equipment that has been omitted from the projection.
Carry profits into net worth correctly
Opening capital or reserves should reconcile with the historical accounts. Carry forward projected profit after the appropriate tax treatment, then account for drawings, distributions and new contributions according to the entity's constitution. A proprietor's capital account differs from a company's share capital and reserves. Do not treat every owner withdrawal as an operating expense.
Promoter funds should have an identified source and timing. A projected contribution is not confirmed merely because it improves the debt-equity ratio. Unsecured loans also need appropriate classification and lender treatment; they do not automatically become tangible net worth. Keep assumptions about subordination or treatment for appraisal subject to the bank's confirmation.
Link borrowings with the repayment schedule
For each term loan, reconcile opening principal, disbursements, repayments and closing principal. Link interest to the relevant schedule and reconcile principal payments with financing cash flows. Separate proposed loans from existing facilities. A falling loan balance should be explained by repayments, while an increasing balance should correspond to an identified drawdown.
Working capital borrowing should follow the cash requirement and the proposed facility. It should not be an unrestricted balancing figure that automatically funds every shortfall. Check the borrowing need against the expected limit, eligibility, margin and operating cycle. If cash is insufficient within the assumed facility, revise the funding plan or operating assumptions transparently.
Apply working capital assessment consistently
Where the lender uses Maximum Permissible Bank Finance, distinguish the two Tandon Committee methods. MPBF Method I = 75% x (Total Current Assets - Other Current Liabilities). Method II = 75% x Total Current Assets - Other Current Liabilities. Other current liabilities here exclude bank borrowings. Method I implies a 25% margin on the working capital gap; Method II implies a 25% margin on total current assets.
Under the turnover method associated with the Nayak Committee approach for MSMEs, the illustrative assessment is working capital requirement at 25% of projected annual turnover, borrower margin at 5% and bank finance up to 20%. The applicable method and sanction remain subject to lender appraisal. Do not present a calculated maximum as a committed borrowing entitlement.
Review all five years together
Check balance-sheet equality in every year, then inspect liquidity, leverage and movement in cash. Review current ratio, TOL/TNW and repayment capacity using consistent definitions. Investigate abrupt improvements that lack an operating explanation. Test slower collections, lower sales or delayed investment to see whether the funding plan remains credible; document those alternative workings separately.
Finxora's CMA report software includes statements, MPBF workings, cash flow and 20+ financial ratios. Its balance sheet software supports financial-statement preparation from trial-balance figures, including Tally XML import. These capabilities support preparation, while the user remains responsible for classification, assumptions and evidence.
Compare the finished output with the sample reports and the lender's checklist. Retain the opening reconciliation, assumption schedule, asset roll-forward and loan workings with the final export. A reliable five-year balance sheet is one whose movements can be explained and verified, year after year, without relying on hidden balancing entries.
