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

What to review before sending an apartment calculator scenario to Wraith

A practical evidence checklist to help sponsors prepare the documents and financial data that support a multifamily financing request, distinguishing source facts from borrower assumptions.

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

A practical evidence checklist to help sponsors prepare the documents and financial data that support a multifamily financing request, distinguishing source facts from borrower assumptions.

Before you enter numbers, gather the documents and reconcile the figures that lenders will eventually underwrite. The following sections walk through what to prepare, why it matters, and how to avoid common mismatches between your scenario and what a bank would verify.

Prepare a current rent roll and a trailing twelve-month operating statement

These are two different documents with different time frames. The rent roll is a snapshot of current occupancy, unit mix, lease terms, and scheduled rent. The T-12 shows actual income and expenses for each of the past twelve months.

Before you compare totals, note the timing difference: the rent roll shows what tenants are supposed to pay now, while The T-12 reports historical income and expenses on its stated accounting basis and spent over the past year. A gap between scheduled rent on the roll and collected income on the T-12 may indicate collection losses or concessions. Record both figures separately so you can explain the variance.

Distinguish gross rent, collected income, net operating income, capital expenditures, debt service, and equity cash flow

A common mistake is treating gross rent as the starting point for debt service coverage. Lenders underwrite based on net operating income (NOI), which is collected income minus operating expenses. Capital expenditures (capex) are not operating expenses; they are treated separately and reduce the cash available for debt service.

Identify each layer in your scenario: - Gross rent: total scheduled rent before any vacancy or collection loss. - Collected income: gross rent minus vacancy, concessions, and bad debt. - NOI: collected income minus operating expenses (property management, utilities, insurance, taxes, repairs). - Capex: major improvements such as roofing, HVAC, or unit renovations. - Debt service: principal and interest payments on the proposed loan. - Equity cash flow: NOI minus capex minus debt service.

If your scenario shows a healthy NOI but thin equity cash flow, ask the actual lender how they treat capex reserves. Some lenders require a separate reserve account; others include capex in the operating expense ratio. Enter zero explicitly when a cost is zero.

Reconcile the reporting basis of your financial statements

Do not assume your financial statements are on a cash basis. Identify whether the T-12 uses cash accounting or accrual accounting. Accrual statements may show income before it is received and expenses before they are paid. Cash statements show only money that actually changed hands.

If you switch between bases without reconciling, you can double-count or omit income. For example, an accrual T-12 might include a December rent payment received in January, while a cash T-12 would show it in January. Compare the total annual income under both methods and note any timing adjustments.

Suggested workpaper: Prepare a one-page reconciliation that lists the total income and total expenses from the T-12, then adjusts for any known timing differences between cash and accrual. This is not a mandatory lender process; it is a suggested way to prepare information that avoids confusion when a lender asks for trailing statements.

Document the source and basis of your cap rate and debt constant assumptions

Record the source of your cap rate: recent comparable sales, an appraisal, or a broker opinion. Lenders will verify this with an appraisal or evaluation. [1] OCC guidance expects national banks to implement a risk-based approach for determining the depth of the review needed to verify that appraisals and evaluations contain sufficient information and analysis to support a credit decision. This guidance applies to national banks; it is not a rule that binds every borrower or nonbank lender.

Suggested workpaper: Create a cap rate justification sheet that lists three to five comparable properties with their sale price, NOI, and calculated cap rate. Include the date of sale and your confidence level in each comparable. This helps you defend your assumption when a lender questions it.

Identify the business plan and value-add assumptions

If you are financing a value-add acquisition, your scenario likely includes a pro forma NOI after renovations. Lenders will want to see the gap between current and projected performance. The rehab budget and timeline are critical.

Prepare a simple schedule that shows: - Current NOI from the T-12. - Projected NOI after renovations. - Total capex budget. - Expected completion date. - Lease-up assumptions (how fast units will be re-rented at higher rents).

Be realistic about lease-up. If you assume full occupancy at higher rents within three months, ask the actual lender what absorption rate they typically underwrite. You control the assumptions, but lenders will test them during underwriting.

Prepare a sponsor and property summary for the submission form

Before you fill it out, gather: - Sponsor company legal name and entity structure. - Property address and ownership entity. - Estimated closing date or refinance maturity date. - A brief business plan that explains your strategy (acquisition, renovation, refinance, or maturity gap). - A website or offering memorandum if available.

You are authorized to share this information. Do not send information you are not authorized to share. Your supporting documents are saved to the same file.

Review your scenario for internal consistency before submitting

Before you click submit, run through this checklist: - Does gross rent on the rent roll match the T-12's gross potential rent? - Does collected income on the T-12 match your scenario's income line? - Are operating expenses consistent with the T-12 and your capex budget? - Is the cap rate supported by comparables? - Is the debt constant consistent with current market rates? - Does the equity cash flow cover your return requirements?

If any number seems off, revisit your assumptions. [1] OCC guidance expects banks to have credit risk review processes that verify accuracy of risk ratings and operational effectiveness. While this guidance is directed at banks, it underscores why your scenario should be internally consistent before a lender sees it.

Frequently asked questions

What is the difference between a rent roll and a T-12? A rent roll is a snapshot of current tenant information, including unit mix, lease terms, and scheduled rent. A T-12 is a historical statement showing actual income and expenses for each of the past twelve months. The rent roll shows what tenants are supposed to pay; The T-12 reports historical income and expenses on its stated accounting basis. Compare the two to identify collection losses or concessions.

Can I change my scenario after submitting? Yes, but you must start a separate request. The tool states that retrying cannot create another deal; your original submission is retained and recoverable using the original receipt. If you need to update assumptions, submit a new request with the corrected scenario and note that it supersedes the previous one.

Ready to share your property, business plan, amount, and timing?

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