Returns-based, holdings-based and transactions-based attribution

Returns-based, holdings-based and transactions-based attribution

Published September 28, 2026

Returns-based, holdings-based and transactions-based attribution

On this page

Learning Outcome Statement

Describe returns-based, holdings-based, and transactions-based performance attribution, including advantages and disadvantages of each.

On the exam: You get a manager-and-benchmark case or method descriptions and must compare the three approaches, including advantages and disadvantages. The response may also require a short holdings-based active-return reconciliation.

Your first decision is not a formula. It is a data decision. The record available to you controls how directly the result can be tied to a manager action.

ApproachData usedTrade-off
Returns-basedPortfolio and benchmark returnsFast and inexpensive, but exposures are inferred
Holdings-basedPortfolio and benchmark holdingsTransparent, but timing can be missed
Transactions-basedHoldings, trades, and cash flowsTiming captured, but complete, accurate records required

Returns-based methods can work when holdings are unavailable, but return patterns can fit several exposures. Holdings-based methods show what the portfolio and benchmark held at measurement dates, while transactions-based methods improve treatment of trading timing and cash flows but require complete, accurate transaction records.

The arithmetic reconciliation below is the holdings-based approach. It uses beginning-of-period portfolio and benchmark weights, group returns, and a gross-of-fees convention.

For the reconciliation, use this notation.

SymbolDefinition
$i$Group index
$w_{p,i}$Portfolio weight in group $i$
$w_{b,i}$Benchmark weight in group $i$
$r_{p,i}$Portfolio return for group $i$
$r_{b,i}$Benchmark return for group $i$
$R_p$Total portfolio return
$R_b$Total benchmark return

The difference $w_{p,i}-w_{b,i}$ is the active weight. The difference $r_{p,i}-r_{b,i}$ is the group return spread. The formula below decomposes active return into allocation, selection, and interaction effects.

$$ \text{Active return} = \sum_i \left[(w_{p,i}-w_{b,i})(r_{b,i}-R_b) + w_{b,i}(r_{p,i}-r_{b,i}) + (w_{p,i}-w_{b,i})(r_{p,i}-r_{b,i})\right] $$

Read the products from left to right as allocation, selection, and interaction. Allocation is positive when the active weight and benchmark relative return share a sign, while selection uses the benchmark weight to scale the group return spread. Interaction is the joint product of active weight and that spread. The three effects add to $R_p-R_b$ under this one-period arithmetic convention.

MeasureInputsOutput
ContributionPortfolio weight and portfolio returnPortfolio's own return
AttributionPortfolio and benchmark returnsActive return

A contribution can sum to the portfolio's own return, but it is not the benchmark-relative reconciliation. For the benchmark-relative question, trace each effect to the pair of quantities that creates it. Allocation asks whether the portfolio held more or less than the benchmark in groups that beat or lagged the benchmark overall. Selection asks whether each group beat its own benchmark group, scaled by the benchmark's weight. Interaction captures the combined consequence of changing both weight and return. Keeping those drivers distinct helps explain a result instead of merely reporting its total.

EffectFormula termDriver pair
Allocation$(w_{p,i}-w_{b,i})(r_{b,i}-R_b)$Active weight, benchmark relative return
Selection$w_{b,i}(r_{p,i}-r_{b,i})$Benchmark weight, group return spread
Interaction$(w_{p,i}-w_{b,i})(r_{p,i}-r_{b,i})$Active weight, group return spread

Under this arithmetic convention, add the effect totals to the benchmark return to reach the portfolio return. This bridge is useful only when the inputs and convention are stated consistently. A return pattern can suggest exposures, but it cannot show precisely what the portfolio held on a date. Holdings provide that snapshot, though they may miss trading that happened between measurement dates. Transaction records add that timing detail and the associated cash flows. The extra detail improves the account of manager activity only when the underlying records are complete and accurate, so match the method to evidence the analyst can defend.

Choose the richest path the records support, not a more detailed path than the records can defend. The image summarizes how the three methods rely on increasingly detailed records, while the decision path below turns that comparison into a practical choice. Start with what is actually available: returns alone support an inferred exposure analysis; holdings permit a more direct comparison at recorded dates; and trades with cash flows allow trading timing to enter the analysis. More data does not remove the need to check its quality. If transaction records are incomplete, the apparent precision of a transactions-based result can be misleading. State the limitation along with the result.

