calculate-loan

01 Loan payments

Cash Flow Projection for Bank Loan: How to Build One

Calculator No. 01-23205 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A cash flow projection for a bank loan is a document that estimates the money coming into and going out of your business over a future period, typically 12 months, to show the lender you can repay the loan. You enter your expected sales, expenses, and loan payments, and the projection outputs your monthly net cash flow and ending cash balance. This article explains what lenders look for, how to build the projection step by step, and common mistakes to avoid.

Formula

The core of a cash flow projection is simple arithmetic:

  • Net Cash Flow = Cash Inflows – Cash Outflows
  • Ending Cash Balance = Beginning Cash + Net Cash Flow

For a loan, the monthly payment is calculated using the standard amortization formula:

Monthly Payment (PMT) = P × (r × (1 + r)^n) / ((1 + r)^n – 1)

Where:

  • P = loan principal (amount borrowed, in $)
  • r = monthly interest rate = APR / 12 (as a decimal, e.g., 8% APR → 0.08/12 = 0.006667)
  • n = total number of payments = loan term in years × 12

The projection then subtracts that payment from your operating cash flow to show whether you can cover the debt.

Worked Example

Using the default values from the calculator above:

  • Loan amount: $50,000
  • APR: 8%
  • Term: 5 years (60 months)
  • Monthly sales: $15,000
  • Monthly operating expenses: $10,000

First, calculate the monthly interest rate: r = 8 / 1200 = 0.006667.

Then the monthly payment:

PMT = 50000 × (0.006667 × (1.006667)^60) / ((1.006667)^60 – 1)

(1.006667)^60 ≈ 1.48985

PMT = 50000 × (0.006667 × 1.48985) / (1.48985 – 1) = 50000 × (0.009932) / 0.48985 ≈ 50000 × 0.020276 ≈ 1013.82

So the monthly payment is about $1,013.82.

Monthly net cash flow = $15,000 – $10,000 – $1,013.82 = $3,986.18.

Year-end cash balance (assuming starting at zero) = $3,986.18 × 12 = $47,834.16.

The calculator rounds the payment to $1,013.82, giving the same results.

Assumptions

  • Interest rate is fixed for the entire term.
  • Payments are made at the end of each month.
  • Interest compounds monthly at APR/12.
  • Sales and expenses are constant each month; in reality they vary.
  • No taxes, insurance, fees, or one-time costs are included unless you add them to expenses.

Why Lenders Ask for a Cash Flow Projection

Banks want to see that your business generates enough cash to repay the loan without relying on outside help. A projection shows:

  • Your expected revenue and when it arrives.
  • Your fixed and variable costs.
  • Your ability to cover the loan payment each month.
  • Your cash cushion for unexpected expenses.

Lenders typically look for a positive net cash flow each month and a cash balance that stays above zero. A projection that shows negative months may signal risk, but it can still be acceptable if you explain the seasonality or planned investments.

How to Build a Cash Flow Projection

Follow these steps to create a projection lenders will take seriously:

  1. Choose a period – usually 12 months, broken down by month.
  2. Estimate cash inflows – list all sources: sales, accounts receivable collections, loans, investments. Be conservative; use realistic numbers, not optimistic ones.
  3. Estimate cash outflows – include rent, salaries, utilities, inventory, marketing, loan payments, taxes, and any other recurring costs.
  4. Subtract outflows from inflows – this gives your net cash flow for each month.
  5. Add beginning cash balance – start with what you have in the bank today, then add net cash flow to get ending balance.
  6. Carry the ending balance forward – next month’s beginning balance is this month’s ending balance.
  7. Review and adjust – if any month shows a negative balance, adjust your assumptions or plan to cover it (e.g., delay a purchase or arrange a line of credit).

Common Mistakes to Avoid

  • Using profit instead of cash – profit includes non-cash items like depreciation; cash flow tracks actual money in and out.
  • Ignoring timing – a sale made in March may not be collected until May; record cash when it arrives, not when the invoice is sent.
  • Overly optimistic sales – lenders discount aggressive forecasts; base numbers on historical data or conservative growth.
  • Forgetting irregular expenses – quarterly taxes, annual insurance premiums, or equipment repairs can sink a projection if left out.
  • Mixing up monthly and annual figures – always keep the same time unit.

How to Present It to a Lender

When you submit your projection, include assumptions clearly. For example, state that sales are based on last year’s average plus 5% growth, or that expenses are from your latest income statement. Lenders appreciate transparency. Also show a column for “actual” figures if you have past months, so they can see you’ve been accurate before.

If your projection shows a tight cash flow, explain how you’ll handle it — for instance, by reducing discretionary spending or securing a short-term credit line. Do not hide problems; lenders may verify with bank statements.

Limitations of a Cash Flow Projection

A projection is an estimate, not a guarantee. It assumes your sales and expenses stay as predicted, which rarely happens. It also doesn’t capture changes in the economy, customer behavior, or unexpected events. Lenders know this, so they often require collateral or a personal guarantee as a safety net. Use the projection as a planning tool, not a promise.

Frequently Asked Questions

Do I need a cash flow projection if I have good credit?
Yes. Even with strong personal credit, lenders want to see that the business itself can repay the loan. A projection demonstrates your understanding of your cash cycle and reduces the lender’s risk.

What if my projection shows a negative month?
It’s not an automatic rejection. Explain why (e.g., seasonal dip) and show how you’ll cover it, such as using a reserve or delaying a capital purchase. Lenders prefer a realistic projection with a plan over an overly optimistic one.

How far ahead should the projection go?
Most lenders ask for 12 months, but some want to see 2 years. Match the loan term — if you’re borrowing for 5 years, consider showing a 5-year projection, though 12 months is usually sufficient for approval.

Can I use a spreadsheet or template?
Yes. Excel or Google Sheets work fine. The key is accuracy and clarity. Many banks provide their own template; ask your loan officer.

What if my business is new and has no historical data?
Use industry benchmarks and your own research. Be conservative. You may also include personal income or a co-signer to strengthen your application.

Does the projection guarantee loan approval?
No. It’s one piece of the application. Lenders also review your credit, collateral, and overall business health. A solid projection helps, but it doesn’t guarantee a yes.

The result from this calculator is an estimate based on your inputs; the lender’s official disclosure will give the exact figures for your loan.

Related

Formula used
in p | Loan amount | $ | 50000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
in sales | Monthly sales (avg) | $ | 15000 | 0 | 10000000
in exp | Monthly operating expenses | $ | 10000 | 0 | 10000000
out pmt | Monthly loan payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out net | Monthly net cash flow | $ | sales - exp - pmt | 2
out bal | Year-end cash balance | $ | (sales - exp - pmt) * 12 | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →