Startup Valuation Model in Excel | Eqvista (2024)

Business valuation is the basis of any future sale or acquisition of a company. Investors and analysts use various startup valuation models to estimate a company’s worth, which can vary drastically based on the figures and assumptions involved.

Valuation models in excel are some of the commonly used formats, and give the company founders and investors a general idea of how much the company is worth. Let’s take a brief look at some of them startup valuation models out there.

Startup Valuation Methods

Startup valuations can be tricky, especially in their pre-revenue stages. Startup valuation models used at this stage have to rely on assumptions. Despite this limitation, the importance of valuation can’t be overlooked. Every startup requires funds to grow and expand their business and a reliable valuation is the only way of estimating the business worth. It is only based on this calculation that investors evaluate funding proposals. In this section, we discuss some of the common valuation methods used for startups.

Startup Valuation Model in Excel | Eqvista (1)

Market Capitalization

This is one of the simplest startup valuation models. Market capitalization determines the total dollar market value of a company’s outstanding shares. It is a far more dependable measure in comparison to the total asset or revenue figures. Investors use the market cap as a quick measure of the company size and a reliable indicator of possible risks.

Market cap = Price per share x Total number of outstanding shares

Companies are categorized based on their market cap. Here is a suggested range:

  • $10 billion or more – Large cap
  • $2 billion – $10 billion – Mid cap
  • $300 million – $2 billion – Small cap

Let’s take an example of two companies A & B worth $2 billion each. Company A has 20 million shares in the market selling at $100 while Company B has 200,000 shares selling at $10,000 each. From an investor’s point of view Company A is much more stable and functional in the industry.

Market cap is established only after a company goes public through an IPO. Before this stage, a startup must engage a professional valuation firm to get a realistic value of the business using various startup valuation models. Based on this information, the startup determines how many shares to issue and at what value. A $10 million company may want to issue 1 million shares at $10 per share or 2 million shares at $5 per share.

Once a startup goes public, their share prices are determined by market forces. The supply and demand of its products and services impact the price of shares. A higher demand increases share price while a falling demand crashes stock prices. Once a company starts trading in the stock market, the market cap becomes a real-time estimate of the company’s value.

Times Revenue Method

This startup valuation method is used to understand the range of a company’s revenue potential. The idea is to determine the ‘max-value’ or ‘ceiling’ for a particular business. To calculate this, the actual revenue data over a period is considered (for eg. one fiscal year). A ‘multiplier’ is applied to this value. Thus a company valuation using Times Revenue Method can be 1x, 2x, 3x, or less than 1. Multiplier value depends on the industry and its economic growth. A hot industry such as AI may have 3x revenue while a service industry may qualify for 0.5x.

It is important to keep in mind that this startup valuation model may not be completely reliable as it uses a company’s overall revenue for calculations. Revenue is not the same as profits. High revenue does not necessarily mean high profits. But this method provides a starting point for investors to fairly estimate the company’s future growth potential.

Earnings Multiplier

This startup valuation model is used as a comparative study with similar companies. Investors use this method to check if the target company’s stock price is more expensive than it should be relative to its contemporaries in the market. Historical stock price data is also taken into consideration.

In this method, the target company’s current stock price is measured against its earnings per share (EPS). For eg, if a company’s current stock price is $100 and earnings per share are $10, the earnings multiplier will be $100/$10 = 10 years. Put simply, this is expressed as: This Company is trading at 10 times its earnings.

As we see, earnings multiplier methods do not provide an exact valuation. They rather give relative information about companies trading in the stock exchange. Investors use these metrics to invest in the most economical stocks that promise future profit potential.

Discounted Cash Flow (DCF) Method

This startup valuation model is used to estimate the present value of an investment based on the company’s future cash flows. This is one of the more commonly used valuation models used.

This again is a comparative metric and not an absolute one as a lot of its findings are based on assumptions. Analysts apply discount rates to neutralize any risks related to the business and its industry of operation.

Startup Valuation Model in Excel | Eqvista (2)

Where:

  • CF – Cash flow for a given year. Yr1, yr2, yr3…and so on.
  • r – Discount rate

