# Cash Flow Projection Analysis for Business Loan Files

- Author: TrueBankFlow (https://truebankflow.com)
- Published: 2026-10-17
- Category: Business loan and MCA underwriting
- Canonical: https://truebankflow.com/blog/cash-flow-projection-analysis

> Cash flow projection analysis for a business loan: testing a borrower's forecast against actual deposits, stress cases and what makes it credible.
Cash flow projection analysis is how a lender checks whether a borrower's forecast of future cash in and out is believable enough to lend against. The analyst starts the forecast from actual bank deposits, tests each revenue and cost assumption, builds at least one weaker case and asks whether the loan still gets repaid if the plan falls short.

## What does cash flow projection analysis test in a loan file?

Cash flow projection analysis in a loan file tests three things: whether the forecast starts from the business's real current performance, whether its assumptions about growth and costs are supported, and whether the loan can still be repaid if those assumptions miss. A projection that passes all three can support a credit decision.

Lenders lean on projections when history alone does not answer the question. That happens when the loan funds something new: a second location, a large piece of equipment, a building purchase, an acquisition or a business only a year or two old. In each case, past results describe a smaller or different business than the one the loan will create.

Borrowers usually arrive with a forecast already built. The [SBA's guide to writing a business plan](https://www.sba.gov/business-guide/plan-your-business/write-your-business-plan) tells owners to include forecasted income statements, balance sheets, cash flow statements and capital expenditure budgets for the next five years, with quarterly or even monthly figures for the first year, and to match the projections to the funding request. That is a fair description of what lands on an analyst's desk.

The analyst's job is not to rebuild the plan. It is to find the few assumptions that drive repayment and decide how much to trust each one. Revenue growth, gross margin, payroll and the timing of the new debt payment usually matter most.

## Projected revenue against actual bank deposits

Projected revenue should start from what the business actually collects today, and bank deposits are the cleanest record of that. The analyst totals revenue deposits for the most recent twelve months, removes transfers, loan proceeds and owner injections, and compares the result with the forecast's first year and with the revenue on the last tax return.

The three figures rarely match exactly. Deposits follow cash timing, tax returns follow the accounting method, and forecasts follow the owner's hopes. The size and direction of the gaps tell the analyst where to dig.

### A worked comparison

The figures below are an example for a fictional commercial bakery planning a second production line. They are illustrative, not benchmarks.

| Line (example) | Last tax return | Trailing 12 months of deposits | Forecast year 1 | Downside case year 1 |
| --- | --- | --- | --- | --- |
| Revenue | $1,180,000 | $1,214,000 | $1,520,000 | $1,290,000 |
| Cost of goods sold | $590,000 | not on statements | $730,000 | $658,000 |
| Gross margin | 50% | | 52% | 49% |
| Operating expenses | $410,000 | | $455,000 | $455,000 |
| Cash available for debt service | $180,000 | | $335,000 | $177,000 |
| Existing debt service | $48,000 | $48,000 (lender debits) | $48,000 | $48,000 |
| New loan debt service | | | $96,000 | $96,000 |
| **Coverage** | | | **2.33** | **1.23** |

The trailing deposits sit close to the tax return, which supports the starting point. The forecast then jumps 25% in one year and improves margin at the same time. The downside case keeps only 6% growth over trailing deposits, lets margin slip by one point and leaves operating costs at plan. Coverage drops from 2.33 to 1.23.

Whether 1.23 is acceptable depends on the lender's policy and the rest of the file. The useful finding is that the loan depends on the new line selling most of its expected output in year one. That is the question to put to the borrower.

A monthly view of the same deposits also shows the bakery's seasonal swing, which matters for when the first payments fall. Tools such as [TrueBankFlow](/) line up statements month by month and recalculate the average when you exclude a transfer or loan credit, giving the analyst the trailing figure without rekeying every deposit. The forecast review itself remains the analyst's work.

## Expense and margin assumptions in a borrower's cash flow forecast

Expense and margin assumptions in a cash flow forecast deserve as much attention as revenue, because small changes in margin move repayment capacity far more than owners expect. The analyst checks whether costs grow with sales, whether payroll covers the staff the plan needs and whether the forecast quietly assumes better supplier prices.

The lines that hide the most optimism:

- **Gross margin.** A forecast that improves margin and grows sales at the same time needs a reason, such as new equipment that cuts waste. Otherwise margins usually hold or slip during expansion.
- **Payroll.** New capacity needs people. Compare headcount in the plan with what the bank statements show in payroll debits today.
- **Rent and occupancy.** A new site often carries rent from day one while sales build slowly.
- **Owner pay.** Some forecasts leave out the owner's salary or distributions. The owner still needs to live, and the money will leave the business.
- **Taxes.** Projected income produces tax bills. A forecast showing higher profit with flat tax payments is incomplete.
- **Working capital.** Faster growth ties up more cash in inventory and receivables before customers pay. The timing problem behind that is the subject of [working capital loan underwriting](/blog/working-capital-loan-underwriting).

Bank statements help here too. Recurring debits show what the business actually pays for rent, insurance, software, loan payments and payroll. If the forecast's monthly operating costs are lower than what the account already pays out, the plan has skipped something.

## Downside cases for a business cash flow projection

A downside case is a second version of the borrower's projection with weaker assumptions, built to see whether the loan still gets repaid if the plan falls short. Most analysts build one or two: a moderate miss on revenue and margin, and a harder case that shows how far results can fall before coverage drops below one.

Examiners expect this discipline in riskier deals. In its discussion of leveraged lending, the [FDIC RMS Manual of Examination Policies, Section 3.2](https://www.fdic.gov/regulations/safety/manual/section3-2.pdf) says an institution's analysis should ensure that cash flow analyses do not rely on overly optimistic or unsubstantiated projections of sales and margins, and that projections are stress tested for one or two downside scenarios. The same habit serves a small business file.

Ways to build a downside case:

1. **Hold revenue near trailing actuals** instead of the forecast's growth.
2. **Push the ramp back.** If the plan says a new location reaches full sales in month six, try month twelve.
3. **Trim margin** by a point or two to reflect input cost increases.
4. **Keep costs at plan.** Rent, payroll and debt payments rarely shrink when sales disappoint.
5. **Raise the rate** on any variable rate debt.

A breakeven case adds one more number: the revenue level at which coverage falls to exactly 1.00. If that level is well below trailing deposits, the loan has room. If it sits above them, the loan only works if the plan succeeds.

## How far ahead can a lender rely on a cash flow forecast?

A lender can usually rely on the first year of a cash flow forecast with some confidence, the second year with less, and later years mainly as a sign of whether the owner has thought the plan through. Each year further out compounds more assumptions, so credit decisions lean on the near term and treat the rest as context.

The weight given to each year depends on how much the business is changing. A firm adding a modest piece of equipment to a known operation has a forecast close to history, so even year three has meaning. A startup or a business entering a new market has a forecast that is mostly assumption from the first month.

Long-term real estate loans test this most. A 504 project financed over 20 or 25 years cannot be underwritten on a 25 year forecast. Lenders look at historical cash flow, the first years of the projection and the strength of the owners. The program's tests are described in [SBA 504 loan underwriting](/blog/sba-504-loan-underwriting). For conventional real estate, the same balance between operating history and a projection appears in [commercial loan underwriting](/blog/commercial-loan-underwriting).

Covenants are the lender's answer to forecast risk. A loan made on a projection often requires annual or quarterly financial statements and a minimum coverage ratio. If results trail the plan, the lender learns early, while there is still time to restructure.

## Forecast warning signs: hockey sticks, missing debt and borrowed growth

Forecast warning signs are patterns that suggest a projection is a sales document rather than a plan. The common ones are a sudden steep rise after flat history, debt payments left out, growth that depends on money the business has not raised, and cash flow that never dips despite a seasonal business.

Look for these in any company cash flow analysis:

- **The hockey stick.** Years of flat revenue, then 40% growth starting the month after funding. Ask what changes on that day.
- **Missing debt.** The forecast shows the new loan but not existing ones. Compare its debt line with recurring lender debits on the statements.
- **Borrowed growth.** Expansion that needs a second loan, a new investor or a large customer contract not yet signed.
- **No seasonality.** Smooth monthly cash flow in a business whose deposits swing every year.
- **Personal income mixed in.** Some owners add household income to the business forecast. Mortgage underwriters sometimes increase nontaxable personal income for qualifying, which is explained in [grossing up nontaxable income](/blog/gross-up-nontaxable-income). A business projection should not apply any such adjustment to company cash flow.
- **No sources.** Market size or price assumptions with nothing behind them.

None of these alone means the loan fails. They mean the analyst should give the projection less weight and lean more on trailing cash flow, collateral and the guarantors.