Category: Uncategorized

A deal can look attractive in a broker package and still fail the moment you test the assumptions. That is why commercial underwriting process steps matter: they turn an asking price, a rent roll, and a trailing financial statement into a decision you can explain to a lender, partner, or client.

For most small to mid-sized CRE operators, speed matters. But speed without a repeatable process creates false confidence. The goal is not to build the most complicated model possible. It is to identify what drives value, determine whether the numbers support the story, and understand where the deal breaks before you spend weeks chasing it.

Start With a Fast Deal Screen

The first pass should answer one question: is this opportunity worth deeper work? Before entering every lease or expense line, review the asset type, location, asking price, current net operating income, occupancy, in-place rents, debt assumptions, and proposed business plan.

Calculate a few initial indicators: price per unit or square foot, in-place cap rate, debt service coverage ratio, and a rough cash-on-cash return. Compare them against recent transactions, your target returns, and the property’s submarket. A low cap rate is not automatically a problem if rents are meaningfully below market and the path to growth is credible. Conversely, a high cap rate may reflect deferred maintenance, tenant concentration, weak demand, or an expense issue that is not obvious in the offering materials.

This screen is also where you define the deal thesis in plain language. For example, the property may be under-rented, operationally inefficient, poorly managed, or positioned to benefit from a local demand driver. If you cannot state the thesis clearly, you are not ready to model the upside.

Gather the Source Documents Before Building the Model

Good underwriting begins with source quality. A model cannot correct incomplete, outdated, or inconsistent information. Request the trailing 12-month operating statement, current rent roll, historical financials, leases for major tenants, tax bills, utility data, capital expenditure history, and any available inspection or environmental reports.

For multifamily, verify unit counts, lease expiration dates, concessions, delinquency, loss-to-lease, employee units, and down units. For retail, office, or industrial, pay particular attention to tenant rollover, lease terms, renewal options, reimbursements, rent escalations, tenant credit, and vacancy exposure.

Do not assume the rent roll ties to the income statement. It often does not. Differences may be legitimate, such as recent move-ins or timing issues, but they need an explanation. When documents conflict, flag the discrepancy instead of quietly choosing the more favorable number.

Commercial Underwriting Process Steps for Revenue

Revenue is where optimistic underwriting most often starts. Build from what exists today, then model what is reasonably achievable. Separate in-place rent from market rent and identify the timing required to capture any increase.

For an apartment property, begin with physical occupancy and economic occupancy. Physical occupancy tells you how many units are occupied. Economic occupancy shows what the owner is actually collecting after vacancy, concessions, bad debt, and delinquency. A property reporting 95% occupancy may still be underperforming if concessions and collections issues are significant.

Next, test market rent assumptions against comparable properties. The right comparison is not simply the newest asset with the highest advertised rent. Consider unit size, finish level, amenities, parking, location, concessions, and actual achieved rents. If your projected rents require renovations, include realistic renovation costs, downtime, and lease-up timing.

Commercial assets require a similar discipline, but the income analysis centers on leases. Review each tenant’s contractual rent, renewal probability, expiration date, expense reimbursements, and options. A building with strong current income can become a very different investment if 40% of its revenue expires within two years.

Use conservative timing. Rent growth may occur, but rarely all at once. Lease expirations, renovation schedules, market absorption, and local competition determine when projected income can actually reach the model.

Normalize Expenses Instead of Copying Them

Historical expenses are evidence, not a forecast. Some costs are fixed or relatively predictable, while others need to be normalized based on operations, market standards, and the condition of the property.

Review each major expense category: payroll, repairs and maintenance, utilities, insurance, property taxes, management fees, marketing, administrative costs, and reserves. Look for one-time items, deferred expenses, owner-specific costs, and expenses that may rise after acquisition.

Property taxes deserve special attention. In many jurisdictions, a sale triggers reassessment. Underwriting taxes from the seller’s historical bill can make a deal appear stronger than it is. Insurance is another common blind spot, particularly for properties in regions facing severe weather, wildfire, flood exposure, or rapidly changing carrier requirements.

For multifamily, compare expenses on a per-unit basis to similar properties. For other commercial property types, per-square-foot analysis can be more useful. A low expense ratio might signal operational efficiency, but it can also indicate that repairs, payroll, or capital needs have been deferred.

Separate Operating Expenses From Capital Needs

Net operating income is not the same as cash flow. Operating expenses keep the property functioning day to day. Capital expenditures address larger replacements and improvements such as roofs, HVAC systems, parking lots, plumbing, elevators, unit turns, or major renovations.

A seller may show a healthy NOI while postponing expensive work. That does not mean the work disappears after closing. Build a capital plan that distinguishes immediate repairs, recurring reserves, and value-add improvements. Then align the timing of those costs with your financing and business plan.

