The result - after ~30 hours it's usable enough to show. Obviously needs more flexibility around the variety of revenue models and expense categories. But really it's just for rough estimates at this point.
- Spreadsheets are prone to fat-fingering and messing up formulas. For example, if you built a spreadsheet with three product SKU's and wanted to add a fourth, it's not so easy. Especially if you have visualizations tied to specific ranges of cells, etc. With this app I can validate data once and not worry about some random missing formula screwing it up down the road.
- When creating models for comparison the typical pattern is Save As -> New. Before you know it, you've got 8 or 10 different spreadsheets with different variations on the numbers. Now add a new expense category to the model in spreadsheet #10. If you want to compare backwards to the rest you'll need to do that work over and over (this is the pattern I was stuck in).
- Longer-term I wanted to be able to overlay models - sort of an A/B test given different configuration
- During the past few months I've met with countless entrepreneurs trying to launch startups pre-money. Most of them are trying to build models from scratch (or a template they found) and it's been a clear pain point for them
- I can share models in a service like this easily. I've already used it several times when someone's asked me to help validate their business model. I create the model in the app and send them a link. They can tweak it and show me their ideas. It's crude right now, but collaboration between founders on something like this might be worthwhile.
- Even longer-term I'd like to add in more templates to support startups beyond the initial financial model. Basically I looked at my last several years' worth of operational spreadsheets from helping run SaaS companies and thought "there ought to be an app for this".
Perhaps it's because I've spent many, many hours using Excel (although less so these days), but those problems you state don't seem like problems:
1) Fat-fingering is a problem only if you mix the task of coding (setting up the structure and formulae in Excel) with the task of using (changing the parameters). You don't code your web site at the same time as using it (except for manual testing), and it can be the same with Excel. Highlight all input cells with a yellow background and blue font, unset their 'Protected' property, and then lock the workbook. You/anyone can then play to your heart's content without worrying about messing up formulae.
2) When you are creating new versions of a spreadsheet, it's either because you are changing the structure (e.g. changing formulae, adding columns) or because you are changing the input data. If the latter then, yes, you can have several different versions. I've managed this in the past (when fundraising and doing regular reviews with investors) by having an 'Assumptions' tab which contains _all_ inputs. Each scenario (set of assumptions) has a name/number and a column of its own. The calculations and output dynamically reference just one scenario at a time depending on the scenario chosen from a drop-down. Not only that, but Excel's 'Data tables' feature (which explicitly supports only one-variable or two-variable scenarios) works with this, even if you have 10s of variables: just set the scenario number as your variable.
3) Using a 'template they found' is clearly a bad idea. They wouldn't just copy-paste some 'code they found' without studying it and the tests. In fact, for something simple, they'd probably just re-create their own after studying someone else's code for something similar. It's the same with Excel files.
4) Can't argue with this one :)
5) This last point intrigues me: until now I thought you were focused on business plans, and that you wouldn't overwrite the historical data with actuals. However, you mention operational data, suggesting you are talking about combining planning and tracking into one tool. Is this correct?
Minor spelling issue I noticed that was bugging me all over the place:
s/Reccuring/Recurring/
This tool is fantastic.
I'd love to be able to modify it for non-MRR companies though. What license are you releasing the code under?
An app like this would hopefully remove some of that rework and eventually allow A/B testing of different fundraising scenarios, or different revenue models with similar fundraising, etc.
You can download here: http://www.startupmodels.com/download/
I haven't used it myself but I know that it has helped quite a few companies work through their financial projections around here. It's at least a decent starting point.
(More info: http://www.siliconprairienews.com/2011/10/startup-models-see... )
For starters, with my business model, the monthly expenses depend on the number of customers directly. Every time I get a customer, I automatically deploy a VM. And I am charging them a few more bucks than the VM costs, so my revenue is directly tied to the number of customers also.
Maybe I just need a spreadsheet. But really its pretty simple. I plan to launch something that I can support alone. Within a month or so, I need to have enough profit to hire a guy from oDesk to help with support.
The other part is charging for support, which I plan to make separate from the servers. So you can pay as low as $5 if you want minimal support, up to $500 if you are a business and want to prepay for up to half a day of consulting each month.
So what I want is a spreadsheet that I can change that has a projection chart off to the side that is automatically connected to the spreadsheet.
With template spreadsheets/charts that I can configure.
Maybe use something like Google Spreadsheets or http://stoic.com/formula/index.html
The addition of one-time costs or revenue based on customer acquisition is important and something that will be there eventually (training is a good example in Saas).
Also the slider seems to be capped out at some really low number (like 30 new customers a month or something?)... not sure if I'm doing something wrong?
The sliders are only one possible solution to visualizing the rate of growth per price tier. Most other things I've tried involve math fiddling that I haven't managed to translate well to a user experience.
Open to suggestions or examples if you have ideas!
Early on you have an idea of what sort of traffic you're able to generate and a likely conversion rate, and therefore estimate a sign up rate using real(ish) numbers. It's only the growth beyond that that you're really guessing at.
You may just want a text box with a gross # of new customers/month based on what you think you can bring in, and then have the slider work on top of that, in effect creating an adjustable polynomial function for growth? Just spitballing here...
Thanks for taking some time on it - feedback is most welcome as I'll continue to hack on it over the next few months - time permitting.
It's a stop-gap feature so that I didn't need to implement a login/authorization system in the MVP.
https://drive.google.com/file/d/0Bxgh-9Z9zd40ZExtRnYyZVhWU2s...
Feature development on the app will be faster (and reach a broader audience) than the spreadsheet, however. And I wanted to learn AngularJS ;)
It could load a bit slow. You can only log in with your Google account ATM.
Currious If you all like it...
Tim
