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

Using an assumption audit to find missing property-financing inputs

A practical guide for CRE sponsors to audit their financing assumptions, identify missing inputs, and prepare a complete evidence checklist before submitting a financing request.

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

A practical guide for CRE sponsors to audit their financing assumptions, identify missing inputs, and prepare a complete evidence checklist before submitting a financing request.

Why an assumption audit matters before you submit

The difference between a scenario that moves forward and one that stalls often comes down to inputs you did not realize were missing. An assumption audit is a structured review of every financial figure you plan to submit, comparing it against source documents you already have or can reasonably gather. This guide walks you through building a concrete evidence checklist and explains how each item affects the financing discussion.

What to include in your evidence checklist

Your evidence checklist is a single workpaper that lists every input your scenario requires, the source document that supports it, and the date or period that document covers. Suggested columns: input name, source document, date or period, your figure, and a column for notes on gaps. For a multifamily acquisition or refinance, typical inputs include purchase price or current debt, rental income, operating expenses, rehab budget, and your equity contribution. Each of these needs a corresponding document such as a purchase agreement, current rent roll, trailing twelve-month operating statement (T-12), and a detailed scope of work with contractor estimates. The workbench tool accepts supporting files like rent roll, T-12, purchase terms, and rehab budget to help review your request . Your checklist ensures you have all of these ready before you submit.

Distinguishing rent roll snapshot from T-12 history

A current rent roll is a snapshot of who occupies each unit, what they pay, and any concessions or deposits, as of today. A T-12 is twelve consecutive months of historical operating data, typically showing income and expenses month by month. These two documents serve different purposes and often produce different totals. The rent roll shows gross potential rent at this moment, while the T-12 shows what tenants actually paid over the past year, including vacancy loss, bad debt, and concessions. To reconcile them, compare the rent roll's gross potential rent against the T-12's collected income. Any gap between gross rent and collected income reveals collection loss, vacancy, or concessions that your underwriting must account for. Record both figures on your checklist and note the timing difference.

Breaking down income and expense layers

Your financing analysis should distinguish at least five layers: gross rent, collected income, net operating income (NOI), capital expenditures (capex), and debt service. Gross rent is the total if every unit were leased at market rate with no concessions. Collected income subtracts vacancy, concessions, and bad debt. NOI subtracts operating expenses from collected income. Capex is separate from operating expenses and covers major improvements like roof replacement or unit renovations. Debt service is the annual principal and interest payment on the proposed loan. Equity cash flow is what remains after debt service and any required reserves. Each layer requires its own evidence. For example, the T-12 supports collected income and operating expenses, while contractor bids support capex. Your checklist should have a row for each layer and the document that backs it up.

Identifying missing inputs from your business plan

Your business plan describes how you intend to operate or improve the property. Compare each element of that plan against your scenario inputs. If the plan includes a value-add renovation, but your scenario has no rehab budget line, that is a missing input. If the plan assumes you will achieve higher rents after renovation, but your income projection still uses current rents, that is another gap. Similarly, if you plan to use low-income housing tax credits or grants, the bank's underwriting will consider that assistance, and the appraiser should reflect it in the market value estimate [1]. Record any such assistance on your checklist and note the source document, such as a tax credit allocation letter or grant agreement.

Reconciling your equity and debt service figures

Your equity contribution is the cash you put into the deal, not your personal net worth or a line of credit. The evidence is a bank statement or proof of funds letter. Your debt service calculation depends on the loan amount, interest rate, and amortization period you assume. The workbench tool calculates a scenario from your assumptions, but financing remains subject to lender underwriting and approval . To prepare, ask the actual lender for their current rate sheet and typical amortization terms for your property type. Record the lender's quoted range on your checklist, not a single fixed number. This prevents you from assuming a rate that no lender offers.

Preparing your package for review

Once your checklist is complete and you have gathered all supporting files, submit your scenario through the workbench tool. The submission creates a private request and deal file, but does not send materials to lenders . You can then upload your evidence documents as supporting files. The tool accepts up to ten files per upload, with a 15 MB per file limit . After submission, you can download a preliminary lender package PDF for your records. Remember that your submitted request is retained and you can recover its status using the original receipt .

FAQs

How do I know if my rent roll is current enough to use?

A rent roll should be dated within the last 30 days. Compare the move-in dates and lease expiration dates on the roll to confirm it reflects current occupancy. If any leases have expired since the roll was printed, ask the property manager for an updated version or a list of month-to-month tenants.

What if my T-12 shows different income than my rent roll projects?

This is common and expected. The T-12 shows historical performance, while the rent roll shows current potential. Record both figures on your checklist and calculate the gap. If the T-12 collected income is significantly lower, investigate whether the difference is due to one-time vacancy, ongoing management issues, or seasonal patterns. Your underwriting should use the more conservative figure unless you have a clear plan to improve.

Do I need an appraisal before I submit my financing request?

No, you do not need a completed appraisal at the submission stage. Your scenario uses your own estimates for property value and NOI. However, the bank will order its own appraisal later, and your assumptions should be realistic enough that the appraisal supports your requested loan amount. If your property includes affordable housing assistance, the appraiser should consider that assistance in estimating market value [1].

Closing invitation

The website supplies the call to action to begin your review.

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