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

Separating model results from source evidence in a lender-facing package

A practical guide for commercial real estate sponsors to build a lender-ready package by clearly distinguishing financial model outputs from the source documents that support them, with a concrete evidence checklist.

Source: CodexTopic: Using financing models and packages851 wordsUpdated 2026-11-19

A practical guide for commercial real estate sponsors to build a lender-ready package by clearly distinguishing financial model outputs from the source documents that support them, with a concrete evidence checklist.

When you present a financing request to a lender, the numbers in your model must trace back to verifiable source documents. Lenders evaluate not just the projected returns but the reliability of the inputs. This guide helps you build a package that separates your analytical assumptions from the evidence that supports them, making underwriting easier and reducing follow-up questions.

Identify the source documents that support your model inputs

Every financial assumption in your model should connect to a specific document. For a multifamily acquisition or refinance, the core evidence package includes a current rent roll, a trailing twelve-month (T-12) operating statement, purchase terms or current debt documents, and a rehab or capital expenditure budget. The rent roll is a snapshot of current occupancy, rents, and concessions. The T-12 shows twelve consecutive months of historical income and expenses. Before comparing these two documents, note the timing difference: the rent roll reflects today’s performance, while the T-12 captures past results. A property may have raised rents or filled vacancies since the T-12 ended, so you need to reconcile the gap by recording known changes and explaining them in a brief narrative.

Distinguish gross rent, collected income, NOI, debt service, and equity cash flow

Your model should clearly label each income and cash flow layer. Start with gross potential rent, then subtract vacancies and concessions to reach gross collected income. Deduct operating expenses to arrive at net operating income (NOI). From NOI, subtract annual debt service (principal and interest) to show before-tax cash flow available to equity. Do not equate a cap rate with a debt constant; cap rate measures property value relative to NOI, while debt constant measures the annual debt payment relative to the loan amount. Record each figure in a simple table or workpaper so the lender can trace the cascade from top-line rent to sponsor cash flow.

Prepare a reconciliation workpaper comparing the T-12 to your projected NOI

Create a one-page workpaper that lists each T-12 line item (e.g., rental income, utility expenses, management fees) alongside your projected figures for the same categories. For each line, note the dollar difference and write a one-sentence explanation. For example, if your projected management fee is lower than the T-12, state that you plan to self-manage or negotiate a lower fee. If projected repair costs are higher, note deferred maintenance identified in the inspection. This workpaper shows the lender you have compared historical evidence to your assumptions and can justify variances. Suggested label: "T-12 to Pro Forma Reconciliation."

Identify the reporting basis and reconcile periods

Financial statements may be prepared on a cash basis or accrual basis. Record which basis the T-12 uses and which basis your model uses. If the T-12 is cash basis and your model is accrual, adjust for known receivables or payables that affect the comparison. Also note the period covered: a T-12 might run calendar months while your model uses fiscal quarters. Reconcile by aligning both to the same start and end dates before comparing totals. This step prevents mismatched figures from creating false gaps or surpluses.

Evidence checklist: documents to prepare for your package

Originals are saved privately to the same deal file and are not automatically verified or sent to lenders .

  • Current rent roll (dated within 30 days)
  • Trailing twelve-month operating statement (T-12)
  • Purchase agreement or current loan documents
  • Rehab or capital expenditure budget with line-item costs
  • T-12 to pro forma reconciliation workpaper (as described above)
  • Narrative explaining any variances between historical and projected figures

Each document should be a clean PDF under 15 MB. Avoid sending information you are not authorized to share .

Ask the actual lender about specific terms

No guide can tell you what every lender demands. Instead of assuming requirements, prepare a list of questions to ask each potential lender. For example: What interest rate index do you use? What is your minimum debt service coverage ratio? Do you require a standby commitment or forward commitment for permanent financing? Record the answers and compare them across lenders. This approach keeps your package flexible and avoids unsupported claims about typical terms.

Frequently asked questions

How do I handle a T-12 that shows higher expenses than my projections? Record the difference in your reconciliation workpaper and write a brief explanation. Common reasons include one-time repairs, management changes, or planned efficiency upgrades. The lender will evaluate whether your explanation is reasonable based on the property’s condition and your business plan.

Should I include a cap rate in my model? Cap rate is a valuation tool, not a financing term. You can include it as a market reference, but do not confuse it with a debt constant or interest rate. The lender will underwrite based on NOI and debt service coverage, not cap rate alone.

What if my financing scenario changes after I submit? Each request is retained privately, and you can recover its status using the original receipt. Retrying cannot create another deal .

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.

Open the acquisition model

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. OCC Commercial Real Estate Lending handbook