Profitability analysis for a diversified asset management and services firm

Problem statement​

• Our client provides a portfolio of services to mortgage providers

• Profitability on an account basis is not well understood because of the shared services nature of the function​

• Data about the serviced loans and the profit allocation process has been managed by spreadsheet

PoC deliverables​

• Onboarded all serviced loan data into the Finray common model​

• Data cleansed and validated​

• Created Control rules to allocate cost and revenue for account level (loan level) profitability​

• Eliminated 10 spreadsheet allocation processes ​

• Full mortgage warehouse for ongoing finance process and reporting improvement​

• Business requirements gathering for further finance improvement​

• Project time: 8 weeks​

• Project cost: $70K​

Finray approach

• Start with a pain point (every FS firm finance function has them)​

• Deliver credibly and quickly​

• Identify the road map for further improvement​

• Repeat​