ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
7
8
9
Your company's name
10
Freelance Genius
11
12
Overview
13
14
- All revenue streams are explained in detail in our guide: Revenues in Financial Features: a Complete Guide for Tech Companies
15
- Need to change the assumptions? Go to File >> Make a copy, then edit
16
- This sheet (Input) contains assumptions (in grey cells) about the volumes and economics of your financial features
17
- All other cells in the entire spreadsheet are calculated according to the assumptions
18
- The products are color-coded throughout this spreadsheet: deposits, cards, ACH, checks
19
- The economics are calculated for you and your end-users
20
- Not covered here: SaaS fees and credit products (lending, cash advance)
21
22
About the next sheets:
23
- Projections contains the 3-year projections for volumes and economics
24
- Totals contains a bottom line summary of the economics along the 3 years
25
26
Number of Accounts
27
28
- Key assumptions:
29
- The number of active accounts for the 3 years of activity
30
31
Y1Y2Y3
32
Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
33
Number of accounts in Q (k)125101215182025305070
34
35
Interest
36
37
- Key assumptions:
38
- Average account balance
39
- Interest economics
40
- Note that interest will change in real time according to changes in fed rate
41
42
Average account balance (k $)2.00
43
44
Economics:
45
EntityGross takeNet take
Net % of total
46
Freelance Genius0.05%0.05%100%
47
End-user0.00%0.00%0%
48
49
Interchange
50
51
% of balance spent via card every month
50.00%
52
Interchange %1.30%
53
54
Economics:
55
Entity
Gross take (%)
Net take
Net % of total
56
Freelance Genius80.00%40.00%50%
57
End-user (cash back)40.00%40.00%50%
58
59
ACH
60
61
# per account / month15
62
63
Economics:
64
EntityPays ($)Net take
65
Freelance Genius0.090.06
66
End-user0.15
67
68
Checks
69
70
# per account / month5
71
72
Economics:
73
EntityPays ($)Net take
74
Freelance Genius0.200.30
75
End-user0.50
76
77
78
79
Constants
80
81
Constants
82
Months per quarter3
83
Thousand1000
84
Quarters per year4
85
Months per year12
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100