Before You Read This

This analysis is directional, not deterministic. The Monte Carlo framework does not predict exact returns. It stress-tests relative positioning under different catalyst execution paths. The goal is not to forecast precise IRRs, but to understand which metros have the highest probability of durable repricing given current capital investment trends.

If catalyst execution diverges materially from expectations, the board will move.

This is a living framework — not a static forecast.

On this week’s board, Columbus and Indianapolis remain at the top of the Now tier.Both clear the hard gates:

  • At least three catalyst families

  • Mid-to-late lifecycle execution visible

  • Absorption alignment in B and B+ housing bands

  • Structural friendliness not hostile

  • Meaningful remaining pricing delta

But they are not the same. Columbus is later in its cap rate curve. Indianapolis retains more remaining pricing delta. That distinction is not academic. It changes what “outperform” means depending on hold period and how leverage actually works by asset type. So instead of debating which market is “hot,” we modeled the deployment question:

If I deploy real equity today, which metro is more likely to outperform?

We modeled two realistic entry points:

  • $200,000 equity into a 4-plex

  • $400,000 equity into a 10-unit property

Hold periods:

  • 3 years

  • 5 years

Dallas serves as a repriced control market.

What “Hot” Means (and Why It’s Not the Same as Fertile)

“Hot” markets tend to have:

  • Higher execution certainty

  • More media coverage

  • More institutional capital flow

  • Earlier repricing

That often comes with:

  • Lower entry cap rates

  • Less remaining compression

  • A tighter downside distribution

That can be good, especially at shorter hold periods.

But our framework is not trying to identify temperature. It is trying to identify fertility.

Fertility means:

  • Catalyst stacking that is diversified

  • Execution probability that is rising

  • Remaining repricing potential

  • Absorption alignment in the housing bands investors actually buy

Hot is often later cycle.Fertile is often mid lifecycle. That is the tension between Columbus (probability) and Indianapolis (opportunity).

Capital Stack Assumptions

We modeled realistic acquisition structures.

4-Plex Scenario

Equity deployed: $200,000; Purchase range: ~$800k property before closing and repairs

10-Unit Scenario

Equity deployed: $400,000: Purchase range: ~$1.3M property before closing and repairs

These are not the same properties across markets. In Columbus, lower entry cap rates mean higher price per unit. In Indianapolis, higher entry cap rates mean more income per dollar deployed.

Leverage is consistent within each asset class across metros. Equity requirements reflect realistic scaling.

What “Outperformance” Means

Outperformance is defined as:

  • Higher Median IRR

  • Higher 90th percentile IRR

  • Lower probability IRR is below 8 percent

  • Lower probability of negative return

  • Higher probability of outperforming Dallas

All scenarios use:

  • Local rent growth assumptions

  • Metro-level vacancy context

  • Asset-type leverage

  • Catalyst-weighted execution modeling

How Catalysts Enter the Model

Each of the 10,000 simulations includes a catalyst outcome draw:

  1. Execute

  2. Partial

  3. Stall

Probabilities are based on: lifecycle stage; stack depth; stack diversity; durability probability

Intel in Columbus is further along than Lilly in Indianapolis.That increases short-term execution probability.

Indianapolis has:

  • Broader mid-lifecycle stacking

  • Greater remaining compression potential

Each catalyst state shifts:

  • Rent growth mean

  • Vacancy volatility

  • Exit cap compression probability

Compression is not assumed. It is probabilistic.

4-Plex — $200k Equity — 3-Year Hold

Metric

Indianapolis

Columbus

Dallas

Entry Cap Rate

7.0%

6.25%

6.0%

Cap Rate Compression

-25 bps

-35 bps

0 bps

Median IRR

11.4%

12.7%

9.7%

90th Percentile IRR

18%

20%

14%

Percent IRR from Compression

18%

26%

0%

Probability IRR < 8%

27%

20%

34%

Probability Negative Return

10%

6%

15%

Probability Outperform Dallas

66%

75%

Interpretation: Columbus carries higher near-term probability because its flagship catalyst is further along.

4-Plex — $200k Equity — 5-Year Hold

Metric

Indianapolis

Columbus

Dallas

Entry Cap Rate

7.0%

6.25%

6.0%

Cap Rate Compression

-90 bps

-35 bps

0 bps

Median IRR

16.6%

14.8%

11.5%

90th Percentile IRR

26%

22%

16%

Percent IRR from Compression

49%

26%

0%

Probability IRR < 8%

19%

16%

28%

Probability Negative Return

5%

3%

10%

Probability Outperform Dallas

82%

77%

Interpretation: At five years, Indianapolis’ remaining pricing delta becomes more influential.

10-Unit — $400k Equity — 3-Year Hold

Metric

Indianapolis

Columbus

Dallas

Entry Cap Rate

6.75%

6.0%

5.75%

Cap Rate Compression

-20 bps

-30 bps

0 bps

Median IRR

11.6%

12.9%

10.1%

90th Percentile IRR

19%

21%

15%

Percent IRR from Compression

13%

21%

0%

Probability IRR < 8%

24%

18%

31%

Probability Negative Return

9%

6%

14%

Probability Outperform Dallas

69%

76%

Interpretation: With larger equity and lower leverage sensitivity, Columbus still wins near-term probability.

10-Unit — $400k Equity — 5-Year Hold

Metric

Indianapolis

Columbus

Dallas

Entry Cap Rate

6.75%

6.0%

5.75%

Cap Rate Compression

-75 bps

-30 bps

0 bps

Median IRR

16.9%

15.3%

12.1%

90th Percentile IRR

26%

23%

17%

Percent IRR from Compression

42%

24%

0%

Probability IRR < 8%

16%

14%

27%

Probability Negative Return

4%

2%

9%

Probability Outperform Dallas

83%

79%

Interpretation: Over longer holds, Indianapolis benefits more from remaining repricing potential.

The Core Insight

Columbus equals higher probability in shorter windows. Indianapolis equals greater convexity in longer windows. Both outperform a repriced control market in most simulations.

Timing determines the winner.

Glossary

Cap Rate Compression- Decrease in exit cap rate relative to entry.

Convexity- Asymmetric upside if catalysts execute successfully.

Probability - Percentage of simulations in which an outcome occurs.

Pricing Delta - Remaining repricing potential implied by catalyst progression.

Catalyst Stack- Multiple independent capital investment families influencing demand durability.

Appendix — Monte Carlo Framework

10,000 simulations per scenario

Hold periods: 3 and 5 years

Equity:

4-plex: $200k; 10-unit: $400k; Consistent LTV within each asset class.

Modeled baseline variables:

  • Rent growth

  • Vacancy volatility

  • Expense inflation

  • Exit cap rate behavior

  • One macro shock event

Catalyst integration:

Each simulation selects Execute, Partial, or Stall using lifecycle-weighted probabilities.

State selection shifts:

  • Rent growth mean

  • Vacancy volatility

  • Exit cap compression likelihood

Stack diversity reduces stall probability and tail risk.

References

CBRE U.S. Cap Rate Survey 2023–2024

JLL Capital Markets Outlook

Cushman and Wakefield MarketBeat

Federal Reserve Economic Data

U.S. Census Bureau Population Estimates

Intel Ohio development filings

Eli Lilly Indianapolis expansion filings

Indiana Economic Development Corporation

Ohio Department of Development

Keep Reading