How banks assess a business financial plan and forecast before lending
A spreadsheet showing revenue growth does not itself convince a bank. Forecasts should extend actual business economics and include seasonality, payment terms, taxes, investment and debt payments. Here are the assumptions banks check and how to integrate profit and loss, cash flow and the balance sheet.
Banks do not accept a financial plan merely because it presents promises attractively. They compare it with business history, contracts, production capacity and cash movements. Larger departures from actual performance require stronger evidence. A reliable model includes base and stress cases, transparent formulas and a source for every loan payment.
When forecasts materially affect the bank’s decision
Actual results remain the starting point for established businesses. Forecasts become especially important for growth, new activities, major contracts, equipment, seasonal purchasing or recovery from temporary deterioration.
Banks examine the path to profit as well as expected profit itself: when costs arise, cash arrives, working capital is needed and whether payments remain manageable if the plan is only partly achieved.
Unsubstantiated growth
New sales appear without contracts, orders, a pipeline or available capacity.
Profit does not become cash
Profit grows while customer credit and inventory create cash shortages.
Mandatory payments understated
Taxes, leases, repairs, capital expenditure or old loan repayments are omitted.
No financial headroom
Even small deviations make debt service impossible.
What banks check in a financial plan
| Component | The bank’s main question | Supporting evidence |
|---|---|---|
| Revenue | Why will sales rise by this amount within this time? | Contracts, orders, pipeline, historical conversion and price lists |
| Cost of sales | Are changing purchasing prices, logistics and utilisation included? | Specifications, quotations and cost calculations |
| Fixed expenses | Are staff, premises and infrastructure sufficient for growth? | Staffing plans, leases and departmental budgets |
| Working capital | How much cash will be tied up in inventory and receivables? | Payment terms, turnover ratios and purchasing schedules |
| Investment | When is investment needed and what does it deliver? | Budgets, contracts, launch dates and capacity calculations |
| Taxes | Do payments match the tax regime and forecast profit? | Tax calendar and taxable-base calculations |
| Debt | Are all bank loans, other loans, leases and sureties included? | Agreements and a consolidated obligation schedule |
| Cash balance | Does a reserve remain after every payment? | Monthly or weekly cash flow forecasts |
Figures must be linked. Higher sales need appropriate purchases, staff or capacity. Profit cannot be shown while ignoring growing receivables. Every material line needs a formula and clear basis.
Why banks need integrated profit and loss, cash flow and balance sheets
Shows economics
Revenue, cost of sales, gross and operating profit by period.
Shows liquidity
Actual timing of receipts and payments, cash shortfalls and debt.
Shows the consequences
Inventory, receivables, payables, fixed assets, equity and borrowing.
Checks consistency
A change in one statement should have explainable effects in the other two.
One period’s closing balance becomes the next period’s opening balance. A negative amount shows the timing and size of a shortfall.
If revenue grows by 30%, the balance sheet should show the supporting inventory and receivables, cash flow should show when sales become cash, and profit and loss should show the additional margin.
Assumptions that prompt the most questions
- Sharp sales growth without signed contracts, a substantiated pipeline or comparable seasonal history.
- Immediate full utilisation of new premises or equipment.
- Unchanged margins despite higher purchase prices, exchange rates or logistics costs.
- Lower receivables without changed contracts or customer collection practices.
- No extra staff or expenses despite substantial expansion.
- Zero capital expenditure despite worn assets.
- Loan repayment from revenue without cost of sales and mandatory payments.
Put key assumptions on a separate sheet: prices, volumes, payment terms, purchasing costs, exchange rates, utilisation, staffing and taxes. The bank can then check the model and the company can quickly recalculate scenarios.
Scenarios to prepare
| Scenario | Approach | What should be visible |
|---|---|---|
| Base case | The most likely plan without maximum optimism | Sufficient cash flow and a reserve after payments |
| Conservative case | Lower or later sales and higher expenses | Resilience limits and management responses |
| Stress case | Several key factors deteriorate together | Peak shortfall, available reserves and any need to revise the transaction |
This is an example, not a universal bank benchmark. Choose parameters reflecting actual business and transaction risks.
Scenarios must change cash flow and the balance sheet as well as profit. Later customer payments increase receivables and cash shortfalls even where annual profit barely changes.
Documents substantiating a forecast
| Document | What it substantiates |
|---|---|
| 12–24 months of actual results | Seasonality, margins, turnover and previous forecast accuracy |
| Contracts and orders | Volume, price, performance dates and payment schedule |
| Sales pipeline | Stages, probabilities and historical deal conversion |
| Budgets and quotations | Equipment, repair, materials and service costs |
| Purchasing plan | The timing and amount of working capital needs |
| Staffing plan | Growth resources and additional payroll |
| Debt schedules | Full commitments including the new loan |
| Actual versus budget | Budgeting quality and past variance explanations |
Example: a profitable plan with insufficient cash flow
A company requests RUB 20 million for purchasing to support growth. Last year’s revenue was RUB 120 million; the base plan assumes RUB 156 million, a 30% increase, and RUB 15 million of operating profit.
| Factor | Base plan | Conservative plan |
|---|---|---|
| Revenue | RUB 156 million | RUB 138 million |
| Operating profit | RUB 15 million | RUB 8 million |
| Inventory increase | RUB 12 million | RUB 10 million |
| Receivables increase | RUB 9 million | RUB 12 million |
| Payments on all debt | RUB 9 million | RUB 9 million |
| Minimum balance | RUB 4 million | RUB −5 million |
Debt is serviceable in the base case, but lower sales and slower customer payments create a RUB 5 million conservative-case shortfall. Banks assess smaller purchases, staged drawdowns, a longer schedule or greater own funding.
The aim is not to force a positive conservative case at any cost. Show a manageable response to deviations in advance.
Preparing a forecast for a loan application
Reconcile profit and loss, cash flow and balance sheets for comparable periods.
Record prices, volumes, margins, payment terms and utilisation.
Provide contracts, orders, pipeline, budgets and resource plans.
Every profit and loss change should flow through cash flow and the balance sheet.
Include bank loans, leases, other borrowing and the new payment schedule.
Test delayed launches, lower sales and higher costs.
Substantiate funding by period, not as a share of revenue.
Briefly explain assumptions, risks and responses to deviations.
Mistakes that reduce forecast credibility
Starting with the desired loan amount
Figures are fitted to borrowing rather than actual business economics.
Showing only profit and loss
Profit does not show cash timing or working capital changes.
Hiding formulas
The bank cannot verify how results were derived.
Using only one scenario
The plan does not show delays or cost increases.
Not explaining past budget variances
Repeated forecasting errors undermine the new model.
Ignoring the minimum cash balance
Formal debt coverage without reserves leaves no liquidity.
Need to check your financial plan before approaching the bank?
NG Finance helps Russian LLCs and individual entrepreneurs understand their finances before raising funds, identify actual needs and select a suitable financing instrument.
Request an assessmentFrequently asked questions
How far ahead should the forecast extend?
Cover at least the transaction period and every material repayment stage. Detail and horizon depend on the product and bank request.
Is a revenue forecast sufficient?
No. Include expenses, working capital, taxes, investment, debt and cash balances.
Can the model be prepared in Excel?
Yes. Transparent formulas, assumptions and integrated statements matter more than software format.
How can future sales be substantiated?
Through contracts, orders, the pipeline, historical conversion, utilisation plans and current actual trends.
Should a stress case be included?
It helps identify resilience limits and prepare answers to bank questions.
Can price increases be forecast?
Yes, where supported by contracts, new price lists, negotiations or pricing history.
What if the cash balance becomes negative?
Review amounts, drawdowns, timing, purchasing schedules, payment terms or own contributions.
Does a forecast guarantee approval?
No. It forms part of a broader assessment of the company, transaction, security and credit risk.
Conclusion
A strong forecast does not promise perfect growth. It shows how actual operations create future revenue, profit and cash, the resources needed and consequences of deviations. Banks value verifiable assumptions and sufficient debt repayment sources.
Official materials
- Bank of Russia: guidance on Regulation No. 590-P and borrower financial assessment
- Bank of Russia: substantiation of business plans and forecast figures
- Russian SME Corporation: investment project structuring and risk analysis
- Federal Tax Service of Russia: state accounting statements information resource
This material is for information and does not guarantee loan approval. Banks use their own models, forecast requirements and risk assessment rules.