In the first two posts in this series, we examined why building a financial model for your startup is important and how to practically get started with your assumptions tab. Today, we’ll continue by diving into the income statement and supporting tabs used to calculate your projected revenue and expenses.
In the previous post of this series, we described what financial modeling is and why it is important for startup founders to build their own models from scratch. Today, we’ll begin by diving into how to practically start building a financial model. In coming weeks, we will also be covering the income statement as well as cash flow, balance sheet and keeping the model updated.
The first of a four part series on building a financial model. In short, a financial model is an abstract mathematical representation of how a company works (and more importantly, how it will work going forward). The model has inputs and outputs. The inputs are the assumptions that drive the model, things like what drives your customer acquisition cost, what your churn rates are, how much you pay people, etc. The outputs are a set of projections that show how the company will perform if the assumptions are true. One model can produce multiple sets of projections given different assumptions.