Case Study: Equity Research - European Bank

Interactive presentations linked to online sources

---

Equity Analysts assemble and maintain large sets of related data and documents, which they must continuously update, analyse, and present to clients. Like most knowledge professionals, they start by building personal databases using spreadsheets, and then transferring information to presentation packages to create reports for clients.

Challenges:

Equity analysts looking to increase personal  productivity while reducing dependencies on IT staff were encountering challenges that spreadsheets are not primarily intended to address, specifically:

• Need to assemble and keep current vast amounts of data- without a database
• Basic record is individual share/company, with supporting documents and links
• Need to incorporate increasing number of available web services for updates on the move
• Challenge is to identify patterns and find comparative opportunities or 'outliers'
• Simulations and sensitivity analyses are multi-variate
• Results must be shared with clients, ideally in professional, branded, interactive, self-updating, visual format
• Typical client query: "which banks in your coverage universe have an RoE above 15% but a minimum core solvency ratio of 7%, trade at a 1-Y forward PE below 13x and at a P/BV multiple below 1.5% …with a cost-income ratio above 75% … no, sorry, say a cost-income ratio below 73%?”

Omniscope Solution:

Many separate Excel workbook tabs were opened and merged into a single, highly-visual, interactive Omniscope file:

-Bloomberg Connector and web services links permit real time data updates. -Embedded links connect to related documents. -Web services links display price charts, etc. -Real-time, multi-variate sensitivity analysis, even offline. -Quick, easy, mouse-based filtering with instant feedback. -Web links and searches integrated into the working files

Branded, interactive, visual Omniscope files presented to clients just as they are, no reformatting or re-keying of data, with working links and pricing updated automatically. PowerPoint and Adobe Acrobat static printed versions generated with one click. Existing PowerPoint slides can be imported into Omniscope files as a Report Pages interleaved with dynamic views of the data. Presentations can be printed as PowerPoint or Acrobat .PDF files as well.

 

Back to Finance Case Studies 

---

Omniscope Top