Calculating The Fair Value Of Mister Spex SE (FRA:MRX)

How far off is Mister Spex SE (FRA:MRX) from its intrinsic value? Using the most recent financial data, we'll take a look at whether the stock is fairly priced by estimating the company's future cash flows and discounting them to their present value. The Discounted Cash Flow (DCF) model is the tool we will apply to do this. There's really not all that much to it, even though it might appear quite complex.

We would caution that there are many ways of valuing a company and, like the DCF, each technique has advantages and disadvantages in certain scenarios. If you still have some burning questions about this type of valuation, take a look at the Simply Wall St analysis model.

See our latest analysis for Mister Spex

The Model

We use what is known as a 2-stage model, which simply means we have two different periods of growth rates for the company's cash flows. Generally the first stage is higher growth, and the second stage is a lower growth phase. To begin with, we have to get estimates of the next ten years of cash flows. Where possible we use analyst estimates, but when these aren't available we extrapolate the previous free cash flow (FCF) from the last estimate or reported value. We assume companies with shrinking free cash flow will slow their rate of shrinkage, and that companies with growing free cash flow will see their growth rate slow, over this period. We do this to reflect that growth tends to slow more in the early years than it does in later years.

A DCF is all about the idea that a dollar in the future is less valuable than a dollar today, so we discount the value of these future cash flows to their estimated value in today's dollars:

10-year free cash flow (FCF) forecast

2023

2024

2025

2026

2027

2028

2029

2030

2031

2032

Levered FCF (€, Millions)

-€23.9m

-€22.6m

-€4.85m

€4.50m

€6.82m

€9.29m

€11.6m

€13.7m

€15.4m

€16.7m

Growth Rate Estimate Source

Analyst x5

Analyst x4

Analyst x2

Analyst x1

Est @ 51.59%

Est @ 36.12%

Est @ 25.3%

Est @ 17.72%

Est @ 12.41%

Est @ 8.7%

Present Value (€, Millions) Discounted @ 5.9%

-€22.5

-€20.1

-€4.1

€3.6

€5.1

€6.6

€7.8

€8.7

€9.2

€9.4

("Est" = FCF growth rate estimated by Simply Wall St)
Present Value of 10-year Cash Flow (PVCF) = €3.0m

After calculating the present value of future cash flows in the initial 10-year period, we need to calculate the Terminal Value, which accounts for all future cash flows beyond the first stage. The Gordon Growth formula is used to calculate Terminal Value at a future annual growth rate equal to the 5-year average of the 10-year government bond yield of 0.03%. We discount the terminal cash flows to today's value at a cost of equity of 5.9%.