If the DCF value is higher than the present investment, it indicates a positive outcome and potential good cash flow in the future years. However be sure to go through the details on how the discount rate was arrived at and what factors of the company were considered.

Book Value

Otherwise known as the ‘net book value’, this startup valuation model simply indicates the carrying value of company assets on its balance sheet. While this method is not the most accurate valuation method for your company, it is quick and easy to calculate and give you a ballpark estimate of the value of your company. It is calculated as follows:

Book value per share = Total common stockholders equity – preferred stock / no. of common shares

Book value serves two purposes:

  • It reflects the worth of company assets that shareholders are entitled to in case of company liquidation
  • This value when compared to the company’s market value indicates if their stocks are legitimately priced.

Be sure though to identify which assets may be subject to fair market adjustments (fixed assets, intangible assets, etc), and what other assets or liabilities are already at FV (cash and cash equivalents, accounts receivable and accounts payable, etc).

Liquidation Value

This startup valuation model is similar to the book value model but considers only the tangible assets like equipment, inventory, real estate, etc. Intangible assets are not considered in this calculation. Hence in value, liquidation value is always less than the book value but higher than the salvage value.

In the event of liquidation, most assets are sold at a loss. Hence investors use the liquidation value to asset a potential investment so that they have a fair estimation of how much they can expect in returns in case the company falls out of business.

Startup Valuation Model in Excel (DCF Method)

We have created a very simple startup valuation model in excel using the discounted cash flow method, one of the more common methods for company valuations.

As the startup may not have many company assets in the beginning, and being too early to have enough financial figures for comparing to other companies in the market, this income based approach may be the easiest way to determine your startup valuation.

Startup Valuation Model in Excel | Eqvista (3)

Do you want the free excel template?Download Sample DCF Excel Model

We included a template for a 5 year and 3 year weighted moving average, as some companies may not be able to determine their growth rate just yet. Also we believe a weighted average may be more applicable than a simple average, especially with early stage companies with fluctuating income levels.

In case you’d like more information on the 3 methods of company valuation, check out our other articles for how to find your company value using the Income Approach, Asset Based Approach and Market Based Approach.

Get your 100% reliable startup valuation in minutes with Eqvista!

It’s now easier and more convenient to get a valuation for your startup with Eqvista’s startup valuation software. We incorporate trusted valuation methodologies into the software to calculate the most accurate valuation for your startup. Also, the 30 multiple-choice questions covers 5 areas of your business: team/management, business, product, market, as well as sales and marketing. A summarized report will be made available for you in 20 minutes.

Startup Valuation Model in Excel | Eqvista (4)

Why should you choose Eqvista for your startup valuation?

There are many startup valuation models and none of them are used standalone. It is best left to the professional evaluators to choose the right mix of these methods to arrive at a justifiable value for the company.

Our team of valuation experts at Eqvista can help you in the valuation of your startup and get an audit ready 409a valuation report. Our online captable also helps you easily manage your company shareholders, equity transactions, valuation reports, and more.

Startup Valuation Model in Excel | Eqvista (2024)

FAQs

What is a company asking $50000 for 5% equity What is the company valued at? ›

If a company is asking for $50,000 for 5% equity they are valuing themselves at $1,000,000.

How do you calculate startup valuation? ›

There are two formulas you'll use to worked toward your valuation:
  1. Anticipated Return on Investment (ROI) = Terminal Value ÷ Post-Money Valuation.
  2. Post-Money Valuation = Terminal Value ÷ Anticipated ROI.

How to do valuation in Excel? ›

The NPV function is used to calculate the net present value (NPV) of the estimated cash flows and the terminal value by discounting them at the cost of capital. The current value of debt and cash can be subtracted from the NPV to determine the intrinsic value of equity.

What is reasonable valuation for startup? ›

Valuation by Stage
Estimated Company ValueStage of Development
$250,000 - $500,000Has an exciting business idea or business plan
$500,000 - $1 millionHas a strong management team in place to execute on the plan
$1 million - $2 millionHas a final product or technology prototype
2 more rows

What is the valuation of a company if 10% is $100000? ›

