Skip to content

Eric Friedman

  • Home
  • Fractional COO & Coaching
  • About

Financial modeling for early stage startups

July 19, 2019 by Eric Friedman

Many early stage investors look for financial models for 3+ years from founders to make an investment. Entrepreneurs often don’t have this information, don’t know how to put it together for the first time, and often are confused by the request.

Like most posts, this request/conversation has come up enough to turn it into my thoughts + the best resources I have to help founders. I have also backed businesses without this info based on other factors and don’t always think its required.

The best resource I have seen for financial modeling templates for startups is https://foresight.is/ which is built by https://taylordavidson.com/ and a constant place I have sent founders. They can download/purchase a financial modeling template, learn the dynamics of the entire worksheet, and turn it into their own.

Even if it’s too early, you are pre-revenue, or just at the idea stage I think its ok to hold your nose and go through the OpEx exercise. Putting something together is very helpful to think through scenarios and come up with some idea of a plan. It will arguably be more helpful to the business than not if you have nothing right now.

For me, this exercise is about competence of a modeling vs accuracy of the financial model.

I can’t remember an early stage team putting together a model that has been accurate for 3 years. In fact, for early stage companies you are usually wildly wrong. Things are either performing way above expectations or you are drastically below them. As mentioned above, the goal for me in looking at a model is the competency of setting up and predicting the costs and monthly burn for the business. It shows some of the thinking of hiring against capital projections. It shows the potential revenue, or intentional delay of revenue, associated with the business. It shows the ability to model out, month-by-month, the real costs of the business. It provides a framework to measure the books monthly – expected vs. actual. Finally, it allows for an intelligent discussion to really understand the business. 
Here are some questions that come directly from this kind of opex planning;

  1. It looks like you have 4 engineers starting in July – do you know who they are yet and what they will be working on?
  2. You have initial revenue in September, do you have an idea of pipeline and close rates for those customers?
  3. There’s a change in the unit economics in 6 months and looks like production ramps at the same time – is there a discount at this scale/volume?

Obviously all hypothetical questions but based in reality in the numbers from a founder. Instead of trying to pick apart a business, you can see the world through their eyes (in the numbers at least) and see if they can put together a comprehensive view of what will be spent. 

A financial model can be a quantitative view of the vision a founder wants to build, and a great way to get to know the strategy of what is going to be built.

Related

Tags: Financial Modeling, OpEx Plan

Post navigation

Previous Post:

Avoiding competitor distractions

Next Post:

The F*ck It Fund

Search

Subscribe via email

Recent Posts

  • SOS Shiny Object Syndrome
  • 2021 Predictions
  • What needs to be true?
  • Don’t be afraid of a “No”
  • Streaming Venture Funds

Top Posts

  • Financial modeling for early stage startups
    Financial modeling for early stage startups
  • SOS Shiny Object Syndrome
    SOS Shiny Object Syndrome
  • Quiet Giants
    Quiet Giants
  • 3 Wide 3 Deep
    3 Wide 3 Deep
  • Aberrant Geniuses (aka jerks)
    Aberrant Geniuses (aka jerks)
  • 2021 Predictions
    2021 Predictions
  • Building The Machine
    Building The Machine
  • The Best Social Network is the one you have with you
    The Best Social Network is the one you have with you

Follow me on Twitter

My Tweets

Projects

  • Building The Machine
  • DoBlu.com
  • Eat.ly
  • Multiplayergames.com
Thoughts from Eric Friedman