Asset management revenue analysis: AUM, fees and mix

Asset management revenue analysis separates changes in average fee-bearing assets, strategy mix and realized fee rates. Match the fee and AUM periods, use each agreement's asset basis, and reconcile the result to recognized management fee revenue. A rising closing AUM balance alone does not prove that the quarter earned more fees.

Assemble matched fee and asset exports

Collect account ID, strategy, share class or mandate, currency, valuation date, eligible asset balance, fee schedule, billing period, waivers and recognized management fees. Retain account-to-strategy mappings for both periods. A strategy reclassification must not become a fictitious subscription or redemption.

The SEC's Form ADV Part 2, Item 5 calls for advisers to describe compensation, fee schedules, negotiability and billing frequency. Item 6 separately addresses performance-based fees. Those distinctions are practical reasons to preserve fee arrangements instead of dividing every revenue line by one AUM total.

Reconcile management fees to the general ledger, including accruals, credits and waivers. Separate performance fees and other revenue before building an asset-based bridge. Keep the same entities, currencies and gross-versus-net presentation in each period.

For the example below, all agreements use average fee-bearing assets and a quarterly factor of one fourth of the annual rate. Actual agreements may use a different valuation basis, day count or tier calculation; reproduce those terms rather than imposing this simplified formula.

Calculate the strategy revenue comparison

Quarterly management fee = Average fee-bearing AUM × Annual realized fee rate × Quarter factor

A fictional US asset manager reports the following two comparable quarters. All amounts are USD; annual fee rates are percentages. The quarter factor is 0.25 throughout.

Revenue increased by $16,700, or 10.4%, rounded to one decimal place. Average assets increased by $20,000,000. Neither number alone explains why the revenue change was smaller than an unchanged-rate, unchanged-mix expansion would produce.

Put the headers in row 1 and the two strategy rows in rows 2 and 3, using columns A through G. Prior fees in F2 and current fees in G2 are:

=B2*C2*0.25
=D2*E2*0.25

When fees come directly from an export named Fees, reconcile current fees by strategy with:

=SUMIFS(Fees[ManagementFee],Fees[Strategy],A2,Fees[Period],"Current")

Microsoft's SUMIFS documentation explains the criteria-based aggregation. Include account or fee-arrangement criteria when a strategy contains contracts with different billing bases.

Separate asset level, strategy mix and rates

Use a stated order: change total average assets first, strategy weights second and realized rates last. Hold the quarter factor constant. This assigns interactions consistently and gives an exact bridge.

The asset-level step scales both prior strategies by the change in total average AUM. At the prior weights, current total assets would allocate $72,000,000 to equity and $48,000,000 to fixed income. Those are $120,000,000 multiplied by 60% and 40%, respectively, derived from the prior AUM table.

For each strategy, put the asset-level effect in H2, mix in I2 and rate in J2:

=(SUM($D$2:$D$3)-SUM($B$2:$B$3))*(B2/SUM($B$2:$B$3))*C2*0.25
=(D2-SUM($D$2:$D$3)*B2/SUM($B$2:$B$3))*C2*0.25
=D2*(E2-C2)*0.25

Fill down. SUM(F2:F3)+SUM(H2:J3) must equal SUM(G2:G3): $160,000 plus $32,000, less $6,000 and $9,300, equals $176,700. The negative mix effect reflects more assets in the lower-fee strategy, even while both strategies grew.

Connect the asset effect to net flows

The $32,000 asset-level effect is not automatically a sales contribution. Average assets can move with subscriptions, redemptions, market values, currency and account transfers. Obtain the dated activity and valuation records to distinguish them.

For daily-average billing, calculate each day's eligible assets and average those balances over the contractual period. An opening-day subscription affects more daily balances than an equal final-day subscription. Attribute dated flow contributions on that same basis before discussing their fee impact; an ending-balance rollforward cannot substitute for it.

Use net flows by client and strategy for the underlying flow analysis. Link the reconciled results into asset management reporting, while customer revenue analysis handles the account view. New or terminated strategies need separate population effects when a prior strategy weight or rate does not exist.

Where it goes wrong

• Closing AUM substituted for billable assets. Apply the actual contractual basis and valuation dates.
• Strategy averages hide fee tiers. Calculate contract-level amounts before aggregating when thresholds or waivers differ.
• Market gains called net sales. Reconcile dated flows separately from valuation changes.
• Performance fees inflate the realized rate. Keep them outside the asset-based management fee comparison.
• Revenue treated as profit. Use asset management cost analysis for the corresponding expense movements.

Covirage is not affiliated with Microsoft.

Explain fee movements in Covirage

Bring matched fee and AUM exports with period, strategy and fee-arrangement fields. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for asset managers for the business context.