Claude
Skills
Sign in
Back

performance-reporting

Included with Lifetime
$97 forever

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.

Data & Analyticsscripts

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