Loading diagram…

Worked example

You are handed a one-period equity portfolio and benchmark split between groups A and B. The investment committee wants to know whether the portfolio's active return came from allocation, selection, or interaction. Use beginning-of-period weights, one-period arithmetic attribution, and gross-of-fees returns.

InputValue
Benchmark weights$w_{b,A}=0.5$, $w_{b,B}=0.5$
Portfolio weights$w_{p,A}=0.6$, $w_{p,B}=0.4$
Benchmark returns$r_{b,A}=0.1$, $r_{b,B}=0.06$
Portfolio returns$r_{p,A}=0.12$, $r_{p,B}=0.07$

The bars are cumulative stages, so the bridge starts at the benchmark return and ends at the portfolio return. Before reading the chart, keep the distinction between each stage's incremental effect and its cumulative level in view. The benchmark is the starting point, allocation moves that base by 0.0040, selection adds another 0.0150, and interaction contributes the final 0.0010. The last bar therefore shows the portfolio return, while the three changes together explain the active return. This ordering makes it easier to audit the arithmetic and identify which driver matters most in this example.

Loading diagram…
StageChangeCumulative return
BenchmarkBase0.0800
Allocation0.00400.0840
Selection0.01500.0990
Interaction0.00100.1000
  1. Build the benchmark total first because allocation uses it as the reference. The benchmark return is $R_b=0.5 \times 0.1+0.5 \times 0.06=0.0800$.
  2. Build the portfolio total and active return so the effects have a reconciliation target. The portfolio return is $R_p=0.6 \times 0.12+0.4 \times 0.07=0.1000$, and active return is $R_p-R_b=0.1000-0.0800=0.0200$.
  3. Calculate the active weights and return spreads because each effect is a product of these drivers. The outputs are $w_{p,A}-w_{b,A}=0.1000$, $w_{p,B}-w_{b,B}=-0.1000$, $r_{b,A}-R_b=0.0200$, $r_{b,B}-R_b=-0.0200$, $r_{p,A}-r_{b,A}=0.0200$, and $r_{p,B}-r_{b,B}=0.0100$.
  4. Multiply the paired drivers and keep the effects separate for the committee. Allocation is $0.1000 \times 0.0200+(-0.1000) \times (-0.0200)=0.0040$. Selection is $0.5 \times 0.0200+0.5 \times 0.0100=0.0150$. Interaction is $0.1000 \times 0.0200+(-0.1000) \times 0.0100=0.0010$.
  5. Reconcile the effects as an audit check. The total is $0.0040+0.0150+0.0010=0.0200$, matching $R_p-R_b$.

The committee should record portfolio return $0.1000$ against benchmark return $0.0800$, giving active return $0.0200$ led by selection at $0.0150$, while treating the outcome as evidence about this period rather than proof of persistent manager skill.

Changed condition

Keep every weight and benchmark return unchanged. Group A's portfolio return falls from 0.12 to 0.1. Predict the new active-return reconciliation before recalculating.

MeasureBeforeAfter
Group A portfolio return0.120.1
Selection effect0.01500.0050
Interaction effect0.0010-0.0010

Your prediction should be that allocation stays at 0.0040 because weights and benchmark returns did not move. Selection falls from 0.0150 to 0.0050 because group A's return now matches its benchmark return. Interaction moves from 0.0010 to -0.0010 because group A's spread disappears while group B's interaction remains -0.0010. The portfolio return becomes 0.0880, so active return falls from 0.0200 to 0.0080. Before reading on, recompute the changed interaction effect from the group-level inputs yourself.

Common error

You may see a sector's return contribution in your portfolio and call it an attribution effect. That feels right because the sector added to your portfolio's own return. The distinction is that contribution uses the portfolio weight and portfolio return, while attribution analysis explains your active return relative to the benchmark and must reconcile under the stated convention.

Go deeper

