ABCDEFGLMNOPQABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCL
1
INPUTS - BIG PICTURE
2024
MONTHLY RESULTS & ACTUALS
2
3
↑ by year (click '+' )
↑ Results by year (click '+' )
4
5
6
7
8
1. MODEL SETUP
9
10
11
First month-year of modelJan-2024abc 123
✍️ Change any cells with blue text or values and white background
12
Financial Year 2024 is Jan 2024 to Dec 2024
123
✍️ Blue values and gray background calculate values for you but can be overtyped with actuals
13
Currency used in modelUSD→
Monthly assumptions also entered on right hand side (if in a gray row then MUST be values to work, not formulae)
16
Calcs
17
18
2. SOURCES OF CASH - FUNDING
19
20
21
Equity funding
22
Equity Fundraising RoundsMonthAmountJan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
23
Pre seedJan-2024500,000Equity funding- 500,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
24
Seed
25
Series A
Equity funding cumulative
- 500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000
26
My other round…
27
28
Formula limit. To add extra events insert an entire row above here
29
Calcs
30
31
3. SOURCES OF CASH - REVENUES
32
33
34
New Subscribers
35
Start Month
Starting Value
Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25Oct-25Nov-25Dec-25Jan-26Feb-26Mar-26Apr-26May-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27May-27Jun-27Jul-27Aug-27Sep-27Oct-27Nov-27Dec-27Jan-28Feb-28Mar-28Apr-28May-28Jun-28Jul-28Aug-28Sep-28Oct-28Nov-28Dec-28
36
New Subscribers OrganicJan-2024 100
New Subscribers Organic MoM growth %
5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%
37
New Subscribers Digital MktgJan-2024 100
New Subscribers Digital Mktg MoM growth %
5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%
38
39
New Subscribers Organic1001051101161221281341411481551631711801891982082182292412532652792933073233393563733924124324544765005255525796086396707047397768158568999439911,0401,0921,1471,2041,2641,3271,3941,4641,5371,6141,6941,779
40
New Subscribers Digital Mktg
1001051101161221281341411481551631711801891982082182292412532652792933073233393563733924124324544765005255525796086396707047397768158568999439911,0401,0921,1471,2041,2641,3271,3941,4641,5371,6141,6941,779
41
New Subscribers tot2002102212322432552682812953103263423593773964164374584815055315575856146456777117477848238649089531,0011,0511,1031,1581,2161,2771,3411,4081,4781,5521,6301,7111,7971,8871,9812,0802,1842,2932,4082,5292,6552,7882,9273,0733,2273,3893,558
46
Calcs
47
48
New Subcriber split
49
New Subscribers tot are split between…2024Jan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
50
New Free Users70%New Free Users1401471541621701791881972072172282392512642772913063213373543713904104304524744985235495766056356677007357728118518949399861,0351,0871,1411,1981,2581,3211,3871,4561,5291,6051,6861,7701,8581,9512,0492,1512,2592,3722,491
51
New Paid Subscribers30%New Paid Subscribers60636669737780848993981031081131191251311381441521591671761841942032132242352472592722863003153313483653834024224444664895135395665946246556887227597968368789229681,0171,067
52
Check Total is 100%: 100%New Subcriber split Total2002102212322432552682812953103263423593773964164374584815055315575856146456777117477848238649089531,0011,0511,1031,1581,2161,2771,3411,4081,4781,5521,6301,7111,7971,8871,9812,0802,1842,2932,4082,5292,6552,7882,9273,0733,2273,3893,558
53
Calcs
54
55
Free Tier
56
Fees every
Subscription paid every M months
Jan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
57
Customers pay us this amount every M monthsM months2024
58
Free Tier 1 0 Free Tier invoiced2854781011231441641842032222412602792993183383593804024244484724975245515806106416747087447828228639079521,0001,0501,1031,1591,2171,2781,3421,4091,4791,5531,6311,7131,7981,8881,9832,0822,1862,2962,4102,5312,6582,7902,9303,076
59
Can leave every
Leavers (% lost every N months)
60
At the end of every contract period this % leave…N months2024
61
Free Tier 1 2%Free Tier active1402703925076167218229211,0171,1121,2071,3011,3971,4931,5911,6911,7941,8992,0082,1212,2382,3602,4862,6182,7552,8993,0493,2053,3703,5413,7223,9104,1084,3164,5334,7615,0015,2525,5165,7936,0836,3886,7087,0447,3977,7678,1568,5648,9929,4429,91510,41110,93111,47812,05212,65513,28813,95214,65015,382
62
Switchers (% switching every N months)
63
…and this % switch to a higher tier2024
64
Free Tier10%Free Tier switch- 14273951627282921021111211301401491591691791902012122242362492622762903053213373543723914114324534765005255525796086396717047407778168568999449911,0411,0931,1481,2051,2651,3291,3951,465
65
66
Free Tier leave- 358101214161820222426283032343638404245475052555861646771747882869195100105110116122128134141148155163171180189198208219230241253266279293
67
68
Free Tier MRR2854781011231441641842032222412602792993183383593804024244484724975245515806106416747087447828228639079521,0001,0501,1031,1591,2171,2781,3421,4091,4791,5531,6311,7131,7981,8881,9832,0822,1862,2962,4102,5312,6582,7902,9303,076
73
Calcs
74
75
Paid Tier
76
Fees every
Fee Paid every M months
Jan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
77
Customers pay us this amount every M monthsM months2024
78
Paid Tier 1 20 Paid Tier bookings1,2002,6204,2215,9737,8489,82811,89614,03916,24918,52020,84723,22825,66328,15230,69933,30635,97738,71741,53244,42847,41250,49053,67156,96160,37163,90767,58071,40075,37479,51583,83388,33993,04397,959103,098108,474114,100119,990126,158132,619139,391146,488153,930161,732169,916178,500187,505196,954206,868217,271228,190239,649251,677264,302277,554291,466306,070321,401337,497354,395
79
Can leave every
Leavers (% lost every N months) set for life when join
80
At the end of every contract period this % leaveN months2024
81
Paid Tier 1 10%Paid Tier active601312112993924915957028129261,0421,1611,2831,4081,5351,6651,7991,9362,0772,2212,3712,5252,6842,8483,0193,1953,3793,5703,7693,9764,1924,4174,6524,8985,1555,4245,7055,9996,3086,6316,9707,3247,6968,0878,4968,9259,3759,84810,34310,86411,40911,98212,58413,21513,87814,57315,30416,07016,87517,720
89
Calcs
90
91
4. USES OF CASH
92
93
94
Management team
95
These are our key roles with their salary and start dateStart Month
Annual Salary
Jan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
96
97
CEOJan-2024 80,000 CEO6,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,667
98
CTOJan-2024 - CTO- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
99
Chief Data ScientistJan-2024 - Chief Data Scientist- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
100
Head of ProductJan-2024 - Head of Product- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
101
Sales DirectorJan-2024 - Sales Director- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
102
Marketing DirectorJan-2024 - Marketing Director- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
103
Finance DirectorJan-2024 - Finance Director- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
104
Customer Service DirectorJan-2024 - Customer Service Director- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
105
Operations DirectorJan-2024 - Operations Director- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
106
HR DirectorJan-2024 - HR Director- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
107
Other leadership 1Jan-2024 - Other leadership 1- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
108
Other leadership 2Jan-2024 - Other leadership 2- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
109
Other leadership 3Jan-2024 - Other leadership 3- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
110
Management team total costs
6,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,6676,667
126
Calcs
127
128
Other teams
129
Ave Salary p.a.
Team sizes set by year
Start in
130
We set the number of people in each team and average salariesif full time2024monthJan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
131
Sales team - 0.0Jan-2024Sales team costs- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
132
Marketing team - 0.0Jan-2024Marketing team costs- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -