performance-reporting
Generate clear, accurate performance reports for investment portfolios with benchmarks, attribution, and risk dashboards. Use when the user asks about portfolio performance reports, return summaries, benchmark comparison, risk dashboards, goal progress tracking, or GIPS-compliant reporting. Also trigger when users mention 'quarterly report', 'how did my portfolio do', 'time-weighted vs money-weighted return', 'annualized returns', 'net-of-fee performance', 'rolling Sharpe', or ask how to present investment results to clients.
What this skill does
# Performance Reporting — Reporting & Communication ## Purpose Generate clear, accurate, and contextually rich performance reports for investment portfolios. This skill covers return calculation and presentation, benchmark comparison, attribution analysis, risk dashboards, goal progress tracking, and visualization best practices — all with an emphasis on honest, plain-language communication that serves the reader. ## Layer 8 — Reporting & Communication ## Direction retrospective ## When to Use - Creating portfolio performance reports (monthly, quarterly, annual) - Summarizing investment returns across multiple time periods - Comparing portfolio performance to appropriate benchmarks - Presenting attribution analysis (what drove returns) - Building risk dashboards with current and rolling metrics - Tracking progress toward financial goals (retirement, education, etc.) - Designing charts and visualizations for investment reporting - Translating quantitative results into plain-language summaries for clients ## Core Concepts ### Return Reporting Accurate and consistent return calculation is the foundation of all performance reporting. **Period returns:** Report standard time periods — MTD (month-to-date), QTD (quarter-to-date), YTD (year-to-date), 1Y, 3Y, 5Y, 10Y, and since inception. Always state the exact inception date. **Cumulative vs annualized:** Annualize returns only for periods greater than 1 year. Annualizing a 3-month return is misleading because it implies the rate is sustainable for a full year. For periods under 1 year, report cumulative (total) returns only. - Annualized return formula: `(1 + cumulative_return)^(1/years) - 1` - For multi-year periods, always present both cumulative and annualized figures so the reader can see total wealth growth and the rate of compounding. **Gross vs net of fees:** Always specify whether returns are gross or net of management fees, advisory fees, and transaction costs. Net-of-fee returns are what the investor actually experiences and should be the primary presentation. If showing gross returns, also show the fee drag. **GIPS (Global Investment Performance Standards):** For institutional reporting, follow GIPS requirements — composite construction, full disclosure, verified calculations, and standardized presentation. Even for non-GIPS reports, the principles of fair representation and full disclosure apply. **Time-weighted vs money-weighted returns:** - Time-weighted return (TWR) removes the impact of cash flows — use for evaluating the investment manager's skill. - Money-weighted return (MWR / IRR) reflects the investor's actual experience including timing of contributions and withdrawals — use for evaluating the investor's outcome. ### Benchmark Comparison A return number in isolation is meaningless. Context requires a benchmark. **Appropriate benchmark selection:** The benchmark must match the portfolio's investment style, geography, capitalization, and asset class mix. A US large-cap equity portfolio should be compared to the S&P 500 or Russell 1000, not the MSCI Emerging Markets Index. - For multi-asset portfolios, use a blended benchmark (e.g., 60% S&P 500 / 40% Bloomberg Aggregate). - The benchmark should be investable — the investor could have held it as a passive alternative. - Document the benchmark rationale and keep it consistent over time to avoid cherry-picking. **Active return (alpha):** Portfolio return minus benchmark return. Positive alpha indicates outperformance; negative alpha indicates underperformance. **Tracking error:** The standard deviation of active returns (portfolio return minus benchmark return) over time. Measures the consistency of active management. **Information ratio:** Alpha divided by tracking error. Measures the efficiency of active management — how much excess return is generated per unit of active risk. An IR above 0.5 is generally considered good; above 1.0 is exceptional. ### Risk Dashboard Complement return reporting with risk metrics to give a complete picture. **Current snapshot metrics:** - Annualized volatility (standard deviation of returns) - Maximum drawdown (peak-to-trough decline) and current drawdown - Value at Risk (VaR) at 95% and 99% confidence levels - Beta relative to the benchmark **Rolling metrics:** Show how risk evolves over time, not just a point-in-time estimate. - 12-month rolling Sharpe ratio - 12-month rolling volatility - 36-month rolling beta - Rolling drawdown chart **Risk exposure breakdown:** - Sector concentration and weights vs benchmark - Factor exposures (value, growth, momentum, quality, size) - Geographic allocation - Duration and credit quality (for fixed income) ### Attribution Summary Explain *why* the portfolio outperformed or underperformed. **Brinson attribution (allocation vs selection):** - Allocation effect: did the manager overweight sectors that performed well? - Selection effect: within each sector, did the manager pick better-performing securities? - Interaction effect: the combined impact of allocation and selection decisions. **Factor contribution decomposition:** Decompose returns into contributions from market beta, size, value, momentum, quality, and other factors. The residual is the manager's idiosyncratic alpha. **Top/bottom contributors (holdings-level):** - List the 5-10 holdings that contributed most positively and most negatively to portfolio returns. - Show both the return of the holding and its contribution to total portfolio return (weight x return). - Provide brief commentary on why each top/bottom contributor performed as it did. ### Goal Progress Tracking For goal-based investors, frame performance in terms of progress toward their specific objectives. **On-track assessment:** Is the portfolio on track, behind, or ahead relative to the financial plan? **Probability of success:** Use Monte Carlo simulation to estimate the probability of reaching the goal given current assets, savings rate, time horizon, and expected return/risk assumptions. Express as a percentage (e.g., "82% probability of funding retirement at age 65"). **Projected vs required return:** Compare the return needed to reach the goal with the expected return of the current portfolio. If the required return exceeds what is reasonable, flag this as a planning gap. **Milestone tracking:** Express progress as percentage of goal funded. For example: "Retirement goal: $2,000,000. Current portfolio: $850,000. 42.5% funded with 15 years remaining." ### Visualization Best Practices Charts communicate faster than tables. Choose the right chart for the message. **Growth of $10,000 chart:** Shows cumulative wealth growth of portfolio vs benchmark over time. Intuitive for all audiences. Use log scale for long time periods to avoid visual distortion from compounding. **Rolling return chart:** Shows trailing 12-month or 36-month returns over time. Reveals consistency and regime changes. More informative than a single annualized number. **Drawdown chart:** Shows peak-to-trough declines over time. Viscerally communicates risk in a way that volatility numbers cannot. **Asset allocation pie/bar chart:** Current allocation vs target/benchmark. Use a grouped bar chart to show both side by side. **Risk-return scatter plot:** Plot portfolio and benchmark (and possibly peer group) on an annualized return vs annualized volatility plane. Positions in the upper-left (high return, low risk) are desirable. ### Report Frequency and Structure - **Monthly brief:** 1-page summary — headline return, benchmark comparison, major attribution drivers, any notable events. - **Quarterly detailed:** 3-5 pages — full return table, attribution, risk dashboard, goal progress, market commentary, and outlook. - **Annual comprehensive:** 8-15 pages — everything in the quarterly report plus year-in-review, tax reporting summary, planning updates, and IPS review. ### Plain Language Communication The most important reporting skill is translat
Related in Data & Analytics
clawarr-suite
IncludedComprehensive management for self-hosted media stacks (Sonarr, Radarr, Lidarr, Readarr, Prowlarr, Bazarr, Overseerr, Plex, Tautulli, SABnzbd, Recyclarr, Unpackerr, Notifiarr, Maintainerr, Kometa, FlareSolverr). Deep library exploration, analytics, dashboard generation, content management, request handling, subtitle management, indexer control, download monitoring, quality profile sync, library cleanup automation, notification routing, collection/overlay management, and media tracker integration (Trakt, Letterboxd, Simkl).
querying-soql
IncludedSOQL query generation, optimization, and analysis with 100-point scoring. Use this skill when the user needs SOQL/SOSL authoring or optimization: natural-language-to-query generation, relationship queries, aggregates, query-plan analysis, and performance or safety improvements for Salesforce queries. TRIGGER when: user writes, optimizes, or debugs SOQL/SOSL queries, touches .soql files, or asks about relationship queries, aggregates, or query performance. DO NOT TRIGGER when: bulk data operations (use handling-sf-data), Apex DML logic (use generating-apex), or report/dashboard queries.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
habit-flow
IncludedAI-powered atomic habit tracker with natural language logging, streak tracking, smart reminders, and coaching. Use for creating habits, logging completions naturally ("I meditated today"), viewing progress, and getting personalized coaching.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
visualizing-data
IncludedBuilds dashboards, reports, and data-driven interfaces requiring charts, graphs, or visual analytics. Provides systematic framework for selecting appropriate visualizations based on data characteristics and analytical purpose. Includes 24+ visualization types organized by purpose (trends, comparisons, distributions, relationships, flows, hierarchies, geospatial), accessibility patterns (WCAG 2.1 AA compliance), colorblind-safe palettes, and performance optimization strategies. Use when creating visualizations, choosing chart types, displaying data graphically, or designing data interfaces.