venture-models - v4final

20
Venture-Models www.venture-models.com Financial Models to Manage the entire Fund Lifecycle 3/26/2015 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

Upload: glenn-g-baker-cpamba

Post on 07-Aug-2015

58 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Venture-Models  - v4Final

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

Page 2: Venture-Models  - v4Final

Venture-ModelsTable of contents

2

Why Venture-Models?

Our Business and Customers

Demo Fund Model

Team

Page 3: Venture-Models  - v4Final

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

Page 4: Venture-Models  - v4Final

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

Page 5: Venture-Models  - v4Final

Venture-Models: WebinarTable of contents

5

Why Venture-Models?

Our Business and Customers

Demo Fund Model

Team

Page 6: Venture-Models  - v4Final

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

Page 7: Venture-Models  - v4Final

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

Page 8: Venture-Models  - v4Final

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

Page 9: Venture-Models  - v4Final

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

Page 10: Venture-Models  - v4Final

Venture-Models: WebinarTable of contents

10

Why Venture-Models?

Our Business and Customers

Demo Fund Model

Team

Page 11: Venture-Models  - v4Final

The model covers the entire fund lifecycle in relatively few worksheets

11Venture-Models Privileged and Confidential

Page 12: Venture-Models  - v4Final

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

Page 13: Venture-Models  - v4Final

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

Page 14: Venture-Models  - v4Final

We have simplified complex calculations like the distribution waterfall to a user friendly format

14Venture-Models Privileged and Confidential

Page 15: Venture-Models  - v4Final

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

Page 16: Venture-Models  - v4Final

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

Page 17: Venture-Models  - v4Final

Charts and reports are customized, so that the model works for ‘you’

17Venture-Models Privileged and Confidential

Page 18: Venture-Models  - v4Final

Venture-Models: WebinarTable of contents

18

Why Venture-Models?

Our Business and Customers

Demo Fund Model

Team

Venture-Models Privileged and Confidential

Page 19: Venture-Models  - v4Final

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

Page 20: Venture-Models  - v4Final

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