This distinction also protects your investment committee narrative. If a projected return depends on spending $1 million on improvements, show where that capital comes from and when it is deployed. Do not bury it in a generic reserve line.

Model Financing and Test the Exit

Debt can improve returns, but it can also turn a manageable underwriting error into a serious problem. Model the actual proposed loan structure, including the interest rate, amortization period, term, interest-only period, fees, reserves, and prepayment provisions.

Then test debt service coverage and debt yield against lender expectations. A deal with thin coverage may still be financeable, but it leaves little room for rent growth delays, higher expenses, or a leasing setback. Floating-rate debt requires an even more deliberate stress test because the cost of capital can change quickly.

Your exit should be conservative enough to survive scrutiny. Apply an exit cap rate that reflects the asset’s likely condition, market outlook, lease profile, and remaining growth potential at sale. It is usually prudent to underwrite an exit cap rate above the entry cap rate, especially when the business plan depends on market growth.

The exit is not a guess about where the market will be. It is a test of whether the investment still works if the market is less favorable than your base case.

Run Sensitivities Before You Trust the Returns

A base case tells you what happens if your assumptions are right. Sensitivity analysis tells you how exposed the deal is when they are not. Test the variables that matter most: rent growth, vacancy, renovation pace, operating expenses, interest rates, exit cap rate, and sale timing.

You do not need dozens of scenarios. A practical approach is to run a downside case, a base case, and an upside case. The downside case should be plausible, not catastrophic. If modest changes to rent growth or exit cap rate erase the return, the deal may be too dependent on favorable conditions.

Pay attention to the break-even points. How much occupancy can decline before debt service coverage becomes uncomfortable? How far can the exit cap rate expand before the equity multiple no longer meets your target? Those answers are often more useful than the headline IRR.

Document Assumptions and Make the Decision

The final step is not formatting the model. It is documenting the assumptions that drive the result and identifying what must be verified during due diligence. Keep a short assumptions log that shows the source, rationale, and confidence level for major inputs.

This makes conversations with partners, lenders, and clients more productive. Instead of arguing about whether a return is right, you can focus on the few inputs that truly determine the outcome: achievable rent, tax reassessment, renovation scope, tenant renewal, or financing terms.

A strong underwriting process does not eliminate uncertainty. It gives uncertainty a place in the model, makes risk visible early, and helps you decide whether to pursue the deal, renegotiate the price, or walk away with confidence.

A one-point change in vacancy can materially change a property’s NOI, debt-service coverage, and value. Yet many underwriting models still treat vacancy as a plug: a flat percentage copied from an offering memorandum or a prior deal. Knowing how to model vacancy assumptions means separating what is vacant now, what may become vacant, and how long it will realistically take income to return.

For multifamily investors, vacancy is usually a recurring operating friction tied to tenant turnover, seasonality, unit condition, and local demand. For office, retail, and industrial investors, it is often a lease-event risk that can appear suddenly when a major tenant rolls. The modeling discipline is the same, but the timing and evidence behind the assumption must match the asset.

Start with the vacancy definition

Before setting a percentage, decide what your model means by vacancy. Physical vacancy measures unoccupied space or units. Economic vacancy measures lost revenue, which can include vacant space, concessions, bad debt, employee units, model units, and sometimes collection loss. These are related but not interchangeable.

A 5% physical vacancy factor does not automatically mean a property loses 5% of gross potential rent. A multifamily property may have 3% vacant units but another 2% of economic loss from concessions and delinquency. Conversely, a fully occupied retail center can have meaningful future vacancy exposure if a tenant’s lease expires during the hold period.

In a clean model, show the components separately when the available data supports it. For a stabilized multifamily property, that may mean a physical vacancy and credit loss line plus a concessions line. For a multi-tenant commercial property, it may mean contractual rent by tenant and suite, followed by a specific vacancy and downtime assumption for each lease rollover. Separate lines make it easier to explain the underwriting to a lender, equity partner, or client.

How to model vacancy assumptions from evidence

The best vacancy assumption is not the most optimistic market statistic or the most conservative round number. It is the assumption that is supported by the property’s current condition, the competitive set, lease structure, and business plan.

Establish the in-place starting point

Begin with trailing operating results and current rent roll data. Calculate actual economic vacancy using collected revenue, not only scheduled rent. If a property reports 96% occupancy but collections consistently trail billed rent, the real income loss may be higher than the occupancy report suggests.

For multifamily, review at least 12 months of occupancy, notices, turn times, concessions, delinquency, and bad debt. Monthly data matters because annual averages can hide a soft leasing season or a recent demand decline. If occupancy has fallen from 97% to 93% over four months, underwriting a 3% vacancy rate because that was last year’s average ignores the current trajectory.

