What we know, what we don’t, and trying to make sense of it all.
Not sure what this is, start here with our README, or catch up on last week, VRBTM Making It Up | Week XII.
As I left it last week, I decided to get the Standard Financial Model made by Taylor Davidson from Foresight.is rather than develop our model from scratch. I figured there’d be some logic in the template that I wasn’t aware of, and ultimately it would save time in getting to where we needed to be.
One thing I also brought up was that we need to find a balance in our model so it’s not too basic that it doesn’t help us, but also not be so involved that we get caught up on the numbers. Especially as these are only assumed projections at this point. After putting everything in I think the Standard Model as a whole is probably a bit much currently. So now it’s a matter of pulling out what we need and tracking from that — knowing we have the full model available to us when the time comes.
To get some clarity out of the model I’m going to pull the numbers out and go month-by-month looking at the assumptions to see what we can figure out.
Things To Note
- We’re only going to look at the first 18 months. Anything past that is truly baseless.
- We’re not including our salaries in the model yet. This is only looking at the business expenses and revenues.
Baseline Assumptions
- We have three pricing tiers: Solo $10, Studio $15, Agency $25 / month / per seat.
- We anticipate a: 25% Solo, 50% Studio, 25% Agency subscription breakdown.
- Cost Of Goods Sold (COGS): $2.50 Solo, $2.50 Studio, $3.00 Agency / month / per seat.
- We’ll be utilizing these services to scale VRBTM: Meteor Galaxy, mLab, FileStack, SendGrid, MailChimp, Amazon S3, and GitHub.
- Other costs considered are: Business Development (field sales), Twitter Ads, Zendesk, and Credit Card Processing (stripe).
- Admin services will include: G Suite, Slack, Creative Cloud, Office 365, Xero, and Baremetrics,
Projection Assumptions
- 555 paying users, at the end of 18 months would put us at ~$100k Annual Recurring Revenue (ARR), and feels like a moderate projection.
- From our connections and the interest of the platform I assume having 70 Beta Testers in months 4, 5, and 6, in lead up to our public launch in month 7.
Ok, let’s look at this month-by-month.
Months 1 to 6 is our development and beta stage. Costs here will be kept low and only start to scale when we start adding beta testers in Months 4, 5, and 6.
Month 1
October, 2016
Users: 0
Revenue: 0
Costs: $37.50
Net: -$37.50
Month 2
November, 2016
Users: 0
Revenue: 0
Costs: $50.81
Net: -$50.81
Month 3
December, 2016
Users: 0
Revenue: 0
Costs: $52
Net: -$52
Month 4
January, 2017
Users: 25 BETA
Revenue: 0
Costs: ($115 + $120 for BetaList) $235
Net: -$235
Month 5
February, 2017
Users: 55 (+30) BETA
Revenue: 0
Costs: $115
Net: -$115
Month 6
March, 2017
Users: 70 (+15) BETA
Revenue: 0
Costs: $215
Net: -$215
Here’s when the model really starts to kick in as we go from a free beta, to a paid platform. Because of that we can’t expect all 70 of our beta testers to stick around and pay for the service. To adjust for this we are assuming a 25% conversion rate that increases 2% every month until reaching 50%. This increase will be due to our sales materials becoming more tailored to our target demo the more we interact with them. We’re also assuming that we’ll see 70 new people viewing the platform per month, which will grow by 2% increasing by 1% every month up to a 5% organic growth rate. The thinking here is that over time more people will become familiar with the platform through organic searches or from the nature of the platform as it requires two or more people to work. Meaning a VRBTM user could send a VRBTM to a non-user who then converts. We’re also going to assume our direct business development efforts and how many new users we can convert each month. These coming from sales pitches, product demos, and really doing all that we can to get this in front of people and selling. I’ve made some assumptions around time of year as to why this number rises and falls. We also have a 2% Churn Rate of lost subscribers.
Month 7
April, 2017
Users: 38
(Organic: +18, BizDev: +20)
Revenue: $617.5 MRR
Costs: $636
Net: -$19
Month 8
May, 2017
Users: 76
(Organic: +19, BizDev: +20, Churned: -1)
Revenue: $1,235 MRR
Costs: $765
Net: $470
Month 9
June, 2017
Users: 114
(Organic: +19, BizDev: +20, Churned: -2)
Revenue: $1,852.5 MRR
Costs: $975
Net: $877
Month 10
July, 2017
Users: 161
(Organic: +20, BizDev: +30, Churned: -2)
Revenue: $2,616.5 MRR
Costs: $1,219
Net: $1,397
Month 11
August, 2017
Users: 209
(Organic: +21, BizDev: +30, Churned: -3)
Revenue: $3,396.25 MRR
Costs: $1,395
Net: $2,001
Month 12
September, 2017
Users: 267
(Organic: +22, BizDev: +40, Churned: -4)
Revenue: $4,388.75 MRR
Costs: $1,665
Net: $2,723
Month 13
October, 2017
Users: 335
(Organic: +23, BizDev: +50, Churned: -5)
Revenue: $5,443.75 MRR
Costs: $2,187
Net: $3,256
Month 14
November, 2017
Users: 382
(Organic: +24, BizDev: +30, Churned: -7)
Revenue: $6,207.5 MRR
Costs: $2,245
Net: $3,962
Month 15
December, 2017
Users: 419
(Organic: +25, BizDev: +20, Churned: -8)
Revenue: $6,808.75 MRR
Costs: $2,345
Net: $4,463
Month 16
January, 2018
Users: 487
(Organic: +26, BizDev: +50, Churned: -8)
Revenue: $7,913.75 MRR
Costs: $2,778
Net: $5,138
Month 17
February, 2018
Users: 554
(Organic: +27, BizDev: +50, Churned: -10)
Revenue: $9,002.5 MRR
Costs: $3,018
Net: $5,984
Month 18
March, 2018
Users: 611
(Organic: +28, BizDev: +40, Churned: -11)
Revenue: $9,928.75 MRR
Costs: $3,184
Net: $6,774
I’m not sure if I made myself more confused going through this exercise or less so. Some things jumped out, while others were much more muddled. I do think at this time it’ll be much easier with a simpler model that I can make in Google Sheets. That said, I wouldn’t of been able to know what we should be looking at without going through the process of modeling everything.
The problem with models however, is that they all trend upward at an exponential rate. Making it appear that the business is destined for greatness. Which we of course want, but the one thing for sure is that the model is wrong. So there’s only so much we can take from this, and it’s knowing what’s important to take from it and what’s not at the moment.
What this model really shows is that it takes a considerable amount of paying users to get to a sustainable business. I haven’t included salaries or any physical expense like a WeWork space in here and when I put those in it changes everything about how we have to look at this. Either we need to raise capital, we have to be much more aggressive in our growth strategies, or we look at it as a time investment that we’ll have to make in getting to that point of sustaining ourselves. Each that has their pros and cons which we’ll have to make decisions about relatively shortly.
We’ve done a ton of work in the past few months and while it’s all documented here in our write ups, I need to spend some time collecting all of the relevant pieces and putting together our story. This will be to develop our sales materials for when it’s time to start pitching the platform to those outside of our immediate connections / those who are aware of the platform already.
We’d love to hear from you…
Get in touch at Founders@vrbtm.co, talk with us on twitter @vrbtm.co, and read our story on medium.
Wes Jones is on Twitter @WesJonesCo
Nick Dandakis is on Twitter @Dandakis