Is a rent growth assumption an input or a result?

A rent growth assumption is an input in the model and a result of the work behind it. The cell holds a number the analyst typed, and that number is only defensible when it comes out of leasing comps, submarket supply and the property’s own rent position. It then has to survive a trace through expenses, debt service and exit value. A rate adjusted until the model hits a target return is a result that has been typed into the input cell.

The cell is an input and its support is a result

In a pro forma, rent growth is a percentage applied to in-place or achievable rent, and every downstream figure flows from it. Nothing inside the spreadsheet can validate it. The formulas only show what that rate produces.

Rent growth sits alongside competition, return on equity, cost of debt and cap-rate movement in the set of inputs that an equity underwriting has to hold together. One underwriting model carried an average of 2.5% through a five-year hold, and that figure came from two licensed submarket and property-level databases combined with local market knowledge. The rate was the output of a separate piece of research, and the model cell only stored it.

That order of cause is the test. The support is built first, the cell is filled second, and the rest of the model then checks whether the number holds.

Why a published average rarely fits the subject property

A forecast of 2.2% multifamily rent growth, set against vacancy of 6.2% and a longer-run average of 2.8%, frames a national scenario. It does not describe a single block. In the same body of research, higher-supply Sun Belt and Mountain West regions were showing negative rent growth while many coastal, lower-supply markets ran above average.

A blended number that mixes negative and above-average regions describes none of them. One quarter showed year-over-year rent growth of only 0.3% after completions outpaced absorption and stabilized vacancy rose, which is a single reading and not a trend line.

The population behind a statistic matters as much as its level. Rent-growth reports built from large portfolios can overrepresent multifamily relative to scattered-site rentals, so a figure measured on one rental format carries limited weight for another. The questions that decide fit are whose rents were measured, in which submarket and in which asset format.

“Consequently, stabilized vacancy rose and YoY rent growth was a low 0.3%.”

How a positive rent rate can still produce falling NOI

Net operating income is revenue minus operating expenses, and rent growth touches only the revenue line. Rising wages, supply costs and insurance expense alongside slowing rent growth have squeezed property cash flow, and higher operating costs can outpace rent growth and pressure NOI.

The test is a comparison of dollars. Rent growth raises NOI only when the dollars of added collected rent exceed the dollars of added expense. A percentage that looks healthy on a large expense base can still lose that comparison.

A model that grows rent and leaves expenses flat therefore reports an NOI gain that the property may never produce. The two lines need separate growth paths so that the rent assumption can be judged on its own.

Agency guidance that limits the input after the early years

Agency multifamily guidance says rent projections above the base assumption income growth rate should not be used beyond Loan Year 4. The practical reading is that a high growth rate has a short permitted life in that underwriting framework.

A sponsor model that carries a high rate through year ten is running an input the guidance excludes for most of the hold. Other lenders set their own conventions, so the useful habit is to find out where a given lender stops accepting the rate. The sponsor’s rate and the lender’s rate can differ, and the debt is sized on the lender’s version.

Exit value and the coupon that rent growth is paired with

Rent growth does double duty at exit. It lifts the NOI that is capitalized, and it is often paired with an assumed refinancing coupon. Value-add borrowers whose debt ratio was premised on a 3 to 4 percent exit coupon, combined with rent growth and little expense growth, found that the debt was too high for the business plan once those pairings failed.

Two favorable assumptions multiplied together make a fragile exit. A rent rate that works only with flat expenses and a low coupon is a conditional outcome and cannot be treated as a market fact.

Underwriting that scrutinizes both the rent growth rate and the exit matters most where new supply is lifting vacancy.

“We can no longer assume that rent is going to grow steadily over time anymore.”

Worked example: a hypothetical 100-unit apartment with 2.5% and 0.3% rent growth

The inputs are hypothetical. The property has 100 units at 95% occupancy, rent of $2,000 per unit per month, other income of $120,000 per year and operating expenses of $1,000,000 in year one. Expenses grow 3% in both cases. The debt is $16,000,000, interest only at 6.25%. Only rent growth differs between the cases, and 2.5% and 0.3% are illustrative rates.

Year one: occupied units are 100 multiplied by 0.95, or 95. Annual rent is 95 multiplied by $2,000 multiplied by 12, or $2,280,000. Adding $120,000 of other income gives revenue of $2,400,000, and subtracting $1,000,000 of expenses leaves NOI of $1,400,000. Interest is $16,000,000 multiplied by 0.0625, or $1,000,000, so cash flow after interest is $400,000.

Year two expenses are $1,000,000 multiplied by 1.03, or $1,030,000, which is $30,000 more than year one. That is the amount of added rent needed just to hold NOI level.

Base case at 2.5%: rent is $2,280,000 multiplied by 1.025, or $2,337,000, which adds $57,000. Revenue is $2,337,000 plus $120,000, or $2,457,000. NOI is $2,457,000 minus $1,030,000, or $1,427,000, which is $27,000 above year one. Cash flow after interest is $427,000.

Stressed case at 0.3%: rent is $2,280,000 multiplied by 1.003, or $2,286,840, which adds only $6,840. Revenue is $2,286,840 plus $120,000, or $2,406,840. NOI is $2,406,840 minus $1,030,000, or $1,376,840, which is $23,160 below year one. Cash flow after interest is $376,840.

Rent grows in both cases, yet NOI rises in one and falls in the other. The gap between the cases is $1,427,000 minus $1,376,840, or $50,160 in a single year. Any exit value capitalized from the base-case NOI inherits that gap, and compounding widens it each year.

Mistakes that turn a rent growth input into a disguised result

Backsolving is the first error. When the rate is adjusted until the model reaches a target return, the number records what the spreadsheet needed. Some rate will reach any target, so hitting it proves nothing. The check is whether independent rent evidence produces the same rate without reference to the return.

Borrowing a statistic from a different population is the second. A figure built from large multifamily portfolios can describe scattered-site rentals poorly, and a national average blends regions with opposite supply conditions. Matching asset format and submarket comes before the number is typed.

The third is growing scheduled rent while ignoring vacancy. Collected revenue is scheduled rent minus vacancy and concessions. When completions outpace absorption and vacancy rises, a rate applied to full scheduled rent overstates what the owner receives.

The fourth is carrying one rate across the whole hold. Agency guidance excludes rent projections above its base assumption rate beyond Loan Year 4, so a flat high rate through the exit year includes years that a lender’s own sizing would not credit.

The fifth is letting rent grow while expenses stay level. In the hypothetical, a 0.3% rent rate against 3% expense growth lowers NOI, and the same rent line with frozen expenses would show a gain that the property cannot deliver.

Questions that separate a supported rate from a typed number

What produced the rate before it reached the model? A rate derived from licensed submarket data and property-level comps has a trail, and a rate chosen to hit a return does not.

Does the statistic measure the same asset format? Large-portfolio reports can overweight multifamily, which weakens them as evidence for scattered-site holdings.

Which region does the comparison market resemble? Higher-supply regions and lower-supply coastal markets have shown opposite signs, so the nearest supply picture carries more weight than a national figure.

Do the added rent dollars exceed the added expense dollars? NOI moves only when the first number is larger than the second.

Where does the lender stop crediting the rate? Agency guidance excludes projections above its base rate beyond Loan Year 4, and other lenders set their own limits.

Does the exit value need the same rent growth to continue? A refinancing coupon and light expense growth paired with rent growth stack three conditions on one outcome.

What does cash flow after debt service look like at the low-growth rate? The answer shows whether the capital structure survives the stressed input.