# 10. Re-Cap on Equity Value Calculation

Overview

With Equity Value now calculated, let's pause and review the steps taken in the past 9 lessons to get to our company valuation.

To explore more Kubicle data literacy subjects, please refer to our full library.

Summary

1. Lesson Goal (00:04)

The goal of this lesson is to recap the steps taken to calculate the enterprise value for MarkerCo.

2. Steps in Calculating Enterprise Value (00:13)

In our model, there were 6 steps needed to calculate the enterprise value for MarkerCo. These steps could of course be used to find the enterprise value of any other company.

1. Develop projections for the Income Statement, Balance Sheet, and Statement of Cashflows for a number of future years.
2. Use information from these projections to calculate unlevered free cashflows for each year, by adding NOPAT, cashflow adjustments and capital expenditure.
3. Calculate the Weighted Average Cost of Capital, or WACC. As part of this step, we use the formula from the Capital Asset Pricing Model, or CAPM, to calculate the cost of equity for the company.
4. Calculate the discounted unlevered free cashflows for each year of our projection, using the WACC as the discount rate.
5. Calculate the terminal value of future cashflows beyond our projection. We can do this using the perpetuity method or the exit multiple method.
6. Calculate the enterprise value by adding the discounted cashflows for each year of our projection to the terminal value.

Transcript

With our discounted cash flow valuation now calculated, let's take one lesson to recap on the stages we took to get this far. From the previous course, we had five-year projections built for the Income Statement, Balance Sheet and statement of cash flows. These projections constituted a lot of the work required to create our DCF.

Our next step was to distinguish between enterprise value and equity value, and we resolved to calculate enterprise value first and then equity value, as this is often the easier path to follow.

To find the enterprise value using the discounted cash flow method, we need to use unlevered free cash flows. To calculate unlevered free cash flows, we found NOPAT, which is net operating profit after tax, and then we adjusted for non-cash expenses, changes in operating assets and liabilities and we also subtracted capital expenditure. These unlevered free cash flow projections could then be discounted by the weighted average cost of capital, or WACC. The weighted average cost of capital for MarkerCo was calculated from the following formula. In this formula, the most challenging value to calculate was the cost of equity, and we used the Capital Asset Pricing Model to calculate the cost of equity. For MarkerCo, the risk-free rate was 2.3%, the expected market rate of return was 8% and beta was 1.3, and this gave us a cost of equity of 9.7%. Returning to our WACC formula, because MarkerCo has no debt, the WACC was simply equal to the cost of equity at 9.7%.

With the WACC now in place, we could discount the cash flows for our five-year projection and from this table, you can see the impact of discounting on our unlevered free cash flows. We now have the value of the company based on the first five years into the future, but what about the remaining years? For this, we need to calculate the terminal value. And the terminal value is calculated using two different methods, the perpetuity method, where we assume a constant growth rate for each year, and the exit multiple method, where we assumed a certain enterprise value all over EBITDA multiple at the end of the projection period. Using a growth rate of 1.5%, we achieved a terminal value of 293.9, which when discounted and combined with the first 5 years of cash flows, provided an enterprise value of 250 million. Using the exit multiple method, our terminal value is 301 million with an enterprise value of 254.5 once discounting had been taken into account. With our enterprise value now calculated, all we need to do is to calculate the equity value of the company, which I'll show you in the next lesson.

Financial Modeling Essentials

Contents

03:35

05:22

05:15

04:43

03:52

05:19

03:03

04:26

06:06

03:15

06:23

03:44

05:00

#### Exercise 4

My Notes

You can take notes as you view lessons.

Sign in or start a free trial to avail of this feature.