For commercial assets, map every tenant’s lease expiration, renewal option, square footage, rent, and credit profile. Current occupancy is only a snapshot. A property that is 100% occupied today may be riskier than an 85% occupied property with stable long-term tenants and a credible lease-up plan.

Compare the property with its actual competition

Market vacancy data is useful context, not a substitute for property-level analysis. A metro-wide multifamily vacancy rate may include new Class A deliveries, older workforce housing, and submarkets that do not compete for the same renter. The same problem appears in office and retail when broad market reports blend very different locations and quality tiers.

Build a relevant comp set. For apartments, compare unit size, condition, amenities, asking rents, effective rents, concessions, and availability. For commercial space, compare location, suite size, building quality, parking, tenant improvements, and lease economics. Ask a practical question: if a prospective tenant or resident says no to this property, where do they go instead?

If comparable properties are offering six weeks free rent, assuming your property will maintain zero concessions needs a clear reason. If your asset has materially better access, finishes, or rents below the market, the assumption may be defensible. The point is not to follow competitors blindly. It is to document why the property should perform differently.

Match the assumption to the business plan

Vacancy should change when the business plan changes. A light value-add multifamily deal may experience temporary vacancy as units turn for renovation, even if long-term demand is strong. The model should reflect that disruption before showing rent premiums and stabilization.

For example, an investor planning to renovate 10 units per month should consider the average days each unit is offline, the expected renovation duration, make-ready time, leasing time, and any delay between lease signing and move-in. Modeling a flat 5% vacancy factor while also assuming aggressive renovations can understate lost rent.

For office, retail, and industrial, model vacancy by suite and by period whenever lease expirations are material. A 20,000-square-foot tenant rolling in year two should not disappear inside a blended 8% vacancy rate. Underwrite a renewal probability, expected downtime if the tenant leaves, market rent at re-lease, tenant improvements, leasing commissions, and free-rent exposure. The model may show no vacancy if the tenant renews, or several months of lost revenue if the space goes dark. That is the risk the investment committee needs to see.

Build vacancy into the timeline, not just the annual total

Annual vacancy assumptions can produce clean-looking forecasts while hiding cash-flow pressure. Monthly or quarterly modeling is especially valuable during acquisition, renovation, lease-up, and major rollover periods.

A practical approach is to model three stages: in-place operations, transition, and stabilized operations. In-place performance reflects actual recent results. Transition captures known vacancy, renovation downtime, lease expirations, or marketing periods. Stabilized operations use a long-term economic vacancy rate based on the competitive market and the asset’s positioning.

For a multifamily acquisition, a stabilized vacancy rate might be 5%, but the first six months may warrant 7% to 9% if turnover is elevated, rents are being repositioned, or the property is carrying deferred maintenance. For a leased commercial asset, stabilized vacancy may be less relevant than the timing of individual lease events. It depends on the lease profile.

Do not forget that vacancy affects more than base rent. Empty units may reduce utility reimbursements, parking income, pet fees, and other ancillary revenue. Vacant commercial suites can also trigger landlord-paid utilities, security costs, leasing expenses, and tenant improvement outlays. A complete model follows the income and expense consequences of lost occupancy.

Test the assumption with simple downside cases

No vacancy assumption is certain, so the model should show what happens when leasing takes longer than planned. This does not require an overly complicated sensitivity table. A few targeted cases often provide more decision value than dozens of scenarios.

Test a realistic downside case against the base case. For multifamily, increase economic vacancy, extend unit turns, reduce renewal rates, or add concessions. For commercial property, shorten a major tenant’s renewal probability, extend downtime, reduce re-leasing rent, or increase tenant-improvement costs. The right stress test reflects the property’s most likely failure point.

Then measure the effect on NOI, debt-service coverage ratio, cash flow, and exit value. Because direct capitalization values are tied to NOI, a vacancy miss can affect returns twice: it reduces operating cash flow during the hold and can reduce the income used in the sale valuation. If the deal only works at a vacancy rate below what comparable properties are achieving, the issue is not a spreadsheet formatting problem. It is a pricing or strategy problem.

Common errors that create false confidence

The most frequent error is using the seller’s trailing vacancy without adjusting for current leasing conditions. Another is applying a market average to an asset with a different quality level, rent position, or tenant base. Investors also often double-count or omit economic loss by mixing vacancy, concessions, bad debt, and credit loss without defining each line item.

A separate issue is assuming immediate stabilization after renovations or lease expiration. Space does not usually move from vacant to fully productive in one month. There may be construction time, marketing time, free rent, and a lag before collections normalize. Conservative timing is often more useful than a conservative percentage because timing drives real cash flow.

