open source financial model
As investors and advisers, we have built hundreds and reviewed thousands of financial models, and have formed views and developed best practice in the process.
We've written exTensively on the topic*
*Note that as Graphite Financial is a new entity, these were originally authored and attributed to ff Venture Capital, from which we were formed.
Now we're putting out a simple template for the world to use
It's a three-statement model, meaning it has an Income Statement, Balance Sheet and Statement of Cash Flow. Any model that doesn't have all three will not project cash burn accurately.
It tells you what you need to know. The model cleanly spits out relevant, digestible, summary information in a board-ready format.
It bridges the gap between real-life and projections. It takes into account things like "real" Accounts Receivable and Accounts Payable.
It lets you know when you've made a mistake. The model has a series of tests that will let you know if something is broken on each page, so you'll know when you need to press Control-Z.
Just remember, this is a template, or a shell. There is no one size fits all solution. Every business is different, and you will need to customize this for your business. This is of course something we have extensive experience with and can assist with.