Housing Supply, Demand and Affordability: Case Analysis and Recommendations

A case memo someone could vote on

Harborstone Properties manages $2.40B AUM across Sun Belt multifamily, industrial, and mixed-use assets. Housing affordability is a supply story with political noise. Can Harborstone underwrite Tampa workforce housing with inclusionary zoning?

Harborstone Properties is a mixed-use real estate investor-developer active in Sun Belt markets (Austin, Phoenix, Nashville, Tampa, Charlotte) and the anchor company for the Real Estate concentration. The firm manages approximately $2.40B in assets under management (AUM, total capital deployed or controlled across funds and balance-sheet holdings) across 14 active projects. Portfolio mix is roughly 42% multifamily, 28% industrial, 18% office/flex, and 12% retail/mixed-use. Managing Partner Sofia Reyes, Head of Acquisitions Tom Bradley, CFO Lina Morales, Head of Development Mei Chen, and VP Asset Management Carlos Ruiz apply the frameworks in these courses to cap rates, development pro formas, capital markets, and portfolio strategy.

Harborstone appears in every worked example so you can trace how one underwriting assumption, lease clause, or capital markets shift changes NOI (net operating income, property revenue minus operating expenses before debt and capital costs), cap rate (capitalization rate, NOI divided by value or price), and IRR (internal rate of return, the discount rate that sets net present value to zero) on the same assets from REA 401 through REA 406. Case lessons synthesize evidence into a recommendation. Use Sunbelt Commons (Tampa, FL, $6M NOI) as the fact pattern unless your applied project specifies otherwise.

Throughout this lesson, anchor examples use Sunbelt Commons (Tampa, FL, $6M NOI) unless noted otherwise.

Housing Supply, Demand and Affordability: the managerial question

Housing Supply, Demand and Affordability at Harborstone is not academic coverage. It is how leadership answers: Can Harborstone underwrite Tampa workforce housing with inclusionary zoning? The answer shapes bids, capital calls, dispositions, and PropTech budgets.

Good analysis names the decision owner (often Tom Bradley for acquisitions, Carlos Ruiz for asset management, or Mei Chen for development), the decision date, and what evidence would change the recommendation. Without that frame, teams produce accurate but unused work.

Harborstone ties Required subsidy per affordable unit vs market rate NOI to weekly operating reviews and quarterly IC packs. Metrics live in a shared dictionary so Fund IV LPs hear the same definitions Sofia Reyes uses internally.

Core vocabulary for this unit:

Use these terms consistently in memos and models. If two teams define NOI or cap rate differently, portfolio aggregation becomes misleading.

Framework: Supply-demand balance: permits, absorption, and affordability gap

Harborstone applies Supply-demand balance: permits, absorption, and affordability gap when working Housing Supply, Demand and Affordability. The framework forces ordered steps: frame the decision, list assumptions, build the base case, stress inputs, and only then recommend action.

Frameworks also expose kill criteria. If entitlement delay exceeds 18 months on a development site, Harborstone may drop the pursuit rather than fund carrying costs indefinitely. If DSCR falls below 1.20x in a downside case, Lina Morales will not approve refinancing terms without additional equity or rate caps.

Even qualitative units require evidence labels: observation, pattern, tested mechanism, or scaled policy. Label honestly when recommending portfolio shifts.

Harborstone fact pattern and assumptions

Use the following consistent fact pattern in examples and practice problems:

When you adjust an assumption, change one input at a time for sensitivity work, then combine inputs only in named scenarios (base, downside, upside). Mixed one-off tweaks produce untraceable recommendations.

Connecting to the Real Estate concentration arc

REA 401 builds cash flow and valuation mechanics. REA 402 adds market and leasing context. REA 403 covers development execution. REA 404 covers fund and capital markets structures. REA 405 connects operations and technology. REA 406 adds urban and policy economics.

Harborstone is the thread across all six courses. FIN 201 (Corporate Finance) discount rates and capital structure informs discount rates in REA 401. Market cycle literacy from REA 402 feeds acquisition timing in REA 404. PropTech choices in REA 405 affect NOI bridges modeled in REA 401.

When you finish this lesson, you should explain how Housing Supply, Demand and Affordability changes at least one line in a Harborstone IC memo.

Decision: Can Harborstone underwrite Tampa workforce housing with inclusionary zoning?

Asset context: Sunbelt Commons (Tampa, FL, $6M NOI)

Primary framework: Supply-demand balance: permits, absorption, and affordability gap

Part A: Frame and inputs