Finally, avoid burying vacancy inside an unexplained percentage of effective gross income. A simple model is good. An opaque model is not. Your assumption should be easy to trace back to rent roll data, property history, market evidence, or a specific lease event.

A vacancy assumption earns confidence when it tells a believable operating story. If you can explain who may leave, how long income may be offline, what it will cost to replace it, and why the property should stabilize, you are no longer using vacancy as a plug. You are underwriting the risk that matters.

A deal can look attractive in a broker package and still fail under basic scrutiny. The difference usually appears in the commercial real estate metrics behind the headline cap rate, projected rent growth, or quoted cash flow. For brokers and investors, the goal is not to memorize every ratio. It is to know which numbers answer the questions that determine whether a deal deserves more time, a lower offer, or a quick pass.

The most useful metrics connect property operations to investor returns and lender requirements. Read together, they turn an offering memorandum into a decision. Read in isolation, they can create false confidence.

Start With Income That Can Actually Be Collected

Underwriting begins with revenue, but gross potential rent is not the same as usable income. Gross potential rent assumes every unit or suite is occupied and every tenant pays the full scheduled rent. It is a starting point, not an outcome.

Effective gross income, or EGI, is the more meaningful figure. It accounts for vacancy, concessions, bad debt, employee units, loss-to-lease, and other collection leakage. For a multifamily property, a 5% physical vacancy assumption may look reasonable, but it can understate reality if collections are weak or renewals require substantial concessions.

A simple formula is:

Effective Gross Income = Gross Potential Income – Vacancy and Credit Loss – Concessions + Other Income

Other income deserves the same scrutiny as rent. Parking, pet fees, utility reimbursements, storage, application fees, and laundry income may be real, but they are not automatically durable. Ask whether those income streams appear in trailing financials, whether they are market-supported, and whether management can continue collecting them after a sale.

For brokers, this distinction helps you speak credibly about a property’s operating story. For investors, it prevents the common mistake of paying for income that exists only in a pro forma.

Commercial Real Estate Metrics for Operating Performance

Net Operating Income

Net operating income, or NOI, is the property’s income after operating expenses but before debt service, capital expenditures, depreciation, and income taxes. It is the core earnings measure used for valuation, financing, and return analysis.

NOI = Effective Gross Income – Operating Expenses

The formula is straightforward. The work is deciding which expenses are sustainable. Taxes may reset after a sale. Insurance may be rising sharply. Payroll may be below market because an owner performs management duties. Repairs and maintenance may appear low because ownership deferred work.

When comparing actuals to a seller’s budget, focus less on whether every line item matches and more on why it differs. A $300-per-unit gap in repairs may be harmless for a newly renovated asset and serious for a 1970s property with aging mechanical systems. Context determines whether an adjustment is conservative or arbitrary.

Expense Ratio

The operating expense ratio shows what share of effective gross income is consumed by operating costs.

Expense Ratio = Operating Expenses / Effective Gross Income

This metric is useful for spotting outliers, not for declaring that one property is better than another. A low ratio could signal efficient management, but it could also point to deferred maintenance, underinsured assets, or missing expenses. A higher ratio may reflect included utilities, higher payroll, or a location with higher property taxes.

Compare the ratio against similar assets with similar utility structures, age, class, and market conditions. A garden-style apartment property with owner-paid utilities should not be benchmarked blindly against a separately metered, newer Class A property.

NOI Margin

NOI margin measures how much of effective gross income becomes NOI.

NOI Margin = NOI / Effective Gross Income

It is the inverse view of the expense ratio and is particularly useful when evaluating how much operating leverage a property has. A property with a strong NOI margin may produce meaningful upside from rent growth. But if income growth requires large concessions or expensive renovations, the margin alone does not prove the business plan works.

Valuation Metrics Need a Clean NOI

Cap Rate

The capitalization rate is one of the most quoted CRE metrics and one of the easiest to misuse.

Cap Rate = NOI / Purchase Price

A going-in cap rate uses current or trailing NOI. A forward cap rate uses projected NOI. Both can be helpful as long as everyone in the conversation is using the same definition. Trouble starts when a deal is marketed on a forward cap rate while the buyer compares it to recent sales based on trailing results.

A higher cap rate is not automatically a better deal. It may reflect weaker location, more vacancy, poor tenant quality, upcoming capital needs, or limited liquidity at resale. Likewise, a lower cap rate can be justified by durable income, strong demand, and below-market financing assumptions that are not available to a new buyer.

Use cap rate to frame the price relative to income. Then test whether that income is real, recurring, and sufficient for the risk involved.

