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

How an explicit zero differs from a missing acquisition-model input

A missing input in an acquisition model is a gap; an explicit zero is a deliberate assumption that the item has no value, cost, or income. This guide provides a concrete evidence checklist to distinguish them, explains how each affects the financing discussion, and helps borrowers prepare a complete loan request.

Source: CodexTopic: Acquisition model inputs1142 wordsUpdated 2026-11-19

A missing input in an acquisition model is a gap; an explicit zero is a deliberate assumption that the item has no value, cost, or income. This guide provides a concrete evidence checklist to distinguish them, explains how each affects the financing discussion, and helps borrowers prepare a complete loan request.

When a lender reviews an acquisition model, every blank cell and every zero tells a story. A missing input may signal incomplete information, while an explicit zero represents a deliberate assumption that the item has no value, cost, or income. Understanding this distinction is essential for preparing a credible loan request and avoiding underwriting delays.

Distinguish missing inputs from explicit zeros in your acquisition model

A missing input is a cell left blank because the information is not yet known, not yet gathered, or not yet decided. An explicit zero is a cell where you have determined the value is zero. For example, if a property has no laundry income, you enter zero. If you have not yet determined whether there will be parking income, you leave the cell blank until you have the information.

To prepare a complete model, systematically review each input category. For each item, ask: Is this information known? If yes, enter the actual figure. If no, leave it blank and note the missing item as a data gap to be filled.

Record the source and basis for every zero in the model

For each zero you enter, document why it is zero. A zero without a source may be interpreted as a missing input. For example, if you enter zero for franchise fees, note whether the property is not franchised. If you enter zero for replacement reserves, note whether the property is newly built or whether the lender's underwriting requires a reserve regardless [1].

The OCC handbook notes that for hotels, replacement reserves for FF&E are generally expected by lenders based on their underwriting requirements [1]. If you enter zero for this line item, you must explain why the property does not need a reserve, or the lender may assume the input is missing and adjust the underwriting accordingly.

Compare your acquisition model with the trailing twelve months (T-12) operating statements

A T-12 is twelve months of historical operating data, which may be reported on a cash or accrual basis. A current rent roll is a snapshot of today’s leases and rents. The acquisition model should reconcile with both. If the model shows zero for a line item that appears in the T-12, you must explain the discrepancy. For example, if the T-12 shows management fees but the model shows zero, note whether the management contract has changed or whether the fee is paid by the tenant.

To reconcile, create a simple workpaper: list each line item from the T-12, note the annual total, then note the corresponding line item in the acquisition model. For each item where the model shows zero but the T-12 shows a positive number, add a column for explanation.

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

The acquisition model should clearly separate these components. Gross rent is the total rent before any deductions. Collected income is gross rent minus vacancies and credit losses. Net operating income (NOI) is collected income minus operating expenses. Capital expenditures (capex) are separate from operating expenses. Debt service is the loan payment. Equity cash flow is what remains after all expenses and debt service.

If you enter zero for any of these, explain why. For example, zero capex in a stable property may be reasonable, but zero debt service is generally not. A missing input for debt service may indicate the loan amount or terms are not yet determined, which is acceptable if noted as a placeholder.

Identify the reporting basis and reconcile periods

Financial statements may be prepared on a cash basis or an accrual basis. The acquisition model should note which basis is used. If the model uses cash basis but the T-12 uses accrual, the two may not match. Reconcile the difference by adjusting for timing of receipts and payables.

For example, if the T-12 shows a large expense for property taxes paid in one month, but the model spreads the expense evenly, note the difference and explain the assumption. The OCC handbook advises that fixed expenses like property taxes should reflect the actual property tax assessment [1].

Prepare a concrete evidence checklist for the lender

Create a workpaper titled "Acquisition Model Input Verification." For each input in the model, list: - The line item name - The value entered (or blank) - The source of the information (e.g., T-12 specifying cash or accrual basis, rent roll, appraisal, budget) - Whether the value is a zero or a missing input - If zero, the reason for the zero - If missing, the expected date the information will be available

This workpaper helps the lender understand which inputs are final and which are placeholders. It also helps you identify gaps in your own data before submitting the loan request.

Ask the actual lender about their underwriting assumptions

Lenders may adjust your model based on their own underwriting standards. For example, the OCC handbook notes that for hotels, management fees are generally expected to align with the lender's underwriting assumptions [1]. If your model shows a different figure, the lender may ask for an explanation or adjust the underwriting.

Rather than guessing what the lender will accept, ask directly. When you submit the loan request, include a note that you are available to discuss any assumptions or inputs. This shows you have prepared thoroughly and are open to the lender's underwriting process.

Frequently asked questions

What if I don't know a specific input yet? Leave the cell blank and note it as a data gap. Do not enter zero unless you are certain the value is zero. A blank input tells the lender you are still gathering information, which is acceptable if you have a plan to fill the gap.

How do I explain a zero that the lender might question? Document the reason in the Acquisition Model Input Verification workpaper. For example, if you show zero for laundry income, note that the property has no laundry facilities. If you show zero for franchise fees, note that the property is independent.

Can a missing input cause the lender to reject my loan request? It may cause delays if the missing input is material to the underwriting. The lender may ask for the information or make an assumption. To avoid this, identify all gaps before submission and note your plan to fill them.


We prepare the loan request, select lenders suited to the property and plan, and negotiate terms through closing. Send us the property, the business plan, the amount needed, and the timing, and we will tell you how we would approach it.

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
  2. Wraith commercial real estate debt