{"id":8173,"date":"2020-06-16T07:07:27","date_gmt":"2020-06-16T07:07:27","guid":{"rendered":"https:\/\/www.ezycount.ch\/?page_id=8173"},"modified":"2021-11-09T22:09:59","modified_gmt":"2021-11-09T21:09:59","slug":"startup-valuation-model-free-excel","status":"publish","type":"page","link":"https:\/\/www.ezycount.ch\/en\/startup-valuation-model-free-excel\/","title":{"rendered":"Startup valuation model and free excel sheet"},"content":{"rendered":"

Startup valuation model – Free Excel<\/h1>\n

The valorization of a startup is closer to an art than to a science. In this article, we show you how to value a company and how it fits for a startup. This is why we created a startup valuation model which can be dowloaded below. <\/p>\n

Valuation of a company<\/h2>\n

The model generally used for the valuation of a company is the discounted cash flow method or, in other words, the present value of all future profits of a company.It sounds complicated but I will try to explain it clearly and simply here.<\/p>\n

It all starts with understanding an investor’s thinking when making an investment. This reflection is very similar when he\/she buys a share, a building or a company, he\/she asks the question: “How much money will I receive per year? For a building, it is the sum of the rents per month, all costs and repairs\/investments. For a share, it is the dividends more or less the variation in the share price. For a company, in simple terms, it is the profit generated each year.It must be understood that an investor can invest in several projects and therefore he is considering investing in a company in order to invest in a building or any other possibility. So he wants to know how much he will earn.The calculation of the company’s value is done by looking at the financial results of the last few years and planning for the next 5 to 7 years. We add the benefits and multiply them by a ratio to show that they are not yet there but arrive in the future and hop, we have a valuation.For a startup, it’s unfortunately not that simple.<\/span><\/p>\n

Startup valuation<\/h2>\n

Since a startup has very little profit or even a history of profit and the company is planning strong growth, the models used to value a company do not work.The investor will therefore try to calculate at what value he will be able to sell to know at what amount he must buy now and in bulk at what value.<\/p>\n

An investor will think like this: at what value will I be able to sell the company in 4, 5 or 7 years. He\/she will look for a way to calculate this by looking at growth plans but also if similar startups have been purchased recently.If the investor thinks he can sell the company for 50 million in 5 years. It divides this amount by a risk coefficient that can range from 60% to 90% depending on the startup. As a result, he finds the current value after his investment.Download the Excel template below to try it out for your startup yourself!<\/p>\n

Most viewed contents<\/p>\n

\n

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“9bd08”:{“name”:”Main Accent”,”parent”:-1}},”gradients”:[]},”palettes”:[{“name”:”Default Palette”,”value”:{“colors”:{“9bd08”:{“val”:”rgb(245, 168, 28)”}},”gradients”:[]},”original”:{“colors”:{“9bd08”:{“val”:”rgb(19, 114, 211)”,”hsl”:{“h”:210,”s”:0.83,”l”:0.45}}},”gradients”:[]}}]}__CONFIG_colors_palette__ <\/span> How to do my accounting?<\/span><\/span><\/span> <\/a> <\/p>\n

An easy-to-use secure online accounting and invoicing platform aimed at SMEs and the self-employed.<\/p>\n

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“9bd08”:{“name”:”Main Accent”,”parent”:-1}},”gradients”:[]},”palettes”:[{“name”:”Default Palette”,”value”:{“colors”:{“9bd08”:{“val”:”hsla(var(–tcb-main-master-h, 210), var(–tcb-main-master-s, 77%), var(–tcb-main-master-l, 54%), 1)”}},”gradients”:[]},”original”:{“colors”:{“9bd08”:{“val”:”rgb(19, 114, 211)”,”hsl”:{“h”:210,”s”:0.83,”l”:0.45}}},”gradients”:[]}}]}__CONFIG_colors_palette__ <\/span> How to organize your office?<\/span><\/span><\/span> <\/a> <\/p>\n

