Loan Collateral Manager


Corporate Bank


The Bank needed to load specific structured finance attributes to a Credit Risk Engine for regulatory compliance (Basel Accord).
They had well over 10,000 structured finance exposures (loans) to primarily large corporates which were managed in non-strategic tools, particularly spreadsheets.


This tactical MS Access solution ensured the bank met regulatory timelines while the strategic solution was developed.
Developed with subject matter experts, it captured each exposure and their collateral securities which could be varied and complex.
The solution not only to tactically manage their exposures, but provide a clean migration to the strategic solution once developed. 


MS Access, VBA

* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.


Get this FREE Portfolio of VBA Projects

Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.

Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.

Click the Download button to get instant access to this project summary as a PDF you can print or share.


Save time, money & stress

Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.

Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.