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

Preparing a model handoff when another adviser will review the numbers

A practical guide for commercial real estate sponsors to prepare a complete, independently verifiable file package and evidence checklist before handing off financing assumptions to another adviser, using the Wraith financing workbench as an organizing tool.

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

When you hand off a financing model to another adviser — an accountant, a partner, a lender, or a second set of eyes — the goal is to make the numbers reviewable, not just presentable. A model that works on your screen but cannot be traced back to source documents will stall the review or, worse, produce a different result for every person who opens it. This guide walks through the specific documents, reconciliations, and evidence you can prepare so the next adviser can verify your assumptions without calling you for every line item.

Identify the reporting basis and reconcile periods

The first question a reviewer will ask is whether your financial statements are prepared on a cash basis or an accrual basis. Record the reporting basis for each statement you include. If you supply a statement prepared on a cash basis, note that it shows cash received and paid, not income earned or expenses incurred. An accrual statement shows earned income and incurred expenses regardless of when cash moves. A reviewer cannot compare a cash-basis statement to an accrual-based rent roll without a reconciliation.

Prepare a short workpaper that lists each financial period you are handing over, the reporting basis, and the date range. For example, if you provide a trailing twelve-month (T-12) operating statement, note whether it covers the most recent twelve calendar months or a fiscal year. Do not assume the reviewer knows the period. The OCC handbook discusses the importance of reviewing financial information, but this guidance is directed at banks, not borrowers [1]. You can prepare a workpaper that lists the reporting basis and period for each document to facilitate review.

Distinguish the rent roll snapshot from the T-12 history

A current rent roll is a snapshot of occupancy and rent as of today. A T-12 is a historical summary of income and expenses over twelve consecutive months. These two documents serve different purposes and will rarely show the same totals. The rent roll shows gross rent potential at a point in time. The T-12 reports historical income and expenses on its stated accounting basis over a period.

To prepare a clean handoff, create a simple reconciliation table that starts with the gross rent from the rent roll, then adjusts for vacancies, concessions, and collection losses to arrive at the collected income shown on the T-12. This reconciliation is your evidence that the two documents are consistent. Without it, the reviewer cannot tell whether a gap between rent roll and T-12 is a data error or a real operating issue.

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

A financing model often collapses these line items into a single net operating income (NOI) number, but a reviewer needs to see each layer. Prepare a waterfall workpaper that shows:

  • Gross potential rent
  • Vacancy and collection loss
  • Effective gross income
  • Operating expenses (distinguish fixed from variable)
  • NOI
  • Capital expenditures (capex) and reserves
  • Debt service (principal and interest)
  • Equity cash flow

Do not combine capex with operating expenses or debt service with NOI. Each line should be traceable to a source document. For example, the vacancy percentage should match the rent roll vacancy calculation, and the expense totals should tie to the T-12 or the property's general ledger. Bank examiners review whether appraisals and evaluations contain sufficient information and analysis to support a credit decision [1]. Your workpaper should similarly provide sufficient information for an adviser to verify your assumptions.

Prepare an evidence checklist for each assumption

A common handoff failure is the undocumented assumption. You may know that you assumed a vacancy rate because the market report says so, but the reviewer does not. Create a checklist that lists every key assumption in your model and, for each one, identifies the source document that supports it. Examples:

  • Rent growth rate: supported by comparable lease data or a market rent survey
  • Expense inflation: supported by historical T-12 trends or a third-party operating expense report
  • Capital reserve amount: supported by a property condition assessment or recent repair invoices
  • Exit cap rate: supported by recent comparable sales in the market

This checklist is not a lender requirement. It is a suggested way to prepare information so the reviewer can verify each assumption independently. If you cannot find a source for an assumption, label it as a sponsor estimate and note the rationale.

Reconcile the model before the handoff

Before you send the file, run a reconciliation that proves the model works mathematically. This means checking that the sum of all cash flows equals the total return, that the debt service coverage ratio matches the NOI and debt payment, and that the leverage percentage ties to the loan amount and purchase price or refinance value. Print or export the model's calculation method if the tool provides one. You can include that note in your handoff package so the reviewer knows which calculations are the tool's assumptions and which are your own.

Organize the package for sequential review

A reviewer will typically look at documents in a specific order: first the executive summary or scenario, then the source documents, then the reconciliation workpapers. Organize your handoff package in that order. Label each file clearly with the document name and date. Avoid sending a single PDF with no table of contents. These originals are saved privately to the same deal file and are not automatically verified or sent to lenders, but they give the adviser the raw data needed to test your assumptions.

FAQs

How do I handle a gap between the rent roll and the T-12?

Prepare a reconciliation that lists each unit's rent per the rent roll, the actual collected amount per the T-12, and the reason for any difference (vacancy, concession, nonpayment, timing). This makes the gap explainable and prevents the reviewer from assuming a data error.

Should I include the model's calculation method in the handoff?

Yes. The calculation method and limitations note tells the reviewer which assumptions are built into the tool and which are your own. Without it, the reviewer cannot distinguish between a modeling constraint and a sponsor assumption.

What if I do not have a source document for an assumption?

Label that assumption as a sponsor estimate and write a brief rationale explaining why you chose that number. The reviewer can then decide whether to accept the estimate or ask for additional support.


This guide is intended to help you prepare a complete, independently verifiable file package. Your submission is a preliminary request, not an engagement or lender submission.

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