Valuation

Excel models containing a valuation analysis template e.g. such as a Discounted Cash Flow valuation analysis (DCF), residual value, replacement costs, market comparables, recent transaction comparables, etc.

This banana tree plantation financial model serves as a financial planning tool for evaluating a banana farm's financial feasibility and…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Furniture Manufacturing Company.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The financial model presents the business case of a SaaS online business. Software as a service (SAAS) is a software…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Car Wash Business.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

A collection of templates suitable for investment decisions in various types of businesses/industries, including Merger & Acquisitions, Leveraged Buyout, DCF,…

Price: $190.00
Add to wish list
$190.00 – Purchase Excluding 7.7% tax

Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Mini Grocery Store.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Financial Model providing a dynamic up to 10-year financial forecast for a Coffee Shop startup or existing business.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

User-friendly 3 statement 5 year rolling financial projection Excel model for existing/startup family park/venue business

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

User-friendly 3 statement 5 year rolling financial projection Excel model for existing/startup entertainment venue business

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

This is an equity only (joint venture capable) financial model for building / acquiring self storage property for some time…

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 7.7% tax

Advanced Financial Model providing a dynamic up to 10-year financial forecast for a Software as a Service (SaaS) startup business.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

If you dream to start a heavy machinery rental business, the template is the first step in making your dream…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The financial model presents the business case of a Mobile App Business. A mobile application, also referred to as a…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Versatile loan calculator! No more generic loan information with a single interest rate used over the life of the loan…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Massage Salon financial model providing advanced financial planning & analysis for a 5-Year Business Plan.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The financial model presents the business case of an eCommerce Platform. An eCommerce Platform is a software solution that allows…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Average rating:

The financial model presents the business case of an online marketplace. A marketplace is a user-friendly platform that allows buyers…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Get Your Laser Tag Financial Model. Investor-ready. Includes a P&L and cash flow statement, balance sheet, and a complete set…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Discover Bowling Financial Plan. Enhance your pitch decks and impress potential investors with a proven, strategy template. Five-year Bowling Excel…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Discover Brewery Pro-forma Template. By running various scenarios of your inputs, you will begin to see which options are best…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Discover Diaper Manufacturing Financial Model. Excel - well-tested, robust and powerful. Get you solid foundation to plan your business model.…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

If you dream to start a boat touring business, the template is the first step in making your dream into…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

This is a 5-year startup model for the rental business. There is specific logic to show the projections and cash…

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 7.7% tax

Dynamic financial model presenting a potential acquisition of a Multi-family Apartment Complex.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Nail Salon financial model providing advanced financial planning & analysis for a 5-Year Business Plan.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The global concrete industry market is expected to significantly grow in the 10 coming years. If you dream to start…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

"Get Nightclub Pro-forma Template. Investor-ready. Includes a P&L and cash flow statement, balance sheet, and a complete set of financial…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Get the Best Solar Panel Manufacturing Plant Financial Model. Spend less time on Cash Flow forecasting and more time on…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Shop Waterpark Budget Template. There's power in Cash Flow Projections and the insight they can provide your business. Five-year financial…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

If you dream to start a Consulting Firm Business, the template is the first step in making your dream into…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax


Valuation Approaches


Valuation, as we already know, is the process of determining the current value of an asset or a business. From conducting a valuation for tangible or intangible assets to valuing liabilities such as bonds, etc. But one must remember that in valuation, the resulting value is subjective since it’s mostly an estimation and will vary accordingly depending on who’s conducting the valuation of an asset or a business.

In Valuation, there are three common terms that you’ll encounter as to describe the value of an asset or liability.

  • Market Value – also knowns as Open Market Valuation (OMV), this is the value perceived by the open market

  • Fair Value – a rational estimate of what could be the value of an asset determined by an evaluation expert

  • Intrinsic Value – also known as Fundamental Value, is the current value of an asset determined by conducting a fundamental analysis without having to refer to its current market value


Business Valuation is a specific kind of valuation where instead of assets or liabilities, it’s more focused on determining the value of businesses and related entities. This is to determine the economic value of a business. Basically, business valuation is conducted when a business wants to sell all or a part of their current operations, or in some cases for merging and acquiring other businesses.

Business valuations can be done in a number of ways, the commonly used approaches are to evaluate the business’ health of cash flows, timings of cash flows, net assets, potential earnings, and costs. Generally, the resulting value will differ from the buyer’s and seller’s points of view. Due to their differing goals, the buyer mostly focuses on the value he pays. While for the seller, it’s what the business is worth, thus, ensuring that they won’t sell below that value.

Of course, a single valuation model will not always result in a fair value, thus to arrive at a fair value range, there are three broad valuation approaches that one can use.



 

Income-Based Approach


This is one of the three popular approaches to valuation, especially for income-producing properties. This approach values a business based on its past, current, or forecasted cash flow and used for exploring the intrinsic value of any business by evaluating the cash flows, NPV, equity method, and economic profit model. The key objective of the income-based approach is to determine the value of a business that will result in an economic benefit to the parties involved.

