What happens when a commercial real estate loan matures—but the property cannot support the same loan amount anymore? That difference is called the refinance gap.

This article explains what Occupancy Cost Ratio (OCR) is, how it is calculated from rent and sales, and how landlords and tenants in retail properties use OCR benchmarks to price leases, assess risk, and make hold/close decisions.

This article walks through why a borrower might want to prepay a commercial real estate (CRE) loan, how a yield maintenance clause changes the math for both borrower and lender, and the economic logic behind it using the attached model.

This article demystifies net leases in U.S. commercial real estate. It explains how real estate taxes (RET), insurance, and CAM are reimbursed under single, double, and triple net leases, and shows—using a sample Excel model—how each structure affects a landlord’s NOI and risk. It also highlights why tenants agree to NNN leases, along with the key benefits and risks they face.

IFERROR helps clean up CRE variance models by replacing error codes with clear outputs like “N/A”, “Check”, “New Line Item”, or 0. It keeps variance and variance‑percentage columns readable even when prior‑year values are zero or inputs are missing, improving how underwriters interpret performance. But because IFERROR wraps all error types into one result, it must be used carefully so real formula or data issues are not silently hidden.

Net Effective Rent (NER) reveals the true average rent per square foot per year after factoring in free rent, TI allowances, commissions, and expense recoveries. Using discounted cash flows and PMT, NER turns complex lease structures into a single comparable number, helping landlords and tenants make apples‑to‑apples decisions across different spaces, terms, and markets.

Automate end-of-month dates in Excel using the EOMONTH function, a must-have for commercial real estate models. It dynamically builds annual and monthly timelines from a single Analysis Date, correctly handling varying month lengths and leap years so your cash flows, debt schedules, and investor reports stay accurate even when project timing shifts.

Technical guide to how lenders size CRE loans using LTV, DSCR, debt yield and mortgage constants, illustrated through a full Excel-based case study. The article walks step-by-step from NOI and value to constrained loan amount, shows how each metric produces a different max loan, identifies the binding constraint, and then recomputes all credit metrics at a custom, business‑plan‑driven loan amount.

Breakeven occupancy is the minimum occupancy at which a multifamily property’s income covers operating expenses and debt service, with zero cash flow after debt. This article explains why it is a core downside‑risk metric, how it complements DSCR and LTV, who relies on it (lenders, equity, asset managers), and shows a simple formula and numerical case study so investors can plug it directly into their Excel underwriting.

Equity waterfalls use a consistent set of terms to describe how cash flows are split between investors and the sponsor; understanding these is essential before you model or negotiate any CRE deal.

This article explores a practical lesson from attempting to build a financial model using AI. While AI tools can accelerate financial modeling and create impressive structures, they still rely heavily on the clarity and completeness of user instructions. The piece draws parallels with onboarding junior analysts, highlights where AI adds value (formatting, structure), where it falls short (judgment, assumptions), and why domain expertise remains critical—especially in complex

Equity waterfalls define how commercial real estate cash flows are split between investors (LPs) and sponsors (GPs). This article explains what a waterfall is, why it is needed, and how it protects both sides through priority tiers and performance‑based promotes. Using a 10‑year case study with an accompanying Excel model, it walks through key assumptions, tier mechanics, and IRR outcomes, and highlights how deal terms are highly negotiable and where modeling errors commonly

AI can now build clean, institutional-quality multifamily underwriting models in minutes—complete with dashboards, metrics, and largely accurate math. But the real challenge begins with iteration. This article explores where AI excels (speed, structure, coverage) and where it breaks (refinement, debugging, nuanced logic), highlighting why domain expertise remains essential and why AI is best used as a starting point—not a replacement.

Lenders scrutinize multifamily properties through 12 key documents to verify durable income, complete expenses, and minimal risks. From rent rolls and T-12 statements to appraisals, PCAs, zoning reports, and sponsor financials, this guide details what each provides, how it's used in underwriting, and real US examples like Phoenix tax resets or Houston ownership transitions. Essential reading for CRE pros navigating agency loans.

Back-of-the-envelope underwriting can turn limited listing data into a decision-ready view on a real multifamily deal. Using XYZ Grove Apartments, this case study shows how market rents, simple expense ratios and standard debt terms can estimate IRR and equity multiple, assess DSCR, debt yield and breakeven occupancy, and run quick cap rate and interest-rate sensitivities before full underwriting.

This article explains that Argus modeling in commercial real estate is far more than data entry. It highlights the importance of understanding lease structures, stacking plans, expense recoveries, and operating expenses before building a model. Using U.S. market examples, it shows how detailed pre-model analysis and market-based leasing assumptions are essential to creating accurate cash flow projections and reliable property valuations.

This article explains why operating statement normalization is essential in CRE underwriting. It shows how inconsistent reporting, misclassified expenses, and ownership changes can distort NOI and return analysis. It also highlights the need to reconcile statements against the rent roll, monthly collections, payroll schedules, manager units, and model units. The core message: accurate underwriting depends on translating raw financials into a consistent, reliable view of prope

Financial models in CRE aren’t just calculations—they’re narratives about how an asset will evolve. Each assumption reflects a strategy, from lease-up to capital spend. Yet in reality, deals are negotiated in the market first, and models are often shaped to justify that price. This article explores how underwriting tells a story—and where that story can diverge from reality.