Key Performance Indicators
Physical Occupancy
97.9%
T-1 (Apr)
Econ Occ (incl L2L)
68.0%
NRI ÷ UW Mkt · T-1 (Apr)
Econ Occ (excl L2L)
97.0%
NRI ÷ (GPR − L2L) · T-1 (Apr)
Avg In-Place Rent
$946
T-1 (Apr)
NOI (Ann.)
$956.8K
T-1 (Apr)
NOI Margin
56.9%
T-1 (Apr)
DSCR
1.34×
T-1 (Apr)
Implied Value / Unit
$105.1K
@ 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. 68.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.)
$242.8K
Workbook KPI N16 (Apr NCF × 12)
Occupancy & Rent
Physical Occupancy Monthly Trend
Feb–Apr 2026
Unit Mix & Rent Analysis
Apr 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 | $946 | — | $1,362 | -30.6% |
Financial Performance
Monthly Revenue vs Expenses vs NOI
Feb–Apr 2026, stacked revenue/expenses + NOI line
Expense Breakdown
T-1 (Apr 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 | $60,291 | 100.0% |
Monthly Income Statement (T-1: Apr 2026)
10-Month P&L Summary
Feb–Apr 2026 actuals — Footer summary pulls from workbook KPIs tab Apr column (N10/N15/N16/N17/N19)
| Line Item | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar (T-2) | Apr (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 = Workbook KPI N10 Apr NOI Ann $956.8K)
| 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.34× | $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
Apr 2026, grouped by bedroom count
Collections & Delinquency
Econ Occ (vs UW Mkt)
68.1%
NRI ÷ Market Rent (Mar)
Collection Rate
99.0%
NRI ÷ Scheduled (Apr)
Bad Debt (Apr)
$1,336
AR Records
78
Apr 30
| AR Aging (Mar 31 — Apr Aged Receivables not delivered by PM) | 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). Apr CapEx of $104K from one-time renovation reserve draws is the primary driver of the negative monthly result. See Net Cash Flow Ex-CapEx row in the 10-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 +15.6% in Apr — $71,065 actual (BS AF48) vs $61,464 budget (BS AE48); OpEx 9.2% under budget is the main driver
97.9% physical occupancy (Apr; 137/140 — 2 vacant apartments + leasing office at Fuller 1400) — strong demand 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.34× (T-1 Apr) — cushion building above lender covenants; only 3 months of actuals (Feb–Apr) 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