Price Per Unit or Square Foot

Price per unit is a practical multifamily comparison metric. Price per square foot often serves the same purpose in office, retail, and industrial assets. These measures help establish whether a deal is priced above or below comparable properties, but they do not replace underwriting.

Two apartment communities can trade at the same price per unit while having completely different economics. One may have renovated interiors, superior parking, and low deferred maintenance. The other may need $15,000 per unit in capital work. The acquisition price is only part of your basis.

Debt Metrics Tell You Whether the Deal Can Carry Its Financing

Debt Service Coverage Ratio

Debt service coverage ratio, or DSCR, measures a property’s ability to pay annual principal and interest from NOI.

DSCR = NOI / Annual Debt Service

A DSCR of 1.25x means the property generates $1.25 of NOI for every $1.00 of annual debt service. Lenders commonly set minimum thresholds, but the required level depends on asset type, loan structure, sponsorship, and market conditions.

Do not underwrite only to the lender’s minimum. A deal that clears at 1.20x may still leave little room for a tax reassessment, occupancy drop, or interest-rate increase if the debt is floating. Run downside cases that reflect realistic stress, not just a token reduction in rent.

Loan-to-Value Ratio

Loan-to-value ratio, or LTV, compares loan amount with property value.

LTV = Loan Amount / Property Value

Lower LTV generally means more borrower equity and more protection for the lender. For the investor, it also means less leverage. That can reduce cash-on-cash returns in a stable scenario while improving resilience when revenue declines or exit values soften.

The right leverage level depends on the asset and plan. A stabilized property with predictable operations may support more leverage than a heavy renovation project with uncertain lease-up timing. The best financing is not simply the largest loan. It is the loan the property can carry through a less favorable operating period.

Return Metrics Should Match the Investment Question

Cash-on-Cash Return

Cash-on-cash return measures annual before-tax cash flow relative to the cash invested.

Cash-on-Cash Return = Annual Before-Tax Cash Flow / Total Cash Invested

It answers a practical question: what cash yield is this investment producing on my equity today? It is easy to communicate and especially relevant for investors focused on current distributions.

Its limitation is that it can be heavily influenced by leverage. A highly leveraged deal may show a strong cash-on-cash return while carrying more refinancing and downside risk. It also does not capture the timing of future proceeds or a major sale event.

Internal Rate of Return and Equity Multiple

Internal rate of return, or IRR, measures the annualized return based on the timing of all projected cash flows. Equity multiple measures total cash received relative to total equity invested.

Equity Multiple = Total Distributions / Total Equity Invested

IRR rewards earlier cash flow. Equity multiple shows the total value created. A deal can have a high IRR from a quick sale but a modest equity multiple. Another can produce a higher multiple over a longer hold with a lower IRR. Neither is universally better. The right result depends on your hold period, liquidity needs, and confidence in the exit assumptions.

When reviewing either metric, work backward from the projected sale. Test the exit cap rate, sale costs, and future NOI. Many optimistic return projections depend less on operational improvement than on a favorable resale assumption.

Build a Repeatable Metric Review

Speed comes from a consistent review order. Start with trailing revenue and expenses, calculate a clean NOI, test the purchase price against that NOI, evaluate debt coverage, and then assess investor returns under both base and downside cases. This sequence keeps the analysis grounded in property operations before it moves into attractive-looking return outputs.

At Underwriting 4 All, the practical standard is simple: every number should have a source, an assumption, or a reason it differs from history. If it has none of those, it is not yet an underwriting input. It is a question.

The best deals rarely depend on one exceptional metric. They hold together when the income is credible, expenses are fully accounted for, debt has breathing room, and returns remain acceptable after you challenge the assumptions. That is the confidence worth building before you submit an offer.

A self-storage offering memorandum can make a property look simple: hundreds of small units, monthly tenants, and an attractive going-in cap rate. But learning how to underwrite self storage means looking past the headline occupancy and asking harder questions. Is the revenue real and repeatable? Is the facility capturing its market-rate potential? And what happens if new supply, elevated move-outs, or a slower lease-up period changes the story?

Self storage can be a highly efficient operating model, but it is still an operating business. Your underwriting needs to connect the physical asset, local demand, competitive set, revenue-management strategy, and financing structure into one decision-ready view.

Start With the Unit Mix, Not Just the Rent Roll

The first task is to understand what the facility actually sells. A self-storage property is not one product. It is a collection of unit types with different demand profiles, rental rates, occupancy levels, and replacement costs.

Build your unit-mix schedule by size, type, and location. At a minimum, separate standard drive-up units, climate-controlled units, parking spaces, and specialty storage such as RV, boat, wine, or business storage. For each category, calculate net rentable square feet, number of units, physical occupancy, in-place monthly rent, and in-place rent per square foot.

