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–Jun 2026
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)
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 - 1BTH12$948$1,305-27.4%
2BR - 1BTH TH32$864$1,305-33.8%
2BR - 1BTH TH PR3$930$1,305-28.7%
2BR - 1BTH TH RR5$785$1,305-39.8%
2BR - 2BTH49$1,045$1,356-22.9%
2BR - 2BTH RR7$1,238$1,356-8.7%
2BR - 2BTH Loft6$1,148$1,356-15.3%
2BR - 2BTH Loft RR2$1,153$1,356-15.0%
3BR - 2BTH10$1,015$1,450-30.1%
3BR - 2BTH RR2$980$1,450-32.4%
4BR - 2BTH10$1,101$1,550-29.0%
4BR - 2BTH RR2$1,068$1,550-31.1%
TOTAL140$1,006$1,362-30.6%
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,24015.9%
Payroll & Benefits$12,24821.1%
R&M (incl Turnover)$2700.5%
Utilities (Elec+Water+Gas)$6,64311.5%
Insurance$8,37314.5%
Property Taxes$11,53419.9%
Marketing$1,7453.0%
G&A (Admin+Legal)$2,3784.1%
Contract Services (incl Landscaping)$5,5109.5%
Other Expenses$00.0%
Total Operating Expenses$57,941100.0%
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
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$156KAdequate
-10%1.29×$714K$207KAdequate
-5%1.36×$714K$258KGood
Base (Workbook KPI N15)1.43×$714K$310KGood
+5%1.51×$714K$361KStrong
+10%1.58×$714K$412KStrong
+15%1.65×$714K$463KStrong
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 days63$-57,996
31–60 days4$-203
61–90 days1$-9,030
91+ days4$-70
Total67$-67,299
Negative balances = tenant credits / prepayments. Strong collections — $67K of credit balances across 67 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). 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
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.
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
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
Expense Categories
📊
Select an expense category to view details
What's Working
Property Tax & Insurance escrowed — predictable monthly accrual ($11.5K tax + $8.4K insurance (Jun); insurance stepped up from $6.0K May to $8.4K Jun)
Mgmt Fee at 6.45% of EGI — competitive vs. typical 4-5% for similar-size properties
Watch Items
Water/Sewer $8,876 Mar → $10,251 Apr → $6,510 May → $5,944 Jun — Reverted to normal range after Mar/Apr spike; sub-$6K/mo run rate holding
R&M normalized ($278 Mar → $817 Apr → $230 May → $270 Jun) — settled to sub-$300/mo run rate
Insurance $8,373/mo (Jun) — equates to ~$622/unit/year, on the high end for Ohio multifamily
Water/sewer May–Jun back to sub-$6.5K/mo normal range; consider RUBS program to shift future costs to tenants
Continue monthly tracking — operating budget loaded ($72.8K/mo OpEx Feb→$75.3K Jan'27); actuals tracking ~24% under in Jun ($57.9K vs $76.5K 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 Apr–Jun OpEx ÷ EGI
Controllable Exp %
43.3%
Payroll+Mgmt+R&M+Mktg
Chartwell Phys. Occ
95.7%
Jun 2026 (per RR Summary)
Chartwell Avg Rent
$1,006
Range: $785–$1,238
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
$1,006
Jun 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
95.7% physical occupancy (Jun) — 134 of 140 apartments occupied; 5 apartments vacant, all in Fuller/Wind buildings: Fuller 1281/1340/1345/1403 + Wind 1543. 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 ~$30.5K Jun (improving from $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
134
Per Rent Roll Summary - Jun (v18)
Vacant Apartments
5
Fuller 1281/1340/1345/1403 + Wind 1543 (all in Fuller/Wind buildings)
MTM Tenants
8
Derived: count of RR Summary - Jun rows where Status = MTM
Jun Leasing Activity
120
120 leads · 19 tours · 10 apps · 6 approved · 5 signed (per PM Dashboard 7/15/26)
Leasing Pipeline & Conversions
Source: Leasing Activity tab (Apr–Jun 2026 actuals)
Month Renewals Move-Ins Move-Outs Net Abs Projected Occ Traffic Apps Approvals Conversion
Mar 202601-198.6%
Apr 2026112-197.9%
May 2026268-693.6%64 leads · 7 tours7 apps · 4 approved2 signed · 50% rate
Jun 2026630+395.7%120 leads · 19 tours10 apps · 6 approved5 signed · 50% rate
Source: Leasing Activity tab (Apr–Jun 2026 actuals). May–Jun projections removed (not yet recorded as actuals).
Move-Outs
Source: PM Dashboard 7/15/26 + RR 6/30/26 (June actuals)
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 7/15/26 + RR 6/30/26 (June actuals)
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 14736/1/26$1,425+$395
Leasing Funnel
Source: PM Dashboard 7/15/26 + RR 6/30/26 (June actuals)
WeekLeadsToursPendingApprovedSigned
6/26/26296031
7/3/26254111
7/10/26516023
7/17/26153100
4-Week Total12019265
Lease Expiration Schedule
Next 12 months (Jul 2026 – Jun 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
95.7% physical occupancy (Jun 30; 134 of 140) — 134 Occupied + 5 Vacant (Fuller 1281/1340/1345/1403 + Wind 1543) + 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–$1,425 — Ivan 1503 (5/1), Kent 1472 (6/1), Wind 1473/1550 (Jun) — confirms renovated-unit rent ceiling is well above current in-place
Strong collections — net credit balance of $67K (67 prepaid tenants) and zero 31-60 day delinquency
Watch Items
Renovation rent uplift validated — 4 reno-then-vacate units (Ivan 1503 $1,350, Kent 1472 $1,350, Wind 1473 $1,425, Wind 1550 $1,350) re-leasing above prior rents vs prior $970–$1,025; avg +$371/mo lift ($4,455/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–Jun 2026
Average Rent Trajectory
With market comparison
Rent Growth by Unit Type
Jun 2026 in-place rents (Feb-Jun 2026, 5 months)
Unit Type Jun 2026 Growth $ Growth %
Multi-month rent growth analysis: 5 months delivered (Feb–Jun 2026). Avg in-place rent Feb $926 → Mar $938 → Apr $946 → May $956 → Jun $1,006 (+1.3% Feb→Mar, +0.9% Mar→Apr, +1.1% Apr→May, +5.2% May→Jun). Unit-type-level rent growth requires PM-provided per-type rent series; June confirms trend.
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–Jun 2026 — Avg in-place: Feb $926 → Mar $938 → Apr $946 → May $956 → Jun $1,006 (+8.6% portfolio-wide over 5 months, June alone +5.2% on spot-market lifts). 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 95.7% (Jun; 134/140) — 5 vacant apartments (Fuller 1281/1340/1345/1403 + Wind 1543 (Fuller 1340 renovated 4/22/26; others per PM renovation tracker) 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 94.4% 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). 31 of 32 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 $1,006 avg in-place and $1,362 avg UW market would add ~$50K/mo (~$598K/yr) to NOI. At 6.5% cap that's ~$9.2M of value uplift, from current $15.75M to ~$24.95M. PM-recorded LtL in Jun GL was -$30.5K (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 ~$598K/yr loss-to-lease ($1,362 UW market vs $1,006 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–Jun CapEx ($67K + $104K + $22K + $95K = $288K) — apartment renovations vs. common area / paving / amenities; reconcile to Unit Renovation Tracker
Source: Budget Summary tab — Budget (AK col), Actual (AL col), Variance (AM col) for Jun 2026. Equivalent Feb cols Y/Z/AA, Mar cols AB/AC/AD, Apr cols AE/AF/AG, May cols AH/AI/AJ. All values copied directly from workbook with no derived calculations on the dashboard side. Annual Adjusted NOI target ramps from $58K monthly (Feb) to $77K (Jan'27), totaling $812K for the period. Note: Mar/Apr/May/Jun GPR (~$168–170K) 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) / Jun NRI ($131.5K) are the comparable revenue lines vs Feb NRI ($114.6K).
Revenue vs Budget (Jun)
+1.3%
Actual $143K vs Budget $141K
OpEx vs Budget (Jun)
-24.3%
Actual $57,941 (AL46) vs Budget $76,524
NOI vs Budget (Jun)
+31.3%
Actual $85,317 (AL48) vs Budget $64,959 (AK48) — 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–Jun 2026 stabilized)
Line ItemAnnual BudgetFeb BudFeb ActMar BudMar ActApr BudApr ActMay BudMay ActJun BudJun ActJun Var %
Effective Gross Income$1,735K$133,443$114,868$135,440$133,954$137,445$139,917$139,459$135,377$141,483$143,258+1.3%
Total Operating Expenses$923K$75,441$55,784$75,711$56,025$75,981$61,230$76,252$59,412$76,524$57,941-24.3%
Net Operating Income (NOI)$812K$58,002$59,084$59,729$77,929$61,464$78,688$63,207$75,965$64,959$85,317+31.3%
EGI: Actual vs UW Budget
Operating budget (Feb–Jun 2026)
NOI: Actual vs UW Budget
Operating budget (Feb–Jun 2026)
DSCR (T-1, Jun)
1.43×
T-3 avg (Apr–Jun): 1.34×
Expense Ratio (Jun)
40.5%
T-1: Jun OpEx $57,941 ÷ Jun EGI $143,258 (T-3 Apr–Jun basis: 42.7%)
Budget Wins
NOI beating budget by +31.3% in Jun — $85,317 actual (BS AL48) vs $64,959 budget (BS AK48); OpEx 24.3% under is the main driver
OpEx 24.3% under budget in Jun — $57,941 actual vs $76,524 budget (BS AK46)
Property Tax & Insurance on plan — fixed escrowed accruals tracking at $11.5K/mo tax + $7.3K/mo insurance, near budget
Budget Misses
Revenue above plan in Jun — Jun EGI $143K vs $141K plan (+1.3%); driven by Fee Income spike ($11.8K vs $4.7K plan) from move-out charges & security deposit forfeits
Feb NOI beat — Feb NOI $59K vs $58K budget (+1.9%); first month post-acquisition, will normalize with more history
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 → Jun $57.9K trending down; 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 5 months (Feb–Jun); T-3 window is Apr–Jun, running -24.3% under