Check: Value × cap ≈ NOI ($111M × 5.50% ≈ $6M)

Part B: Build the analysis

Qualitative analysis still requires structure. Score Housing Supply, Demand and Affordability drivers on a 1–5 scale for evidence strength, then weight by strategic importance to Fund IV.

Harborstone documents dissent: if acquisitions and asset management disagree on rent growth, both cases appear in the memo with probabilities.

Part C: Sensitivity or scenario

Check: Downside case should use coherent inputs (lower rent growth AND higher vacancy, not mixed unrelated tweaks).

Part D: Managerial read

IC summary: Recommend proceed only if downside Required subsidy per affordable unit vs market rate NOI still clears Fund IV hurdle rates and LPs can trace assumptions to Sunbelt Commons (Tampa, FL, $6M NOI). Assign Carlos Ruiz a 90-day KPI to validate operating assumptions post-close. If evidence is descriptive only, label the memo exploratory and specify the cheapest next test (pilot, Phase I environmental, or broker re-trade).

A generic analyst memo says "Housing Supply, Demand and Affordability looks attractive given market trends." Harborstone rejects that language. Required instead: named asset (Sunbelt Commons (Tampa, FL, $6M NOI)), dated assumptions, Supply-demand balance: permits, absorption, and affordability gap, downside case, and explicit kill criteria.

Narrative discipline: separate facts from inference. Cite broker comps with dates. Label policy risks as conditional scenarios, not footnotes.

Managerial read: LPs pay Harborstone for repeatability, not heroics. Can Harborstone underwrite Tampa workforce housing with inclusionary zoning? should be answerable the same way next quarter with updated inputs.

Using Harborstone and Housing Supply, Demand and Affordability, complete the following:

1. Restate the decision in one sentence with owner and date.

2. Apply Supply-demand balance: permits, absorption, and affordability gap to Sunbelt Commons (Tampa, FL, $6M NOI) with a base case using amiPct = 0.8.

3. Run a downside case that changes at least two inputs coherently.

4. Recommend proceed, retrade, or stop with two falsifiers you will check in 60 days.

Solution

Sample structure (your numbers may vary with assumptions):

Decision: Can Harborstone underwrite Tampa workforce housing with inclusionary zoning? Owner: Tom Bradley. Date: next IC.

Base: Required subsidy per affordable unit vs market rate NOI supports proceed if returns clear Fund IV 15% IRR hurdle and DSCR stays above 1.25x.

Downside: If amiPct worsens by 10% and cap rates expand 50 bps, IRR falls below hurdle; recommend retrade price down $4M or pass.

Falsifiers: (1) Three-month trailing NOI below $6M; (2) leasing velocity below 4 units/month if development-related.

Check: Downside recommendation matches stated hurdle without hidden optimism.

Key takeaways

• Housing Supply, Demand and Affordability decisions require explicit owners, dates, and kill criteria at Harborstone.
• Use Supply-demand balance: permits, absorption, and affordability gap so assumptions can be challenged in IC and LP settings.
• Define vocabulary (NOI, cap rate, DSCR, IRR) before comparing deals or markets.
• Required subsidy per affordable unit vs market rate NOI must reconcile across memo, model, and asset management KPIs.
• Separate base, downside, and upside cases; avoid mixing unrelated one-off tweaks.

1. Apply Housing Supply, Demand and Affordability: Case Analysis and Recommendations to your applied project organization or reuse Harborstone with one changed assumption.
2. Build a one-page assumption ledger for Housing Supply, Demand and Affordability with sources and confidence labels.
3. Begin the next unit in this course and link findings to Housing Supply, Demand and Affordability.

Harborstone portfolio context for Housing Supply, Demand and Affordability: Case Analysis and Recommendations

Harborstone Properties underwrites Housing Supply, Demand and Affordability against a $2.40B portfolio spanning Austin, Phoenix, Nashville, Tampa, and Charlotte. Sofia Reyes expects every lesson concept to map to a line item in an IC memo, a lender covenant, or an asset management KPI. Tom Bradley's acquisitions team tracks broker pipelines weekly; Carlos Ruiz's asset management team tracks NOI bridges monthly; Mei Chen's development team tracks entitlement milestones daily when projects are active.

When housing supply, demand and affordability: case analysis and recommendations influences a bid, the team links going-in cap rate, DSCR (debt service coverage ratio, NOI divided by debt service), and IRR (internal rate of return, discount rate that zeroes NPV) on the same model tab. Lina Morales publishes a rate sensitivity weekly so floating-rate exposure is not re-discovered at refi. Fund IV LPs receive DPI (distributions to paid-in capital, cash returned divided by contributed equity) and TVPI (total value to paid-in, distributions plus NAV over paid-in) updates quarterly, so lesson concepts must survive LP scrutiny not only spreadsheet review.

