Key Performance Indicators
Physical Occupancy
93.6%
May: 131 / 140 units
Econ Occ (incl L2L)
75.6%
NRI ÷ GPR · RR Summary May S11
Econ Occ (excl L2L)
94.3%
NRI ÷ (GPR − L2L) · RR Summary May S12
Avg In-Place Rent
$956
T-1 (May)
NOI (Ann.)
$911.6K
T-1 (May)
NOI Margin
56.1%
T-1 (May)
DSCR
1.24×
T-1 (May)
Implied Value / Unit
$100.2K
@ 6.5% cap, T-1
Reading the two Econ Occ figures: "Incl L2L" measures cash collected against full UW market potential — penalizes for vacancy + loss-to-lease + bad debt + concessions. "Excl L2L" measures cash collected against scheduled in-place rent — penalizes only for collection issues. The gap (98.9% vs. 74.1%) reflects the loss-to-lease drag against new UW market rents — current in-place rents sit ~31% below UW market potential.
Net Cash Flow (Ann.)
$173.8K
Workbook KPI N16 (May NCF × 12)
Occupancy & Rent
Physical Occupancy Monthly Trend
Feb–May 2026
Unit Mix & Rent Analysis
May 2026 in-place vs. market — per-type avgs from Rent Roll Summary E12:E20; TOTAL row from R26 (= KPI N8: D8/D6)
| Unit Type | Units | In-Place | Market (PM-reported) |
UW Market (Chartwell UW) |
Gap to UW |
|---|---|---|---|---|---|
| 2BR - 1BTH | 12 | $852 | — | $1,305 | -34.7% |
| 2BR - 1BTH TH | 36 | $847 | — | $1,305 | -35.1% |
| 2BR - 1BTH TH RR | 4 | $803 | — | $1,305 | -38.4% |
| 2BR - 2BTH | 51 | $996 | — | $1,356 | -26.5% |
| 2BR - 2BTH RR | 5 | $754 | — | $1,356 | -44.4% |
| 2BR - 2BTH Loft | 7 | $1,049 | — | $1,356 | -22.7% |
| 2BR - 2BTH Loft RR | 1 | $1,275 | — | $1,356 | -6.0% |
| 3BR - 2BTH | 12 | $1,009 | — | $1,450 | -30.4% |
| 4BR - 2BTH | 12 | $1,059 | — | $1,550 | -31.7% |
| TOTAL | 140 | $956 | — | $1,362 | -30.6% |
Financial Performance
Monthly Revenue vs Expenses vs NOI
Feb–May 2026, stacked revenue/expenses + NOI line
Expense Breakdown
T-1 (May 2026) — sourced from workbook Expense Trends tab M6:M15
| Category | Amount | % of OpEx |
|---|---|---|
| Property Management | $9,405 | 15.6% |
| Payroll & Benefits | $10,019 | 16.6% |
| R&M (incl Turnover) | $2,128 | 3.5% |
| Utilities (Elec+Water+Gas) | $9,766 | 16.2% |
| Insurance | $7,254 | 12.0% |
| Property Taxes | $11,534 | 19.1% |
| Marketing | $1,850 | 3.1% |
| G&A (Admin+Legal) | $2,825 | 4.7% |
| Contract Services (incl Landscaping) | $5,510 | 9.1% |
| Other Expenses | $0 | 0.0% |
| Total Operating Expenses | $59,412 | 100.0% |
Monthly Income Statement (T-1: May 2026)
4-Month P&L Summary
Feb–May 2026 actuals — Footer summary pulls from workbook KPIs tab May column (N10/N15/N16/N17/N19)
| Line Item | Feb | Mar | Apr (T-2) | May (T-1) | Total |
|---|
Debt & Returns
DSCR Monthly Trend
With 1.20x floor target
Capital Stack
Annual Debt Svc
$714K/yr
NOI (Annualized)
$957K
CapEx Budget (Total Program)
$1,008K
Net Cash Flow (Annualized)
+$243K
Loan Balance
$9.52M
Loan-to-Cost
65.6%
Int. Rate
7.50%
Equity
$5.00M
Valuation Sensitivity
NOI delta × Cap rate (Base = May NOI Ann $911.6K, MF V48 × 12)
| NOI Δ | 5.0% | 5.5% | 6.0% | 6.5% | 7.0% | 7.5% | 8.0% |
|---|---|---|---|---|---|---|---|
| -15% | $16.3M | $14.8M | $13.6M | $12.5M | $11.6M | $10.8M | $10.2M |
| –10% | $17.2M | $15.7M | $14.4M | $13.2M | $12.3M | $11.5M | $10.8M |
| –5% | $18.2M | $16.5M | $15.1M | $14.0M | $13.0M | $12.1M | $11.4M |
| Base | $19.1M | $17.4M | $15.9M | $14.7M | $13.7M | $12.8M | $12.0M |
| +5% | $20.1M | $18.3M | $16.7M | $15.5M | $14.4M | $13.4M | $12.6M |
| +10% | $21.0M | $19.1M | $17.5M | $16.2M | $15.0M | $14.0M | $13.2M |
| +15% | $22.0M | $20.0M | $18.3M | $16.9M | $15.7M | $14.7M | $13.8M |
Cash Flow Sensitivity
Annual NCF at varying rent growth × expense growth
| Rent ↓ / Exp → | -5% | -2.5% | Base | +2.5% | +5% |
|---|
DSCR Sensitivity
At varying NOI levels vs. current debt service
| NOI Δ | DSCR | Annual DS | Surplus / (Gap) | Status |
|---|---|---|---|---|
| -15% | 1.14× | $714K | $99K | Tight |
| -10% | 1.21× | $714K | $147K | Adequate |
| -5% | 1.27× | $714K | $195K | Adequate |
| Base (Workbook KPI N15) | 1.24× | $714K | $243K | Good |
| +5% | 1.41× | $714K | $290K | Good |
| +10% | 1.47× | $714K | $338K | Strong |
| +15% | 1.54× | $714K | $386K | Strong |
Leasing & Collections
In-Place vs Market Rent by Unit Type
May 2026, grouped by bedroom count
Collections & Delinquency
Econ Occ (vs UW Mkt)
74.1%
NRI ÷ Market Rent (Mar)
Collection Rate
94.3%
NRI ÷ (GPR−L2L) (May)
Bad Debt (May)
$712
AR Records
78
May 31
| AR Aging (May 31) | Records | Balance |
|---|---|---|
| 0–30 days | 77 | $-72,183 |
| 31–60 days | 1 | $-1,970 |
| 61–90 days | 0 | $0 |
| 91+ days | 0 | $0 |
| Total | 78 | $-74,153 |
Negative balances = tenant credits / prepayments. Strong collections — $74K of credit balances across 78 tenants, zero positive 31–60+ delinquency.
Cash Returns & Asset Valuation
Monthly Net Cash Flow + YTD Cumulative
Bar chart + cumulative line (dual Y-axis)
Note: NCF includes CapEx (NOI − Debt Service − CapEx). May CapEx of $22K continues renovation reserve draws; May NCF is -$7K (vs Apr -$84K). See Net Cash Flow Ex-CapEx row in the 4-Month P&L table for operating cash flow excluding CapEx.
Implied Property Value Monthly
6.5% cap rate, with stabilized target
Year-over-Year Snapshot
Year-over-Year Snapshot
YTD comparison — Chartwell acquired Feb 2026, no prior-year data
| Metric | Proforma | YTD Actual | Variance | Var % |
|---|---|---|---|---|
|
Property acquired Feb 2026 (3 months of ownership data). YoY snapshot will populate once Feb 2027 data arrives. | ||||
Commentary
Strengths
NOI beating budget by +20.2% in May — $75,965 actual (BS AI48) vs $63,207 budget (BS AH48); OpEx 22.1% under budget is the main driver
93.6% physical occupancy (May; 131/140 — 8 vacant apartments, all renovated (RR) units + leasing office at Fuller 1400) — 6 net new vacancies opened for spot-market pricing at current pricing
Strong collections — net $74K credit balance across 78 tenants (prepaid rent), zero 31-60+ aging
Concerns
$938 avg in-place rent sits 31% below $1,362 UW market — large loss-to-lease gap (~$59K/mo, ~$713K/yr at UW basis)
DSCR at 1.24× (T-1 May) — cushion building above lender covenants; only 3 months of actuals (Mar–May) so T-3 reflects the same period
Budget anchored to Year 1 ramp ($812K annual Adjusted NOI) — Year 2 UW stabilized target is materially higher at $1.11M NOI / $17.1M value
Next Steps
Push renewal pricing toward UW market on 2BR-1BTH TH ($821→$1,000+) and 2BR-2BTH ($990→$1,150+) — closing UW gap drives $713K/yr NOI uplift
Execute renovation plan — 138 units remaining in $893K program; 2 completed at +$380–$450/mo rent lift vs prior
Once May–Jul actuals arrive, refresh T-3 budget variance to confirm the +15.6% NOI beat trend holds