Organize your office to be more efficient in your administrative tasks.<\/p>\n

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“9bd08”:{“name”:”Main Accent”,”parent”:-1}},”gradients”:[]},”palettes”:[{“name”:”Default Palette”,”value”:{“colors”:{“9bd08”:{“val”:”hsla(var(–tcb-main-master-h, 210), var(–tcb-main-master-s, 77%), var(–tcb-main-master-l, 54%), 1)”}},”gradients”:[]},”original”:{“colors”:{“9bd08”:{“val”:”rgb(19, 114, 211)”,”hsl”:{“h”:210,”s”:0.83,”l”:0.45}}},”gradients”:[]}}]}__CONFIG_colors_palette__ <\/span> How to create Swiss invoices?<\/span><\/span><\/span> <\/a> <\/p>\n

Find all the information you need to create compliant and complete Swiss invoices.<\/p>\n

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“9bd08”:{“name”:”Main Accent”,”parent”:-1}},”gradients”:[]},”palettes”:[{“name”:”Default Palette”,”value”:{“colors”:{“9bd08”:{“val”:”hsla(var(–tcb-main-master-h, 210), var(–tcb-main-master-s, 77%), var(–tcb-main-master-l, 54%), 1)”}},”gradients”:[]},”original”:{“colors”:{“9bd08”:{“val”:”rgb(19, 114, 211)”,”hsl”:{“h”:210,”s”:0.83,”l”:0.45}}},”gradients”:[]}}]}__CONFIG_colors_palette__ <\/span> How to valuate my startup?<\/span><\/span><\/span> <\/a> <\/p>\n

Free Excel model to calculate the value of your startup when it is not yet making a profit or very little.<\/p>\n

__CONFIG_group_edit__{“kbjp1vpj”:{“name”:”All Logo(s)”,”singular”:”– Logo %s”},”kbjp1xfn”:{“name”:”All Title(s)”,”singular”:”– Text %s”},”kbjp22kc”:{“name”:”All Paragraph(s)”,”singular”:”– Text %s”},”kbjp2ag5″:{“name”:”All Read Review Button(s)”,”singular”:”– Button %s”},”kbjp3xj6″:{“name”:”All Visit Website Button(s)”,”singular”:”– Button %s”},”kbjp44dp”:{“name”:”All Buttons Column(s)”,”singular”:”– Column %s”},”kbjp4d43″:{“name”:”All Text Column(s)”,”singular”:”– Column %s”},”kbjp4k9i”:{“name”:”All Content Box(s)”,”singular”:”– Content Box %s”},”kbjp4mck”:{“name”:”All Content Box(s)”,”singular”:”– Content Box %s”}}__CONFIG_group_edit____CONFIG_local_colors__{“colors”:{},”gradients”:{}}__CONFIG_local_colors__ __CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“55242”:{“name”:”Accent Lighter”,”parent”:”3c75f”,”lock”:{“saturation”:0,”lightness”:1}},”3c75f”:{“name”:”Main Accent”,”parent”:-1},”965f3″:{“name”:”Accent Transparent”,”parent”:”3c75f”}},”gradients”:[]},”palettes”:[{“name”:”Default”,”value”:{“colors”:{“55242”:{“val”:”rgb(198, 199, 199)”,”hsl_parent_dependency”:{“h”:144,”l”:0.78,”s”:-0.01}},”3c75f”:{“val”:”var(–tcb-skin-color-0)”},”965f3″:{“val”:”rgba(245, 165, 25, 0.47)”,”hsl_parent_dependency”:{“h”:38,”l”:0.53,”s”:0.92}}},”gradients”:[]},”original”:{“colors”:{“55242”:{“val”:”rgb(201, 201, 201)”,”hsl_parent_dependency”:{“h”:0,”s”:0,”l”:0.78}},”3c75f”:{“val”:”rgb(102, 57, 248)”,”hsl”:{“h”:254,”s”:0.93,”l”:0.59}},”965f3″:{“val”:”rgba(102, 57, 248, 0.47)”,”hsl_parent_dependency”:{“h”:254,”s”:0.93,”l”:0.59}}},”gradients”:[]}}]}__CONFIG_colors_palette__ \"Retrouver<\/span><\/p>\n

Are you looking for a simple Swiss accounting solution? EZYcount is for you.<\/h6>\n

<\/span> Try now<\/span><\/span> <\/a> <\/p>\n

Improve the valorisation of your startup<\/h2>\n

To improve the value of your startup, you must reduce the risk of project failure. Here is a non-exhaustive list:<\/p>\n