Sign in

Blog · Industry

Investment management: guides and articles

Explore client, fund and revenue data across your investment-management business. Work with dashboards and an AI analyst on reports shaped around your strategies, channels and client relationships.

Finance metrics and formulas · Investment management

WAULT calculation in Excel from a lease schedule

Calculate rent-weighted unexpired lease terms from a commercial property lease schedule. Build the Excel formulas, separate contractual expiry from tenant break dates, and reconcile the average to rent and expiry concentrations.

Oct 24, 20265 min read
Finance metrics and formulas · Investment management

Asset management cost analysis by fund and client

Separate an asset management firm's direct expenses from shared service and reporting costs. Build a fund and client-segment cost view from expense and activity workbooks, then reconcile the allocations to the firm's operating total.

Oct 11, 20265 min read
Board and management reporting · Investment management

Client reporting in asset management: reconcile the figures

Reconcile opening assets, contributions, withdrawals, supplied valuation changes and fees to each client's closing balance. Use a worked asset-management report to separate an explainable movement from an unresolved difference.

Oct 2, 20265 min read
Board and management reporting · Investment management

AUM Reporting: Separate Flows from Market Movements

AUM reporting reconciles opening assets to closing assets while separating client flows from investment movements. Build an AUM bridge from fund and transaction exports, check internal transfers, and prove each closing balance.

Sep 26, 20265 min read
Board and management reporting · Investment management

Asset management revenue analysis: AUM, fees and mix

Explain asset-manager fee revenue through average fee-bearing assets, strategy mix and realized fee rates. Reconcile AUM and fee exports before separating the drivers.

Sep 21, 20264 min read
Alternatives and comparisons · Investment management

How to choose analytics software for asset managers: questions, data and traps

How asset managers should choose analytics software: start from the questions, check the data you hold, ask vendors ten questions, avoid the traps.

Aug 29, 20264 min read
Board and management reporting · Investment management

Distribution KPIs for asset managers: ten measures that matter, each with its formula and the export it comes from

The ten distribution KPIs an asset manager should run on, each with its formula, the export it comes from and what it tells you: net flows by client and strategy, gross sales and redemptions separately, share of an intermediary's flows, redemption watch, coverage of intermediaries and consultants at cadence, channel share per strategy, flow concentration, fee yield on flows, strategies held per client, and consultant rating coverage. Also the three measures most distribution teams miss, the figures to drop, the identities, and who owns what.

Aug 12, 20264 min read
Coverage and territory · Investment management

Ten questions a head of distribution asks, and the table that answers each

The ten questions an asset manager's head of distribution puts to the wholesalers and the institutional team, where is share of wallet lowest, which intermediaries turned, which strategy is under-distributed in a channel, which consultants advise the most and rate us least, which advisers have gone quiet, which platforms are reviewing us, where are the redemptions coming from, what did the roadshow move, which relationships are single-threaded, and what changed, each with the table from the transfer agent and CRM data, and the answer to send back.

Jul 30, 20262 min read
Wallet share and penetration · Investment management

How to calculate share of wallet for an asset manager's distribution team

A working method for share of wallet in asset management distribution: what counts as the wallet, which rows you need from your own systems, the roll-up level by level, and the three places the number usually goes wrong.

Jul 25, 20264 min read
Forecast and pipeline · Investment management

Redemption watch: the intermediaries whose flows turned before their assets did

How an asset manager's distribution team finds the intermediaries whose net flows have turned negative against their own history while their assets still look intact, from the transfer agent file: the flow baseline per intermediary per strategy, the turn signal, the months of runway before the assets follow, and the list that reaches the wholesaler while there is still a conversation to have.

Jul 19, 20262 min read
Wallet share and penetration · Investment management

Net flows by client and strategy: telling retention accounts from growth accounts

Why an asset manager's distribution team should read assets and net flows per client side by side: the four quadrants they produce, how to compute net flows by client and strategy from subscriptions and redemptions without netting away a switch, and the quarterly list each quadrant becomes.

Jul 12, 20263 min read
Coverage and territory · Investment management

Channel share per strategy: platform, wirehouse and RIA flows side by side

How an asset manager's distribution team measures net flows per strategy by channel from the transfer agent and platform data, sets each strategy's expected channel mix from its own peers in the range, and finds the strategy that is under-distributed in one channel while the range as a whole looks fine, without ever naming an end client.

Jun 24, 20263 min read
Coverage and territory · Investment management

Consultant coverage: the gatekeepers of institutional flows, and whether anyone has called them

How an asset manager's institutional team measures its coverage of investment consultants from the consultant master, the ratings file and the contact log: consultants ranked by the assets they advise in the manager's strategies' classes, the manager's rating status at each, contact recency against a stated cadence, the consultants who advise the most and rate the manager least, and the mandates won and lost by consultant that say which relationships convert.

Jun 24, 20263 min read
Covirage for Investment management

Investment management analytics for your business.

See the page