24
8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 1/24 FUNDRAISING: FINANCIAL MODELLING 1

PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

Embed Size (px)

Citation preview

Page 1: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 1/24

FUNDRAISING:FINANCIAL MODELLING

1

Page 2: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 2/24

QUESTIONS

1. How should I build my financial model?2. How much should I raise?3. What will investors look for?

2

Page 3: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 3/24

PART 1

HOW SHOULD I BUILDMY FINANCIAL MODEL?

3

Page 4: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 4/24

HOW SHOULD I BUILD MY FINANCIAL MODEL?

4

Part 1

 What is my businessmodel?

Page 5: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 5/24

HOW SHOULD I BUILD MY FINANCIAL MODEL?Part 1

Revenue

models

Commerce

Advertising

  Subscription

Peer-to-

peer

Transaction

Processing

Licensing

Data

Mobile

Page 6: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 6/24

HOW SHOULD I BUILD MY FINANCIAL MODEL?

6

Part 1

 What is my revenue

model “family” and itssibling?

Page 7: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 7/247

Part 1

Commerce  • Retaiing - ex. Zappos• Marketplace - ex. Etsy• Crowdsourced Marketplace - ex. Threadless• Excess Capacity Markets - Uber, AirBnB• Vertically Integrated Commerce - ex. Warby Parker• Aggregator - ex. Lastminute.com• Flash Sales:  Gilt Groupe, Vente Privee• Group buying - ex. Groupon• Digital goods / downloads - ex. iTunes• Virtual goods - ex. Zynga

• Training - ex. Coursera• Pay what you want - ex. Radiohead• Commission - ex. SharesPost• Commission per order - ex. Seamless, GrubHub• Auction - ex. eBay• Reverse Auctionex Priceline

• Barter for services ex. SwapRight

HOW SHOULD I BUILD MY FINANCIAL MODEL?

Page 8: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 8/248

Part 1

Advertising  • Display Ads - ex. Yahoo!• Search Ads - ex. Google• Text Ads - ex. Google• Video Ads - ex. Hulu

• Audio Ads - ex. Pandora• Promoted Content - ex. Twitter, Tumblr• content links - ex. Outbrain• Recruitment Ads - ex. LinkedIn• Lead Generation - ex. MoneySuperMarket, ZocDoc• Affiliate Fees - ex. Amazon Affiliate Program

• Classifieds - ex. Craiglist• Featured listings - e.g. Yelp, Super Pages;• Email Ads - as done by Yahoo, MSN• Ad Retargeting - ex. Criteo 

• Real-time Intent Ad Delivery

• Location-based offers - ex/ Foursquare• Sponsorships / Site TakeoversPandora

HOW SHOULD I BUILD MY FINANCIAL MODEL?

Page 9: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 9/249

Part 1

Subscription

HOW SHOULD I BUILD MY FINANCIAL MODEL?

 • Software as a Service (SAAS) - ex. Salesforce• Physical Service - ex. Range-Moi

• Content as a Service - ex: Spotify, Netflix• Infrastructure/Platform As A Service - ex. AWS• Freemium SAAS - ex. Dropbox• Donations - ex. Wikipedia

• Sampling - ex Birchbox• Membership Services - ex Amazon Prime• Support and Maintenance - ex 10gen, Red Hat• Paywall - ex. NYTimes• Voice and video-conferencing - ex. Uberconference 

Page 10: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 10/2410

Part 1

Mobile

HOW SHOULD I BUILD MY FINANCIAL MODEL?

 • Paid App Downloads - ex. WhatsApp

• In-app purchases - ex. Zynga Poker• In-app subscriptions - ex. NY Times app

• Advertising- ex. Flurry, AdMob

• Digital-to-physical - ex. Red Stamp, Postagram

• Transactions - ex Hailo

Page 11: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 11/2411

Part 1

Transactions

HOW SHOULD I BUILD MY FINANCIAL MODEL?

  • Merchant Acquiring - ex. PayPal (Online / Offline)Stripe (Online), Square (Offline)• Intermediary - ex. IP Commerce (POS 2.0), CardSpring• Acquiring Processing - ex. Paymentech• Bank Transfer - ex. Dwolla• Bank Depository Offering - ex. Simple, Movenbank (spread on average deposits)• Bank Card Issuance - ex. Simple (interchange fee per transaction)• Fulfilment - ex. Amazon• Messaging - ex. Peer-to-Peer SMS, IM, Group Messaging

• Telephony - ex. termination/origination in public telephony networks (skype out/in)• Telephony - ex. termination/origination within private telephony cloud (e.g. native skype)• Payment Gateways: Mobile -ex. Braintree• Platform Monetisation ("Tax") - Facebook Credits; iO6 30% cut.

