Valuation Analysis Excel Model Template

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

by CFI
Corporate Finance Institute® (CFI) - Official provider of the Financial Modeling & Valuation Analyst (FMVA)™Follow 169

116 views|Start the discussion!|Bookmark

Description
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 business tool includes
1 Excel Spreadsheet, 1 Youtube Video, 1 PDF