Market & Comp Analysis
Build the market picture behind a deal: what rents are achievable, what's competing, where the market is heading.
When to use
"Pull comps for [submarket]," "build me a market study," "what are rents/cap rates doing in [market]," "who are the competitive properties near [site]?"
Inputs
- Subject property/site location and product type.
- Unit mix if known (studio/1BR/2BR/3BR), target rent band if any.
- Radius or named submarket for the comp set.
What to assemble (cite sources + dates)
- Comparable set — 4–8 competing communities: name, location, year built, units, unit mix, current asking rents (by unit type and per SF), concessions, occupancy. Note the source for each.
- Rent trend — direction and rate of rent growth over the last 1–3 years for the submarket.
- Occupancy / vacancy — current and trend.
- Supply pipeline — units under construction and planned nearby; expected delivery timing; absorption pace. Call out oversupply risk explicitly.
- Cap-rate & sales trend — recent multifamily sales/cap rates in the market if available; direction of movement.
- Concessions & lease-up reads — what new deliveries are offering to lease up.
Tools
- Yardi Matrix connector if connected — best for rents, comps, pipeline, ownership.
- Otherwise built-in web search / Tavily / Exa: pull from property marketing sites, market reports (CBRE/JLL/Cushman/Marcus & Millichap), census/BLS, local news on new developments.
- The user can also paste CoStar/RealPage exports — fold those in and cite them as firm-provided.
Output
- Market study using
underwriter-os/templates/market-study.md, saved to the deal folder.
- Comp table (clean, sortable): community, rents by type, $/SF, occupancy, vintage, distance.
- Read on achievable rent for the subject + the supply risk verdict.
- Bottom line: is the market supportive of this deal's rent and absorption assumptions?
Accuracy
- Every comp and number gets a source + date. If a rent is an estimate, label it.
- Don't average across non-comparable product — note when comps are imperfect.
- Distinguish asking rents (advertised) from effective rents (after concessions) and say which you used.
1---2name: market-comp-analysis3description: Pull rent comps, occupancy, supply pipeline, absorption, and cap-rate trends for a submarket, then build a market study. Use when the user asks for "comps," "rent comps," "market study," "what are rents doing," "cap rates," "what's the competition," or needs the market picture behind a deal.4---56# Market & Comp Analysis78Build the market picture behind a deal: what rents are achievable, what's competing, where the market is heading.910## When to use11"Pull comps for [submarket]," "build me a market study," "what are rents/cap rates doing in [market]," "who are the competitive properties near [site]?"1213## Inputs14- Subject property/site location and product type.15- Unit mix if known (studio/1BR/2BR/3BR), target rent band if any.16- Radius or named submarket for the comp set.1718## What to assemble (cite sources + dates)191. **Comparable set** — 4–8 competing communities: name, location, year built, units, unit mix, current asking rents (by unit type and per SF), concessions, occupancy. Note the source for each.202. **Rent trend** — direction and rate of rent growth over the last 1–3 years for the submarket.213. **Occupancy / vacancy** — current and trend.224. **Supply pipeline** — units under construction and planned nearby; expected delivery timing; absorption pace. Call out oversupply risk explicitly.235. **Cap-rate & sales trend** — recent multifamily sales/cap rates in the market if available; direction of movement.246. **Concessions & lease-up reads** — what new deliveries are offering to lease up.2526## Tools27- **Yardi Matrix** connector if connected — best for rents, comps, pipeline, ownership.28- Otherwise built-in web search / Tavily / Exa: pull from property marketing sites, market reports (CBRE/JLL/Cushman/Marcus & Millichap), census/BLS, local news on new developments.29- The user can also paste CoStar/RealPage exports — fold those in and cite them as firm-provided.3031## Output32- **Market study** using `underwriter-os/templates/market-study.md`, saved to the deal folder.33- **Comp table** (clean, sortable): community, rents by type, $/SF, occupancy, vintage, distance.34- **Read on achievable rent** for the subject + the supply risk verdict.35- Bottom line: is the market supportive of this deal's rent and absorption assumptions?3637## Accuracy38- Every comp and number gets a source + date. If a rent is an estimate, label it.39- Don't average across non-comparable product — note when comps are imperfect.40- Distinguish asking rents (advertised) from effective rents (after concessions) and say which you used.