Aqueduct Capital
Chartwell
1400 Fuller Court, Lancaster, OH 43130 · 140 units · 139,344 SF · Built 2001
Owner/Sponsor: Lion Citi Ventures (Shloime Plutchok) · Acquired Feb 2026 · PM: Rushmore Management
Reporting: Feb–May 2026
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)
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 - 1BTH12$852$1,305-34.7%
2BR - 1BTH TH36$847$1,305-35.1%
2BR - 1BTH TH RR4$803$1,305-38.4%
2BR - 2BTH51$996$1,356-26.5%
2BR - 2BTH RR5$754$1,356-44.4%
2BR - 2BTH Loft7$1,049$1,356-22.7%
2BR - 2BTH Loft RR1$1,275$1,356-6.0%
3BR - 2BTH12$1,009$1,450-30.4%
4BR - 2BTH12$1,059$1,550-31.7%
TOTAL140$956$1,362-30.6%
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,40515.6%
Payroll & Benefits$10,01916.6%
R&M (incl Turnover)$2,1283.5%
Utilities (Elec+Water+Gas)$9,76616.2%
Insurance$7,25412.0%
Property Taxes$11,53419.1%
Marketing$1,8503.1%
G&A (Admin+Legal)$2,8254.7%
Contract Services (incl Landscaping)$5,5109.1%
Other Expenses$00.0%
Total Operating Expenses$59,412100.0%
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
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$99KTight
-10%1.21×$714K$147KAdequate
-5%1.27×$714K$195KAdequate
Base (Workbook KPI N15)1.24×$714K$243KGood
+5%1.41×$714K$290KGood
+10%1.47×$714K$338KStrong
+15%1.54×$714K$386KStrong
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 days77$-72,183
31–60 days1$-1,970
61–90 days0$0
91+ days0$0
Total78$-74,153
Negative balances = tenant credits / prepayments. Strong collections — $74K of credit balances across 78 tenants, zero positive 31–60+ delinquency.
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
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.
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
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
Expense Categories
📊
Select an expense category to view details
What's Working
Property Tax & Insurance escrowed — predictable monthly accrual ($11.5K tax + $7.3K insurance — Apr and May ran same)
Mgmt Fee at 3.07% of EGI — competitive vs. typical 4-5% for similar-size properties
Watch Items
Water/Sewer $8,876 Mar → $10,251 Apr → $6,510 May — May reversion to more normal range after Mar/Apr spike; monitor next 2 months
R&M normalized ($278 Mar → $817 Apr → $230 May) — settled to sub-$300/mo run rate
Insurance $7,254/mo — equates to ~$622/unit/year, on the high end for Ohio multifamily
Compare Mar–May water/sewer trend; May $6.5K back closer to normal; consider RUBS program
Continue monthly tracking — operating budget loaded ($72.8K/mo OpEx Feb→$75.3K Jan'27); actuals tracking ~22% under in May ($59.4K vs $76.3K budget)
Insurance shop at next renewal — benchmark vs. similar Ohio assets
Expense Efficiency Metrics
YTD annualized operating benchmarks
Total OpEx / Unit (Ann.)
$4,765
OpEx / SF (Ann.)
$4.79
Expense Ratio
43.9%
T-3 Mar–May OpEx ÷ EGI
Controllable Exp %
43.3%
Payroll+Mgmt+R&M+Mktg
Chartwell Phys. Occ
93.6%
May 2026 (per RR Summary)
Chartwell Avg Rent
$956
Range: $821–$1,105
Lancaster 2BR Comp Avg
$1,360
5 active comps (Apartments.com)
Cap Rate (Workbook)
6.5%
Per Assumptions tab B22
Chartwell vs Comp Avg
-31%
Portfolio avg vs $1,360 2BR comp
Chartwell Avg Rent
$956
May 2026 in-place across all units
2BR Comp Avg
$1,360
5 active Lancaster comps
Comp Set Size
5 props
36–132 units, 1970–2024
In-Place Rent vs. Market Benchmarks by Unit Type
Chartwell in-place vs. comp set avg by bedroom
Positioning Summary
Chartwell vs. comp averages
Unit Type Chartwell In-Place Comp Avg Spread Gap to Close
2BR - 1BTH$828$1,360-39.2%$532/mo
2BR - 1BTH TH$821$1,360-39.6%$539/mo
2BR - 1BTH TH RR$830$1,360-39.0%$530/mo
2BR - 2BTH$990$1,360-27.2%$370/mo
2BR - 2BTH RR$1,000$1,360-26.5%$360/mo
2BR - 2BTH Loft$1,049$1,360-22.9%$311/mo
2BR - 2BTH Loft RR$1,105$1,360-18.8%$255/mo
3BR - 2BTH$986No 3BR comp data
4BR - 2BTH$1,059No 4BR comp data
2BR Portfolio Wtd Avg$920$1,360-32.4%$440/mo
Comp Properties — Lancaster, OH 43130
Nearby multifamily comps, market rent survey data
Property City Units Vintage 2BR Rent 2BR SF
Chartwell (Subject)Lancaster, OH1402001$990*932
Lodge at River VillageLancaster, OH1101980$1,295900
Courtship Village TownhomesLancaster, OH1321979$1,299700
Concord Manor ApartmentsLancaster, OH361970$1,100700
Lancaster MidtownLancaster, OH2024$1,4051,100
Lancaster Ridge (The Residences)Lancaster, OH1112017$1,7001,175
Comp Average$1,360915
* Chartwell 2BR-2BTH avg in-place rent. Chartwell has no 1BR units (only 2BR/3BR/4BR). Comp rents are "starting at" rates from Apartments.com listings as of 2026-05-05.
Community Amenities — Chartwell vs. Comp Set
Sources: Apartments.com listings May 2026 · Chartwell: 4 amenities | Comp range: 2–7
Community Amenity Chartwell Lodge at River Village Courtship Village Concord Manor Lancaster Midtown Lancaster Ridge
PoolYesYesYesYesYes
Fitness CenterYesYesYes
Business CenterYes
ClubhouseYesYesYes
Dog ParkYes
PlaygroundYesYesYes
EV ChargingYes
Package LockersYes
Covered ParkingYes
GaragesYesYes
Storage UnitsYes
Pet-FriendlyYesYesYesYesYes
Valet TrashYes
TOTAL4520125
Chartwell amenity gaps vs. premium comps (Lancaster Midtown, Lancaster Ridge): Pool, Fitness Center, Clubhouse, Business Center — potential value-add targets.
Unit-Level Amenities — Chartwell vs. Comp Set
Chartwell: 7 unit amenities | Comp range: 2–9
Unit Amenity Chartwell Lodge at River Village Courtship Village Concord Manor Lancaster Midtown Lancaster Ridge
In-Unit W/DYesYesYes
W/D HookupsYesYes
Air ConditioningYesYesYesYesYesYes
DishwasherYesYesYes
Stainless AppliancesYesYesYes
Granite CountersYes
Walk-In ClosetsYesYesYesYesYes
Patio/BalconyYesYesYesYes
Cable ReadyYesYesYesYesYesYes
Hardwood/LVP FloorsYesYesYes
TOTAL665496
Move-In & Recurring Fee Survey
Awaiting fee data
Amenity Sources (verified May 2026):
• Chartwell: Apartments.com — confirmed: on-site laundry, covered parking, dog park, pet-friendly, A/C, dishwasher, walk-in closets, patio
• Lodge at River Village: Apartments.com
• Courtship Village Townhomes: Apartments.com
• Concord Manor Apartments: Apartments.com
• Lancaster Midtown: Apartments.com
• Lancaster Ridge: Apartments.com
Fee Category Chartwell Lodge at River Village Courtship Village Concord Manor Lancaster Midtown Lancaster Ridge
Application Fee$50/applicant$45/applicant$40/applicantContact office$60/applicant$50/applicant
Admin / Leasing Fee$50$100$150$100
Hold / Reservation Fee$99$200 (refundable)$100
Security Deposit$350–$850 (credit)$400–$700 (credit)$5001× rent$500–$1,000 (credit)$300–$600 (credit)
Pet Fee — Dog (one-time)$300$250$300No pets$300$300
Pet Rent (per month)$30$25$25N/A$35$30
Pet Limit / Weight2 / 25 lbs2 / 50 lbs202 / 75 lbs2 / 50 lbs
Storage Rent$50/mo
Valet Trash Fee$25/mo
Renters Insurance$100K GL req.$100K GL req.
Late Fee10% rent (5-day grace)10% rent$50 flat$50 flat10% rent10% rent
NSF / Returned Pmt$35$35$35$35$50$35
Transfer Fee (mid-lease)$500$500$300
Fee data sourced from Apartments.com listings (May 2026). Chartwell column reflects PM-confirmed values; comp columns are best-available public data.
Strengths
93.6% physical occupancy (May) — 131 of 139 rentable apartments occupied; 8 apartments vacant, all RR (renovated): Fuller 1281/1340/1345/1403 + Kent 1472 + Wind 1473/1543/1550. Fuller 1400 is the leasing office
Covered parking — only Lancaster Ridge offers this among comps
Pet-friendly with on-site dog park — matches premium comps
Gaps
2BR rents (~$990) at ~27% discount to comp average ($1,360) — significant LTL
No pool, fitness center, clubhouse — gap vs. Lancaster Midtown ($1,405) and Ridge ($1,700)
PM-recorded Loss-to-Lease ~$33.4K May ($35.2K Apr, $36.8K Mar); UW-basis LtL gap = $59.4K/mo at new $1,362 UW market
Push 2BR-2BTH renewal pricing toward $1,150–$1,250 (interim — UW market $1,356, comp avg $1,360)
Add fitness center + clubhouse — bridge premium-comp amenity gap
Execute reno plan: 140 units in tracker (2 done), $893K total budget; track post-reno rent uplift
Currently Occupied
131
Per Rent Roll Summary - May (v17)
Vacant Apartments
2
8 vacant, all RR: Fuller 1281/1340/1345/1403 + Kent 1472 + Wind 1473/1543/1550
MTM Tenants
8
Derived: count of RR Summary - May rows where Status = Vacant
May Leasing Activity
64
64 leads (R18) · 7 apps (R19) · 4 approvals (R20) · 50% renewal rate (R16)
Leasing Pipeline & Conversions
Source: Leasing Activity tab (Mar–May 2026 actuals)
Month Renewals Move-Ins Move-Outs Net Abs Projected Occ Traffic Apps Approvals Conversion
Mar 202601-198.6%
May 2026268-693.6%64 leads · 7 tours7 apps · 4 approved2 signed · 50% rate
Source: Leasing Activity tab (Mar–May 2026 actuals). May–Jun projections removed (not yet recorded as actuals).
Move-Outs
⚠ Source: PM Dashboard 4/29/26 (not yet in KPI workbook)
UnitDate VacatedPrev Rent
Wind 15503/30/26$985
Ivan 15034/30/26$970
Wind 15434/30/26$1,025
Kent 14725/31/26$1,005
Move-Ins
⚠ Source: PM Dashboard 4/29/26 (not yet in KPI workbook)
UnitMove-In DateNew RentLift vs Prior
Ivan 15035/1/26$1,350+$380
Kent 14726/1/26$1,350+$345
Wind 15506/1/26$1,350+$365
Wind 15436/24/26$1,350+$325
Leasing Funnel
⚠ Source: PM Dashboard 4/29/26 (not yet in KPI workbook)
WeekLeadsToursPendingApprovedSigned
4/10/2691211
4/17/26173100
4/24/26192110
5/1/26191000
4-Week Total64721
Lease Expiration Schedule
Next 12 months (Jun 2026 – May 2027)
New vs Renewal Rents
Awaiting client data
Month Avg New Lease Avg Renewal Variance
New vs. renewal rent comparison requires leasing activity data. Awaiting PM delivery.
Positive Signals
93.6% physical occupancy (May 31; 131 of 140) — 131 Occupied + 8 Vacant (all RR: Fuller 1281/1340/1345/1403 + Kent 1472 + Wind 1473/1543/1550) + 1 Model (Fuller 1400 = leasing office). Vacancy uptick reflects two recent renovation move-outs awaiting re-lease at higher rent.
4 move-outs all re-leased at $1,350 — Ivan 1503 (5/1), Kent 1472 (6/1), Wind 1543/1550 (Jun) — confirms renovated-unit rent ceiling is well above current in-place
Strong collections — net credit balance of $74K (78 prepaid tenants) and zero 31-60 day delinquency
Watch Items
Renovation rent uplift validated — 4 reno-then-vacate units (Ivan 1503, Kent 1472, Wind 1543/1550) all re-leasing at $1,350 vs prior $970–$1,025; avg +$354/mo lift ($4,250/yr per unit)
2BR-1BTH TH segment under-rented — 37 units at ~$821 avg in-place vs $1,305 UW market (–$484/mo gap); largest below-market segment by unit count
Pre-Feb 2026 leasing history not delivered — historical monthly traffic/applications/renewals not in workbook; trailing conversion + renewal rates can't be computed yet
Request from PM: monthly leasing activity (traffic, apps, approvals, move-ins, move-outs, renewals) + 12-month lease expiration schedule
At rollover, push renewals on 2BR-1BTH TH ($821→$1,000+ interim) and 2BR-2BTH RR ($800→$1,100+ interim) — both have material room to UW market ($1,305 / $1,356)
Execute renovation program — 138 units remaining in $893K plan; track per-unit cost + post-reno rent uplift to compute realized ROI
Physical & Economic Occupancy
Feb–May 2026
Average Rent Trajectory
With market comparison
Rent Growth by Unit Type
May 2026 in-place rents (limited history)
Unit Type May 2026 Growth $ Growth %
Multi-month rent growth analysis: 3 months delivered (Feb–May 2026). Avg in-place rent Feb $926 → Mar $938 → Apr $946 → May $956 (+1.3% Feb→Mar, +0.9% Mar→Apr, +1.1% Apr→May). Unit-type-level rent growth requires PM-provided per-type rent series; awaiting May close for trend confirmation.
Reno Program Performance
Units Completed
Total Spend
UW Cost/Unit
$8.7K
UW model reference
Units w/ Post-Reno Rent
2
Per Reno Tracker
Rent Premium Analysis
Avg Premium/Unit
Awaiting reno data
Annual Incremental Rent
Tracker: 140 units, 2 done
Simple ROI
Annual payback
Payback Period
Awaiting reno data
Valuation Impact
Reno Uplift
Awaiting completed reno data
Cost of Reno Program
No reno data delivered
Theoretical Upside
$11.0M
If LTL of $713K/yr closes (UW basis)
Total Reno Budget
$893K
Per Reno Tracker Budget tab
Value-Add Thesis Validated
Rent growth tracking: Feb–May 2026 — Avg in-place: Feb $926 → Mar $938 → Apr $946 → May $956 (+3.2% portfolio-wide over 4 months). Unit-type-level growth pending PM-provided series.
Renovation data tracked — 2 units complete (Fuller 1340 + Ivan 1503, both 4/22/26); see Renovation Insights tab for unit-level detail.
Physical occupancy at 93.6% (May; 131/140) — 8 vacant apartments (all RR: Fuller 1281/1340/1345/1403 + Kent 1472 + Wind 1473/1543/1550, all freshly renovated 4/22/26 awaiting re-lease at higher rent); Fuller 1400 is the leasing office (not rentable). Renovation program (per UW: 140 units · $893K total) is in early phase.
Structural Challenges
Collection rate at 98.9% on scheduled in-place rent — strong tenant performance. Versus new UW market rent, NRI runs at 74.1% (the 25.9 pt gap is loss-to-lease vs higher UW market, not collections).
2BR-1BTH TH at $821 avg is the lowest-rent segment at 39.6% below 2BR comp avg ($1,360). 36 of 37 units are currently occupied; this floor plan represents ~$240K/yr of potential rent uplift if pushed to comp parity.
Renovation in early phase — 140-unit program with $893K total budget ($6.4K/unit avg). 2 units completed (Fuller 1340 + Ivan 1503, both 4/22/26); 138 units remaining. Need PM to deliver ongoing completion log + post-reno rent uplift tracking.
Theoretical upside if rents reach UW market: closing the gap between $938 avg in-place and $1,362 avg UW market would add ~$59.4K/mo (~$713K/yr) to NOI. At 6.5% cap that's ~$11.0M of value uplift, from $14.15M to ~$25.1M. PM-recorded LtL in May GL was -$33.4K (gap from PM's lower market benchmark).
Prioritize 2BR-1BTH TH (37 units, ~$484/mo gap to UW market $1,305 / ~$539/mo to comp avg $1,360) — largest absolute rent lift opportunity per renovation dollar.
Closing the UW-basis ~$713K/yr loss-to-lease ($1,362 UW market vs $938 in-place) through renovation + lease rollovers would lift NOI and economic occupancy materially.
Units in Tracker
140
Per Reno Tracker
Interior Reno Budget
$893K
Per CapEx Tracker R6 (Interior); Total CapEx program: $1,008K
Units Renovated
2
Of 140 tracked
Premium Captured: Actual vs. UW Projection
Premium = renovated cohort\'s avg in-place rent − unrenovated baseline (same BD type)
BD TypeReno Tier# UnitsAvg In-Place Unreno BaselineActual PremiumUW PremiumCapture %
Headline: Building-level renovation items (paint, countertops, vinyl, cabinets, lighting) all DONE per client — total program budget $893K. Unit-by-unit renovations are ramping: 2 of 140 units individually renovated to date.
Per-Unit Renovation Cost vs. UW Budget
2 completed unit renovations · Total program budget $893K (Reno Tracker)
UnitTypeReno DateRent BeforeRent After Actual PremiumReno CostUW CostCost Variance
Fuller 134004/22/2026$875$1,325$+450$15,825$8,663$+7,162
Ivan 150304/22/2026$970$1,350$+380$15,788$8,663$+7,125
In-Place Rent vs. UW Market Rent vs. PM Market Rent
UW = post-reno proforma (Chartwell UW workbook) · PM Market = OneSite asking rent (NOT yet in workbook — needs PM-provided market benchmark; values shown are placeholder approximations)
Unit TypeBDReno Tier# Avg In-PlaceUW MktPM Mktvs UWvs PM
UW Plan
140 units in renovation tracker with total program budget of $893K. Per client: building-level items (paint, countertops, etc.) DONE. Individual units: 2 of 140 completed.
Reno reserve funded at acquisition — capital is in place to execute
Significant LTL opportunity — 2BR-2BTH in-place ~$990 sits ~$366 below UW market ($1,356) and ~$370 below comp avg ($1,360)
Pending Data
2 units complete; $67K Mar + $104K Apr CapEx — Fuller 1340 + Ivan 1503 done; GL shows $67K Mar + $104K Apr capex but unit-level cost allocation pending PM detail
No post-reno rent uplift data — need before/after rent by renovated unit
No PM market rent — PM has not provided post-reno comparable rent benchmarks
Request renovation tracking spreadsheet from PM (unit #, completion date, scope, cost, post-reno rent)
Establish baseline: pre-reno rent for each candidate unit so post-reno premium can be measured
Categorize Mar–May CapEx ($67K + $104K + $22K = $193K) — apartment renovations vs. common area / paving / amenities; reconcile to Unit Renovation Tracker
Source: Budget Summary tab — Budget (AE col), Actual (AF col), Variance (AG col) for May 2026. Equivalent Feb cols Y/Z/AA, Mar cols AB/AC/AD. All values copied directly from workbook with no derived calculations on the dashboard side.32%/mo. Annual Adjusted NOI target ramps from $58K monthly (Feb) to $77K (Jan'27), totaling $812K for the period. Note: Mar/Apr/May GPR (~$168–169K) is materially higher than Feb ($115K) because PM moved to full accrual accounting in Mar — booking gross market rent then offsetting via Loss-to-Lease (~$35–37K). Mar NRI ($129.8K) / Apr NRI ($129.6K) / May NRI ($127.7K) are the comparable revenue lines vs Feb NRI ($114.6K).
Revenue vs Budget (May)
-2.9%
Actual $135K vs Budget $139K
OpEx vs Budget (May)
-22.1%
Actual $59,412 (AI46) vs Budget $76,252
NOI vs Budget (May)
+20.2%
Actual $75,965 (AI48) vs Budget $63,207 (AE48) — Budget Summary tab
Annual Budget NOI Target
$812K
12-mo Adjusted NOI Feb'26–Jan'27 ($58K–$77K monthly)
Monthly Variance Detail
UW values per Monthly CF tab (Feb–May 2026 stabilized)
Line ItemAnnual BudgetFeb BudFeb ActMar BudMar ActApr BudApr ActMay BudMay ActMay Var %
Effective Gross Income$1,735K$133,443$114,868$135,440$133,954$137,445$139,917$139,460$135,377-2.9%
Total Operating Expenses$923K$75,441$55,784$75,711$55,972$75,981$61,230$76,252$59,412-22.1%
Net Operating Income (NOI)$812K$58,002$59,084$59,729$77,982$61,464$78,688$63,207$75,965+20.2%
EGI: Actual vs UW Budget
Operating budget (Feb–May 2026)
NOI: Actual vs UW Budget
Operating budget (Feb–May 2026)
DSCR (T-1, May)
1.24×
T-3 avg (workbook Dashboard G6): 1.26×
Expense Ratio (May)
43.1%
T-1: May OpEx $59,412 ÷ May EGI $135,377 (T-3 Mar–May basis: 43.9%)
Budget Wins
NOI beating budget by +20.2% in May — $75,965 actual (BS AI48) vs $63,207 budget (BS AH48); OpEx 22.1% under is the main driver
OpEx 22.1% under budget in May — $59,412 actual vs $76,252 budget (BS R46)
Property Tax & Insurance on plan — fixed escrowed accruals tracking at $11.5K/mo tax + $7.3K/mo insurance, near budget
Budget Misses
Revenue slightly below plan in May — May EGI $135K vs $139K plan (-2.9%); fee income ramp + concession burn-off driving the beat
Feb NOI miss — Feb NOI $67K vs $58K budget (+16%, Adjusted NOI basis); first month of accrual recording, will normalize
Annual NOI target $812K (Adjusted) — vs UW Year 2 stabilized $1.11M; plan is Year 1 ramp pace, not stabilized run-rate
OpEx beat holding — Mar $56.0K → Apr $61.2K → May $59.4K is flat; confirm it isn't masking deferred maintenance / one-time savings
Drive revenue toward UW market via renewals — closing the $59.4K/mo LtL gap drives an additional $713K/yr NOI
Budget variance now on 4 months (Feb–May); T-3 window is Mar–May, running -22.1% under