Budget-to-Actual Variance Analysis for Commercial Loan Underwriting

01

Start with the lender's exact comparison

Identify which budget, forecast, covenant case, borrowing-base plan, or underwriting model the lender is using. Record the version date, reporting period, entities, accounting basis, currency, units, seasonality, acquisition or disposition assumptions, and definitions of revenue, EBITDA, net operating income, fixed charges, capital expenditures, and debt service. A comparison against an obsolete board budget or a different consolidation perimeter can create apparent variances that are only definition differences. Preserve the original approved case and label every subsequent forecast separately.

02

Reconcile the actual results before explaining them

Tie actual revenue and expenses to the general ledger and interim income statement, cash to bank reconciliations, debt to lender statements, receivables and payables to aging reports, inventory to the perpetual or physical records, and capital spending to the fixed-asset schedule. Resolve late entries, cutoff errors, intercompany activity, reclassifications, and changes in accounting policy. A narrative cannot repair numbers that do not reconcile. Show preliminary amounts as preliminary and replace them through a controlled update when the close is final.

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

03

Build a revenue bridge using volume, price, mix, and timing

Separate the variance caused by units, customers, occupancy, billable hours, utilization, average ticket, rent, rates, product or service mix, geographic mix, project timing, cancellations, returns, concessions, and foreign exchange where applicable. Distinguish signed backlog and recurring contracts from pipeline or management expectations. Explain whether revenue moved between months or disappeared, and reconcile reported sales to invoices, contracts, deposits, and collections. A lender needs to understand the repeatable driver, not only that sales were above or below plan.

04

Explain gross-margin and net-operating-income movement

Bridge revenue to gross profit or property NOI using labor, materials, freight, utilities, occupancy, commissions, discounts, vacancy, credit losses, repairs, taxes, insurance, management fees, and other direct costs. Separate price recovery from real productivity and identify costs deferred into another period. For real estate, reconcile the rent roll and actual collections to income and normalize operating expenses under the lender's definitions. For operating companies, explain unit economics and whether recent margin changes are sustainable after current supplier and wage commitments.

05

Analyze operating expenses by controllability and recurrence

Group expenses into fixed, variable, discretionary, contractual, one-time, and timing categories. Document hiring, overtime, professional fees, technology, marketing, litigation, relocation, integration, repairs, insurance, and other material departures from plan. Identify amounts that management can reduce, contractual costs that will persist, and expenses that were merely delayed. Do not present a recurring cost as a one-time add-back or claim a future saving without a measurable implementation date and operating consequence.

06

Connect earnings variances to working capital and cash

Compare the income-statement result with receivable days, collection aging, inventory units and turns, payable timing, customer deposits, deferred revenue, tax payments, vendor deposits, retainage, and other cash-cycle items. Growth can consume liquidity before it improves cash flow, while slower purchases or stretched vendors can temporarily increase cash. Prepare a sources-and-uses or cash bridge from beginning cash through operating cash flow, working-capital changes, capital expenditures, financing, owner activity, and ending cash. Reconcile the bridge to bank activity and the balance sheet.

07

Review the balance sheet, leverage, and collateral impact

Explain variances in cash, receivables, inventory, fixed assets, payables, accrued expenses, taxes, related-party balances, debt, equity, and contingent obligations. Update the debt schedule for new draws, repayments, leases, seller notes, equipment obligations, and guarantees. If collateral values or borrowing-base eligibility changed, quantify the effect on availability and required reserves. A favorable income variance may not improve credit quality if leverage, liens, past-due obligations, or collateral dilution increased.

08

Recalculate covenants and debt-service capacity consistently

Use the definitions, exclusions, cure rights, testing dates, annualization rules, and reporting basis in the executed loan documents or proposed term sheet. Show the original budget case, actual result, lender-defined calculation, and management's internal calculation when they differ. Recalculate DSCR, fixed-charge coverage, leverage, liquidity, debt yield, net worth, and other relevant tests with supporting schedules. If a breach or near-breach is possible, notify qualified advisers and the lender under the applicable process rather than waiting for the reporting deadline.

09

Reforecast the remainder of the period and stress the new case

Update the forecast from the latest actual month instead of simply adding the original remaining budget. Reflect current backlog, staffing, pricing, costs, collections, inventory, capital spending, interest rates, debt payments, taxes, distributions, and closing assumptions. Present a base case and downside case with identified triggers. Quantify how much of the original annual variance can realistically recover and when. A reforecast should show a credible path to liquidity and debt service, not mechanically force the year-end result back to budget.

010

Give the lender an accountable action plan

Prepare a concise variance report with the metric, budget, actual, dollar and percentage difference, cause, recurrence, cash impact, forecast impact, responsible owner, corrective action, deadline, and evidence. Address bad news directly and avoid unsupported optimism. Track actions such as repricing, collections, inventory reduction, hiring changes, expense controls, additional equity, covenant relief, or revised financing structure. PFCS can help organize the financing package and coordinate information with prospective capital sources, while lenders and qualified accounting, legal, tax, valuation, and other professionals determine calculation treatment, disclosure, compliance, approval, and final terms.