Fundamental Analysis of much Talked About Stocks...

[nanjil]

Hi Friends

The aim of this thread is to Analyse the Stocks which are being talked in our Forum. Their Fair value and One year Target Price based on their current and past performance...

Investing is not a science that we can use some magic formulae and win big... It involves valuation, Technical Entry Levels, General Market condition etc which makes it more of an art...

Modus Operandi

1.10 years Annual results and corresponding stock price
2.Calculate Average PE based on last three/four years
3.Extrapolate the Sales growth to next two more years and apply last three years average percentage of profit.
4. Calculate Expected EPS and multiply with Average PE will give the Stocks fair price and one year Target.

What do you say...

 

[nanjil]

1. Astra Microwave Products Ltd

A very good growth company.

Oscar Capital says : Astra Microwave is one of those rare bets that fits both our Top-Down (Huge Opportunity Size, Accelerating Growth, Structural drivers) and Bottom-Up (Good Management, Prudent Capital Allocation, Healthy Return Ratios, Durable Moats, Reasonable Valuations) investment criteria.

My Analysis says : Some worries with Astra Trailing four Q results are not V.Good even though Company has good consistent profit growth of 53.51% over 5 years View attachment 20614

 

[nanjil]

2.TECHNOCRAFT INDUSTRIES (INDIA) LTD

40 year old company in diversified feilds... presence in 10 counties and exporting to 80 Countries
TIIL is the second largest global manufacturer of Steel Drum Closures including Tite Seal Flanges & Plugs, Tite Seal Gaskets, Tite Seal Leak Locks Plugs, Octagon base Drum Flanges & Auto Closure Systems.
Technocraft successfully manufactures & supplies high quality Scaffolding System
It is internationally renowned for premium quality yarn.
Technosoft Engineering (TE) was established in 1999 and it provides engineering design services to various engineering / manufacturing companies.
FA looks Good TA looks Good too

 

[masonicinvestor]

2.TECHNOCRAFT INDUSTRIES (INDIA) LTD

40 year old company in diversified feilds... presence in 10 counties and exporting to 80 Countries
TIIL is the second largest global manufacturer of Steel Drum Closures including Tite Seal Flanges & Plugs, Tite Seal Gaskets, Tite Seal Leak Locks Plugs, Octagon base Drum Flanges & Auto Closure Systems.
Technocraft successfully manufactures & supplies high quality Scaffolding System
It is internationally renowned for premium quality yarn.
Technosoft Engineering (TE) was established in 1999 and it provides engineering design services to various engineering / manufacturing companies.
FA looks Good TA looks Good too


View attachment 20616

What software is this that you are using in screenshot?

 

[nanjil]

It is an Access data base template connected to Excel data

 

[Ferrari1976]

What are your data sources for the fundamental data about each of these companies?

 

[nanjil]

https://www.screener.in/company/UFLEX/consolidated/

 

[infor]

Very nice piece of Info , :clapping: appreciate it!

 

[masonicinvestor]

Can you teach how to use the access database and excel like you did?