Of course, there are pros and cons to using the income approach. One of the advantages when using this approach is its flexibility in addressing businesses or assets in their different stages of life-cycle since it factors different assumptions over the projected period. Though it is considered powerful and effective unlike the other approaches, it doesn’t need to rely on any historical financials. So, it is very convenient for small businesses or startups that don’t have enough past transactions.

However, this approach is dependent on the assumptions on the future projections, it tends to be subjective, especially if the assumptions are not tested. There is a great risk of being inaccurate and biased since it, after all, makes use of estimated figures which can be manipulated according to one’s preference. The resulting value is also highly sensitive due to different estimates of growth rate and required rate of return, thus, the appraiser needs to provide inputs that are realistic and fair. It is clear that the income-based approach valuation can be a bit more complex compared to the other approaches therefore, it requires more time for its implementation.

The following are the methods that make use of the income-based approach:

  • Discounted Cash Flow – This method is used to value a business by basing it on its future cash flows which are then discounted to the present value of the business. Basically, you need to make an estimate of the future cash flows and estimate also a realistic discount rate after undergoing different assumptions that will affect the value such as certain risks and interest rates. Then, using the derived estimates, you will calculate to come up with an assumed present value of the future cash flows.

  • Capitalization of Earnings – This method is used to value a business by discounting its future earnings and dividing them by the capitalization rate. Using this method will also be beneficial in determining the potential risks and return of buying a business. To determine the capitalization rate, one will need significant know-how of the business and industry. Once all variables needed are known, you can simply use the formula: Capitalization rate = Operating Income/Purchase Price.

  • Economic Value Added – EVA or also known as Economic Profit is another method under the income-based approach due to its nature of valuing a business based on its residual wealth which is calculated by deducting the cost of capital to its operating project, then adjusted for taxes on a cash basis. Basically, by using this method, you will be able to determine a business’s financial performance or simply put, to show that the business is producing value from the funds invested in it.


 

Market-Based Approach


The next known approach to valuation is the market-based approach. It is used to determine the value of a business, intangible asset, business ownership interest, or security, by taking into account the market prices of assets or businesses that are comparable and were sold or still on the market. Thus, when conducting a valuation, there will be adjustments made based on the historical or present prices of the assets or business accordingly.

The market-based approach is a handy approach when capturing the market sentiment, considering the peers. It helps determine the value of a business or asset by doing a comparison to historic sales of similar businesses. In this method, it relies on pricing multiples to determine if there’s relevance between the economic value and potential selling price of a business.

Just like the income-based approach, the market-based approach has its own advantages and disadvantages. First off, since it is a straightforward method, it only involves simple calculations. This means it is easy to understand and more honest since it uses figures or data which is real and public. Thus, no need for guessing or making any estimations which makes the market approach not dependent on subjective projections. But, this means that it is less flexible compared to the other approaches. Some opportunities to earn or save more might be lost without checking the future value of a business after all. Another one of its disadvantages is, it also raised problems such as not having enough data available or if the data is good enough to use. One would need an experienced expert with expansive know-how in the industry to try and resolve those issues.

There are three methods that make use of the market-based approach:

  • Precedent Transaction Analysis – This is a valuation method where the value is derived from the historical price value of a comparable business. As a market-based approach, it heavily relies on public information to arrive at a reasonable estimate of multiples or premiums from other buyers or sellers for a publicly traded business. This method is commonly used by analysts for mergers and acquisitions.

  • Stockmarket Multiples Analysis – This valuation method is less known but works the same as Quoted Comparable Company Analysis where the data used to compare prices is derived from the stock market. This method is usually used for valuing listed businesses by comparing multiples such as EV/Sales, EV/EBITDA, EV/EBIT, and P/E.

  • Relative Valuation Comparisons – By using this method, you’ll be able to determine the value of a business by conducting a market analysis regarding the pricing of its competitors or comparable business. This valuation method will require one to do a lot of research and comparing of prices to get the ideal price that would help with earning back more (for those who sold their assets) or saving up money (for those interested buyers). Mostly, this method is to determine whether you won’t go over or under the current pricing range. Another thing to take note of is that this valuation method is more industry-specific (e.g. value per room - hotels, value per sqm - real estate).


 

Cost-Based Approach


The last approach, the cost-based approach, is a valuation method that values a business based on the balance sheet and is generally known as the property valuation approach. This approach focuses on determining the net asset value (NAV) or the fair market value (FMV) out of the total assets, then subtracted by the total existing liabilities resulting in the would-be cost to re-create the business. In other words, it takes the net difference between the value of its assets and liabilities. Generally, it is used to value businesses based on the market value of assets, cost to build, replacement costs, and liquidation value of the assets.

This valuation method is usually used in certain cases such as replacing the business building or determining an estimated value of an individual tangible asset or intangible asset. Since the data needed to calculate is available by just referring to the balance sheet, finding the total value is easier and simpler compared to the other approaches, but then again it only focuses on finding the value of cost to be expended rather than determining the total value of a business's future earnings to determine the value of a business.

