Commercial Real Estate Portfolio Analysis & Optimization
Analyze & optimize commercial real estate portfolios with financial modeling and risk assessment
What You Can Do
You can ingest multi-property portfolio data and generate comprehensive financial diagnostics, including performance metrics, peer benchmarking, concentration risk analysis, and stress-test scenarios across economic conditions. Claude systematizes the analysis of 10-500+ heterogeneous assets (varying property types, leverage, lease structures, and markets) to identify underperformers, quantify rebalancing impact, and deliver executive summaries with specific buy/sell/hold recommendations backed by financial modeling.
Features
IRR, total return, cash-on-cash, levered/unlevered yields across property cohorts
tenant exposure, market concentration, leverage ratios, and single-asset risk contribution
compare portfolio and individual assets against NCREIF, REIT indices, and peer fund returns
model portfolio performance under interest rate shocks, cap rate expansion, vacancy increases, and economic downturns
evaluate candidate deals against existing holdings using quantified impact on portfolio metrics and risk profile
generate allocation adjustments across asset classes, geographies, or strategies with financial justification
flag assets underperforming on total return, cash flow, or relative value metrics with repositioning options
synthesize complex multi-asset analysis into board/LP-ready reports with clear recommendations and financial impact
Example Output
Portfolio Review Summary:
- Aggregate Portfolio: $850M AUM, 47 assets, 8.2% unlevered IRR, 12.4% levered IRR
- Sector Performance: Office -120 bps vs. NCREIF; Multifamily +85 bps; Industrial +45 bps
- Top Risk: Single tenant (Amazon) represents 12.3% of NOI; recommended maximum 8%
- Stress Test (cap rate +150 bps): Portfolio IRR declines to 6.1%; disposition of 3 secondary market assets recommended
- Disposition Candidates: 2 core-plus office assets generating 4.2% returns; replace with industrial assets in supply-constrained markets
- Rebalancing Impact: Shift $120M from office to industrial reduces concentration risk and increases expected return 60 bps
Individual Asset Example:
- Property: Class B Office, Denver
- Current Performance: 5.8% unlevered IRR, $2.1M annual NOI
- Benchmark: 7.2% (NCREIF Denver Office)
- Gap Analysis: Lease-up delay (88% vs. 95% market), below-market rent roll
- Recommendation: HOLD with active lease-up; project achievement of market rent within 18 months (+140 bps return improvement)
What's Included
- SKILL.md instruction file with portfolio analysis framework and workflows:
- Portfolio data template (Excel-compatible) for property-level inputs (address, type, basis, NOI, debt, cap rate, tenant mix):
- Financial metrics calculator: formulas for IRR, total return, leverage ratios, and peer benchmarking
- Risk assessment checklist: concentration thresholds, tenant exposure analysis, geographic diversification targets
- Stress-test scenario matrix: interest rate, cap rate, and vacancy sensitivity templates
- Executive summary template: board/LP reporting framework with visual highlights for key findings and recommendations
Who It's For
- Real Estate Investment Analysts managing institutional or fund portfolios (10-500+ assets)
- Portfolio Managers conducting quarterly or annual reviews for board/LP reporting
- Real Estate Investment Committee members evaluating acquisition/disposition decisions
- Asset Managers identifying rebalancing opportunities and concentration risk
- CFOs or Treasurers overseeing real estate allocation within diversified institutional portfolios
Best For
- Quarterly/annual portfolio performance reviews and diagnostics
- Acquisition or disposition evaluation against existing holdings
- Portfolio rebalancing across asset classes, geographies, or risk profiles
- Concentration risk analysis and stress-testing under economic scenarios
- Benchmarking performance vs. peer funds, REITs, and NCREIF indices
- Identifying underperforming assets and repositioning recommendations
You might also like
You'll architect backtesting systems that separate genuinely profitable strategies from curve-fitted fantasies. The skill guides you through modeling realistic market microstructure, accounting for transaction costs, detecting survivorship bias, and stress-testing strategies across regime changes. You'll implement walk-forward validation, out-of-sample testing, and Monte Carlo simulations to predict actual live performance and identify where backtest results diverge from real trading outcomes.
by fission
You can systematically evaluate real estate acquisition opportunities by inputting property financials, market data, and deal terms into a standardized framework. The skill analyzes cap rates, cash flow projections, market fundamentals, and risk factors to generate consistent, comparable metrics across multiple deals. This enables you to quickly identify investment-worthy opportunities versus deals that fail fundamental criteria, while documenting your investment thesis for compliance and portfolio tracking.
by fission
You can map individual holdings against multiple thematic investment frameworks simultaneously, generating transparency-rich alignment scores that reveal true thematic exposure. Unlike traditional ESG screening, this skill identifies positive exposure to specific trends and solutions, helping you track portfolio concentration within thematic segments, detect misaligned holdings, and quantify drift from stated investment mandates with measurable impact metrics.
by fission
You'll construct sophisticated DCF models that treat each clinical asset as a branching probability tree, weighting revenue contributions by phase-specific success rates (Phase I: 30%, Phase II: 33%, Phase III: 25-30%, FDA approval: 80-90%). This approach replaces deterministic sales projections with realistic scenario ranges, enabling you to value pre-revenue or early-revenue biotechs by their pipeline potential, regulatory trajectory, and time-to-market dynamics. The skill guides you through setting risk-adjusted discount rates (10-15% above pharma majors) and conducting sensitivity analyses that institutional investors expect.
by fission
You can rapidly evaluate multiple financing structures for M&A, recapitalizations, and growth transactions by modeling different capital stack configurations and comparing them against recent comparable transaction benchmarks. The skill helps you assess debt capacity, analyze covenant headroom across downside scenarios, and stress-test leverage under EBITDA decline, capex disruption, and refinancing risk—enabling you to present optimized structures that balance cost of capital, covenant flexibility, and stakeholder requirements in client presentations and pitch books.
by fission
You can systematically evaluate corporate bond issuers by synthesizing quantitative metrics (leverage ratios, cash flow coverage, liquidity), qualitative factors (management quality, competitive positioning, covenant protections), and market signals (credit spreads, relative value) into a cohesive credit opinion. This framework enables you to construct ratings that withstand peer review, document credit theses for investment committees, and respond to market events with quantified analytical support.
by fission
You can design and execute comprehensive ESG screening across equity and fixed income universes using customizable criteria, weighted scoring models, and tiered filtering processes. The framework converts mission-driven sustainability objectives into defensible, repeatable, auditable screening methodologies that integrate both negative screens (exclusions) and positive screens (inclusions/preferences), eliminating unsuitable candidates and prioritizing those warranting further due diligence.
by fission
You can systematically analyze complex alternative fund portfolios by decomposing returns into alpha, beta, and fee components, then benchmark manager performance against peers. The skill processes manager letters, fund documents, and performance data to identify risk sources, flag operational red flags, and generate standardized due diligence matrices that support investment committee decisions across hedge funds, private equity, infrastructure, and real assets.
by fission