Management Reporting

Hedge funds, asset managers, private equity firms, and middle market lenders who all have different strategies and invest in the entire spectrum of the capital structure of companies — have a common challenge. How do they present this complex data to their executives and investors in a format that is easy to digest but that still has a drill-down to the minutest detail of the underlying assets? Unfortunately, data needed for this type of reporting is often isolated in disparate systems ranging from individual spreadsheets to being housed within an accounting system.

The Solution

NorhtPoint has created a lightweight Portfolio Data Warehouse that consolidates Issuer, Asset, Position, and Portfolio information into a flexible format that is optimized for exactly this type of reporting. It utilizes a Global Securities Master to integrate disparate systems and ensure that data is current and valid. New data points can be added on-the-fly by users so that fundamental company information can be captured. Standard and user-customizable reporting is provided through templates and grid controls that also provide an “Excel-like” interface (complete with formulas) that can replace individual analysts' spreadsheets. Specific reports can be grouped together and published as an Asset Book – especially useful in Investor Reporting where high-level performance statistics are needed with drill-down to specific assets.

Features

  • Creates summarized reports with drill-down to underlying detail
  • Functionality to perform historical and trend analysis
  • Creates, defines, and maintains portfolios and their associated deals, per reporting periods
  • Monitors, audits, and tracks: Position Information, Asset Information, Borrower Information (including capital structures, financial information, covenant tracking, etc.)
  • Provides ability to create, modify, and export Deal Cash Flows to calculate Actual/Projected IRR, under-written IRR at a deal or strategy-level
  • Users can generate customized Asset Page reports for external parties utilizing external data, user-entered data, and calculated data
  • Generates individual or book-level reporting of portfolio/deals in protected PDF format
  • Grids, charts, and other roll-up reports allows highly-customizable, user-generated reporting
  • Externally generated PDF merging functionality provides users flexibility and robustness in generating the "final" Asset Book
  • Export functionality allows any and all data (including cash flows) to be exported to Excel for off-line uses