260 likes | 333 Views
Entrepreneurship in Entertainment Technology. Welcome!. Today’s Agenda. Financial Statements Review from Tuesday Financial Modeling Examples. Financial Statements. Main Types. Income Statement (P&L) Balance Sheet Cash Flow. Financial Models: Drivers, Assumptions and Metrics.
E N D
Today’s Agenda • Financial Statements • Review from Tuesday • Financial Modeling • Examples
Main Types • Income Statement (P&L) • Balance Sheet • Cash Flow
Financial Models • What • When • How • Why • Who
Financial Models • Simulation • Rules + Assumptions + Initial Values
Why? • Test Scenarios • Sustainable? • Sensitivity Analysis • Find Toxic Events • Find Metrics
How? • Hypothesize • Test • Iterate • Try Different Models
Drivers and metrics • Drivers • Key factors that drive revenue and expenses • Ratio • Assumptions • Numbers you plug into drivers • Metrics • A measurement of a Driver’s performance • Ratio
Example 1 – Subscription • Drivers • Revenue per Customer per Month • Cost per Sales Lead • Conversion Rate • Churn Rate • Metrics • LCV/CAC • Conversion rate (% leads who pay) • Retention or churn (% repeat customers) • Growth
Example 2 – Freemium Games • Driver • Conversion Rate • Revenue per Paying User • Churn Rate • Hosting Cost per MAU • Metrics • LVC/CAC • Growth • Gross Profit Margin
Sample Financial models • techcrunch.com/2010/10/10/teardown-13-ways-10-million-revenues/
Example 3 – Ad supported • Driver • Revenue per Click • Metrics • Unique visitors • Page views per visitor • Conversion rate (% visitors who click)
Example 4 – Marketplace • Driver • Listings Closed • Metrics • New listings • Conversion rate (% listings that close)
Expense Examples • Number of servers ← Pages served per minute • Pages served ← Number of visitors • Acquisition cost = Marketing cost per new customer • R&D cost ← Number of products • Customer support ← Number of customers
Zynga • Source: • Public Filings
Analytics • http://www.google.com/intl/en/analytics/features/multichannel-funnels.html
whiteboard • Revenue streams • Costs of revenue (variable costs) • Key drivers • Key metrics • Assumptions you’ll have to make • Other important aspects of your model
homework • Read • techcrunch.com/2010/10/10/teardown-13-ways-10-million-revenues/ • Financial Model for your market opportunity • Meet with me to determine goal • Excel spreadsheet • Explicit detail on assumptions • No company intro – just get straight to the data • Due date: email to Carl by Monday 2/25, 7pm
Resources • Teardowns • techcrunch.com/2010/10/10/teardown-13-ways-10-million-revenues/ • techcrunch.com/2010/05/13/zynga-teardown/ • techcrunch.com/2010/05/02/teardown-groupon/