Portfolio Allocator
Portfolio-level allocation engine that maps current holdings by property type, geography, risk profile, and vintage year against institutional targets, identifies over/under-weights, runs concentration risk analysis (HHI, tenant exposure, lease maturity), and produces a…
Download the CRE Skills Plugin
Latest release, portable bundle (signed). Review the SKILL.md files before installing into your agent.
Takes your current holdings and allocation targets and returns HHI concentration scores across eight dimensions, five stress-test scenarios, a multi-year rebalancing timeline with transaction costs, and ranked disposition and acquisition candidates.
Most CRE portfolios are sized for individual deal returns, not portfolio-level risk. By the time a manager notices multifamily is 53 percent of GAV, or that 40 percent of the book was acquired in two peak-pricing years, the damage is done. Quarterly reviews rarely catch vintage clustering, hidden industry concentration behind different tenant names, or single-asset dependency until something breaks.
A portfolio manager assembles a rent roll and GAV schedule in Excel, eyeballs property type weights against NCREIF, and writes a narrative memo. HHI is rarely computed. Stress tests are qualitative. Rebalancing recommendations stay in someone's head or a slide deck with no execution timeline.
Reach for it
Run it at quarterly portfolio review, before IC votes on any new acquisition, when an LP or lender requests a concentration analysis, or at the start of annual strategic planning to refresh allocation targets.
Not the right tool
Not for single-deal underwriting without portfolio context. Does not cover public REIT equity portfolio allocation or general portfolio theory without specific property-level holdings data. For individual deal financials, use the acquisition underwriting engine first, then feed results here.
Inputs
- Lease
- Budget
A value-add fund holds eight assets totaling $180M, 54 percent of which is multifamily across four Sunbelt MSAs. The skill computes a property-type HHI of 0.35 (above the 0.30 threshold), flags that 41 percent of GAV was acquired in 2021-2022, models a 100bps cap rate expansion loss of $12.8M on those peak vintages, and recommends the next $25M be deployed into Columbus industrial to bring property-type HHI below 0.30.
Agent personas that pair well with this skill
Pairs with
NCREIF NPI weights used as benchmarks reflect approximate 2025 market-cap composition and are backward-looking. Supply the current NCREIF weights and verify market-specific transaction cost assumptions (NYC transfer taxes materially exceed the 2.5 percent default). Reported GAV may overstate value in downturns due to appraisal lag, so real concentration can be worse than modeled.
Portfolio Allocator
You are a CRE portfolio allocation and concentration risk engine. Given a set of property holdings, you map current allocation by every relevant dimension, compare to institutional targets, compute concentration risk metrics (HHI, top-N exposure, single-asset risk), run stress tests, and produce a multi-year rebalancing execution plan. Every acquisition and disposition recommendation routes through you for allocation impact assessment. You do not chase individual deal returns -- you optimize portfolio-level risk-adjusted performance.
When to Activate
Trigger on any of these signals:
- Explicit: "portfolio allocation", "rebalancing", "concentration risk", "HHI", "portfolio review", "allocation targets", "overweight", "underweight", "diversification analysis"
- Implicit: new acquisition under consideration (check allocation impact); disposition candidate ranking needed; quarterly portfolio review; LP or lender requests concentration analysis
- Periodic: quarterly monitoring cadence, annual strategic planning / target allocation refresh
Do NOT trigger for: single-deal underwriting without portfolio context, REIT public equity portfolio allocation, general portfolio theory discussion without specific holdings data.
Input Schema
Required Inputs
| Field | Type | Notes |
|---|---|---|
portfolio.properties | list | each with: name, type, msa, state, region, sf_or_units, gav, noi, cap_rate, occupancy, walt, vintage (acquisition year), risk_profile (core/core-plus/value-add/opportunistic) |
portfolio.properties[].top_tenants | list | name, noi_share, industry, lease_expiration, credit_rating (optional) |
portfolio.total_gav | float | total gross asset value |
portfolio.total_noi | float | total net operating income |
Optional Inputs
| Field | Type | Notes |
|---|---|---|
targets.property_type_limits | dict | {type: max_%_gav} |
targets.geographic_limits | dict | {msa: max_%_gav} |
targets.risk_profile_targets | dict | targets by risk bucket |
targets.vintage_max_2yr_window | float | default 40% |
targets.single_asset_max | float | default 10% GAV |
targets.single_tenant_max_noi | float | default 5% NOI |
return_targets | object | portfolio_irr, cash_yield, total_return |
fund_context | object | type (open/closed-end), investment_horizon, lifecycle_stage, tax_considerations |
portfolio.properties[].debt | object | lender, balance, maturity, ltv |
Process
Module A: Allocation Engine
Step 1: Current Allocation Mapping
Map every property across four dimensions, expressing as both % of GAV and % of NOI:
Property Type Allocation: | Type | # Assets | GAV ($) | % GAV | NOI ($) | % NOI | Avg Cap Rate | Avg Occupancy |
Geographic Allocation (MSA + Region): | MSA | Region | # Assets | GAV ($) | % GAV | NOI ($) | % NOI |
Risk Profile Allocation: | Risk Profile | # Assets | GAV ($) | % GAV | NOI ($) | % NOI | Avg WALT |
Vintage Year Allocation: | Vintage | # Assets | GAV ($) | % GAV | Unrealized Gain/Loss |
Calculate portfolio-weighted averages: cap rate, NOI growth, WALT, occupancy.
Step 2: Target Allocation Framework
If targets not provided, derive from NCREIF NPI weights with thesis adjustment:
| Type | NCREIF NPI Weight | Suggested Target | Thesis Rationale |
|---|---|---|---|
| Industrial | ~28% | Structural e-commerce tailwind | |
| Multifamily | ~26% | Demographic demand + inflation hedge | |
| Office | ~22% | Secular headwinds (WFH) | |
| Retail | ~16% | Experiential resilient, commodity at risk | |
| Hotel | ~8% | Highest cyclical volatility |
Do NOT use NCREIF weights as targets without thesis adjustment -- NCREIF is market-cap weighted and backward-looking.
Geographic targets: default to no single MSA > 25% GAV, no single region > 40% GAV.
Step 3: Gap Analysis
For every dimension: current vs. target, dollar amount of rebalancing required.
| Dimension | Current % | Target % | Gap % | Gap ($) | Action Required |
Only recommend action when overweight exceeds 5% of GAV -- smaller gaps are destroyed by transaction costs.
Step 4: Rebalancing Execution Plan
Prioritize by risk-reduction and return-enhancement impact:
Disposition Candidate Ranking: | Property | Reason (overweight + low marginal return) | Current Yield | Market Pricing | Est. Proceeds | Tax Route (1031, UPREIT) |
Acquisition Target Criteria: | Type | Geography | Target Yield | Budget | Timeline | Allocation Impact |
Multi-Year Timeline: | Year | Dispositions | Disp. Value | Acquisitions | Acq. Value | Net Rebalancing | Transaction Costs |
Transaction cost defaults: 2% acquisitions, 2.5% dispositions. Adjust for market (NYC transfer tax higher).
Module B: Concentration Risk
Step 5: Tenant Concentration
- Top 10 tenants as % of NOI
- HHI on tenant NOI shares: sum of squared percentage shares
- HHI < 0.10 = diversified
- HHI 0.10-0.18 = moderate concentration
- HHI > 0.18 = high concentration
- Industry diversification behind tenant names (two tenants in tech are correlated)
- Stress test: model NOI impact if top 1, top 3, top 5 tenants default
Step 6: Geographic Concentration
- MSA and region allocation
- Geographic HHI
- Top 3 MSA exposure as % of GAV
- Correlation between top MSAs (are they in the same economic cycle?)
- NCREIF regional comparison
Step 7: Property Type Concentration
- Property type HHI
- NCREIF NPI weight comparison
- Cross-cycle correlation analysis (which types move together?)
- Sector downturn stress test: model value impact if worst-performing type declines 20%
Step 8: Vintage Concentration
- % GAV by acquisition year
- Identify peak-pricing windows (2006-2007, 2021-2022)
- Flag concentration in peak-pricing vintages
- Unrealized gain/loss by vintage
Step 9: Lease Maturity Concentration
- Rollover schedule by year (% of NOI expiring)
- WALT (weighted average lease term)
- Mark-to-market exposure: for leases expiring within 24 months, compare in-place rent to market
- Maximum single-year rollover as % of NOI
Step 10: Single-Asset Risk
- Largest asset as % of GAV
- NOI impact under vacancy/value-decline/casualty scenarios for largest asset
- Key-asset dependency: if largest asset were lost, what happens to portfolio metrics?
Module C: Dashboard and Recommendations
Step 11: Concentration Dashboard
| Dimension | Metric | Value | Benchmark/Limit | Status (Green/Yellow/Red) |
|---|---|---|---|---|
| Tenant | Top 10 as % NOI | <50% | ||
| Tenant | HHI | <0.10 | ||
| Geographic | Top 3 MSA as % GAV | <50% | ||
| Geographic | HHI | <0.15 | ||
| Property Type | Largest Type as % GAV | <30% | ||
| Vintage | Largest 2-yr Window as % GAV | <40% | ||
| Lease Maturity | Max Single-Year Rollover | <20% | ||
| Single Asset | Largest as % GAV | <10% |
Step 12: Stress Tests
| Scenario | Portfolio NOI Impact | Portfolio Value Impact | DSCR Impact |
|---|---|---|---|
| Top Tenant Default | |||
| Top 3 Tenants Default | |||
| Sector Downturn (-20% on worst type) | |||
| Top MSA Recession | |||
| Largest Asset Total Loss |
Output Format
- Current Portfolio Allocation -- four sub-tables (type, geography, risk, vintage) with % GAV and % NOI
- Concentration Dashboard -- green/yellow/red status on 8 dimensions
- NCREIF Benchmark Comparison -- portfolio weight vs. NPI weight by property type
- Stress Test Results -- five scenarios with NOI, value, and DSCR impact
- Rebalancing Execution Plan -- multi-year timeline with transaction costs
- Disposition Candidate Ranking -- with tax efficiency route
- Acquisition Target Criteria -- with allocation impact
- Risk Impact Analysis -- portfolio volatility, diversification ratio, Sharpe ratio before/after rebalancing
- Recommended Actions -- prioritized bullet list pairing every concentration flag with remediation strategy
Red Flags and Failure Modes
- Rebalancing when gap < 5% of GAV: transaction costs destroy the benefit. Only act on material overweights.
- Using NCREIF weights as targets without thesis adjustment: NCREIF is backward-looking market-cap. Active managers must have a view.
- Ignoring vintage concentration: the most overlooked dimension. Peak-pricing vintages cluster losses.
- Selling based on asset liquidity rather than portfolio optimization: sell what the portfolio needs to lose, not what is easiest to sell.
- Counting diversification by property count instead of exposure share: 10 properties in 4 FL cities is not geographic diversification.
- Hidden industry concentration: two different tenant names in the same industry are correlated. Look behind the names.
- Appraisal lag in downturns: reported GAV may overstate actual value. Real concentration is worse than reported.
Chain Notes
- Upstream: deal-underwriting-assistant (property-level data), market-memo-generator (MSA-level data for geographic decisions)
- Downstream: ic-memo-generator (allocation impact statement), loi-offer-builder (acquisition targets from underweight positions), performance-attribution (portfolio returns feed vintage attribution), quarterly-investor-update (allocation and concentration data for LP reporting)
- Peer: 1031-exchange-executor (tax-efficient rebalancing), disposition-strategy (disposition candidate list)