Can I Afford This Property?Commercial real estate financing, worked out

Building a pro forma lenders will take seriously

A practical guide to constructing pro formas that withstand lender scrutiny through rigorous assumption support and sensitivity analysis.

Topic: Preparing the loan package995 wordsUpdated 2026-11-19

Lenders evaluate pro formas primarily to verify the viability of the underlying business plan and to assess the sponsor’s ability to service debt under adverse conditions. A credible model requires transparent, defensible assumptions and clear sensitivity scenarios that demonstrate resilience against market volatility. This approach shifts the focus from optimistic projections to risk-aware planning, which is essential for securing financing approval.

The Role of Assumption Support in Lender Underwriting

Commercial real estate debt providers do not view pro formas as predictions of the future; they view them as logical constructs based on current data and reasonable expectations. When you present a financial model, lenders immediately scrutinize the inputs behind every line item. If an assumption lacks a basis in market data, historical performance, or contractual obligations, it raises red flags about the sponsor’s diligence. For instance, rental growth projections must be supported by comparable lease transactions in the subject property’s submarket or by existing tenant renewal patterns[1]. Similarly, operating expense escalations should align with local inflation trends or specific vendor contracts rather than arbitrary percentages.

Transparency is critical here. You should clearly distinguish between hard costs, which are fixed by contract, and soft costs, which may vary. Lenders appreciate when sponsors explicitly state the source of each assumption. If you project leasing velocity, cite absorption rates from recent industry reports or the track record of your leasing team. If you assume stabilization dates, reference the construction schedule and typical time-to-market for similar assets. This level of detail allows lenders to quickly validate your logic without needing to request additional clarification, streamlining the underwriting process.

Constructing Credible Revenue and Expense Projections

Revenue projections form the core of any pro forma, yet they are often the most heavily challenged section. Lenders look for conservatism in top-line estimates. Overstating occupancy or rental rates can signal inexperience or an attempt to inflate asset value. Instead, base your revenue on realistic lease-up curves or current trailing-twelve-month operating statements if the asset is already stabilized[2]. For development projects, this means modeling phased completions and accounting for vacancy during the lease-up period. Do not assume immediate full occupancy upon completion unless there is a pre-leasing commitment to substantiate it.

On the expense side, accuracy matters just as much. Underestimating operational costs can leave little cushion for debt service. Include all relevant expenses, including management fees, insurance, property taxes, and maintenance reserves. For construction loans, lenders will scrutinize the development budget and schedule closely, ensuring that contingency funds are adequate to cover unforeseen cost overruns[1]. If you omit common expenses or use outdated benchmarks, lenders may discount your entire model. It is better to slightly overstate expenses than to understate them, as this demonstrates prudence and provides a margin of safety for the lender.

Sensitivity Cases: Stress-Testing Your Model

One of the most powerful tools in a pro forma is the sensitivity analysis, which shows how the project performs under various economic scenarios. Lenders want to see that the asset can survive downturns, not just boom periods. You should prepare at least three scenarios: base case, downside case, and severe downside case. The base case reflects your most likely outcome based on current market conditions. The downside case introduces moderate stressors, such as higher vacancy, lower rental growth, or increased interest rates. The severe downside case tests the limits of the project’s resilience.

In these scenarios, adjust key variables systematically. For example, if you reduce projected rental income by ten percent, does the debt service coverage ratio remain above the lender’s minimum threshold? If vacancy increases by five percentage points, can the sponsor still meet reserve requirements? These exercises help identify weak points in the business plan before the lender does. By presenting these cases proactively, you show that you have thoughtfully considered risks and have strategies to mitigate them. This builds confidence in your ability to manage the asset through challenging times.

Practical Preparation Steps for a Robust Pro Forma

Building a lender-ready pro forma requires a structured approach. Start by gathering all necessary data, including rent rolls, trailing-twelve-month operating statements, and market research reports[2]. Ensure your sources and uses table accurately reflects all capital requirements, including closing costs and initial reserves[2]. Next, develop your assumptions document, listing the rationale for every major input. This document serves as a companion to your financial model and helps lenders understand your logic.

Then, construct the financial model using consistent formulas and clear labeling. Avoid complex macros that obscure the underlying calculations. Instead, use simple, auditable spreadsheets where inputs are separated from outputs. This allows lenders to easily modify variables and test their own scenarios. Finally, review the model for internal consistency. Ensure that cash flow statements balance, debt schedules match loan terms, and equity returns align with the overall investment thesis. A clean, well-organized model signals professionalism and attention to detail.

Common Mistakes and Tradeoffs

Sponsors often make the mistake of treating the pro forma as a sales tool rather than an underwriting document. Optimistic bias can lead to unrealistic projections that collapse under scrutiny. Another common error is ignoring the impact of covenants and reserves on cash flow. Lenders require certain financial ratios and reserve accounts, which can constrain liquidity. Failing to account for these requirements in your sensitivity cases can result in covenant breaches during stressful periods. Additionally, some sponsors neglect to update their models after significant market changes. A static pro forma becomes obsolete quickly, so regular updates are essential.

The tradeoff lies in balancing detail with clarity. While comprehensive models provide depth, overly complex ones can confuse lenders and slow down the underwriting process. Strive for a middle ground where every assumption is justified, but the narrative remains easy to follow. Remember that lenders are evaluating risk, not rewarding creativity. A straightforward, conservative model with solid backing is always preferable to an intricate one built on shaky premises.

When legal or tax implications arise from your financing structure, consult counsel or a tax advisor to ensure compliance and optimize outcomes.

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. Commercial construction loans — Wraith Real EstatePrimary
  2. Request financing — Wraith Real EstatePrimary