Portfolio Analyser & Enquiry
- Has a comprehensive enquiry routine, (using OLAP techniques) which enables any subset of data to be quickly and easily extracted from the database and manipulated, e.g. Portfolio, Fund, Performance, & Investment Company data.
- User defined calculations can be set up to use the enquired data
- Enquiries can be set up and saved to a public or private library of views available to authorised users. All enquiries use real time data.
- Easy to use graphical interface enabling data extracted in the enquiry routine to be graphed for internal and external reporting. Enquiry results can be printed or exported to Word files for integration in investment or partner reports.
- Different formats of graphical presentation of data can be saved; they are automatically updated for new transactions.
- Data can be extracted for BVCA surveys e.g. investment activity survey
- Any number of transaction types can set up to sub-analyse the balances above.
- Investment performance data – all performance categories (account classifications) used to collect data from investment companies can be viewed. Valuation calculations can be added, the results graphed and the enquiry view saved for investment executives.
- Investment Company data - all information held for an investment company, fund, partner or valuation, can be viewed in the enquiry screen. This enables data to be selected for investment reporting and analysis. For example, risk profiles can be compared.
- IRR's are available on capital account movements.
- IRR's can be produced at any time by investment directors and portfolio managers
- IRR selections are made from the user-friendly Enquiry screen, IRR selections can be saved and published as views constantly updated for new transactions.
- IRR
capability includes:
- Tracker IRR's
- Fund IRR's
- Investment IRR's
- Partner IRR's
- Facility to include/exclude management fees
- Facility to include/exclude co-investment fund
- Monthly, quarterly, yearly IRR's
- Forecast transactions can be input to produce forecast IRR's
- Facility to post “amendment” transactions
- IRR results can be presented graphically
- Carry, hurdle, and preferred return analysis with investment realisation forecast
Report Viewer
- Query Analyser provides a simple end user enquiry and report production tool that can interrogate any data stored in the Portfolio and Fund database.
- A library of reports (including the set delivered with the system) can be maintained and made available to users according to their access rights.
- Data can be exported directly from the enquiry routine to any report writer, (e.g. the Crystal Report Writer), report production only requires basic formatting
- Data can be extracted from the enquiry routine into MS Excel.
- Reports can be produced as ad-hoc scratch reports, camera-ready reports, or Internet ready reports.