This step exposes issues that a blended average can hide. A facility may report 92% physical occupancy overall, for example, while its 10-by-10 climate-controlled units are full and its larger 10-by-30 drive-up units sit mostly vacant. Those are different underwriting problems. One may support rent growth; the other may require a change in marketing, pricing, or even unit conversion.

Also confirm the distinction between gross building area and net rentable square feet. Self storage is commonly valued and benchmarked using rentable area. Hallways, leasing offices, elevators, mechanical rooms, and other non-rentable space affect development cost and operating efficiency, but they do not directly produce rental income.

Underwrite Self Storage Revenue in Layers

Self-storage revenue is more dynamic than apartment rent. Tenants generally rent month to month, rates can change frequently, and a property can generate material income from fees, tenant insurance, retail sales, and other ancillary sources. That flexibility creates upside, but it also means trailing financials may not represent stabilized performance.

Start with in-place rental revenue. Apply the current occupied units and contractual monthly rates by unit type. Then compare those rates to competitive facilities. Do not rely only on an owner’s stated market rent. Call nearby facilities, review their advertised rates, ask about promotions, and identify whether their quoted price is an introductory rate or the rate paid after a few months.

Your market-rent conclusion should reflect comparable units, not just comparable properties. A climate-controlled, interior 5-by-10 unit should be compared against similar product in the same trade area. A facility with easy drive-up access, strong visibility, newer construction, and digital gate access may justify a premium. An older asset with weak signage or deferred maintenance may not.

From there, model a realistic path from in-place rents to market rents. If the current average rate is 15% below market, do not assume the full increase lands on day one. Management must balance rate increases against move-outs and new-customer conversion. The right pace depends on local supply, seasonal demand, current occupancy, and how far existing customers are below market.

A common approach is to model new-tenant rates at or near market immediately, while phasing existing-tenant increases over several months. If occupancy is already high and comparable facilities are charging more, the facility may have pricing power. If occupancy is soft, a more conservative increase schedule is usually more credible.

Ancillary revenue deserves its own line items. Tenant insurance commissions, administrative fees, late fees, lock sales, moving supplies, and truck rental can be meaningful, particularly at professionally managed properties. Use historical performance when it is reliable, but test each category against the unit count and local operating model. A small facility with minimal staffing should not be assumed to produce the same retail income as a larger, fully managed location.

Separate Physical Occupancy From Economic Occupancy

Physical occupancy tells you how many units are occupied. Economic occupancy tells you how much potential revenue the facility is actually collecting after concessions, discounts, bad debt, and vacancy. You need both.

A property at 90% physical occupancy may have lower economic occupancy if it relies on deep promotions or carries substantial delinquency. Conversely, a facility with 85% physical occupancy may have strong economics if occupied units are paying above-market rates and management is intentionally holding out for better tenants.

In the underwriting model, show gross potential rent, vacancy, concessions, bad debt, and other revenue adjustments separately. Combining them into a single vacancy assumption makes the model harder to audit and can conceal an overly aggressive revenue forecast.

For a stabilized facility, vacancy should be based on the submarket, unit mix, and competitive positioning, not simply the seller’s recent average. For a lease-up asset, use a monthly absorption schedule. Lease-up is rarely linear. Demand may improve during peak moving season and slow materially in winter, while a new competitor can interrupt absorption without warning.

Build Expenses From Operations, Not a Percentage of Revenue

Self storage often has lower operating expenses per square foot than multifamily, but expense underwriting still requires discipline. A broad percentage-of-revenue assumption can be useful as a reasonableness check, not as the primary method.

Underwrite property taxes based on expected post-sale assessment, not just the seller’s tax bill. In many jurisdictions, an acquisition can trigger reassessment. Missing this adjustment can materially overstate net operating income and value.

Review payroll, utilities, repairs and maintenance, marketing, insurance, management fees, software, security, and property taxes individually. Older facilities may need higher repair reserves, roof work, gate upgrades, paving, camera replacement, or HVAC maintenance for climate-controlled space. A facility converting from onsite management to remote or hybrid management may lower payroll, but it may also require technology investment and a carefully planned customer-service process.

Marketing deserves special attention during lease-up or in a competitive market. If your revenue plan assumes rapid occupancy growth, make sure the model includes enough spend for digital advertising, local outreach, signage, and promotional activity to support that growth.

Test the Supply Story Before You Believe the Upside

New supply is one of the fastest ways for a self-storage underwriting model to lose its margin of safety. Facilities can be developed relatively quickly in many markets, and a property that is underbuilt today may not remain underbuilt through your hold period.

