Time & Money
I am setting out to build a financial modeling platform in Coda that would make Coda not only competitive with Excel, but superior to Excel, for building and using financial models. I call it Time & Money. I know it sounds ambitious, but isn’t Coda itself pretty ambitious?
So far, I have created a relatively simple prototype that demonstrates how a financial modeling platform in Coda might work. It demonstrates:
- That time series data, such as monthly cash flows, can be addressed in Coda.
- How in Coda, cash flows can be generated by rules, rather than by copying numbers and formulas across columns and down rows as in Excel.
- Some huge advantages of a rules-based approach to generating a financial model:
- The user can easily modify major model parameters, such as the project schedule, that would require structural changes to an Excel model.
- Changes can be made to model parameters definitionally, such as to increase all expenses by 5%. To do something like this in Excel would require what a financial modeler would likely call “brain damage."
- Errors in copying cells across and down, which are hard to eliminate in Excel, become nonexistent.
To get a copy of the prototype: 1) click the link below, 2) click “Open with Coda” at the top of the screen, and 3) click on the down arrow next to the “Time & Money Prototype” title to select “Copy doc.”
Time & Money grew out of a project I started a few years ago, to be built on top of Excel. I had run a real estate development company that relied heavily on cash flow modeling, and I was continuously frustrated by how seemingly small changes to the model (“hey, what if you put a 5% annual growth rate on sales prices?”) required hours to implement. What’s worse, we kept finding little errors in programming cells, particularly as models became more complex, that had huge effects on the projected bottom line. Holding a 30-page printout of a model that we were going to use to make a major financial decision, I would joke (with gallows humor), “so we are going to bet the whole project on this packet of paper?”
Although I set out to build Time & Money years ago to solve some of these major financial modeling problems, I realized that doing it on Excel would be an immense project. I got bogged down, then got a job, and I set Time & Money aside. Now Coda provides a platform that provides an easily programmed relational database engine at its foundation—a far better base for building Time & Money—and I am at it again.
This prototype is the first step. From here, I plan to:
- Generalize Time & Money to make it a platform for building cash flow models of all kinds;
- Create Time & Money templates for specialized uses with which I am familiar;
- Add features, such as handling debt and equity financing structures, to increase the usefulness of Time & Money; and, eventually
- Add features that make it useful for other types of financial modeling (beyond cash flow modeling).
I don’t know yet how Time & Money should be monetized. That may depend largely on what tools Coda might provide in the future for distributing and monetizing Coda docs/apps/templates.
I would love any feedback on the concept and on the prototype.