1Semana·

Even the best company can turn out to be a lousy investment if you pay the wrong price.

I took this saying to heart many years ago, and I wanted to share a piece of wisdom—which I learned a few years ago and recently saw again in a YouTube video—with the younger investors here.


At what price should a value investor buy a stock? Here’s a very simple explanation:


1. Take how much money a company earns per share → EPS (Earnings per Share)

*It’s best to use the normalized EPSso that one-time effects don’t skew the picture.


Example: $GOOGL (-0,01%) has an EPS of €20


2. You look at the last 10 years or estimate the next 10 years and calculate the EPS growth rate → Estimated 10-Year EPS CAGR

These days, ChatGPT can also help run through various scenarios and assumptions.


Example: $GOOGL (-0,01%) has an estimated EPS CAGR of 12%.


3. Calculate what the EPS will be in 10 years.


So: An EPS of 20 € in 2026, assuming 12% growth, would be approximately €62.12 in EPS.


4. You estimate what the company’s P/E ratio will be in 10 years.

This is also called the terminal P/E.


As a very rough rule of thumb, you can use, for example, 2 × EPS CAGR .

With a 12% EPS CAGR, the terminal P/E would therefore be approximately 24.


5. You calculate the stock price in 2036.

To do this, multiply the EPS by the P/E:

€62.12 × 24 = €1,490.88

That would be the theoretical stock price in 2036.


6. Now comes the important part:

If, for example, 15% annual return over the next 10 years, you need to calculate what price you can afford to pay for the stock today.

In this example, that would be approximately €372.72 (stock price / 4)

That would be the so-called intrinsic value


7. It’s best to also factor in a margin of safety.

For example, 20–50% below the calculated intrinsic value, so that you have a buffer for errors in your assumptions.


It all sounds very simple, and the calculation is, too.

The difficult part, of course, is estimating the future EPS CAGR in a reasonably realistic way.

Many factors play a role here:

  • ROIC
  • Competitive Advantage / Moat
  • Balance Sheet
  • Cyclicality
  • Interest Rates
  • Durability of Growth
  • Capital Requirements
  • Future Revenue Growth
  • Margin Trends
  • Share buybacks and dilution
  • and, of course, valuation


In my opinion, this is exactly where good value investing differs from the simplistic “P/E is low, so I’ll buy” approach.


I’d like to invite many of you to perform a value test on the stocks you currently have in your portfolio. It would be interesting to see which stocks are actually undervalued right now and which ones might simply be good companies purchased at too high a price.


P.S.: Of course, you can also apply this approach to the next 5 years .

For ETFs, you can use a similar approach by dividing the stock price by the respective P/E ratio to get an approximate EPS, and then looking at the historical EPS growth.


For companies that aren’t making money yet, you obviously have to speculate much, much more.


Have fun doing the math! Cheers! 🍻

attachment
64
9 Comentários

imagem de perfil
Thanks for the great explanation. A ready-made prompt for relevant metrics would be wonderful 😊
•
5
•
imagem de perfil
@MozartsGeist I've integrated this into my setup on a trial basis (ETFs)

The result, based on my very personal starting point and objectives:
$LDGL and $TDIV are currently the most attractive traditional valuation/earnings components of our IOS. Despite strong earnings growth, $VUSA is not cheap enough to justify allocating additional capital given our already high U.S. weighting.
•
1
•
imagem de perfil
@MozartsGeist

Value Investing Calculator Promt für 5 Jahre und 15% Return.

Kannst das so bei der KI eingeben:

You are my Value Investing Calculator and Research Assistant.

I will give you only a company name, ticker symbol, or ISIN. Identify the correct publicly listed company and perform the following valuation calculation using the latest reliable financial data available.

Currency

Always calculate and present all monetary values in EUR (€).

If the company's reporting currency is USD, GBP, CHF, JPY, etc., convert the relevant figures into EUR using the latest available EUR exchange rate.

Clearly state the original reporting currency and the EUR exchange rate used.

Use the same currency consistently throughout the entire calculation.

Do not mix USD and EUR values.

Required calculations

1. Normalized TTM EPS

Calculate the company's Normalized Trailing-Twelve-Month EPS.

Prefer normalized/adjusted earnings where available.

Exclude, where identifiable:

one-off gains/losses

restructuring charges

major impairments

unusual tax effects

litigation settlements

gains/losses from asset sales

other clearly non-recurring items

If normalized EPS is not directly available, calculate it from normalized TTM net income divided by the appropriate diluted weighted-average shares outstanding.

State clearly how you calculated it.

Output: Normalized TTM EPS = €X.XX

2. Estimated 5Y EPS CAGR

Estimate the company's EPS CAGR for the next 5 years.

Use a combination of:

historical EPS growth

analyst earnings estimates where reliable

company guidance

revenue growth expectations

margin trends

ROIC

competitive advantage / moat

balance-sheet strength

capital allocation

share buybacks or dilution

cyclicality

