Transcript VC/PE Quest PIT - Confisys Solutions Pvt. Ltd.

VC/PE Quest – Portfolio Company Financial Review (Private Equity)
Developed by Confisys Solutions Pvt. Ltd.
Copyright © Since 2001
Restriction on Disclosure and Use of Data
The data in this document contains trade secrets and confidential or proprietary
information of Confisys Solutions , the disclosure of which would provide a
competitive advantage to others. As a result, this document shall not be disclosed,
used or duplicated, in whole or in part, for any purpose other than to evaluate the
Product developed by Confisys Solutions . The data subject to this restriction are
contained in the entire document. This software is protected by Indian Copyrights
Laws. Copying, distribution is strictly prohibited
© since 2001 Confisys Solutions Pvt. Ltd.
V C / P E Q U ES T
Portfolio Company Financial Review (Private Equity)
a complete
middle office solution for
Investment/Deal Managers
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Agenda
 Following are the topics for the PCFR presentation:
Product Introduction
Addressing Pain-points
Customers’ Pre-requisites
Value Proposition
Data Modeling
Data Mining
Performance Analysis
Compliance & Meeting Reminders
Architecture & Security
Technology
Return on Investment
In Conclusion – The Solution can DO
Company Profile
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Product Introduction
Green Tech
Telecom
Request
Education
MIS Reports
AMC/ Fund House
Templates for Financial &
Operational data
Request
MIS Reports
Investors/LP’s
Power
IT &
Telecom
PCFR application
Windows based –
Client Server Architecture
Pharma
Infrastructure
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Addressing Pain-points
 Pertaining to Portfolio Company’s financial review for Investment Manager team
Ad hoc/ Non-Standard internal procedures adopted during data management
Scalability of operations when more Funds & Portfolio Companies are added
Accuracy and Time Spent on generating reports for decision making and analyzing the data
Desire to make portfolio companies input the data & hence avoid duplication of work
The Deal Managers are currently maintaining all the Information in a large number of Spread
sheets which is very scattered in nature
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Customers’ Pre-requisites
 The Fund Managers require a robust tool for:
4.
Comprehensive
analysis of such
data
3.
Quick and easy
assimilation of
data
C O N F I S Y S
1.
Centralized
storage of data
collected for
anytime review
2.
Standardization of
the data collection
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Value Proposition
Deal Manager
Sector/
Industry
Data Modeling
Data Mining
Portfolio
Company
Portfolio
Companies
Financial
Review
Performance Analysis
Business Units
Compliance & Meeting
Organizer
Surrounding IT Infrastructure
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Data Modeling
Multiple business
functions
•
•
•
•
Different granularity
•
•
•
•
Monthly
Quarterly
Half-yearly
Annually
P&L
Balance sheet
Cash flow
Operational
Multidimensional
data model
Multiple business
units
Different business
cases
• Actual
• Optimistic
• Audited
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Data Mining

Super flexible report creation & generation
Multi-dimensional analysis
• combine and compare data across multiple dimensions using the same report structure
Broad range of report formats
• choose between tabular reports as well as graphical reports in a variety of chart types
Compare business cases
• generate comparisons between different business cases, such as actual vs. forecast, even if the
business cases have different granularities
Compare business units
• compare data between ad-hoc combinations of business units
Cyclical comparisons
• supports automatic generation of Q-o-Q, M-o-M and Y-o-Y in few clicks
Cross-company comparisons
• mappings between sector-level and company level entities
We can even customize any other MIS reports you may require.
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Performance Analysis
Automatic XIRR calculations
• capture your investment related cash-flows and fair market value for
calculation of XIRR. (include exchange gain/losses, expenses, etc)
Deal-wise XIRR
• generate XIRR reports to monitor performance of your investment in a
portfolio company, for single-fund as well as co-investment structures
Fund-wise XIRR
• generate XIRR reports for a single fund across all its investments
Investment risk management
• provides reports to study exposure of your fund’s portfolios to different
sectors and jurisdictions to manage risk
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Compliance & Meeting Reminders

In-built Organizer features
Contacts Book
• capture important contacts for each project
Meeting Diary
• organize your meetings and related documents, e.g. agendas for
upcoming meetings, MOMs using the integrated meeting diary
Reminders
• set up reminders to manage important tasks effectively
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Architecture & Security

