Project Sentinel CRE
Multifamily deal analysis & conservative underwriting terminal
No deal analyzed yet
Enter deal details below and click Analyze to generate audited metrics.
Deal Intake
T-12s, rent rolls and OMs — PDF, Excel, CSV or pasted text.
Drop financials here or click to upload
.pdf · .xlsx · .xls · .csv · .txt
$0 / unit
Please verify monthly collected rent before analyzing.
Revenue & deductions (annual)
Operating expenses (annual)
Debt terms (LTV, rate, amortization) and exit assumptions live in the Buy Box below and stay fully editable.
Enter a unit count, asking price and current monthly collected rent to run the audit.
Buy Box & Sensitivity Controls
Every figure below recalculates instantly — deterministic math, no round trips.
Year-one cash distributions ÷ equity in. Most syndicators promise 6–8%; above 10% usually means distressed pricing or heavy leverage.
Annualized return including sale proceeds. 13–16% is the institutional band for stabilized multifamily; 18%+ implies real value-add risk.
Your quoted rate. Every 50 bps moves the strike price by roughly 3–5% — quote this before you offer, don't guess.
Debt as a share of price. Agency tops out near 75%, but proceeds are usually capped by DSCR or debt yield well before that.
NOI ÷ debt service. Lenders require 1.25x on agency debt; below that the loan doesn't size and you fund the gap with equity.
Minimum insurance charged regardless of the seller's number. $900–1,200 in the Midwest; $1,800+ on the Gulf Coast.
Advanced debt & exit assumptions(exit cap spread, interest-only, amortization)
Basis points added to the going-in cap at sale. Underwriting a flat or tighter exit is how pro formas flatter themselves.
Years before principal starts amortizing. IO lifts early cash-on-cash by 150–250 bps and masks a thin deal.
Schedule used to size the payment. 30 years is standard agency; a 25-year schedule raises debt service and lowers the strike.