The Sharks will usually confirm that the entrepreneur is valuing the company at $1 million in sales. The Sharks would arrive at that total because if 10% ownership equals $100,000, it means that one-tenth of the company equals $100,000, and therefore, ten-tenths (or 100%) of the company equals $1 million.

What is 250k for 5 valuation? ›

Yes, if your company receives an investment of $250,000 for 5% equity, it means that the post-money valuation of your company is $5,000,000. This is because the investor is valuing the company at $5,000,000 by offering to invest $250,000 for 5% of the company.

What is an example of a startup valuation? ›

Calculation: Valuation = Total Assets - Total Liabilities. Example: If your startup's total assets are $1.5 million, and liabilities are $500,000, the book value valuation would be $1 million. Use When: Appropriate for mature startups with substantial tangible assets.

How do I calculate what my company is worth? ›

Take your total assets and subtract your total liabilities. This approach makes it easy to trace to the valuation because it's coming directly from your accounting/record keeping. However, because it works like a snapshot of current value it may not take into consideration future revenue or earnings.

What is a typical startup valuation multiple? ›

Startup valuation multiples:
  • SaaS: usually 10x revenues, but it could be more depending on the growth, stage and gross margin.
  • E-commerce: 2-3x revenues or 10-20x EBITDA.
  • Marketplaces, hardware or low-margin businesses: 1-2x revenue.
  • Travel: 1-2x revenue for low-margin verticals like flights, 6-8x for hotel bookings.

What is the formula for the valuation model? ›

The formula for valuing a stock to be held one year, called the one-period valuation model, is P = E/(1 + k) + P1/(1 + k), where E is dividends, P1 is the expected sales price of the stock next year, and k is the return required to hold the stock given its risk and liquidity characteristics.

What is an example of valuation model? ›

A common example of valuation is a company's market capitalization. This takes the share price of a company and multiplies it by the total shares outstanding. For example, if a company's share price is $10, and the company has 2 million shares outstanding, its market capitalization would be $20 million.

What is a 10x revenue valuation for a startup? ›

They are often used to value start-ups that are not yet profitable or have high growth potential. Revenue multiples are calculated by dividing the market value of a company by its annual revenue. For example, if a company has a market value of $100 million and annual revenue of $10 million, its revenue multiple is 10x.

How much equity is normal for a startup? ›

Calculating Startup Equity Compensation

Of the equity pool for employees, shareholders may receive the following average percentages of equity in the company by level of seniority: C-suite executives: 0.8% to 5% Vice president: 0.3% to 2% Director: 0.4% to 1%

What is a startup valuation per round? ›

Seed funding is usually between $500,000 and $2 million, but it may be more or less, depending on the company. The typical valuation for a company raising a seed round is between $3 million and $6 million.

What is 5% equity of a company? ›

A company's equity is the value of the stock held by all shareholders plus net profits. So your 5% equity is 5% of that figure. Usually this is in the form of stock: If you own 5% of a company's stock you have 5% equity in the company.

How much is 5% of a company worth? ›

In the simplest sense, if you own 5% of a company, that means that if the company were sold to someone for $100 you would get $5, or 5% of the proceeds.

How do you value a company based on equity? ›

To calculate the book value, subtract the company's liabilities from its assets to determine shareholder's equity, excluding the value of intangibles to value the tangible assets. While calculating book value is relatively easy, it may not be accurate.

How do you calculate equity value of a company? ›

Equity value is calculated by multiplying the outstanding shares by the market share price. Another way of calculating equity value is by subtracting the net debt from the enterprise value of the business.

Top Articles
Latest Posts
Article information

Author: Moshe Kshlerin

Last Updated:

Views: 6097

Rating: 4.7 / 5 (57 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Moshe Kshlerin

Birthday: 1994-01-25

Address: Suite 609 315 Lupita Unions, Ronnieburgh, MI 62697

Phone: +2424755286529

Job: District Education Designer

Hobby: Yoga, Gunsmithing, Singing, 3D printing, Nordic skating, Soapmaking, Juggling

Introduction: My name is Moshe Kshlerin, I am a gleaming, attractive, outstanding, pleasant, delightful, outstanding, famous person who loves writing and wants to share my knowledge and understanding with you.