top of page
All Posts


How Low Can Occupancy Go Before You Start Losing Money?
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.
Himanshu Nassa
2 days ago5 min read


Equity Waterfall Jargon
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.
Himanshu Nassa
4 days ago6 min read


I tried building an Equity Waterfall model using AI recently and failed at it
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
Himanshu Nassa
6 days ago3 min read


The Math Behind CRE Deals: How Equity Waterfalls Protect Investors and Reward Sponsors
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
Himanshu Nassa
Jun 76 min read


I Let AI Build My Underwriting Model - Here’s What Happened
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.
Himanshu Nassa
May 143 min read


The 12 Documents That Can Make or Break a Multifamily Loan
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.
Himanshu Nassa
May 1311 min read


From Broker Flyer to Buy Box: A Back-of-the-Envelope Multifamily Case Study
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.
Himanshu Nassa
May 125 min read


What Nobody Tells You About Building Accurate Argus Models
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.
Himanshu Nassa
May 114 min read


Why Normalizing Operating Statements Is Critical in CRE Underwriting
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
Himanshu Nassa
May 76 min read


Financial Models Don’t Calculate Value — They Narrate It
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.
Himanshu Nassa
Apr 294 min read


Rent Roll Analysis in CRE Underwriting: Breaking Down the Foundation of Cash Flow
The rent roll is more than a list of tenants—it’s the foundation of CRE underwriting. This article breaks down how to analyze tenant concentration, lease terms, and expense recoveries, while highlighting common data issues that can distort assumptions. A structured approach to rent roll analysis helps uncover risks early and build more reliable underwriting.
Himanshu Nassa
Apr 275 min read
bottom of page