Arithmetic attribution adds the effects within the stated period. A geometric attribution links periods through compounding, so its effects should not be inserted into this additive reconciliation. Keep the gross or net label consistent across the portfolio return, benchmark return, and effects.

Check yourself

Practice

describe

Describe the best attribution approach when holdings, trades, and cash flows are complete, and identify its main disadvantage.

Which statement best distinguishes contribution from attribution?

Revision snapshot

The holdings-based arithmetic formula is below.

$$ R_p-R_b=\sum_i\left[(w_{p,i}-w_{b,i})(r_{b,i}-R_b)+w_{b,i}(r_{p,i}-r_{b,i})+(w_{p,i}-w_{b,i})(r_{p,i}-r_{b,i})\right] $$

Returns-based attribution infers exposures from return patterns. Holdings-based attribution uses portfolio and benchmark holdings. Transactions-based attribution uses holdings plus trades and cash flows. Holdings-based attribution commonly decomposes active return into allocation, selection, and interaction effects under a stated arithmetic convention. Attribution explains active return relative to a benchmark. Contribution is the portfolio's own return contribution and is not the same measure. Transactions-based attribution improves treatment of trading timing and cash flows but requires complete, accurate transaction records. On the exam, name the data used and its trade-off, state the convention, and check the reconciliation. One strong attribution period is evidence about that period, not proof of persistent manager skill.

Unlock the full lesson and continue reading

Signup to continue reading this lesson and unlimited access questions, flashcards, AI notes, and more

Scan to download app

Scan to download
UNLOCK FREE ACCESS

