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

Preparing an appraisal input file with consistent rent and expense data

A practical guide for commercial real estate sponsors to assemble a complete, internally consistent appraisal input file, including a rent roll, trailing twelve-month operating statements, and a pro forma, with a concrete evidence checklist to support the appraiser's market value conclusion.

Source: CodexTopic: Valuation and collateral evidence1109 wordsUpdated 2026-11-19

A practical guide for commercial real estate sponsors to assemble a complete, internally consistent appraisal input file, including a rent roll, trailing twelve-month operating statements, and a pro forma, with a concrete evidence checklist to support the appraiser's market value conclusion.

When a lender orders an appraisal, the appraiser relies on the sponsor's historical operating data and future projections to estimate the property's market value. A complete and internally consistent appraisal input file helps the appraiser produce a credible report and supports the lender's review under bank supervisory guidance [1]. This guide explains how to prepare that file, what to include, and how to reconcile the numbers so the appraiser can use them directly.

Assemble the current rent roll as a snapshot

The rent roll is a point-in-time list of every unit or space, the tenant name, lease start and end dates, rent per month or per square foot, any rent concessions or abatements, and the security deposit held. It must be current as of the date you provide it. The appraiser uses the rent roll to confirm the property's physical occupancy and to cross-check the income reported in the operating statements. If the rent roll shows a unit as occupied but the operating statement shows no rent collected for that unit, the appraiser will ask for an explanation. Record the date of the rent roll clearly on the first page [1].

Prepare the trailing twelve-month operating statements

A trailing twelve-month (T-12) operating statement reports the property's actual income and expenses for each of the twelve months ending with the most recent full month. Unlike the rent roll, which is a snapshot, the T-12 is a historical record. It should show gross potential rent, vacancy and collection loss, net rent collected, other income (such as parking or laundry), operating expenses (broken out by category), net operating income (NOI), capital expenditures (capex), and debt service (if any). The T-12 must be reconciled to the rent roll: the sum of monthly net rent collected over the twelve months should equal the gross rent from the rent roll minus vacancy and collection loss for that period. If they do not match, identify the differences (e.g., a tenant moved in mid-month, or a lease started after the rent roll date) and explain them in a brief note. The appraiser will use the T-12 to calculate historical NOI and to support the income approach to value [1].

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

A common source of confusion in appraisal input files is mixing up these terms. Gross rent is the total rent billed before any vacancy or collection loss. Collected income is what the landlord actually received after vacancy and bad debt. NOI is collected income minus operating expenses (but before debt service and capex). Capex is spending on improvements that extend the asset's life, such as a new roof or HVAC system, and is not an operating expense. Debt service is the loan payment (principal and interest). Equity cash flow is what remains after all expenses, capex, and debt service are paid. When you prepare the input file, label each line clearly so the appraiser can identify which number goes into the income approach and which is for the lender's debt service coverage calculation [1].

Include a capital expenditure and deferred maintenance schedule

If the property has had recent capital improvements or has known deferred maintenance, list them in a separate schedule. Include the date, description, cost, and whether the work was completed or is planned. The appraiser uses this information to adjust the property's condition and to estimate the effective age and remaining economic life. For example, a new roof or HVAC system may extend the property's useful life, while deferred maintenance may reduce its value. Bank supervisory guidance expects the appraisal to reflect the property's actual physical condition [1].

Provide a market analysis or feasibility study for development properties

If the property is a residential tract development or a condominium project with fewer than five units per building, the bank may rely on appraisals of individual units if the sponsor can demonstrate through an independently obtained feasibility study or market analysis that all units can be built and sold within 12 months [1]. For such transactions, the appraisal must reflect appropriate deductions and discounts, and the market value should be the "as is" value of the property as of the effective date [1]. If you are financing a development, include a market analysis that shows absorption rates, comparable sales, and a timeline for completion and sale. This helps the appraiser apply the correct discounts and supports the lender's underwriting.

Evidence checklist for the appraisal input file

Use this checklist to confirm your file is complete before you send it to the appraiser:

  • [ ] Current rent roll, dated and signed
  • [ ] Trailing twelve-month operating statements, with each month's income and expenses broken out
  • [ ] Reconciliation note explaining any differences between the rent roll and T-12 totals
  • [ ] Pro forma with all assumptions stated (vacancy rate, rent growth, expense changes)
  • [ ] Capital expenditure and deferred maintenance schedule
  • [ ] Market analysis or feasibility study (for development or condominium properties)
  • [ ] Property survey, legal description, and zoning information
  • [ ] Photos of the property (exterior and interior, including any deferred maintenance)
  • [ ] Any recent appraisals or evaluations of the property (if available)
  • [ ] Organizational documents for the borrowing entity (to confirm ownership)

How do I reconcile the rent roll with the T-12 if a tenant moved in mid-month?

Record the tenant on the rent roll as occupied from the move-in date. On the T-12, show the partial month's rent as collected in that month. Add a note in the reconciliation explaining the partial month. The appraiser will accept this as long as the totals match over the full twelve months.

Does the appraiser need the actual lease documents?

Not always, but it helps. The rent roll should summarize each lease's key terms. If the appraiser questions a rent amount or a concession, you may be asked to provide the lease. Include a set of the ten largest leases (by rent) in the input file for reference.

What if I don't have a full twelve months of operating statements?

If the property was acquired recently or is newly built, provide whatever months you have (e.g., six months). In that case, the appraiser will rely more on market data and the pro forma. Be prepared to explain why the history is short and how you derived the projections.


If you have a property and a business plan, send us the property details, the amount and timing you need, and we will tell you how we would approach it.

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

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