๐Ÿ  Home ๐Ÿ“š Learn ๐ŸŽฏ Get Bankable ๐Ÿฆ For Bankers โšก Check My Ratios โ†’
For Bankers ยท Investment Property

Investment Property Underwriting: NOI, Cap Rate, Debt Yield, and Rent Roll Analysis

By BankLiterate ยท 11 min read ยท For Bankers & Loan Officers

Investment real estate โ€” property owned for the income it generates rather than the space it provides for a business โ€” is underwritten from a fundamentally different starting point than owner-occupied commercial real estate. The primary repayment source is not the borrower's business cash flow. It is the property's net operating income. The property has to support the debt on its own merits.

This distinction reshapes every part of the underwriting process. The borrower's personal financial strength matters โ€” but it's secondary. The underwriting starts with the property.

The Primary Repayment Source

In investment real estate lending, the loan is underwritten to the property first and the borrower second. A highly creditworthy borrower does not make a poorly performing property creditworthy. The property's NOI must support the debt service โ€” that's the primary test. Everything else is secondary.

This is why investment real estate underwriting requires a deep analysis of the income โ€” not just the current income, but the sustainable stabilized income. What will this property generate in a normal operating environment, with realistic vacancy, and with expenses that reflect actual maintenance requirements rather than an owner who has deferred everything to make the numbers look good for the sale?

Constructing NOI Correctly

Net Operating Income is the foundation of investment real estate analysis. NOI = Gross Potential Income โˆ’ Vacancy and Credit Loss โˆ’ Operating Expenses. It does not include debt service, depreciation, or capital expenditures โ€” NOI is pre-financing, pre-tax, and pre-capex.

NOI Construction
Gross Potential Rent (all units at contract rent, 100% occupied) โˆ’ Vacancy and Credit Loss (market rate, not historical best case) = Effective Gross Income (EGI) + Other Income (parking, laundry, late fees, ancillary) = Total Effective Gross Income โˆ’ Operating Expenses (taxes, insurance, management, maintenance, utilities, reserves) โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ = Net Operating Income (NOI)
โš ๏ธ Do NOT include mortgage interest or principal payments in operating expenses. NOI is pre-debt service by definition. Including debt service below the NOI line is how DSCR is calculated โ€” it is not part of NOI construction.

The most common errors in NOI construction: understating vacancy, excluding management fees (even when the owner self-manages), understating reserves for replacement, and including below-market rents from related-party leases without normalizing to market.

Cap Rate Valuation

The cap rate (capitalization rate) is used to convert stabilized NOI into an estimated property value. Value = NOI รท Cap Rate. A property with $100,000 of stabilized NOI in a market with prevailing cap rates of 6.5% implies a value of approximately $1,538,000.

The cap rate should come from market evidence โ€” comparable sales of similar properties in the same submarket. Using a cap rate that is too low (aggressive) overstates value; too high (conservative) understates it. The appraisal will establish the market cap rate, but the analyst should have a view going in. If the borrower's asking price implies a cap rate significantly below prevailing market rates, that's a valuation risk that needs to be surfaced before ordering the appraisal.

Debt Yield โ€” The Ratio That Matters Most to Sophisticated Lenders

Debt yield is NOI divided by the loan amount โ€” expressed as a percentage. A $100,000 NOI with a $1,200,000 loan produces a debt yield of 8.33%. This ratio is independent of the cap rate and the interest rate โ€” it measures the property's inherent cash-on-cash return to the lender if they had to foreclose and hold the asset.

Debt Yield
Debt Yield = NOI รท Loan Amount Example: $95,000 NOI รท $1,100,000 loan = 8.64% Minimum thresholds: typically 8โ€“10% depending on property type and lender Below 8%: Property is overleveraged relative to its income

Sophisticated institutional lenders often use debt yield as a primary underwriting constraint rather than LTV. Why? Because LTV depends on the appraisal, which depends on the cap rate, which fluctuates with market conditions. Debt yield is a direct measure of the property's income relative to the loan โ€” it doesn't depend on any appraisal assumption.

Rent Roll Analysis

The rent roll is the document that lists every tenant, their leased space, their contract rent, and their lease expiration date. Analyzing the rent roll is how you evaluate whether the income on which you're underwriting is real, durable, and creditworthy.

For each tenant, evaluate: how much of the total income do they represent? What is the creditworthiness of the tenant (national credit tenant vs. local small business vs. unknown)? When does their lease expire? What is the likelihood of renewal? Is the contract rent at, above, or below current market?

Concentration risk is the central concern in rent roll analysis. A property where 80% of income comes from one tenant is a very different risk profile from a property with 20 tenants where no single tenant exceeds 8% of income. The former is a credit bet on one tenant's continued occupancy. The latter is a diversified income stream that can withstand individual tenant losses.

Lease Roll-Off Risk

Lease roll-off โ€” leases expiring in the near term โ€” is where investment property underwriting gets forward-looking. A property that looks fully stabilized today may have 40% of its leases expiring in the next 18 months. That's a property whose income is at risk even if everything looks fine right now.

Analyze the lease expiration schedule by year. When do significant leases expire? What is the current market rent relative to the expiring contract rent? If market rent has declined since those leases were signed, renewal may require a rate reduction โ€” which reduces NOI and potentially triggers covenant violations.

The anchor tenant analysis is especially critical for retail and office properties. When a national credit tenant is the property's anchor โ€” the reason other tenants chose the location โ€” their lease expiration date is arguably the most important date in the loan file. An anchor non-renewal can trigger co-tenancy clauses in other leases, creating cascading vacancies.

Vacancy and Credit Loss

Use market vacancy rates, not the property's historical occupancy. A property that has been 98% occupied for five years under exceptional management is not necessarily a 98% occupancy property for underwriting purposes โ€” it's a property in a market with a specific vacancy rate, and the underwriting should reflect the market, not the manager's best-ever performance.

Credit loss (bad debt) is separate from physical vacancy. Budget 1-3% of gross potential income for credit loss on most multi-tenant properties. Higher for properties with weaker tenant quality.

Stress Testing the Investment Property Analysis

Standard practice is to stress the underwriting at a higher vacancy rate and a higher cap rate than the base case to understand the downside. How does DSCR perform at 15% vacancy vs. your underwritten 5%? What does the property value at a 100 basis point higher cap rate? These sensitivity analyses belong in the credit memo โ€” not to show the deal fails under stress, but to show the analyst has modeled the downside and the bank has acceptable exposure even in a deteriorated scenario.

Use the Borrowing Base tool for rent roll analysis

The BankLiterate Borrowing Base Calculator can model eligible rental income as a collateral base โ€” useful for quickly structuring investment property line availability.

Open Borrowing Base Tool โ†’