Practice Questions: Returns-based, holdings-based and transactions-based attribution

  1. 1. A portfolio earned a cumulative time-weighted return of 12.00% over 18 months. The calculated annualized return is closest to:

    • A. 7.85%
    • B. 8.00%
    • C. 12.00%
    Show answer

    Answer: A. 7.85%

    > Key point: Annualize a cumulative return by raising its growth factor to 12 divided by the number of months, then subtracting 1. Why 7.85% is correct - The 18-month growth factor is 1 + 0.12 = 1.12. - Annualizing gives 1.12^(12/18) − 1 ≈ 7.85%. Working | Step | Working | Result | |---|---|---| | Growth factor | 1 + 12.00% | 1.12 | | Annualize | 1.12^(12/18) − 1 | 7.85% | Answer: 7.85% Why the other options are wrong - 8.00%: Multiplying 12.00% by 12/18 annualizes arithmetically and ignores compounding. - 12.00%: This is the cumulative return over 18 months, not the annualized return.

  2. 2. An asset manager markets one pooled fund as “GIPS compliant,” although the manager does not claim firm-wide compliance. Which conclusion is most accurate?

    • A. The firm's compliance claim applies only to the pooled fund
    • B. The pooled fund may claim compliance independently of the firm
    • C. The firm must claim compliance on a firm-wide basis
    Show answer

    Answer: C. The firm must claim compliance on a firm-wide basis

    > Key point: GIPS compliance is claimed by the investment management firm on a firm-wide basis, not by an individual pooled fund. Why the firm must claim compliance on a firm-wide basis is correct - The firm—not an individual product—makes the GIPS compliance claim. - A firm cannot limit its claim to one pooled fund while leaving the rest of the firm outside it. Why the other options are wrong - The firm's compliance claim applies only to the pooled fund: GIPS compliance cannot be claimed for only one fund. - The pooled fund may claim compliance independently of the firm: A pooled fund cannot make an independent GIPS compliance claim.

  3. 3. Meridian Asset Consulting is reviewing the annual performance of a US small-cap equity fund for a pension client. The fund is managed against a broad US total-market index, although its investment mandate permits only securities within the US small-cap opportunity set. The pension committee wants performance measurement to reflect the manager's investment decisions rather than the timing of contributions determined by the plan sponsor. The sponsor made one external contribution during the year. The fund was valued immediately before the contribution, and no other external cash flows occurred. Exhibit 1 provides all values needed to calculate the annual return. Returns are not affected by taxes, and the fund values are after transaction costs but before investment management fees. The consultant also conducts a sector attribution analysis using beginning-of-period weights. Exhibit 2 reports sector weights and returns for both the fund and its current benchmark. The consultant uses the Brinson–Fachler model, under which allocation is measured relative to the total benchmark return. Selection and interaction effects are reported separately. During a committee meeting, one trustee argues that the current broad-market index should be retained because it is widely recognized. Another trustee proposes using the median return of a database of small-cap managers. The consultant notes that the database median cannot be purchased or replicated and is affected by changes in the managers included in the database. The consultant instead considers an investable index representing the securities available under the fund mandate. Finally, the committee asks whether the manager has generated active return through security-specific skill after controlling for systematic factor exposures. Exhibit 3 reports the fund's annualized active return, tracking error, and residual risk. The consultant explains that the information ratio uses tracking error, whereas the appraisal ratio uses residual risk. All risk measures were estimated over the same period as the annualized active return.

    • 4. A firm has a discretionary, fee-paying portfolio that has not been included in any of its composites. Under the GIPS standards, the firm should most likely:

      • A. Include the portfolio in at least one composite
      • B. Exclude the portfolio if it is immaterial to firm assets
      • C. Report the portfolio's performance separately outside any composite
      Show answer

      Answer: A. Include the portfolio in at least one composite

      > Key point: Every fee-paying discretionary portfolio must be included in at least one composite. Why Include the portfolio in at least one composite is correct - GIPS requires the firm to include this portfolio in a composite; its discretionary, fee-paying status meets the stated requirement. - Including it helps prevent selective reporting of favorable performance. Why the other options are wrong - Exclude the portfolio if it is immaterial to firm assets: Immateriality does not exempt a fee-paying discretionary portfolio from inclusion. - Report the portfolio's performance separately outside any composite: Separate reporting does not replace the requirement to include it in at least one composite.

    • 5. A portfolio earns a cumulative return of 21.00% over two years. The calculated annualized geometric return is closest to:

      • A. 9.53%
      • B. 10.00%
      • C. 10.50%
      Show answer

      Answer: B. 10.00%

      > Key point: Annualized geometric return is the per-year rate that compounds to the cumulative return. Why 10.00% is correct - Convert the cumulative return to an ending wealth factor: 1 + 0.21 = 1.21. - Take the two-year root and subtract 1: √1.21 − 1 = 0.10, or 10.00%. Working | Step | Working | Result | |---|---|---| | Ending wealth factor | 1 + 21.00% | 1.21 | | Annualized return | 1.21^(1/2) − 1 | 10.00% | Answer: 10.00% Why the other options are wrong - 9.53%: This is the continuously compounded annual rate, ln(1.21) ÷ 2, not the effective annual geometric return. - 10.50%: Dividing 21.00% by two ignores compounding; at 10.50% annually, the two-year wealth factor is 1.105² = 1.221025, not 1.21.

    • 6. An evaluator should most likely emphasize a time-weighted return when which condition applies?

      • A. External cash flows are controlled by the client
      • B. Portfolio valuations are available only at year-end
      • C. The manager determines all contribution dates
      Show answer

      Answer: A. External cash flows are controlled by the client

      > Key point: Emphasize time-weighted return when the client controls external cash-flow timing, so the measure isolates the manager’s performance. Why external cash flows are controlled by the client is correct - Time-weighted return removes the effect of external cash-flow timing by linking returns between flows. - When the client controls those flows, this helps evaluate the manager without attributing client decisions to the manager. How they compare | Condition | Why it matters | |---|---| | Client controls external cash flows | Time-weighting reduces the effect of client-controlled timing. | | Portfolio valuations only at year-end | Missing valuations at cash-flow dates impedes accurate time-weighting. | | Manager determines contribution dates | Contribution timing is the manager’s decision; money-weighted return reflects its impact. | Why the other options are wrong - Portfolio valuations are available only at year-end: Without valuations at external cash-flow dates, returns between flows cannot be accurately linked. - The manager determines all contribution dates: This timing reflects manager decisions, rather than an external effect to remove.

    • 7. Northbridge Pension Plan is reviewing the performance of an externally managed domestic equity fund. The investment policy statement gives the manager discretion to select securities from the domestic mid-cap value universe. The manager is not responsible for determining the timing or amount of contributions and withdrawals initiated by the plan sponsor. Accordingly, the investment committee wants a return measure that isolates the manager's investment decisions from sponsor-controlled external cash flows. During the most recent quarter, the sponsor made a large contribution immediately after the portfolio was valued at the end of Month 1. Exhibit 1 provides the valuations and cash-flow timing. All portfolio values are stated after investment management fees except where otherwise indicated, and no other external cash flows occurred during the quarter. The committee asks its performance analyst to calculate the quarter's time-weighted return by valuing the portfolio at the time of the external cash flow and geometrically linking the resulting subperiod returns. The analyst also performs sector attribution. Exhibit 2 contains the complete portfolio and benchmark sector data; there were no other sectors. The analyst uses the Brinson–Fachler framework, under which each sector's allocation effect is calculated as the difference between portfolio and benchmark sector weights multiplied by the difference between that sector's benchmark return and the total benchmark return. Selection and interaction effects are calculated separately. The committee next reviews annualized statistics in Exhibit 3. One member states that the information ratio should use the fund's total standard deviation because this measure captures all uncertainty experienced by beneficiaries. The analyst responds that the appropriate denominator depends on whether performance is assessed relative to the risk-free asset or relative to the designated benchmark. Finally, the committee questions whether its current broad domestic equity benchmark remains appropriate. The manager's mandate has consistently required investment in domestic mid-cap value securities, and the manager has not used large-cap or growth securities as strategic allocations. Investable, rules-based broad-market, large-cap value, and mid-cap value indices are all available, transparent, and measurable. The committee wants the benchmark that provides the most valid assessment of decisions within the manager's assigned opportunity set.

      Flashcards: Returns-based, holdings-based and transactions-based attribution

      1. 1. Capture Ratios

        Show answer

        Upside capture = portfolio return / benchmark return\ Downside capture = portfolio return / benchmark return Capture Ratios = upside capture / downside capture

      2. 2. Benchmark Properties

        Show answer

        - Specified in advance - Appropriate - Measurable - Unambiguous with clearly defined securities and weights - Reflective of the manager's current investment opinions - Accountable: manager and client agree it is applicable - Investable SAMURAI

      3. 3. The M2 Measure

        Show answer

        Average incremental return over a market index of a hypothetical portfolio that is created by combining the account with borrowing or lending at Rf. Measure the value added or lost relative to the market if the portfolio had the same risk

      4. 4. Hedge Fund Index Issues

        Show answer

        - Biases in index creation - Value weighted often become skewed to best performer - Relevance of past data - Survivorship bias - Stale price bias - Backfill bias

      5. 5. Information Ratio

      6. 6. Performance Attribution

        Show answer

        - Macro Attribution - Conducted at the fund sponsor level - Micro Attribution - Carried out at the investment manager level

      7. 7. Fixed-Income Attribution

        Show answer

        Factors that contribute to the total return of a fixed income portfolio are the External IR Effect and the Management Effect. External IR Effect - Is estimated using term structure analysis - Manager has no control over external IR environment - Can be seperate into expected (forward curve) and unexpected (what actually happened) Management Effect - Interest rate management effect - Sector/quality management effect - Security-selection effect - Trading effect

      8. 8. Validity of Using Manager Universes as Benchmarks

        Show answer

        Finishing in the top half of all managers in the same style might be a good performance objective, it has a number of drawbacks as a benchmark: - Apart from being measurable it fails all of the other properties of a valid benchmark - Have to rely on compiler's classifications - Subject to survivor bias

      9. 9. Portfolio Return Components

        Show answer

        A portfolio can be broken up into three components: Market, Style and Active Management P = M + S + A S = B - M\ A = P - B

      10. 10. Performance Data Quality Issues

        Show answer

        - Price of illiquid and infrequently priced assets generally not reliable in nature - Matrix pricing often used for thinly traded fixed income (price based on similar) - Account should be valued on trade date rather than settlement

      Everything you need for CFA prep

      Get full Oncourse access with lessons, practice questions, flashcards and AI study tools.

      GET STARTED FOR FREE
      75% OFFLimited time offer
      GET 75% OFF