Thinking Through Your Two-Sided Marketplace_Worksheet

	A	B	C
1
2
3	INSTRUCTIONS
4	This tab is to share an example. The second tab you can fill out with your own variables to see at what scale you can expect revenue. You need to make a copy of this Google doc to your own drive to be able to edit the document.
5
6	Company Overview
7	'On Foot Fido' is a two-sided marketplace connecting dog owners with dog walkers. The benefit to both audiences is a single location to source more walks and organize necessary walk info (scheduler, contact info, start / stop notifications).
8
9	Revenue Streams		Explanation
10	Cost Per Transaction	$30.00	Cost for a single dog walk
11	% Revenue per Transaction	5%	What percent of a dog walk is collected for 'On Foot Fido' revenue.
12	Revenue Per Transaction	$1.50	Total amount of revenue per dog walk for 'On Foot Fido'
13	Dog Owner Platform Costs (per year)	$0	If we are charging an audience to have an account, for example a subscription that value goes here. In this example, dog owners can join the platform for free.
14	Dog Walker Platform Costs (per year)	$60.00	If we are charging an audience to have an account, for example a subscription that value goes here. In this example, dog walkers can join the platform for $5 / month.
15
16	Audience Goals		Explanation
17	Goal # of Buyers	100	Goal number of dog owners on the platform
18	# of Transactions per Buyer per year	105.00	Goal number of dog walks purchase per year by a single dog owner
19	Business Revenue	$157.50	Business revenue collected with those goals
20	Goal # of Sellers	200	Goal number of dog walkers on the platform
21	# of Transactions per Seller per year	208	Goal number of dog walks a single dog walker is completing in a year
22
23	Seller Value Prop		Explanation
24	Seller Time Commitment per tranaction (hours)	0.5	How much time does a seller put in for a transaction?
25	Time Commitment per Seller per year (hours)	104	We assume each walk is 30 minutes.
26	Seller Revenue per year	$5,928.00	Removing the % that goes to 'On Foot Fido', how much revenue would a Dog walker make.
27	Seller Revenue per month	$494.00	Divide that revenue by 12 months.
28	Seller Revenue per hour	$57.00	Comparing total revenue by time commitment.
29
30	Fido On Foot Revenue		Explanation
31	Total Revenue For Subscriptions	$12,000.00	With our goal dog walker size, how much can we expect to bring in based on subscriptions?
32	Total Revenue for Single Purchases	$31,500.00	With our goal dog walker audience size, and a sense of amount of purchases, how much can we expect to bring in based on purchases?
33	Year 1 Product Revenue	$43,500.00
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100