My Excel sheet based fundamental Analysis of #Kajaria

ZERO trendline/momentum, chart pattern, candle stick mumbo jumbo. Pure fundamentals.

Step 1 : Background checks👇
Step 2 : Sales analysis

Notice how the 'trendline' of sales shows a smooth, steady rise in revenues Y-o-Y, unlike the stock price which is deceptively zigzag, which clouts one's objective judgment.
Step 3 : Profit analysis

Notice how, unlike revenues, profit tends to be slightly more volatile, reason being the fluctuating raw material prices.

One can see why there was a breakout in 2014.

Hint : it wasn't because of "green bullish engulfing candle" or any other candle🤦‍♂️
Step 4 : Risk analysis (cyclical costs)

Crude oil & power affect their margins more than labor costs or technology R&D, as is typical for manufacturing companies.

Kajaria has only 2500 employees running a 10,000cr market cap company.
Discounted Cash Flow (DCF) valuation of the future :

Future EPS discounted at historic growth rate of 14.6%, gives 2030 EPS value as 92rs/share.

Multiply EPS with:

A) Highest historic PE (45) : 4140
B) Lowest historic PE (20) : 1840
C) Median PE (28) i.e Intrinsic price 2663
Kajaria could trade anywhere between 2k and 4k in 2030, depending on the market sentiment in 2030

Just the PE multiple fluctuates with sentiment, EPS projection remains unaffected.

5X growth i.e 15% CAGR expected from CMP.
10X bagger (25% CAGR) for those who bought near 300.
@BoostTrade this is how we fundamentalists follow trends 😇

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Generic Boi

Generic Boi Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @techlunatic

26 Dec
The paradox of momentum stock picking is that it performs when it doesn't matter i.e when the rest of the market is already rallying.

Backtesting shows that any momentum strategy will have given 50% in the past 6 months, when the Index itself gave 82% from 7500 to near 13700.
Although 50% seems a lot in absolute terms, but in relative terms, it has still underperformed the Index in the same time frame.. THE INDEX; Not even comparing it with exceptional cases like Bajaj Finance.
This happens because the BUY signal will be generated on moving-averages crossover only after the initial 20% rally is missed, and the SELL signal will be generated at a trailing stoploss that is hit 20% below peak, so 40% of the rally is lost by design.
Read 5 tweets
26 Dec
@KumarBhatia1806 Taking good advice is also an art. People who ask for advice then obliquely undermine the advice giver like "pakka na?" are not in a state of mind to act with conviction and benefit from the advice that is given to them.
@KumarBhatia1806 Someone asked, I said "Colgate". This was in 2018, at a CMP of 1000. Next day he comes back "Economic Times is saying fiscal deficit... debt restructuring, structural reforms, capex..". I said Ram Ram and moved on...
@KumarBhatia1806 Last week he was saying, Nifty ka top lag gaya, I said congrats on the gains. He's like "kaheka gains, kuch liya hi nahi tha".

Neither stock selection nor perfect timing, it's people's behavior that limits their growth. This comes from initial 20Yrs of grooming; Hard to unlearn.
Read 4 tweets
24 Dec
Minimizing the number of decisions improves your yield.

1 decision to buy a good stock in 2014 would have given you double digit CAGR compared to dozens of algorithmic buy/sell trades executed on a daily basis.

There is sophistication in simplicity.
Subsequent averaging in a stock you've bought once doesn't count as a decision. It's just the reinforcement of the initial decision, as and when fresh salary becomes available to you.

Trimming on rise, booking partial profits, re-entering these gymnastics counts as a decision.
Take 1 good decision & keep reinforcing it through the decade. Don't play bull and bear at the same time. Be a buyer throughout the decade.

If you feel like the market is in a bubble, sell everything and exit, that's again 1 decision. Don't take that decision on a daily basis.
Read 4 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!

Follow Us on Twitter!