Document every metric in Harborstone's shared dictionary: definition, source system, refresh cadence, and owner. A cap rate comp is useless without the NOI definition used by the broker. A PropTech ROI claim is useless without baseline turnover time measured pre-install. This discipline is how Harborstone scales to fourteen active projects without fourteen silent definitions of "occupancy."

Extended scenario: IC room dialogue

Picture Fund IV IC reviewing Housing Supply, Demand and Affordability. Tom presents market support; Carlos presents operating risks; Lina presents debt options; Sofia asks for downside coherence. A weak presentation jumps from a pretty map to a recommendation. A strong presentation states: decision, base case, downside case, kill criteria, and next study if data is thin.

Harborstone Gateway (312 units, Austin) often anchors multifamily examples; Meridian Flex (185,000 SF, Phoenix) anchors industrial; Sunbelt Commons (Tampa mixed-use) anchors retail-residential complexity. Use the same asset within a unit so sensitivity tables remain comparable across lessons. If you change rent growth in lesson three, lesson four should reference that change explicitly.

For housing supply, demand and affordability: case analysis and recommendations, write three sentences you would say aloud if Sofia Reyes asked, "What would make you change your mind?" If you cannot answer, the analysis is not ready for capital allocation regardless of spreadsheet precision.

Technical mechanics and reconciliation (Harborstone standard)

Harborstone models include explicit check lines. Sources equal uses in development budgets. Year-five reversion value equals exit NOI divided by exit cap. Portfolio weights sum to 100%. Fund fees apply to documented bases (committed vs invested) consistently across deals.

When building qualitative analysis for Housing Supply, Demand and Affordability:

1. State the grain (property, fund, portfolio, city).
2. State the period (T-12, forward year one, hold period).
3. State comparables criteria (distance, age, occupancy band).
4. State evidence label (observation, pattern, tested, scaled policy).

If two tabs show different NOI for the same asset, stop and reconcile before adding commentary. IC members notice drift faster than analysts expect.

Common LP and lender questions (and disciplined answers)

LPs ask: "Why this market now?" Lenders ask: "What happens at refi if rates are 150 bps higher?" Tenants ask: "Will you maintain service during renovation?" Cities ask: "What community benefit justifies density?" Good answers reference Housing Supply, Demand and Affordability frameworks with numbers and dated comps.

Disciplined answer format: recommendation, evidence strength, limitations, next study. A fourth bullet lists falsifiers within 60 days. Harborstone rejects memos that only argue upside.

Practice extension: self-check

Before moving on, open a blank document and complete four rows for Housing Supply, Demand and Affordability: Case Analysis and Recommendations:

1. Decision owner and date for a Harborstone-relevant choice.
2. Base case metric and threshold for proceed.
3. Downside case that changes at least two inputs together.
4. Two falsifiers you will monitor in the first 60 days.

Compare your rows to the worked example. Gaps indicate sections to re-read.

Cross-course links (REA 401–406)

Real estate fluency compounds across the concentration. Cash flow mechanics from REA 401 feed market timing in REA 402 and development feasibility in REA 403. Fund structures in REA 404 set hurdles that operations and PropTech investments in REA 405 must clear to protect NOI. Urban economics in REA 406 explains why Harborstone overweight Sun Belt growth markets without ignoring policy and affordability constraints.

When studying Housing Supply, Demand and Affordability, name one concept from an earlier REA course that this lesson depends on, and one concept in a later course that this lesson enables. Integration is intentional: Harborstone is the same company throughout.

Metric definitions Harborstone reuses weekly

Occupancy = occupied units or SF divided by total rentable, per lease abstract rules. Economic occupancy adjusts for concessions and bad debt. NOI excludes debt service, income taxes, and corporate overhead unless modeling levered fund returns. Cap rate = NOI / value unless labeled "nominal" with adjustment notes. Cash-on-cash = cash flow after debt service divided by equity invested in year one. Yield on cost = stabilized NOI / total development cost.

These definitions appear tedious until someone changes them mid-quarter. Housing Supply, Demand and Affordability: Case Analysis and Recommendations training includes insisting on definition links in memo footers. When Harborstone compares Fund III exits to Fund IV entries, shared definitions are the chain between track record and new commitments.