Advisor books, holdings, client cash flows, and AUM
Industry
Wealth Management
Company size
Boutique firm
Advisor team
24 advisors across 6 offices
Client base
650 households and 1,050 accounts on the books, 609 households and 919 accounts still open at the end of the window
Fee profile
$24.4M cumulative advisory fee revenue across the 24-month history, at an annualised yield of 26.1 bps on digital advisory up to 82.9 bps on private wealth
Kelnoro Capital Advisors is a fictional boutique wealth-management firm created for BI demos, analytics workshops, and semantic-model examples; it represents no real advisory business, investment product, client, custodian, or person. The firm serves a fictional U.S. client footprint through six offices, with most households in advisor-led relationships across six regions. It grew from an independent practice for founder-led families into tax-aware portfolio models, retirement-income mandates, and private-wealth coverage. Buyers move from firmwide AUM, fee yield, and advisor-book trends into household segmentation, holdings exposure, allocation drift, and retention-watch analysis.
These are the operating questions this kit is optimized to answer first.
household mix, fee yield, and excess return spanning -10.1 to +8.2 basis points a month.
high-net-worth households are 19.9% of the client base and 64.7% of latest AUM.
an account's opening balance is its own prior month-end closing balance on all 22,568 consecutive pairs.
a month's net flow opens straight into the inflow and outflow rows behind it for every account-month.
a position stays put across 91.6% of month pairs, turning over only at a staggered model refresh.
realized allocations track each model, and 26.2% of account-months sit past their own rebalance tolerance.