Map existing competitors and active development sites within the property’s realistic customer radius. That radius varies. Dense urban sites may draw from a tighter area, while suburban drive-up facilities can pull customers from farther away. Consider traffic patterns, visibility, access, neighborhood barriers, and the location of apartment communities, single-family housing, businesses, and recreational demand generators.

Do not stop at projects under construction. Check proposed developments, zoning activity, entitled sites, and parcels where self storage is a logical use. Then ask whether a competitor is likely to compete for the same tenant. A large climate-controlled facility near apartments may not affect boat and RV storage demand in the same way, but it could pressure conventional unit rents.

Supply risk does not automatically kill a deal. It changes your assumptions. You may need slower rent growth, higher concessions, more vacancy, greater marketing expense, or a lower exit value.

Size the Debt to a Downside Case

Once you have a base operating forecast, underwriting should become less about proving the deal works and more about identifying where it breaks. Run a downside case that combines slower rent growth, higher vacancy, elevated operating expenses, and a higher exit cap rate.

For self storage, a useful stress test might assume that market-rate growth takes longer than planned, economic occupancy falls several points below the base case, and expense growth exceeds inflation for taxes or insurance. Measure the impact on debt service coverage, debt yield, cash flow, refinance proceeds, and equity returns.

If a deal only works with immediate rent increases, near-perfect occupancy, and a favorable exit cap rate, the issue is not your spreadsheet. The issue is that the acquisition price may leave little room for ordinary operating risk.

Make the Model Auditable

A strong self-storage model lets another deal professional trace every major assumption back to a source. Keep market rents, occupancy, concessions, expenses, capital items, debt terms, and exit assumptions clearly labeled. Separate historical results from your forward assumptions, and make the bridge between the two visible.

That is how underwriting becomes faster over time. You are not rebuilding your logic for every offering. You are using a repeatable process, then applying judgment where the property and market demand it.

The best next step is simple: take one live self-storage deal, underwrite the unit mix at the individual product level, and compare your assumptions against the seller’s story. The gaps you find are often where the real investment decision begins.

A broker has a limited window to turn a new listing, OM, or off-market lead into a credible point of view. An underwriting spreadsheet for brokers is what separates a quick opinion from a deal conversation grounded in numbers. It should help you identify the value drivers, expose the weak assumptions, and explain the opportunity without pretending you can predict the future perfectly.

The goal is not to build an institutional model with 30 tabs and formulas no one can audit. The goal is to create a repeatable analysis that answers the questions buyers, lenders, and partners actually ask: What is the property earning now? What can it earn after a realistic business plan? What is the buyer paying for that income? And what happens if the market does not cooperate?

What a Broker Underwriting Spreadsheet Must Do

A broker’s model has a different job than an acquisition team’s final investment committee model. It needs to be fast enough for early deal triage, clear enough to support a client conversation, and reliable enough that the headline outputs do not collapse when someone asks about the assumptions.

That means the spreadsheet should tell a cohesive story from the source data to the conclusion. A user should be able to trace a projected rent increase back to the current rent roll, see how operating expenses were estimated, and understand why the exit value changes under a different cap rate.

A useful model also separates facts from assumptions. Current in-place rents, unit counts, tax bills, trailing expenses, debt terms, and sale comparables are inputs supported by documents or market evidence. Renewal growth, loss-to-lease capture, renovation premiums, bad debt, expense growth, and exit cap rates are assumptions. Blending these categories together is one of the fastest ways to create false confidence.

Build the Underwriting Spreadsheet for Brokers Around Decisions

Start with the decisions the analysis needs to support. For a multifamily listing, that may be whether the asking price is supportable, which buyer profile is most likely to pursue the deal, and what return narrative is defensible. For a buyer-side assignment, it may be whether the property clears a target yield, cash-on-cash return, or internal rate of return.

Do not start by adding every possible line item. Start with a clean input section, then build only the calculations required to reach the decision. A practical layout usually includes property and purchase assumptions, operating assumptions, a multi-year pro forma, debt, sale assumptions, and a concise returns summary.

Start with the in-place operation

The first underwriting question is simple: what is happening at the asset today? For apartments, load the unit mix, unit counts, current average rents, market rents, occupancy, other income, and concessions. If an actual rent roll is available, use it rather than relying solely on OM averages. Averages can hide a meaningful number of under-market units, employee units, vacant units, or nonpaying residents.

Use trailing 12-month operating statements whenever possible. Compare actual revenue and expenses against the seller’s budget, then identify the items that need normalization. Property taxes may reset after a sale. Insurance may be materially higher at current replacement costs. Management fees, payroll, utilities, repairs, and turn costs can all shift depending on the buyer’s operating approach.

