venture-models - v4final
TRANSCRIPT
Venture-Modelswww.venture-models.com
Financial Models to Manage the entire Fund Lifecycle
3/26/2015CPA/MBA, Part time CFO for start ups and funds
20 years end to end experience with 5 Venture funds
Expert in financial modeling and VC audit/accounting processes
Mechanical/Industrial Engineer, MBA from MIT Sloan
Consulting experience at Bain and for mid market
Excel Ninja - 15+ years of modeling and simulation experience
Manaswi Sharma
Glenn Baker
Venture-ModelsTable of contents
2
Why Venture-Models?
Our Business and Customers
Demo Fund Model
Team
3
Current solutions for managing a private equity fund lifecycle are full of frustrations
Data is scattered over hundreds of files leading to huge time waste for audits and reporting Software solutions are either not sophisticated enough or need enormous implementation resources
Venture-Models solution is a single file excel model, that can answer all fund related questions - cutting response times, audit costs and freeing up CFO bandwidth
Th
e p
rob
lem
Th
e S
olu
tion
Venture-Models is the answer to several key issues facing the fund CFO and GPs
Venture-Models = fund Manager’s utopia: Robust, Elegant, Cost Effective
Venture-Models Privileged and Confidential
4
Comprehensive
Accurate
Fast, Responsive
Simple
Customized
Easy to use
Venture-Models delivers a Robust, Elegant and Cost Effective solution
Saves audit costs
Saves CFO time
Uses excel, no new software or platform
Cost EffectiveElegantRobust
Venture-Models Privileged and Confidential
• Advances and LoC
Capital calls
• Multiple rounds
Investments • Partial
sales
Dividends and Exits
• Non pro-rata and Claw-backs
Distributions
Covered under the Model
Not Covered
Portfolio Company Models
Venture-Models: WebinarTable of contents
5
Why Venture-Models?
Our Business and Customers
Demo Fund Model
Team
6
Who we are• We create customized financial models to run the
back office of venture capital, mezzanine and private equity funds
• The founders each have over 15 years of experience in excel modeling and in the Venture Capital and Private Equity industry
Who we work with• We work with CFOs and Operations Managers of
Venture Capital, Mezzanine and Private Equity funds
• Our clients are typically managing single strategy funds with AUM between $50M and $1B
We work with private equity fund CFOs and managers, typical fund size is up to $1B
Venture-Models Privileged and Confidential
7
What You Get• An easy-to-use, interactive Excel Model which is
customized for your fund and enables you to evaluate scenarios and analyze results quickly
Our business model• We initially set up the model per your fund LPA, and
customize reports and charts per your requirement, for an upfront fee
• We provide ongoing support and product upgrades to ensure quality control and data integrity, for a small maintenance fee
We create a customized excel model to manage your fund, and provide maintenance support
Venture-Models Privileged and Confidential
8
“These guys have created a solid platform for our fund that is making my life easy on a day to day basis”
- Jonathan TManaging Partner
Michigan Income & Principal – Protected
Growth Fund
Initial feedback we have received from our clients is very encouraging
Venture-Models Privileged and Confidential
We have a solid product, but are enthusiastic to refine and modify it to suit the requirements of each individual client – because we know
that each fund is unique
9
Model highlights
Responsiveness Fast analysis and reporting Automated reports for all your LP
inquiries Real time ‘what-if’ analysis
Superior User Interface
Limited data entry sheets Clear layout Easy to use ‘events’ table for GPs to
simulate portfolio investments and exits
Quality Control Data integrity - separation of data entry from formulas and reports
Free upgrades to the model as needed for 3 years – included in the maintenance fee
Ongoing technical support to ensure that the model works as per spec
Venture-Models Privileged and Confidential
Venture-Models: WebinarTable of contents
10
Why Venture-Models?
Our Business and Customers
Demo Fund Model
Team
The model covers the entire fund lifecycle in relatively few worksheets
11Venture-Models Privileged and Confidential
12
We design the model so that user inputs are limited to only a few worksheets – typically 4
All the what-if scenarios can be run from the model control panel and portfolio dashboard
Clean yet powerful user interface that allows you to model all the relevant variables
Venture-Models Privileged and Confidential
13
Data flows to all the needed financial statements and other reports needed by the clients and their LPs
Forecasting Engine allows you to set the actuals cutoff date and run actual vs forecast analysis as needed
All standard and ad hoc reports are auto-generated, freeing up bandwidth for your team
All reports have a consistent and professional look and feel
Reports expand to display monthly data, or collapse to yearly summaries – as needed
Venture-Models Privileged and Confidential
We have simplified complex calculations like the distribution waterfall to a user friendly format
14Venture-Models Privileged and Confidential
Portfolio analysis is simpler because all relevant data is in one file
15
Portfolio performance by investment
Venture-Models Privileged and Confidential
3M
American Express
AT&T
Boeing
Caterpillar
Chevron
Cisco Systems
du Pont
Exxon Mobil
General Electric
Goldman Sachs
Home Depot
Intel
IBM
Johnson & Johnson
JPMorgan Chase
Future #1
Future #2
Future #3
-$200,000,000 $0 $200,000,000 $400,000,000 $600,000,000
Investment Cost Realized Gain or Loss Unrealized Gain or Loss
The charts are interactive to help with better visualization of data
16
IRR Chart
Simple controls allow the user to choose the data to be displayed on the chart
Venture-Models Privileged and Confidential
Charts and reports are customized, so that the model works for ‘you’
17Venture-Models Privileged and Confidential
Venture-Models: WebinarTable of contents
18
Why Venture-Models?
Our Business and Customers
Demo Fund Model
Team
Venture-Models Privileged and Confidential
The Venture-Models team has deep experience in modeling and the VC/PE industry
Venture-Models Privileged and Confidential 19
CPA/MBA, Part time CFO for start ups and funds
20 years end to end experience with 5 Venture funds Expert in financial modeling and VC audit/accounting processes
Mechanical/Industrial Engineer, MBA from MIT Sloan
Consulting experience at Bain and for mid market
Excel Ninja - 15+ years of modeling and simulation experience
Manaswi Sharma
Glenn Baker
Available upon requestAdvisors &References
20
We guarantee that we can create a fund model for you that will delight you and make your life easier.
Venture-Models – if you can imagine it, we can model it
Please schedule a Model Demo session with Venture-Models
Glenn BakerVenture Models co-founder and Director of Business Development Phone – 617-529-5420Email : [email protected]
Venture-Models Privileged and Confidential