Key Performance Indicators
Physical Occupancy
95.7%
Jun: 134 / 140 units
Econ Occ (incl L2L)
77.4%
NRI ÷ GPR · RR Summary Jun S11
Econ Occ (excl L2L)
94.4%
NRI ÷ (GPR − L2L) · RR Summary Jun S12
Avg In-Place Rent
$1,006
T-1 (Jun)
NOI (Ann.)
$1.02M
T-1 (Jun)
NOI Margin
56.1%
T-1 (Jun)
DSCR
1.43×
T-1 (Jun)
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 (94.4% vs. 77.4%) 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.)
-$825.7K
MF V56 × 12 (Jun annualized)
Occupancy & Rent
Physical Occupancy Monthly Trend
Feb–Jun 2026
Unit Mix & Rent Analysis
Jun 2026 in-place vs. market — per-type avgs from Rent Roll Summary E12:E22; TOTAL row from R24 (= KPI N8: D8/D6)
| Unit Type | Units | In-Place | Market (PM-reported) |
UW Market (Chartwell UW) |
Gap to UW |
|---|---|---|---|---|---|
| 2BR - 1BTH | 12 | $948 | — | $1,305 | -27.4% |
| 2BR - 1BTH TH | 32 | $864 | — | $1,305 | -33.8% |
| 2BR - 1BTH TH PR | 3 | $930 | — | $1,305 | -28.7% |
| 2BR - 1BTH TH RR | 5 | $785 | — | $1,305 | -39.8% |
| 2BR - 2BTH | 49 | $1,045 | — | $1,356 | -22.9% |
| 2BR - 2BTH RR | 7 | $1,238 | — | $1,356 | -8.7% |
| 2BR - 2BTH Loft | 6 | $1,148 | — | $1,356 | -15.3% |
| 2BR - 2BTH Loft RR | 2 | $1,153 | — | $1,356 | -15.0% |
| 3BR - 2BTH | 10 | $1,015 | — | $1,450 | -30.1% |
| 3BR - 2BTH RR | 2 | $980 | — | $1,450 | -32.4% |
| 4BR - 2BTH | 10 | $1,101 | — | $1,550 | -29.0% |
| 4BR - 2BTH RR | 2 | $1,068 | — | $1,550 | -31.1% |
| TOTAL | 140 | $1,006 | — | $1,362 | -30.6% |
Financial Performance
Monthly Revenue vs Expenses vs NOI
Feb–Jun 2026, stacked revenue/expenses + NOI line
Expense Breakdown
T-1 (Jun 2026) — sourced from workbook Monthly Financials V col
| Category | Amount | % of OpEx |
|---|---|---|
| Property Management | $9,240 | 15.9% |
| Payroll & Benefits | $12,248 | 21.1% |
| R&M (incl Turnover) | $270 | 0.5% |
| Utilities (Elec+Water+Gas) | $6,643 | 11.5% |
| Insurance | $8,373 | 14.5% |
| Property Taxes | $11,534 | 19.9% |
| Marketing | $1,745 | 3.0% |
| G&A (Admin+Legal) | $2,378 | 4.1% |
| Contract Services (incl Landscaping) | $5,510 | 9.5% |
| Other Expenses | $0 | 0.0% |
| Total Operating Expenses | $57,941 | 100.0% |
Monthly Income Statement (T-1: Jun 2026)
5-Month P&L Summary
Feb–Jun 2026 actuals — Footer summary pulls from Jun T-1 annualized (MF V48/V56 × 12)
| Line Item | Feb | Mar | Apr | May (T-2) | Jun (T-1) | Total |
|---|
Debt & Returns
DSCR Monthly Trend
With 1.20x floor target
Capital Stack
Annual Debt Svc
$714K/yr
NOI (Annualized)
$1,024K
CapEx Budget (Total Program)
$1,008K
Net Cash Flow (Annualized)
-$826K
Loan Balance
$9.52M
Loan-to-Cost
65.6%
Int. Rate
7.50%
Equity
$5.00M
Valuation Sensitivity
NOI delta × Cap rate (Base = Jun NOI Ann $1.02M, MF V48 × 12)
| NOI Δ | 5.0% | 5.5% | 6.0% | 6.5% | 7.0% | 7.5% | 8.0% |
|---|---|---|---|---|---|---|---|
| -15% | $17.4M | $15.8M | $14.5M | $13.4M | $12.4M | $11.6M | $10.9M |
| –10% | $18.4M | $16.8M | $15.4M | $14.2M | $13.2M | $12.3M | $11.5M |
| –5% | $19.5M | $17.7M | $16.2M | $15.0M | $13.9M | $13.0M | $12.2M |
| Base | $20.5M | $18.6M | $17.1M | $15.8M | $14.6M | $13.7M | $12.8M |
| +5% | $21.5M | $19.5M | $17.9M | $16.5M | $15.4M | $14.3M | $13.4M |
| +10% | $22.5M | $20.5M | $18.8M | $17.3M | $16.1M | $15.0M | $14.1M |
| +15% | $23.5M | $21.4M | $19.6M | $18.1M | $16.8M | $15.7M | $14.7M |
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.22× | $714K | $156K | Adequate |
| -10% | 1.29× | $714K | $207K | Adequate |
| -5% | 1.36× | $714K | $258K | Good |
| Base (Workbook KPI N15) | 1.43× | $714K | $310K | Good |
| +5% | 1.51× | $714K | $361K | Strong |
| +10% | 1.58× | $714K | $412K | Strong |
| +15% | 1.65× | $714K | $463K | Strong |
Leasing & Collections
In-Place vs Market Rent by Unit Type
Jun 2026, grouped by bedroom count
Collections & Delinquency
Econ Occ (vs UW Mkt)
74.1%
NRI ÷ Market Rent (Jun)
Collection Rate
94.4%
NRI ÷ (GPR−L2L) (Jun)
Bad Debt (Jun)
$671
AR Records
67
Jun 30
| AR Aging (Jun 30) | Records | Balance |
|---|---|---|
| 0–30 days | 63 | $-57,996 |
| 31–60 days | 4 | $-203 |
| 61–90 days | 1 | $-9,030 |
| 91+ days | 4 | $-70 |
| Total | 67 | $-67,299 |
Negative balances = tenant credits / prepayments. Strong collections — $67K of credit balances across 67 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). Jun CapEx of $94.6K resumes heavy renovation reserve draws (vs May $22K); Jun NCF is -$68.8K (vs May -$7K). See Net Cash Flow Ex-CapEx row in the 5-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 (5 months of ownership data). YoY snapshot will populate once Feb 2027 data arrives. | ||||
Commentary
Strengths
NOI beating budget by +31.3% in Jun — $85,317 actual (BS AL48) vs $64,959 budget (BS AK48); OpEx 24.3% under budget is the main driver
95.7% physical occupancy (Jun; 134/140 — 5 vacant apartments (Fuller 1281/1340/1345/1403 + Wind 1543) + leasing office at Fuller 1400) — 3 net leases (Kent 1472, Wind 1473, Wind 1550) executed in June at current pricing
Strong collections — net $67K credit balance across 67 tenants (prepaid rent), zero 31-60+ aging
Concerns
$1,006 avg in-place rent sits 26% below $1,362 UW market — large loss-to-lease gap (~$50K/mo, ~$598K/yr at UW basis)
DSCR at 1.43× (T-1 Jun) — cushion building above lender covenants; now 5 months of actuals (Feb–Jun); T-3 reflects Apr–Jun 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
T-3 budget variance (Apr–Jun) confirms +25.6% avg NOI beat holding — Rushmore executing on OpEx side