Originally published: 10/08/2016 13:26
Last version published: 26/01/2017 14:48
Publication number: ELQ-80767-2

Startup Financial Model Template

A simple financial model for an early-stage startup/anyone building a model for a company

by David Teten
Managing Partner @ HOF Capital

by ff Venture Capital
The most engaged technology venture capital firm in New York City.

150 reviews6,983 views|Start the discussion!|download for free

finance financial model entrepreneurship startups early-stage end-to-end standard financial statements venture capital key operating metrics raising capital

Description
The following financial model is designed to cover all sections need for an early-stage business. It produces standard financial statements and important operation metrics that are calculated from the user’s inputs.

A plus to the model is that it can be easily customized to a company’s needs, as well as being completely transparent.

Some credits of this model go to Rodi Blokh who along with ff Venture capital (www.ffvc.com) developed the model in the basis of a cleaned up version of a financial model, specifically for start-ups, built by David Teten (www.teten.com).

Rodi is a MBA students graduated in Berkeley, who was formerly a corporate banker at the Bank of America Merrill Lynch.

David is a partner of ff Venture Capital, as well as the chair of Harvard Business School Angels of Greater NY and formerly an investment banker for Bear Stearns.

Special thanks to Adam Kalamchi (Columbia MBA ’13) who gave some input into the model.

- David Teten

This Best Practice includes
1 Excel spreadsheet

David Teten offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Objectives

The model is designed to give you the following standard financial statements:

1/ The income statement sheet is built to configure both your expenses and revenues at the moment changes take place. As opposed to the Cash Flow statement, that takes measure of the actual money movement, the income statement saves money transaction processes and forecasts things such as depreciation, that don’t actually show yearly flows of cash, but instead are measured in multiple years.

2/ The balance sheet gives you a view of your company at a particular date, it tells you how many assets are available at the given time, but not necessarily related to previous or later dates. This sections allows you to see listed assets, liabilities and your equity.

3/ The cashflow statement is key for a startup given that it tells you whether you can or you can’t pay the crucial bills, for example, paying your employees.

4/ To further make the model whole, we added a Discounted Cash flow valuation tab, but this may not be very important for startups. In the end of it all, forecasting cash flows for startups is rather based on probabilities or even guessing. Startups however can see their valuation clearer if discusses with an investor, rather than a DCF.

5/ The funding round tab, the last tab on your model, should help you when evaluating the options available for raising capital. One important thing here would be that your current shareholders will be diluted if your future capital raises, for this reason the model will show you what the final equity share percentage will be after you have gone through your planned funding stages.

Use it if

The downside is that typically, financial models are designed for more established businesses so the assumptions and calculations in these cases are not suitable for startups (i.e terminal growth and EBITDA multiples). The model should be a strong enough option for entrepreneurs that want to analyse and evaluate the operational side to their business, but it does not aim at limiting against pivots and tech disruptions.

Reviews

- 4.5 / 5 (150 votes)
  - 69%
  - 19%
  - 9%
  - 1%
  - 2%
- Rate this Downloadable Best Practice
  Write a review
Iyanu Akinladenu(last updated: 05/04/2021 21:45)
Seref Celiktas(last updated: 17/01/2021 05:30)
Robin Thomas(last updated: 16/01/2021 05:23)
GavMas(last updated: 21/11/2020 01:31)
hamide Amiri(last updated: 09/10/2020 05:13)
Chaithanya Raju(last updated: 03/10/2020 07:56)
CA.Rajesh Yanamandram(last updated: 20/09/2020 15:22)
Mohamed Gamal Elmenshawy(last updated: 14/09/2020 13:48)
Adib Basbous(last updated: 10/09/2020 07:55)
Phil Clarke(last updated: 03/09/2020 23:39)
Vijay Jonnala(last updated: 20/07/2020 21:10)
Hoanganh Setup(last updated: 12/04/2020 18:22)
Tareq Al Mahsiri .PMP(last updated: 19/02/2020 13:40)
Bhaskar Das(last updated: 27/01/2020 17:36)
ALI BENSABER(last updated: 05/12/2019 15:54)
Sylvia Rhodes(last updated: 15/11/2019 07:10)
Sanjay Bandare(last updated: 14/11/2019 06:36)
dani santoso(last updated: 30/10/2019 04:34)
José Nunes(last updated: 23/10/2019 16:54)
Shamsher Singh Gill(last updated: 24/09/2019 05:22)
Mansi Jaiswal(last updated: 12/09/2019 07:22)
mddave(last updated: 10/09/2019 08:33)
George Lugembe Malyeta(last updated: 07/09/2019 04:47)
Nipun A Bhuyan(last updated: 03/09/2019 04:09)
Saurav kumar(last updated: 27/08/2019 22:45)
Terence Chia(last updated: 17/08/2019 15:32)
Charles.HA. Chen(last updated: 31/07/2019 03:30)
Rajneesh Dwivedi(last updated: 14/07/2019 05:46)
gus cor(last updated: 03/07/2019 08:16)
Ok
I would expect higher quality from someone with this reputation. A lot of repetition in the model, hard to read, and a lot of redundant information. Works fine though.
Hanh Ho(last updated: 23/06/2019 07:47)