How to identify unsupported forecast inputs in a multifamily model
A practical checklist for commercial real estate sponsors to test whether the assumptions in their multifamily pro forma are grounded in source data or are speculative projections that could weaken a financing request.
A practical checklist for commercial real estate sponsors to test whether the assumptions in their multifamily pro forma are grounded in source data or are speculative projections that could weaken a financing request.
When you prepare a multifamily financing request, the model you build is only as credible as the inputs you feed it. Lenders will compare your forecast against historical operating data, market benchmarks, and the property's physical condition. This guide helps you identify which inputs are supported by evidence and which are assumptions that need a stronger basis before you submit a package.
Identify the reporting basis for your financial statements
Before you pull income or expense numbers from your financial statements, record the reporting basis. If the statements are prepared on an accrual basis, the revenue shown includes amounts billed but not yet collected. If they are cash basis, the revenue shown is only what was actually deposited. Mixing these two can make your net operating income (NOI) look stronger or weaker than reality. Compare your rent roll—a snapshot of current leases—with your trailing twelve-month (T-12) operating statement, which covers twelve historical months. The T-12 reports historical income and expenses on its stated accounting basis over that period, while the rent roll shows what is contractually due today. When you compare totals, note the timing difference: a rent roll reflects current occupancy, while a T-12 includes months when units may have been vacant or tenants were in nonpayment. Use the T-12 as your primary source for historical collection performance.
Distinguish gross rent, collected income, and net operating income
A common unsupported input is a forecast that uses gross potential rent without deducting vacancy, credit loss, or concessions. Build a clear line from gross rent to collected income to NOI. Gross rent is the total of all signed leases at face value. Collected income is what actually arrives after vacancies, nonpayment, and rent concessions. NOI is collected income minus operating expenses, before debt service and capital expenditures. If your model skips any of these steps, the NOI figure is likely overstated. Record each line item separately and compare the collected income percentage from your T-12 to the percentage you are forecasting. A significant gap without explanation is a red flag for unsupported optimism.
Compare your forecast vacancy and collection loss to historical performance
Pull the actual vacancy rate and collection loss from your T-12. Collection loss includes both units that were physically vacant and units where tenants did not pay. If your model assumes a vacancy rate lower than the historical average, or if you have not accounted for collection loss at all, that input is unsupported. Lenders will ask why future performance should be better than the recent past. You can propose a reasonable improvement if you have a specific plan—such as a new management team or a capital improvement that makes units more desirable—but you must document that plan separately. Without that documentation, the lower vacancy assumption is an unsupported forecast. [1]
Separate capital expenditures from operating expenses in your model
Capital expenditures (capex) are major improvements that extend the life or value of the property, such as new roofs, HVAC systems, or parking lot repaving. Operating expenses are routine costs like landscaping, utilities, and property management fees. If your model treats a large capex item as an operating expense, you will understate true NOI and overstate the property's ability to cover debt service. Record capex in a separate schedule with estimated costs and timing. If you have not included any capex reserve, your NOI forecast may be unsupported.
Create a document workpaper: the input evidence checklist
Prepare a single spreadsheet or document with the following columns: input name, source document, date of source, value from source, forecast value, and variance explanation. For example, under "rent per unit per month," list the current rent roll as the source, the date of that rent roll, the actual average rent, your forecast average rent, and a brief explanation of any difference. Do this for vacancy rate, collection loss, operating expenses per unit, capex per unit, and NOI. This workpaper is not a lender requirement, but it shows that you have systematically compared every key input to actual data.
Ask the actual lender about their underwriting criteria
No tool or checklist can replace a direct conversation with the lender who will evaluate your loan. Use the workbench to build your scenario and download a preliminary package, then contact your lender to ask what specific underwriting standards they apply. For example, ask what LTV they require, whether they use the as-is value or the upon-completion value, and what debt service coverage ratio they expect. [1] The OCC handbook notes that for properties where improvements are to be constructed, a bank may request a market value upon completion of land improvements, if applicable. [1] This means your forecast of higher rents after renovation must be supported by a credible appraisal or market study, not just your own estimate.
Frequently asked questions
What is the difference between a rent roll and a T-12? A rent roll is a snapshot of current leases in place today. A T-12 is a historical report of income and expenses over the trailing twelve months. The rent roll shows what is contractually due; The T-12 reports historical income and expenses on its stated accounting basis. Comparing the two helps identify collection issues or seasonal patterns.
Do I need to include a capital expenditure reserve even if I am not planning major work? Yes. Including a reserve for replacements helps account for routine capital items like appliances, flooring, and HVAC units that wear out over time. If you exclude this reserve, your NOI forecast may be too high and unsupported.
How do I know if my vacancy forecast is realistic? Compare your forecast to the actual vacancy rate from your T-12 over the past twelve months. If you are forecasting a lower rate, document the specific reason—such as a new management contract or a planned renovation—and attach that documentation to your request.
The website supplies the call to action.
Model this deal and request financing
Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).