Commercial Property Portfolio Valuation Engine
Value commercial property portfolios using income capitalization and comparable sales analysis
What You Can Do
You can apply multiple valuation methodologies—income capitalization, comparable sales analysis, and discounted cash flow models—to establish defensible valuations across diverse commercial property types. The skill normalizes financial statements across your portfolio, identifies over/undervalued assets relative to market benchmarks, stress-tests portfolio resilience under various market scenarios, and generates institutional-grade valuation reports with transparent assumptions and sensitivity analysis to guide disposition planning and capital allocation decisions.
Features
Calculate NOI-based valuations using market-appropriate cap rates and normalize rental income across properties with different lease structures
Benchmark portfolio properties against recent transactions and market comps to validate valuations and identify relative market positioning
Consolidate individual property valuations into portfolio-level summaries with asset-class breakdowns and concentration analysis
Model portfolio value under market downturns, interest rate changes, and cap rate expansion scenarios
Estimate probable exit values, rank assets by strategic fit, and quantify impact of selling specific properties on portfolio composition
Standardize operating statements across diverse properties to ensure apples-to-apples comparability and identify performance outliers
Compare individual asset yields and multiples against sector indices and peer fund performance to validate investment thesis
Generate defensible valuation summaries with assumption transparency, confidence levels, and audit-trail documentation
Example Output
Example 1: Portfolio Valuation Summary
Oakland Mixed-Use Portfolio (8 assets, $287M estimated value):
- Office: $92M (32%) | Cap Rate: 4.8% | Risk: Moderate
- Retail: $68M (24%) | Cap Rate: 5.2% | Risk: Moderate-High
- Industrial: $127M (44%) | Cap Rate: 4.1% | Risk: Low
Disposition Recommendation: Sell underperforming retail asset (5.8% NOI yield vs. 5.2% market) to redeploy $68M into industrial (4.1% cap rate justified by 7-year avg 3.2% annual appreciation).
Example 2: Stress Test Results
Base Case Portfolio Value: $287M | NOI: $14.2M | Weighted Avg Cap Rate: 4.95%
Downside Scenario (200 bps cap rate expansion):
- Estimated Value: $261M (-$26M / -9%)
- Most Exposed: Office assets (valuation decline 12%)
- Recommendations: Consider fixed-rate debt lock-in; prioritize office disposition
Example 3: Comparable Sales Validation
Property: 450 Market St Office Tower | Management Est. Value: $58M
- Recent Comps (6-month avg): $62M (avg NOI multiple: 16.8x)
- Your NOI: $3.2M | Implied Value: $53.8M
- Assessment: Slightly undervalued vs. comps; hold for 12-18 months or negotiate 5-8% premium if selling now
What's Included
- SKILL.md instruction file with valuation framework and use-case triggers:
- Portfolio Valuation Template: Excel-ready workbook for income cap, comp analysis, and aggregation across 20+ property fields
- NOI Normalization Checklist: Standardized worksheet to adjust for one-time expenses, below-market rents, and capital needs
- Stress Test Matrix: Scenario builder for cap rate, rental growth, and exit timing sensitivity
- Disposition Ranking Framework: Scorecard to rank assets by strategic fit, relative valuation, and exit probability
- Institutional Report Generator: Markdown template for LP-ready valuation summaries with assumption transparency and confidence intervals
Who It's For
- Real estate investment analysts managing multi-property commercial portfolios for funds, REITs, or institutional investors
- Asset managers preparing portfolio valuations for LP reporting, refinancing, or strategic reviews
- Acquisitions managers validating market-rate valuations during property underwriting and post-acquisition reviews
- Capital allocators deciding whether to hold, sell, or redeploy portfolio assets based on relative valuation and risk
- Portfolio strategists stress-testing asset concentration and optimizing sector/geography exposure
Best For
- Valuing diverse multi-property portfolios (office, retail, industrial, multifamily) using income and market approaches
- Identifying over/undervalued assets relative to market benchmarks and peer performance
- Modeling disposition impacts and ranking assets for strategic sale or hold decisions
- Stress-testing portfolio resilience under rising cap rates, economic downturns, and lease rollover scenarios
- Generating institutional-grade valuation reports with transparent assumptions for LP reporting and lender presentations
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 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.
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