Commercial Loan Projections: Build a Forecast Lenders Can Stress-Test

01

Start With the Financing Decision the Forecast Must Support

Define the request before building the model: loan amount, use of proceeds, expected funding date, repayment structure, and the business change the capital will enable. A forecast for an equipment purchase should connect capacity and operating savings to installation and ramp-up timing. Acquisition projections should separate the target's existing performance from integration assumptions. A working-capital request should show when cash is tied up in receivables or inventory and when it returns. The model should cover the lender's requested period and clearly distinguish monthly, quarterly, and annual figures.

02

Reconcile the Starting Point to Historical Results

Begin with finalized historical financial statements, tax returns, and the latest year-to-date results. Reconcile the forecast's opening cash, receivables, inventory, payables, debt, and equity to a dated balance sheet. Explain material differences between tax reporting, internal statements, and lender-adjusted results. If recent performance departs from prior years, identify the operational reason and provide evidence such as contracts, orders, pricing changes, staffing records, or closed locations. A model that starts from unsupported numbers will remain unreliable even if every later formula is correct.

• Requested amount and use of proceeds
• Historical and current financial statements
• Complete debt and ownership schedules
• Collateral and transaction documentation

03

Build Revenue From Verifiable Drivers

Translate revenue into the few operating variables management actually controls or observes. Depending on the business, those may include units sold, average price, customers, utilization, billable hours, occupied rooms, leased square feet, recurring contracts, conversion rates, or project backlog. Separate committed business from pipeline assumptions, account for cancellations and seasonality, and avoid applying one growth percentage to every month. When financing itself creates growth, show the lag between funding, delivery, hiring, production, shipment, invoicing, and collection.

04

Model Margins and Operating Costs Independently

Do not assume expenses remain a fixed percentage of revenue when the underlying costs behave differently. Separate direct material, freight, subcontractor, commission, and labor costs from rent, insurance, technology, professional fees, and other overhead. Reflect known wage changes, benefit costs, contract escalators, maintenance, taxes, and insurance renewals. Identify owner compensation and any proposed adjustments without assuming the lender will accept them. Gross margin, operating margin, and break-even volume should be traceable to the same assumptions used in the revenue plan.

05

Connect Profit to Working Capital and Cash

Accounting profit is not the same as cash available for debt service. Model collection timing for receivables, supplier terms, inventory purchases, customer deposits, retainage, tax payments, distributions, and other cash movements. Growth can increase financing needs even while reported earnings improve. Build a balance sheet and cash-flow statement that roll forward with the income statement so receivables, inventory, payables, cash, and equity change consistently. If a revolving line is part of the request, show the expected borrowing and repayment cycle rather than carrying a constant balance without explanation.

06

Add Capital Spending and Every Debt Obligation

Schedule equipment purchases, installation, improvements, maintenance capital expenditures, and disposals in the periods when cash will move. Tie depreciation assumptions to the capital plan where relevant. Bring every existing loan, lease, line of credit, seller note, and proposed facility into one debt schedule with its rate, payment, amortization, maturity, and balloon. For floating-rate obligations, identify the benchmark, spread, floor, and reset timing. The forecast should calculate debt service from those structures instead of inserting a single annual estimate.

07

Give the Lender a Base Case and a Credible Downside Case

A downside case should change the assumptions that create risk, not simply reduce net income by an arbitrary percentage. Test slower sales conversion, lower volume, margin compression, delayed collections, higher payroll, cost overruns, a later opening date, customer loss, vacancy, or a higher floating rate as appropriate. Show the effect on liquidity, borrowing-base availability, debt-service coverage, covenant headroom, and any balloon or maturity. State the actions management could realistically take and the timing required; do not assume costs disappear immediately when revenue softens.

08

Package the Forecast for Review and Ongoing Use

Provide a concise assumptions page, monthly detail for the near term, annual summaries, historical-to-projected comparisons, and clear labels for management estimates versus signed commitments. Make formulas consistent, flag circular references, and reconcile totals across schedules. Identify the preparer, version date, and changes from the previous forecast. After funding, compare actual results with the model and explain material variances. PFCS can help organize a commercial financing request and coordinate it with third-party capital sources, but each lender determines acceptable assumptions, underwriting adjustments, covenants, approval, pricing, and final terms.