Enterprise and Equity Values

3 minutes read
Last updated: November 14, 2023

Calculating Enterprise Value

The enterprise value (EV) of the business is calculated by discounting the unlevered free cash flows (UFCFs) projected over the projection period and the terminal value calculated at the end of the projection period to their present values using the chosen discount rate (WACC).

EV = FCF1 + FCF2 + + FCFn + TV
(1+r)1 (1+r)2 (1+r)n (1+r)n

In Excel, EV = NPV(r, array of FCFs for years 1 through n) + TV/(1+r)n.

Where:

FCFn = Unlevered FCF occurring at the end of interval n
TV = Terminal Value
r = Weighted-average cost of capital (WACC)

Always calculate the EV for a range of terminal multiples and perpetuity growth rates to illustrate the sensitivity of the DCF analysis to these critical inputs.

Mid-Year vs. End-Period Convention

The calculation of EV is affected by the assumptions regarding timing of the cash flows within a projection interval. The mid-period convention assumes that the UFCFs occur at the middle of each projection interval, while the end-period convention assumes all UFCFs occur at the end of each interval. In practice, the end-period convention is often used because it is more conservative (the UFCFs are discounted at a time more distant from the present).

The EV formula above assumes end-period convention. EV based on mid-year convention is calculated using the following formula:

EV = FCF1 + FCF2 + + FCFn + TV
(1+r)0.5 (1+r)1.5 (1+r)n−0.5 (1+r)n

Where:

FCFn = Unlevered FCF occurring in the middle of interval n

Alternatively, to arrive at the present value of the UFCFs using the mid-period convention, the present value of UFCFs based on end-period convention must be moved forward by half a year in time by multiplying it by (1+r)0.5 as follows:

EV (mid-period
convention)
= PV of UFCFs (end-period convention) × (1+r)0.5 + TV
(1+r)n

Note that the NPV function in Excel uses end-period convention.

Calculating Equity Value

Equity value is calculated by simply subtracting net debt from the computed EV. While considering which balance sheet items should be included in the calculation of net debt, one must consider whether or not the income/expenses associated with a particular asset/liability was included in the calculation of EBIT to arrive at UFCF. Generally, if the expense associated with a liability is included in the calculation of EBIT, the liability should not be included in net debt. Likewise, if the income attributable to an asset has been included in the calculation of EBIT, the asset should not be included in the calculation of net debt.

Net debt is not dependent on the assumptions used in the DCF valuation, so you can subtract the constant net debt value from the range of EVs calculated as described above to arrive at a range of equity values. As an additional step, divide by the equity value by the current diluted shares outstanding to arrive at a theoretical range of share prices based on the DCF valuation.

 

Create Financial Models 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking and productivity tools to help you accelerate financial modeling and presentations.

Start your Free Trial
 

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more