Investment Underwriting Model for Better CRE Deals

A commercial property can look compelling in a broker package and still underperform the moment real operating costs, lease rollover, capital needs, or financing terms enter the picture. An investment underwriting model puts those variables into one disciplined decision framework. It helps investors, owners, lenders, and developers determine what an asset is worth today, what it may produce over a holding period, and what assumptions need to be true for the deal to work.

For Long Island commercial real estate, underwriting must do more than apply a market cap rate to current income. Office, industrial, flex, retail, medical, and land transactions each carry different leasing patterns, expense structures, tenant-credit considerations, zoning limitations, and buyer demand at exit. The model is where those differences become measurable.

What an Investment Underwriting Model Should Answer

A useful model is not a spreadsheet built to confirm a target price. It is a decision tool designed to challenge the investment thesis. Before a buyer submits an offer or a seller sets expectations, the underwriting should answer several practical questions: What is the property’s stabilized net operating income? How much capital must be invested before that income is achievable? Can the property service its debt under realistic conditions? What sale price is needed at exit to reach the required return?

The answers depend on the type of asset and the investor’s plan. A fully leased industrial building with credit tenants may be evaluated primarily on lease durability, rent growth, expense recoveries, and renewal probability. A partially vacant office property requires a more detailed view of downtime, tenant improvements, leasing commissions, free rent, and the pace of absorption. A redevelopment site may have little current income at all, placing greater weight on entitlement timing, construction costs, financing capacity, and the value of the completed project.

Good underwriting also separates facts from assumptions. Current rent rolls, operating statements, tax bills, lease abstracts, environmental reports, and debt quotes are facts or verifiable inputs. Market rent growth, renewal rates, vacancy, exit cap rates, and construction contingencies are assumptions. The model should make that distinction visible rather than burying risk inside a single projected return.

Build the Investment Underwriting Model From the Property Up

The strongest underwriting begins at the lease level, then builds toward property cash flow and investor returns. Starting with a market-level revenue estimate can be acceptable for an early screen, but it is not sufficient for a serious acquisition decision.

Establish the in-place income

Begin with every existing lease. Record the rentable area, contractual rent, escalation structure, expiration date, options, reimbursements, concessions, security deposits, and guarantor strength. For retail and office properties, distinguish between base rent and recoverable expenses. For industrial assets, confirm whether leases are triple net, modified gross, or structured another way.

Then compare contractual rents with market rents. Above-market leases may support current cash flow but create rollover risk. Below-market leases may represent future upside, but only if the space can be renewed or released at higher rates without excessive downtime or capital spending. A model that assumes every expiring tenant renews at market rent may produce an attractive internal rate of return, but it does not reflect a credible leasing plan.

Normalize operating expenses

Historical operating statements are essential, but they should not be copied directly into projections. Review each expense category for whether it is recurring, controllable, recoverable, and likely to change after a sale. Real estate taxes, insurance, utilities, repairs, payroll, management fees, snow removal, and common-area maintenance should be evaluated individually.

Tax treatment deserves special attention in Nassau and Suffolk Counties, where reassessment, property classification, and transaction-related changes can materially affect future operating costs. A buyer should understand the basis for the tax assumption, not simply use the prior owner’s expense line. For a property with tenants that reimburse expenses, model the recovery structure and any caps, gross-up provisions, exclusions, or administrative fees contained in the leases.

Model vacancy, downtime, and lease-up costs

Economic vacancy is more than an arbitrary percentage applied to gross revenue. It should reflect physical vacancy, expected tenant rollover, collection loss, and the time required to return space to service. In a multi-tenant building, every lease expiration should feed a schedule that shows potential downtime, market rent at renewal or release, tenant improvement allowances, leasing commissions, and free-rent periods.

This is where underwriting often becomes overly optimistic. A landlord may be able to increase rent, but the higher rent can require a new tenant build-out, brokerage fees, months without income, and additional marketing costs. In some cases, retaining a tenant on a lower increase is more valuable than pursuing a theoretical market rent. The correct assumption depends on building quality, location, suite size, tenant demand, and competitive supply.