Page 12: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 12/24

HOW SHOULD I BUILD MY FINANCIAL MODEL?

12

Part 1

 What are my

parameters?

A few rules and some choicesLook at benchmarks

Page 13: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 13/24

HOW SHOULD I BUILD MY FINANCIAL MODEL?

13

Part 1

Elements of the P&LEagle view

DetailsParameters for scenariosMonths, quarters and years, no dates

Separate variable and fixed costsCOGS or no, intermediate margins if itmakes sense

Page 14: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 14/24

HOW SHOULD I BUILD MY FINANCIAL MODEL?

14

Part 1

Elements of the P&LCAC - benchmark Contribution MarginBreakeven, payback Opex (var + fixed costs)CapexCashflowAny parameter that makes sense to your

model (Churn, CLV)

Page 15: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 15/24

15

How much should I raise?

Page 16: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 16/24

HOW MUCH SHOULD I RAISE?

16

Part 2

Cash analysis

Page 17: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 17/24

HOW MUCH SHOULD I RAISE?

17

Part 2

!"#$$$ $$$

!"&$$ $$$

" $

"&$$ $$$

"#$$$ $$$

"#&$$ $$$

   '   #

   '   (

   '   )

   '   *

   '   &

   '   +

   '   ,

   '   -

   '   .

   '   #   $

   '   #   #

   '   #   (

   '   #   )

   '   #   *

   '   #   &

   '   #   +

   '   #   ,

   '   #   -

   '   #   .

   '   (   $

   '   (   #

   '   (   (

   '   (   )

   '   (   *

   '   (   &

   '   (   +

   '   (   ,

   '   (   -

   '   (   .

   '   )   $

   '   )   #

   '   )   (

/012 34

/012 567

Page 18: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 18/24

HOW MUCH SHOULD I RAISE?

18

Part 2

!"#$$$ $$$

!"&$$ $$$

" $

"&$$ $$$

"#$$$ $$$

"#&$$ $$$

"'$$$ $$$

"'&$$ $$$

"($$$ $$$

   )   #

   )   '

   )   (

   )   *

   )   &

   )   +

   )   ,

   )   -

   )   .

   )   #   $

   )   #   #

   )   #   '

   )   #   (

   )   #   *

   )   #   &

   )   #   +

   )   #   ,

   )   #   -

   )   #   .

   )   '   $

   )   '   #

   )   '   '

   )   '   (

   )   '   *

   )   '   &

   )   '   +

   )   '   ,

   )   '   -

   )   '   .

   )   (   $

   )   (   #

   )   (   '

/012 34 /012 567 89:: /012 8;<=> 0??6@6;07:A

Page 19: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 19/24

HOW MUCH SHOULD I RAISE?

19

Part 2

!"#$$$ $$$

!"&$$ $$$

" $

"&$$ $$$

"#$$$ $$$

"#&$$ $$$

"'$$$ $$$

"'&$$ $$$

"($$$ $$$

   )   #

   )   '

   )   (

   )   *

   )   &

   )   +

   )   ,

   )   -

   )   .

   )   #   $

   )   #   #

   )   #   '

   )   #   (

   )   #   *

   )   #   &

   )   #   +

   )   #   ,

   )   #   -

   )   #   .

   )   '   $

   )   '   #

   )   '   '

   )   '   (

   )   '   *

   )   '   &

   )   '   +

   )   '   ,

   )   '   -

   )   '   .

   )   (   $

   )   (   #

   )   (   '

/012 34 /012 567 89:: /012 8;<=> 0??6@6;07:A

2 tranches

Page 20: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 20/24

HOW MUCH SHOULD I RAISE?

20

Part 2

Cash requirement diff thancapital to be raised (20%/25%)

Page 21: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 21/24

HOW MUCH SHOULD I RAISE?

21

Part 2

Amount to close

Minimum closeMaximum close

Page 22: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 22/24

22

Part 3 What will investors look for?

Page 23: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 23/24

 WHAT WILL INVESTORS LOOK FOR?

23

Part 3

No “conservative” bsOne scenario that makes sense (no money-printing scheme)

Business logic/benchmark (CAC?)ParametersEagle view

Understanding of key indicatorsCost/profitability analysisCashflow understandingCap table that makes sense

Page 24: PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

8/10/2019 PAFI-6 Janv 2015- Cedric Naintré -Fundraising Finance Modeling

http://slidepdf.com/reader/full/pafi-6-janv-2015-cedric-naintre-fundraising-finance-modeling 24/24

 WRAP-UP

24

1. How should I build my financial model?2. How much should I raise?3. What will investors look for?