Valuation Analysis Excel Model Template
Originally published: 02/10/2018 15:21
Last version published: 17/05/2019 20:00
Publication number: ELQ-47727-4
View all versions & Certificate

Valuation Analysis Excel Model Template

This Excel model includes the principal methods for the valuation of a company.

This Valuation Model by CFI comprises Comparable Analysis (Comps), Precedent Transactions, DCF (Discounted Cash Flow) Analysis, and Football Field Chart summaries. The first two being forms of relative valuation, with the DCF approach being an intrinsic valuation. Together, these models help to form a more accurate valuation for a company.

- Comparable Analysis

Comps entails a valuation model of relativity in which a comparison is made of similar businesses with regards to trading multiples.

- Precedent Transactions

These are similar to Comps in that they are a method of valuation comparison. However, with Precedent Transactions, the user compares a company to another that has recently been sold/acquired.

- DCF Analysis

A DCF Analysis requires much more input than the aforementioned. However, it often produces the most accurate assessment. The business’ unlevered free cash flow is forecasted into the future and then discounted back to the present time at the firm’s WACC.

- Football Field Chart

This type of chart is a clear and efficient way of displaying the above analyses in a digestible form. The Excel model assists in producing the chart with the inputs derived from the other valuation models.

The accompanying video concisely explains the types of models and also how to read the Football Field Chart. In addition, a PDF guide offers more detailed descriptions of the models.

This Best Practice includes
1 Excel Spreadsheet, 1 Youtube Video, 1 PDF

Acquire business license for $100.00

Add to cart

Add to bookmarks


2.0 / 5 (1 votes)

please wait...