Key Takeaways
- Bespoke fund terms may create fee-calculation requirements that traditional investor servicing and accounting systems are not designed to efficiently handle.
- Reliance on spreadsheets and standalone fee models frequently increases manual work, fragments oversight and creates maintenance challenges.
- Centralizing calculation logic within a controlled framework helps improve transparency, consistency, and knowledge transfer.
- System integration and effective model governance, including audit trails, maker-checker controls and permissions, help to strengthen workflow efficiency and control.
- Scalable, customizable fee models help firms accommodate new fund structures and changing requirements without rebuilding each calculation process from scratch.
Although alternative investment funds frequently share common structural features, terms are rarely identical. Carried interest or waterfall calculations, performance fees, management fees, side letters, and equalization provisions are often tailored to the fund strategy, structure, and investor base. This flexibility, however, creates challenges for fee modeling and calculations across three general areas: workflow efficiency, transparency and control, and adaptability.
1. Streamlining workflows
Fund documents may outline calculation terms that a core accounting system cannot easily accommodate. Common examples include fund-specific waterfalls, multiple hurdle rates, performance tiers, and equalization provisions. Addressing the immediate need through a separate spreadsheet or stand-alone model creates another process outside of the main accounting system, which must be updated when changes to terms or underlying data occur. As separate models are introduced, oversight becomes difficult and the process becomes increasingly harder to maintain.
Workflow challenges are compounded when data needed to support calculations is dispersed across multiple systems and records. Before a calculation begins, teams may need to assemble capital and investment activity, investor-level records, and accounting data from multiple sources. Governing documents and additional key terms determine how those inputs should be applied. When the source data is held in different places, this preparation takes time and files may need to be uploaded manually. Connecting the model directly to the administration environment can reduce repeated handling and help information move more efficiently between the relevant systems and the calculation.
2. Increasing transparency and controls
A complex model can accumulate years of institutional knowledge. Its formulas may reflect amendments to the fund documentation as well as decisions made during previous calculation periods. When that logic is buried in a workbook, even a small change can require teams to trace formulas across tabs or compare earlier versions. The challenge becomes more apparent when employee or team responsibilities shift, particularly when teams need to adapt a current methodology for another fund with different terms. Holding the calculation logic within a controlled framework centralizes this information, making it easier to maintain and apply elsewhere.
At the calculation review stage, reviewers also need a clear understanding of how the result was produced. When key information is spread across files and systems, tracing the calculation from input to output takes time. Model governance including audit trails and maker-checker controls help to address this challenge, providing a clearer record of the process and establishing who can prepare, review, and approve calculation activity. Dashboards and detailed reporting may help improve reviewers’ visibility into the calculation.
3. Meeting evolving requirements
New fund vehicles do not always fit an existing fee model, and fund terms can change after launch and call for different calculation methodologies. If each variation requires one-off spreadsheets or a separate technology build, the process becomes increasingly harder to maintain. To address this need, an operating framework needs to be scalable with enough flexibility to reflect differences between funds without starting from scratch every time.
A library of customizable models may provide a starting point for hybrid fund structures and other fund-specific arrangements, while allowing those models to be adapted for bespoke or ad hoc requirements as they arise.
A Scalable Approach
MUFG Investor Services developed its fee modeling solution to support complex calculations across alternative fund structures. Our modeling team builds custom frameworks that standardize and automate data elements, helping to reduce manual data entry and shorten processing time.
With a combination of automation, integration, and specialist support, firms can improve the efficiency and consistency of fee calculations while preserving the customization their fund structures require.
