Fixed Income Data Organiser
A Regulatory Reporting Solution which saved £170 million in opportunity cost and boosted P&L by £11 million
Client
Investment Bank
Business Problem
The client, one of Europe’s largest banks, had a regulatory obligation to calculate and report the regulatory capital required for its securitisation holdings (such as Mortgage Backed Securities or MBS).
The manual process performed solely with spreadsheets took days, sometimes weeks, and was very error prone.
Solution Delivered
In collaboration with the Fixed Income Regulatory Capital team, we developed an automated, secure solution with full audit trail and regulatory report generation.
As the process required a lot of data, the solution started with a SQL Server database to process 8 Gb of data daily and perform the regulatory calculations.
The solution provided a clear and clean separation of business users' responsibilities to comply with regulatory requirements and automated the regulatory report generation process in hours rather than days or weeks.
Results
Technology
Excel | VBA | C# | SQL Server | ExcelDNA
Free Download
Explore 30 Excel Solutions Used by Leading Financial Services Firms
Discover how Excel automation can drive measurable results. This exclusive portfolio showcases over 30 high-impact projects, each designed to streamline workflows, save time, and reduce operational risks for financial services firms. Download now to see real examples of how we’ve helped firms like yours achieve ROI gains of up to 631%.
Ready to stop managing Excel and start improving it?
Book a 30-minute discovery call.
We'll look at your current Excel environment, identify where the biggest risks and inefficiencies are, and tell you honestly whether Excel on Tap is the right fit.
No sales pitch. No obligation. Just a straightforward conversation about your situation.