The system has a robust and highly secure architecture
Maker-checker functionality
• provides locking of records in all modules
Users classification based on organizational boundaries
• allows users to be classified as AMC users, Portfolio Company users and Fund Investor user
Module-level access rights
• allows you to configure create, view, edit and remove permissions for individual modules for
each user
Portfolio Company-level access rights
• provides for restricting access to each portfolio company to a specific set of users, allowing for
easy division of responsibilities
Complete foot-prints
• provides complete audit trail of system activity
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Technology
 The software is a Windows based II-tier client / server application
 The application can be hosted on Citrix server
External environment
Investor Users
server
AMC Users
Deal Company
Users
LAN environment
MS SQL database
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Return on Investment
Time Spent
Current Scenario
Expected Scenario – with PCFR
45
Raw Data
Collection
40
Data verfication
35
Data Mining for
reports
30
25
Performance
analysis
20
15
10
5
50
Raw Data
Collection
45
Resource time spent Hrs/week
Resource time spent Hrs/week
50
40
Data
verfication
35
30
Data Mining
for reports
25
20
Performance
Analysis
15
10
5
0
0
1
2
3
4
5
1
6
2
3
4
5
6
Increase in no. of Portfolio Companies
Increase in no. of Portfolio Companies
Note: All the information is just an assumption to generate a self explanatory analysis.
Associates spends time in data collection, verification & data mining. And Deal team & Associates together spends time
in performance analysis.
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Return on Investment
Cost Involved
Expected Scenario – with PCFR
$50
$50
$45
$45
$40
$40
$35
$30
Downfalls:
$25
• Increase in
Cost per P/C?
$20
• Increases
people
dependency
$15
$10
• Increases
risk of
accuracy
$5
$0
1
2
3
4
5
Resource cost thousands $
Resource cost thousands $
Current Scenario
$35
Upside:
$30
• Increases
Efficiency
$25
• Improves
decision
making
$20
$15
• Decreases
people
dependency
$10
$5
$0
6
1
Increase in no. of Portfolio Companies
2
3
4
5
6
Increase in no. of Portfolio Companies
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
In Conclusion – The Solution can DO
Project Management
Financial Management


Project /Portfolio Companies details
Financial Statements: Bal. Sheet, P & L, Operational, Cash Flow
Data Modeling
Financing Details : Debt, Promoter’s Equity, etc.
Data Mining
Disbursement Schedules as per project milestones
Performance Analysis
Project Compliance, Approvals and related documentation
MIS Reports

Vanilla Reports
Business Case Comparison Reports
Customized Comparison Reports
Security
Business Units Comparison Reports

Cross Project Reports
Graphical Reports
Access to different modules
Grant appropriate Access permissions to
Deal Manager, AMC user Investors, Portfolio
Company users
Portfolio Company wise Investment Report – XIRR Analysis
Fund wise Investment Report – XIRR Analysis
Investment Allocation Report
Log reports for DBA
C O N F I S Y S
S O L U T I O N S
PVT LTD
CONFIDENTIAL
V C / P E Q U ES T
Company Profile

Confisys Solutions Pvt Ltd, has been
incorporated in the year 2000

Promoted by Bharat Khemka (CEO)

Focuses on providing software licensing,
advisory services, KPO activities

Products based solutions to several sectors in
the financial space with major forte in VC, PE,
Realty, Hedge, Fund of Funds, Fund
Administrators and Tax & Audit Firms, etc.
C O N F I S Y S
S O L U T I O N S

Today, our products manage
assets to the tune of USD
10,000,000,000+ (and growing)

Our core values govern the
way we perform our work,
make decisions and interact
with people

Integrity, Customer – centricity,
Innovation, Care.
PVT LTD
CONFIDENTIAL
V E N T U R E C A P I T A L / P R I V A T E EQ U I T Y
VC/PE
Quest
Portfolio Company Financial Review (Private Equity)
A complete solution for your Deal Team for monitoring the performance of your portfolio’s.
Thank you
for viewing the presentation.
Hoping to hear from you soon.
Contact us:
107, Creative Industrial Estate,
Sitaram Mills Compound,
Lower Parel (East),
Mumbai 400 011, India.
Reach us on: 91-22-2301 2714 / 2715
Email us at [email protected]
Visit us at http://www. confisyssolutions.com