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

Modeling annual rent growth without applying it twice

A practical guide for sponsors preparing an acquisition pro forma, focused on how to present rent growth assumptions so they are supported by market evidence and not double-counted in the cash flow analysis.

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

A practical guide for sponsors preparing an acquisition pro forma, focused on how to present rent growth assumptions so they are supported by market evidence and not double-counted in the cash flow analysis.

Why rent growth assumptions get scrutinized

When you present a pro forma for an acquisition, the lender will examine how you modeled future rent increases. The OCC Commercial Real Estate Lending handbook states that a lender should analyze whether cash flow and NOI projections are reasonable and supported, and that inadequately supported or questionable analysis should be challenged [1]. If your model applies rent growth twice—once in the rent roll and again in the escalation clause—the projected income will be overstated, and the lender may discount the entire underwriting. This guide walks through how to prepare a rent growth evidence worksheet that keeps the assumptions visible and verifiable.

What the lender wants to see: historical, current, and projected rates

The OCC handbook lists several factors a lender typically considers when analyzing income-generating capacity, including historical, current, and projected rental rates, operating expenses, capital expenditures, and vacancy and absorption rates [1]. A lender will also look at lease renewal trends and anticipated rents, as well as comparable rental rates and terms of current leases [1]. Your job is to organize this information into a single worksheet that shows where each assumption came from and how it flows into the pro forma.

The rent growth evidence worksheet: what to prepare

Create a simple spreadsheet with the following columns. This is not a mandatory lender form but a suggested way to prepare information so the lender can follow your logic.

  • Unit or space identifier: list each lease or unit type.
  • Current base rent: the rent in effect today, per the rent roll snapshot.
  • Lease expiration: the date the current term ends.
  • Contractual escalation: any step-ups written into the existing lease, including percentage or CPI-based increases.
  • Market rent estimate: your opinion of what the space would rent for today if vacant, supported by comparable listings or recent leases.
  • Projected rent at rollover: the rent you assume will be achieved when the lease renews or turns, and the year that happens.
  • Source of market rent: identify the comparable property, broker opinion, or market report used.
  • Annual growth rate implied: the difference between current rent and projected rollover rent, expressed as an average annual change over the years until rollover, without specifying numerical percentages.

Fill this out for every lease that will roll during your hold period. For leases that do not expire, list only the contractual escalations. The worksheet becomes the evidence trail for every rent assumption in your pro forma.

How to distinguish contractual growth from market growth

A common mistake is to apply a market rent growth rate to all units, including those still under a fixed lease. If a lease has a contractual step-up, that is contractual growth. If you also apply a market growth factor to the same unit, you have effectively applied growth twice on that space until the lease expires. The OCC handbook warns that lenders should challenge projections that use assumptions relative to current market conditions such as higher than current rents or occupancy rates [1]. To avoid this, separate the two concepts in your model:

  • Contractual growth: apply only to units with active leases that have scheduled increases. These are fixed and do not need market support.
  • Market growth: apply only to units that are vacant or will roll during the projection period. The growth rate should be supported by the evidence worksheet.

In your pro forma, show a line for "in-place rent" and a separate line for "market rent at rollover." Do not blend them into a single growth factor.

Reconciling the rent roll snapshot with the trailing twelve months

A current rent roll is a snapshot of what tenants are paying today. A trailing twelve months (T-12) operating statement shows what was actually collected over the past year. These two documents can tell different stories. The OCC handbook notes that even if a rent roll shows high occupancy, actual collections should be examined to determine true economic occupancy [1]. To reconcile them:

  1. Identify whether the T-12 operating statement is on a cash or accrual basis.
  2. Compare the total rent collected or accrued over the trailing twelve months to the sum of current base rents from the rent roll snapshot.
  3. If the T-12 amount is lower, identify the difference as collection loss, vacancy during the period, or concessions.
  4. Document each cause in a short reconciliation note.

This step shows the lender you understand the difference between billed rent and collected income. The OCC handbook specifically states that the analysis should consider volume and trends in past-due leases [1]. Your reconciliation is the place to show that.

Distinguishing NOI, debt service, and equity cash flow

Your pro forma should clearly separate these four numbers:

  • Gross rent: total potential rent if every unit were leased at market rent.
  • Collected income: gross rent minus vacancy, concessions, and collection losses, reflecting actual cash collected.
  • Net operating income (NOI): collected income minus operating expenses, but before debt service and capital expenditures.
  • Debt service: the annual principal and interest payment on the proposed loan.
  • Equity cash flow: NOI minus debt service and capital expenditures.

If you model rent growth, apply it only to gross rent. Do not apply it to NOI or to debt service. The OCC handbook states that repayment of loans financing income-producing CRE typically depends on the property's ability to service debt from cash flow [1]. If you inflate NOI by applying growth twice, the debt service coverage ratio will appear stronger than supported. A lender will recalculate NOI using the lower, supportable rent number and may reduce the loan amount.

Presenting the growth assumptions under normal and stressed conditions

The OCC handbook advises that each factor should be considered under both normal and stressed conditions [1]. In your worksheet, add a column for "stressed rent growth." This should be based on documented assumptions such as growth rates from prior downturns or conservative market scenarios. Show the impact on NOI and debt service coverage. This is not a prediction but a way to demonstrate that the property can still service debt if rent growth slows. Lenders will see that you have considered downside risk, which can strengthen the credibility of your base case.

FAQs

How do I know if I am double-counting rent growth?

Review each unit in your pro forma. If a unit has a contractual escalation in its current lease, that increase is already accounted for in the rent roll projection. Do not add a separate market growth factor to that unit until the lease expires. A simple test: if you apply both a lease step-up and a general growth factor to the same unit in the same year, you are double-counting.

Should I use the same growth rate for all units?

No. Each unit's lease terms, expiration date, and market position are different. The OCC handbook says a lender will look at comparable rental rates and terms of current leases [1]. Your worksheet should show a separate growth rate for each unit or at least for each lease type. A single blended rate is difficult to support and easy for a lender to challenge.

What if I do not have comparable market data?

You can still prepare the worksheet using the best available information, such as a broker opinion of value, a recent market study, or your own knowledge of the submarket. The OCC handbook notes that information on local building permits and construction starts is usually available from data services or directly from local government offices [1]. If you lack direct comparables, state the source clearly and acknowledge the limitation. A transparent assumption is better than an unsupported one.

Closing invitation

If you are preparing an acquisition pro forma and want to discuss how these assumptions will be received by lenders, send us the property, the business plan, and the capital you need. 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