There are four methods that use the cost-based approach valuation:

  • Replacement Cost – A business valuation method where you value a business by considering the replacement cost instead of the liquidation value deducted by the total liabilities to determine the value of a business. The replacement cost is usually higher than the book value due to depreciation not being accounted for. Another way of calling this method is the replacement value method.

  • Cost to Build – A valuation method to estimate the value of an asset or business by considering the cost incurred to build and to make it fully operational. Basically, it’s a method focused only on the cost expended to determine the value of an asset or business. This valuation method is more ideal for real estate to determine the price a buyer should pay which should be equal to the cost to build the same property.

  • Net Asset Value – This method is used to determine the value of a business by estimating the current value based on the existing assets and liabilities of a business. In cases where a solvent company shuts down, decided to sell off all assets, and settling its liabilities, the leftover cash would then serve as the current floor value of the business. Hence, the name net asset value represents the net value of an asset or business. The formula to arrive at the resulting net asset value is by taking the total value of an asset or business minus the total value of its liabilities.

  • Liquidation Value – This valuation method is applicable only to businesses that are out or about to go out of business (e.g. bankruptcies, workouts, insolvency, etc.). If a business qualifies either of the two, the total value of a business is then determined via taking the total worth of the business's physical assets such as real estate, fixtures, equipment, and inventory. Take note that the intangible assets aren’t counted in determining the liquidation value which is why it is typically lower than the fair market value.


As you noticed, the income-based approach is mentioned first, the market-based approach is second, and lastly, the cost-based approach. It is placed that way since that’s usually the systematic way of determining the value of an asset or business. The first on valuing a business is to calculate the past, present, and future income of the business to derive the potential value of a business. Then after getting that result, the next step would be to compare the value derived to comparable businesses in the market. This is to check if the resulting value is a fair value and not over or under the acceptable range of prices based on the prices of comparable businesses. Lastly, to further check the estimated value of the business, the last approach is to check the total value of existing assets minus the liabilities. In conclusion, all three approaches have their own advantages and disadvantages but it is also clear to see that each approach are somewhat connected and have their own edges that differentiates them from the other approaches.

 

Discounted Cash Flow Valuation Method – The Most Used Valuation Method


Discounted Cash Flow (DCF) is a valuation method that uses the income approach to determine the value of an asset or business. It is usually used to make an estimate on how attractive an investment opportunity is. Hence, it is quite popular and most used by interested parties to conduct the valuation. This method analyzes the future cash flow projections and discounts them with the required annual rate to determine the present estimated value of an entity. The value derived is then used to evaluate if the investment is potentially feasible or profitable.

The formula is as follows:

DCF = [CF/ (1+r)1] + [CF/ (1+r)2] + ... + [CF/ (1+r)n]

CF = Cash Flow

n = year

r= discount rate (Weighted Average Cost of Capital)

To further understand how it is calculated, see below illustration as an example.



 


Uses of Valuation


Valuation covers a wide range of uses such as:

  • Averting Shareholder Disputes: Oftentimes, there are cases when a business fails, which will lead to a dilemma on how to break up the assets accordingly. So, conducting a valuation will help avert disputes between the shareholders.

  • Mergers, Acquisitions, and Sales: Valuation is very critical to these tasks. The model will be used as a tool to negotiate for either mergers, acquisitions, or sale of assets, thus, both interested parties will be satisfied as they come up with the best fair market price.

  • Buy-Sell Agreements: Valuation is usually conducted when transferring equity between partners or shareholders.

  • Purchase Price Allocation: The valuation will serve as a report about all the business’ assets and liabilities to determine the tangible and intangible assets.

  • Financing: Usually, to gain the interest of investors, they would require you to submit a report about the value of your business as proof that your business is worth investing in. Thus, a valuation is done to appraise your business. This also applies when obtaining a loan and other ways to raise financing.

  • Employee Stock Participation Scheme: Is also known as the Employee Stock Purchase Plan (ESPP) where you give the employees an opportunity to purchase stock shares to be more devoted to the business.


There are many other current cases that valuation is needed so it is undeniable that valuation is significant in many ways.

 

Valuation Model Templates in Excel


Usually, it is recommended to ask for help when doing a valuation since it is, after all, you want to get most of it when selling a business or settle with a great investment when acquiring or merging with other businesses. An appraiser or an expert in valuation models is needed typically, but this doesn’t mean that one can’t do it themselves. With the existing tools available nowadays, conducting a valuation can be done without having to go through different processes especially when starting from scratch. Therefore, instead of spending high costs for professional services or spending too much time figuring it out on your own, making use of valuation model templates in Excel is a much better choice.

If you are looking for valuation model templates in Excel, then you can check out our list above and see if there are model templates that fit your specifications. The available models are ready-made and user-friendly with clear transparency so that when you edit them accordingly, you won’t have to spend a lot of time figuring how the values came about. The valuation model templates in Excel are made by skilled experts in financial modeling with extensive experience and industry know-how, thus, you can rest assured that the valuation models are professional looking and designed accordingly for different applications.

Here is a list of financial model templates that include a Valuation:

No Downloads found