Include capital expenditures that do not appear in NOI

Net operating income is valuable, but it does not capture every dollar an owner must spend. Roof replacement, parking lot work, HVAC upgrades, elevator modernization, façade repairs, environmental remediation, and major tenant improvements can change the economics of a deal quickly.

Separate recurring replacement reserves from known near-term capital projects. A reserve is a prudent annual allowance. A known project is a specific cash requirement that should be timed in the model and supported by vendor estimates, inspections, or engineering review. Treating a major deferred-maintenance item as a generic reserve can overstate cash flow and understate the acquisition price adjustment a buyer should seek.

Test Debt Before You Rely on Leverage

Debt should be modeled with the same discipline as operating income. Include the loan amount, interest rate, amortization period, term, origination fees, interest-only period, reserves, prepayment terms, and any required future funding. For construction or redevelopment deals, model the draw schedule and interest carry rather than assuming the full loan is available and cost-free from day one.

Debt service coverage ratio and loan-to-value are not just lender requirements. They are early warning indicators for the investor. A projected return may appear strong because leverage amplifies equity performance, while the property’s cash flow is only marginally sufficient to cover debt service. That position can become difficult when a lease rolls, rates reset, or refinancing arrives during a weaker sales market.

Run at least a base case, a downside case, and an upside case. The downside case does not need to be dramatic to be useful. A modest increase in vacancy, a six-month leasing delay, higher tenant improvement costs, or a 50-basis-point expansion in the exit cap rate can show whether the capital structure has enough room for normal market friction.

Use Exit Value as a Test, Not a Promise

Most commercial real estate models derive resale value by capitalizing forward net operating income with an assumed exit cap rate. That approach is standard, but the result is only as reliable as its two inputs. A projected NOI that includes unsustainable rent growth or ignores capital needs will inflate exit value. An exit cap rate that assumes the market will improve can conceal risk rather than price it.

A prudent model typically uses a terminal capitalization rate that is at least as conservative as the entry rate, especially when interest rates, property condition, lease rollover, or market liquidity create uncertainty. The exit value should then be reduced by brokerage fees, legal costs, transfer-related expenses, and any debt payoff costs. Gross sale price is not net proceeds to equity.

For a stabilized asset, compare the implied exit price per square foot with recent relevant transactions. For a value-add property, ask whether the buyer at exit will view the asset as stabilized or will inherit unresolved rollover, deferred maintenance, or management issues. The buyer’s underwriting is ultimately part of your exit strategy.

Know Which Return Metrics Matter

Cash-on-cash return, internal rate of return, equity multiple, net present value, debt yield, and debt service coverage ratio each provide a different perspective. No single metric should determine the decision.

Cash-on-cash return shows annual cash flow relative to invested equity and is particularly useful for investors focused on current income. Internal rate of return captures the timing of cash flows and sale proceeds, but it can look favorable in short hold periods where an early sale drives the result. Equity multiple shows how much equity is returned in total, although it does not account for timing. Net present value can be especially useful when a buyer has a defined return threshold and wants to compare alternatives on a consistent basis.

The right measure depends on the capital source and business plan. A private investor seeking steady income may place greater weight on cash flow durability. A developer or value-add investor may focus on the risk-adjusted return on incremental capital. An institutional buyer may require a clear path to both a target yield and a liquid exit.

Underwriting Is a Market Process, Not Just a Spreadsheet

The model should be updated as diligence produces better information. Lease reviews may reveal options or expense caps. Property inspections may identify capital projects. Conversations with leasing professionals may change the achievable rent or absorption timeline. A credible investment case becomes more precise as uncertainty is replaced with verified facts.

NAI Long Island approaches underwriting as part of a broader advisory process: connecting asset-level analysis with leasing conditions, comparable sales, tenant demand, operating realities, and the owner’s objective. That perspective matters because the best deal is not always the one with the highest projected return. It is the one whose risks are understood, priced correctly, and manageable through the holding period.

Before committing capital, ask one final question: if the market performs merely adequately rather than exceptionally, does the investment still meet the objective? A model that can answer that question clearly gives the buyer a far better basis to move forward.