Overview

Valuation is both an art and a science. The purpose of the template is to facilitate the user to consider multiple ways to value a business in order to triangulate a reasonable valuation. Don't know much about valuation? Don't worry, this template will guide you through all the factors to consider - just enter your assumptions into the yellow cells and the model will do the rest.

 

Outputs – contains a summary of valuation results including transaction/M&A (mergers and acquisitions) comparables, Listed company comparables, Net present value, Gordon’s growth model and Balance Sheet valuations. Valuations consider both historical and forecast data as well as demonstrating the valuation in using both annual or monthly data. Also contains a summary of average assumptions for each valuation type. There is also an output that triangulates an average of all methodologies used.

Assumptions – In general settings set up the valuation template by entering the name, units, model timeline start date and forecast date. Tick the boxes to determine which valuation methodologies to consider. We recommend using as many as possible. In 1.2 enter your P&L and Balance Sheet data. You can select to enter both historical and forecast data, and also choose to enter data annually, monthly, or both (as determined by your settings in 1.1). 1.3 enter your comparable transaction data that relates to the company you’re valuing. 1.4 enter your comparable listed company data. We also recommend applying a liquidity discount as your company will likely be privately owned. Note that with both 1.3 and 1.4 you can choose whether the calculation includes or excludes negative multiples. 1.5 Net present value uses the discounted free cash flow methodology so you’ll need to enter both your terminal growth rate assumption and your discount rate. 1.6 enter the dividend growth assumption (the discount rate is entered in 1.5).

Reviews Add a review
No reviews yet

More From FinanceGuyHQ

Browse our top rated business templates. See All
Company valuation template
1,656
1
Valuation is both an art and a science. The purpose of the template is to facilitate the user to consider…
Bachelor / Bachelorette (Hen / Stag) Party Event Budget Planner
4,076
1
Template for preparing and managing budgets for stag, hen parties, and other events. The user will have the ability to…
Platform & Bolt on Acquisition Planning Model
3,818
1
Acquisition planning model including the initial purchase of a platform asset and up to 10 bolt on acquisitions. Up to…
Anaerobic Digestion Plant Model
3,722
0
The purpose of the model is to enable the user to assess the viability of a anaerobic digestion plant project…
Solar Farm Investment Model
3,784
1
The purpose of the model is to enable the user to assess the viability of a solar farm project or…
Wind Farm Investment Model
3,560
0
The purpose of the model is to enable the user to assess the viability of a wind farm project or…
See All