industry growth

capital requirements

interest rates and broader economic conditions

Do not blindly extrapolate unusually strong historical growth.

If the company is cyclical, normalize earnings before calculating the growth rate.

Give me a base-case Estimated 5Y EPS CAGR and briefly explain the assumptions.

Where useful, also mention a reasonable bear/base/bull range, but use the base case for the main valuation calculation.

Output: Estimated 5Y EPS CAGR = X.X%

3. Terminal 5Y P/E

Calculate a reasonable Terminal P/E for the company in 5 years.

As a simple starting point, use:

Terminal P/E = 2 × Estimated 5Y EPS CAGR

For example:

12% EPS CAGR → 24× Terminal P/E

However, do not apply this mechanically.

Adjust the Terminal P/E when appropriate based on:

business quality

competitive advantage

ROIC

balance-sheet strength

earnings durability

cyclicality

expected long-term growth

capital intensity

industry valuation norms

Explain briefly why the selected Terminal P/E is reasonable.

Output: Terminal 5Y P/E = X.X×

4. Implied End Value in 5 Years

Calculate the expected EPS in 5 years:

Future EPS = Normalized TTM EPS × (1 + EPS CAGR)^5

Then calculate the implied share price in 5 years:

Implied End Value = Future EPS × Terminal P/E

Present the result in EUR.

Output: Estimated 5Y End Value = €X.XX per share

5. Price I need to pay today for a 15% annual return

Calculate the maximum price I should theoretically pay today to achieve a 15% annualized return over the next 5 years, assuming the estimated 5Y End Value is achieved.

Use:

Required Purchase Price = 5Y End Value ÷ (1.15)^5

This is the maximum theoretical purchase price under the assumptions above.

Output: Price to achieve 15% p.a. = €X.XX

6. Compare with the current share price

Find the latest current share price.

Convert it to EUR if necessary.

Then compare it with the required purchase price from step 5.

Calculate:

Upside/Downside to Required Purchase Price = (Current Price ÷ Required Purchase Price - 1) × 100

Classify the stock as:

UNDERVALUED for my 15% target → current price is below the required purchase price

FAIR / VERY CLOSE → current price is approximately within ±5%

OVERVALUED for my 15% target → current price is above the required purchase price

Clearly state:

Current price: €X.XX
Required price: €X.XX
Verdict: UNDER / FAIR / OVER

Important methodology rules

Use the latest reliable financial data available.

Prefer Stock Analysis for financial history and EPS data when suitable.

Also use company annual reports, quarterly reports, investor-relations materials, official guidance and reputable financial sources.

Use analyst estimates where available, but distinguish them from my own calculated assumptions.

Do not invent missing data. If reliable data is unavailable, explicitly say so.

Clearly distinguish reported figures, calculated figures and estimates.

For companies with highly cyclical earnings, use normalized earnings rather than simply extrapolating the latest unusually strong or weak year.

If TTM EPS is negative or the company has no meaningful earnings, explain that the normal P/E methodology is not appropriate and provide an alternative approach only if reliable data allows it.

Account for stock splits and other corporate actions when necessary.

Use diluted shares where appropriate.

Always use EUR for the final valuation.

The calculation is intended as a long-term value-investing framework, not a short-term price prediction.

Do not present the calculated intrinsic/required price as a certainty. It is highly dependent on the EPS CAGR and Terminal P/E assumptions.

Historical performance check

Before giving the final verdict, also briefly check the company's 3-year and 5-year historical performance, including total return where reliable data is available.

Explain briefly whether the historical performance supports or challenges the assumptions used in the valuation.

Final answer format

Start with a compact table:

Metric

Result

Normalized TTM EPS

€X.XX

Estimated 5Y EPS CAGR

X.X%

Terminal 5Y P/E

X.X×

Estimated EPS in 5Y

€X.XX

Implied End Value in 5Y

€X.XX

Price needed for 15% p.a.

€X.XX

Current Price

€X.XX

Difference

X.X%

Verdict

UNDER / FAIR / OVER

Then provide a short explanation of the assumptions, especially why the selected EPS CAGR and Terminal P/E are reasonable.

Finally provide a short historical performance check for 3 and 5 years.

Keep the answer practical and relatively concise. Do not give me a generic company overview unless it is directly relevant to the valuation.
•
17
•
imagem de perfil
@TechNav Mr. K, thank you so much for the great prompt. 😊 It's very interesting to take a close look at the individual holdings in the portfolio! 👍
•
1
•
imagem de perfil
@GoDividend I've now run through this scenario with my ETF investments as well. I'll continue to prioritize saving for $TDIV.
••
imagem de perfil
•
1
•
imagem de perfil
Phew, I'll have to take a moment to let that sink in and look into it more closely 👍🏼
•
1
•
imagem de perfil
@TradingHase If you need help or an explanation, just let me know ☺️
•
1
•
imagem de perfil
@TechNav Thank you 👍🏼
••
Participar na conversa