The underwriting should show the in-place net operating income separately from the projected NOI. When those figures are combined too early, users can mistake a future business plan for current performance.

Model revenue growth with a reason

Revenue assumptions need a clear source. A rent growth input should reflect local supply, recent leasing activity, comparable properties, and the asset’s starting position in the market. A property already at market rent does not have the same upside as a property with clear loss to lease.

For value-add deals, distinguish between organic rent growth and renovation premiums. Organic growth applies to the existing unit condition. Renovation premiums require a renovation scope, a budget, downtime or turn assumptions, and a realistic schedule for completed units. If 40 units can be renovated in a year, the model should not assume premiums across 120 units in that same year.

Other income deserves the same discipline. Parking, pet rent, RUBS, storage, application fees, and utility reimbursements can matter, but each should be tied to a plausible adoption rate. Small revenue lines are often overstated because they look insignificant on a per-unit basis. Across a large property and a five-year hold, they can materially affect value.

Treat expenses as operating realities, not placeholders

Expense ratios are helpful for a quick screen, but they are not a substitute for reviewing property-specific costs. Taxes and insurance deserve special attention because both can change sharply after closing. For taxes, consider the local assessment process, likely reassessment timing, and assessed-value relationship. For insurance, use current market quotes or credible benchmarks rather than a historical number that may no longer be obtainable.

For controllable expenses, show the logic behind the forecast. If utilities are expected to decline because of submetering or a RUBS program, account for implementation timing and resident participation. If repairs and maintenance are expected to fall after capital improvements, do not assume that benefit arrives before the work is complete.

A dependable spreadsheet makes these choices visible. Hiding adjustments inside formulas may save space, but it makes the analysis harder to defend.

Debt and Exit Assumptions Need Their Own Stress Test

Many deals look attractive until financing and disposition assumptions are tested. Build the debt section with the loan amount, interest rate, amortization, term, interest-only period, lender fees, and prepayment costs where relevant. The model should calculate annual debt service, ending loan balance, debt yield, loan-to-value, and debt service coverage ratio.

For brokers, this is particularly useful because it helps frame the buyer pool. A deal with modest leverage requirements and strong coverage may appeal to a wider range of buyers. A deal that only works with aggressive leverage or a low rate assumption has a narrower path to closing.

The exit cap rate should not simply match the going-in cap rate. It depends on the projected condition of the property, market outlook, interest rates, buyer demand, remaining upside, and the age of the income stream at sale. A renovated asset with stable operations may earn a stronger exit than a property with unfinished work, but that result must be supported by the facts.

Run at least three cases: base, downside, and upside. In the downside case, combine slower rent growth, higher expenses, a higher exit cap rate, and financing that is less favorable than expected. You do not need to manufacture a disaster scenario. You do need to know whether a reasonable miss turns the deal from compelling to fragile.

Use Outputs That Improve the Conversation

A model can calculate dozens of return metrics, but a broker usually needs a short list that makes the economics clear. Purchase price per unit, going-in cap rate, stabilized NOI, price per square foot when relevant, debt yield, annual cash flow, equity multiple, and levered IRR are generally enough to anchor the discussion.

Pair the output with sensitivity tables. A price versus exit cap rate table shows how valuation changes when the market moves. A rent growth versus expense growth table can be useful for operations-heavy properties. The point is not to overwhelm a client with scenarios. It is to show which assumptions truly drive the result.

Be precise about what each metric means. A high IRR can result from a short hold and aggressive sale assumptions, while a strong cash-on-cash return may reflect favorable debt rather than superior property operations. Metrics are evidence, not a substitute for judgment.

Keep the Model Auditable and Fast

The best spreadsheet is one another professional can review without a guided tour. Use consistent colors or formatting for hardcoded inputs, formulas, and links from other tabs. Label assumptions clearly. Avoid hardcoding numbers inside long formulas. Add source notes beside major inputs, especially market rents, tax assumptions, renovation costs, and exit cap rates.

Build a standardized template, but do not force every deal into identical assumptions. A 1970s garden-style property with utility inefficiency needs a different expense review than a newer, urban mid-rise. Standardization should speed up the workflow, not erase the details that make a deal investable or risky.

Before sharing the file, run a short quality-control check: confirm unit counts reconcile, verify the pro forma begins with in-place performance, inspect formulas for broken references, and test whether the sale proceeds use the correct ending loan balance. Then ask one practical question: if a buyer challenged the three biggest assumptions, could you explain and support each one?

That is the standard worth building toward. A clear underwriting spreadsheet does more than produce a return estimate. It gives brokers a disciplined way to qualify opportunities, communicate value, and earn trust when the conversation moves from a promising deal to a real decision.