Financial Projections & DSCR Analysis

How we build pro formas, calculate debt service coverage, and stress-test projections for SBA underwriting

The financial projection is where every element of the feasibility study converges into a single question: can this project generate enough cash flow to service its debt? The market analysis establishes demand. The competitive analysis validates pricing. The site assessment confirms physical viability. The financial projection takes all of those inputs and translates them into a multi-year income statement, a debt service calculation, and the DSCR that determines whether the loan gets approved.

Our financial modeling methodology follows one principle above all others: every number in the pro forma must be traceable to a market finding or an industry benchmark. A revenue projection that cannot point to its source in the market analysis is an assumption. An expense projection that cannot point to a published benchmark is a guess. Assumptions and guesses do not survive credit committee review.

Revenue Projection Approaches by Asset Class

There is no universal revenue projection model. Each property type has a different revenue structure, different performance metrics, and different data sources. The methodology must match the asset class.

Each revenue model is built bottom-up from the market analysis, not top-down from a target. We do not start with a desired revenue number and work backward to find assumptions that support it. We start with the market data (traffic counts, comp set performance, demographic demand) and build forward to a projected revenue figure. If that figure does not produce an adequate DSCR, the project may not be feasible. That is a finding, not a failure of the model.

Operating Expense Benchmarking

Operating expenses are projected using industry-specific benchmarks, adjusted for local cost factors. We never accept borrower-provided expense estimates without independent validation against published data.

The management fee is always included, even for owner-operated businesses. This is a point of frequent disagreement with borrowers who plan to manage the business themselves and view the management fee as unnecessary. The fee must be included because the DSCR must demonstrate that the business can service its debt independent of the owner working for free. If the owner becomes incapacitated, the business must be able to hire a replacement manager and still cover its obligations. SBA lenders and processing centers routinely reject pro formas that omit management compensation.

NOI and Cash Flow Modeling

The pro forma follows a standard commercial real estate income statement structure that credit officers are trained to read.

We model the pro forma on two timescales. The annual pro forma covers Years 1 through 5 (or longer for projects with extended ramp periods) and provides the stabilized DSCR that drives the credit decision. The monthly pro forma covers the first 12 to 24 months and is essential for new construction, startups, and seasonal businesses where the annual average masks months of negative cash flow. A hotel that achieves 1.30x DSCR annually may operate below breakeven from November through February. The lender needs to see the monthly trajectory, not just the annual average.

DSCR Calculation and SBA Minimum Thresholds

The debt service coverage ratio is calculated as adjusted NOI (cash flow available for debt service) divided by total annual debt service. Total debt service includes all obligations the business must service from operating cash flow.

Total debt service means ALL debt. The most common DSCR error we encounter in studies from other providers is calculating DSCR against only the SBA mortgage while omitting equipment leases, lines of credit, seller carry-back notes, or partner distributions that are contractually required. If the business has $300,000 in annual SBA mortgage payments plus $80,000 in equipment lease payments, total debt service is $380,000. A $450,000 NOI produces a 1.50x DSCR against the mortgage alone but only 1.18x against total debt service. The second number is the real DSCR, and it is the one the lender must evaluate.

Sensitivity Analysis and Stress Testing

The base case DSCR answers the question "what happens if everything goes according to plan?" Sensitivity analysis answers the more important question: "what happens when it doesn't?"

We construct three standard scenarios for every feasibility study.

Base case: the most probable outcome derived from market data. This is the scenario the revenue and expense projections are calibrated to produce. It represents the median expectation, not the best case.

Optimistic case: assumes favorable conditions. Revenue 10% to 15% above base case (faster absorption, stronger pricing, better competitive positioning than projected). Expenses 5% to 10% below base case (efficient operations, favorable utility rates). This scenario is included for completeness and to show the upside potential, but no credit decision should be based on the optimistic case.

Pessimistic case: assumes adverse conditions. Revenue 15% to 25% below base case (slower absorption, competitive price pressure, economic softening). Expenses 10% to 15% above base case (labor cost increases, utility spikes, higher maintenance). This scenario is the one that matters for risk assessment. If the pessimistic DSCR remains above 1.0x, the project can survive adversity. If it drops below 1.0x, the lender must evaluate the probability and duration of the adverse scenario.

Single-Variable Sensitivity Testing

Beyond the three scenarios, we test individual variables to identify which assumptions have the greatest impact on DSCR. This tells the lender where the real risk lies.

The output of single-variable testing is a sensitivity table that shows the DSCR at each test level. This table is one of the most referenced exhibits in the study by credit committees. It answers questions like "what occupancy does the hotel need to maintain a 1.15x DSCR?" or "how much can labor costs increase before the restaurant breaks even?" These breakeven thresholds give the lender concrete risk metrics rather than abstract scenarios.

Monte Carlo Simulation for Complex Projects

For complex projects with multiple interdependent risk variables, we employ Monte Carlo simulation to quantify the probability distribution of DSCR outcomes. Rather than testing one variable at a time (which ignores the correlation between variables), Monte Carlo runs thousands of simulations where all key variables fluctuate simultaneously within their expected ranges.

The output is a probability distribution: "there is a 75% probability that DSCR will exceed 1.15x in Year 2" is a more informative risk statement than "base case DSCR is 1.35x." We use Monte Carlo simulation selectively for projects where the interaction between variables is significant: mixed-use developments with multiple revenue streams, seasonal businesses with weather-dependent demand, and projects in volatile markets where multiple adverse conditions may coincide.

Monte Carlo simulation is not standard in SBA feasibility studies. Most studies use the three-scenario plus single-variable approach, which is sufficient for straightforward transactions. We reserve Monte Carlo for complex projects where the standard approach does not adequately capture the risk profile, and when the additional analytical depth is warranted by the project's size and complexity.

Projection Timeline and Growth Assumptions

The projection period is typically 3 to 5 years. Year 1 includes monthly detail. Years 2 through 5 are annual. The timeline extends beyond 5 years only for properties with unusually long stabilization periods (self-storage at 3+ years) or when the loan term demands it (504 debentures with 20 or 25-year terms may warrant a longer projection horizon).

Revenue growth assumptions are anchored to market evidence. We typically project 2% to 4% annual revenue growth beyond stabilization, which reflects a combination of rate increases (inflation-linked) and modest occupancy/utilization improvements. Growth assumptions above 4% require specific market justification (documented population growth above 3% annually, demonstrated supply constraints, contractual rate escalators). We do not project hockey-stick revenue growth because lenders do not believe it and SBA examiners flag it.

Expense growth assumptions are projected at 2% to 3% annually for most categories, with specific adjustments for known escalators (scheduled minimum wage increases, property tax reassessment triggers, insurance market hardening, franchise fee increases). Labor cost growth in the current environment is projected at 3% to 5% given the persistent tightness in service-sector labor markets across most U.S. metros.

How This Connects to the Market Analysis

The financial projection is not a standalone model. Every input traces back to the market analysis. The projected occupancy comes from the demand quantification model. The projected rate comes from competitive benchmarking. The absorption timeline comes from comparable transaction analysis. The expense ratios come from industry benchmarks adjusted for local conditions identified during the market analysis.

This traceability is what makes the financial projection defensible. A credit officer who questions the revenue projection can follow it back to the demand model. If the demand model is sound, the revenue projection is sound. If the demand model has a gap, the revenue projection inherits that weakness and the study acknowledges it. There are no orphan numbers in our pro formas. The complete SBA loan DSCR methodology reference explains the numerator, denominator, current thresholds, global coverage and stress tests in detail.