How to use Screener for Company analysis?

8 min readJun 8, 2024

Developing a quick research framework along with a bonus free add-on at the end

Hello Readers,

Do you often find yourself struggling with analyzing quality businesses on the go?

Look, don’t get me wrong, analyzing quality businesses does take a lot of time and energy especially when doing it for the first time and that requires a detailed research framework.

But a quick research framework can also be developed which helps you to analyze or pick a business on the go, without getting into every detailed aspect, but also without compromising on quality.

Both the frameworks are equally important.

Analysis requires some tools to support it, otherwise it becomes manual labor. One such top-notch and free tool is Screener.

Let us go through this with an example so that everything is crystal clear.

So let us pick up Jubilant Foodworks Ltd.

(This isn’t a stock recommendation; it is just for educational purposes…)

So the pop ups on the top of the page redirect the user to either of three websites, viz.

Company’s official website
Company page on National Stock Exchange (NSE)
Company page on Bombay Stock Exchange (BSE)

(Let us keep the Smart Analyze tool for the end…)

Now you can get to know more about the company by clicking on Read More (bottom right corner)

Here are Jubilant’s highlights:

It holds the master franchisee rights for Dominos brand (in India, Bangladesh, Nepal and Bhutan. It is the largest franchisee of Domino’s brand outside the USA), Popeyes (is a hardcore non vegetarian brand to compete with KFC) and has also launched its first homegrown brand — Hong’s Kitchen in Chinese cuisine segment (which was necessary as a 33000 Crore company can’t be run solely on the basis of franchisee rights, it needs something of its own)
Company has exclusive rights to Popeyes and Dunkin and started opening a fleet of restaurants from FY 22 and FY 23 for the above 2 as well as for Hong. It also wants to revamp the culture of Dunkin and make it more like a cafe rather than just a takeaway for donuts and 8 out of 21 Dunkin’ stores are now as per the brand’s new Coffee-first identity.
Company wound up its RTC (Ready to Cook) segment Chefboss and has scaled down the network of Ekdum! Biryani.
Company has a vision of doubling down on Dominos along with scaling up Popeyes and Hong Kitchen.
It is working to enhance overall customer experience with leveraging technology (as online sales contribute >98% to its overall sales) along with building an ambient physical dine in experience for diners.
It has tie up with IRCTC to deliver fresh pizzas to the customers’ seats on the trains.
Some additional points:

So, this was about the company…

Now comes the panel of Ratios and Graphs:

So this panel has various options:

First is the timeframe for which you want to look at the business. It ranges from a month to the maximum timeframe Screener has, as you can see in the top left of the picture.

So, if you look at the bottom, the are some checkboxes ticked, so I have the Volume indicator checked which shows the traded volume of the stock (represented on the left axis of the graph) and the price (represented on the right axis of the graph), the DMA stands for Displaced Moving Average.

On the top right, there are various parameters like Price, P/E Ratio, and more things if you click the drop-down:

Sales and Margin graphs, they include:
Gross profit Margin
Operating Profit Margin
Net Profit Margin
More details here.

EV/EBITDA Ratio

Price to Book Value Ratio

Market Capitalization to Sales ratio

Further you can also set alerts for certain triggers

Now about the Pros and Cons:

They can be useful but one should not take a decision solely based on those as they are machine generated too

Peer Comparison Panel

It gives us the industry, sector and peers for the specific company.

You can also go into the edit columns to add more parameters for comparison if you wish…

What’s more, you can even create your own ratios…

Here’s the link to do that…

Quarterly Results Panel

Here you can view the quarter or quarter results as reported by the company…

Keep in mind that these quarterly results aren’t audited fully but are just graced by something known as a limited review.

So you can expand on specific parameters, here’s how it looks…

You can also access the raw pdf of the outcome of board meetings and the auditor’s review on the raw pdf tab.

Just one caution, that the YoY sales growth should be compared to the same quarter of the last year and not to the immediately preceding quarter.

March 2024 should be compared with March 2023 and not December 2023.

In the top left, there is an option to either view the consolidated results or the standalone results.

One can see that the results in the winter months of the year and during sport seasons are comparatively better than other…

If you subtract the material cost % from 100%, you will get the Operating profit margin.

Operating profit is similar to (not same as) EBITDA.

Jubilant has reported a great YoY sales growth as compared to previous quarters and the percentage of material and employee costs to total expenses are relatively similar.

Profit and Loss Panel

Here one can view the yearly statement of profit and loss with various parameters such as the breakup of sales, expenses, other income, net profit etc. and also various measures which are key to analyzing a company such as compounded sales and profit and stock price growth (or decline) and the return on equity too.

For exposing frivolous management, it also has a related party transactions tab at the top right for users to take a note.

One may note that the CAGR of Sales is pretty impressive but the profit CAGR isn’t as Jubilant has to pay royalty to Dominos which is captured in other costs of the PnL account.

Balance Sheet Panel

In the Balance Sheet, the main areas to analyze are mainly Fixed Assets (which symbolizes Capex by the company) and Liabilities (Borrowings) and Reserves (which simply put are the profits which the company has earned till today and has reinvested it into the business).

There is a tab on the top right to get to know Corporate Actions like bonus, split, buyback, etc.

Borrowings which have increased include long term borrowings for capex purposes and from 2020 onwards, lease liabilities are also to be included in borrowings as per IND AS and IFRS requirements and Jubilant may be having many of its stores on lease, so they’re now shown in borrowings.

Cash Flow Panel

Just as the Profit and Loss account measures items on accrual basis, the Cash Flow statement serves the objective results, that is cash in cash out based results.

More details here.

Jubilant has reported consistent positive operation cash flows which is a sign of healthy and efficient operations.

The cash flow from investing activities is negative as it symbolizes more capex for meeting the spiking demand and is a good sign.

Cash flow from financing portrays that Jubilant has constantly repaid its financial liabilities and in the recent times, its long term borrowings too.

Ratios panel