How to do Stock Analysis | A step-by-step process using screener.in

In this video, Vivek Mashrani explains various strategies to perform fundamental analysis of Indian stocks using excel screener template. This is ultimate session to understand various aspects on analysis of Income statement, Balance Sheet, Cashflow statement as well as performing Ratio Analysis.

00:00 - Overview and excel screener template overview
06:51 - Details of different tabs inside stock screener excel
10:46 - Understanding and stock analysis for income statement
17:01 - Understanding income statement financial ratios
27:16 - Understanding balance sheet and it's ratios
42:20 - Cashflow statement analysis of company
48:08 - Dupont analysis - three stage and five stage model

If you love reading TechnoFunda Investing books, you can explore below video:

This video will be very useful if you are searching for below:
- best stock screener setup
- how to screen for growth stocks
- high growth stock screener
- best stock screener formulas
- value investing screener criteria
- best stock screens
- Basics of Fundamental Analysis of Stocks for beginners
- How to find fundamentally strong stocks
- Free screener for fundamental analysis
- How to choose the right stocks for investments

Read full disclaimer and privacy policy below:
*Investments in securities are subject to market risks. Read all the related documents carefully before investing. The securities quoted are for illustration only and are not recommendatory. Please consult your financial advisor before making any investing or trading decisions.*

#TechnoFunda #VivekMashrani #Screener

[MrVeer]

Many thanks for explaining many of the things in a lucid way.

[ammupachayil]

That was excellent Session. Thank you so much for your Love, Simplicity and Sincerity. I would love to share my holdings and take appropriate advice.

[harpalsinghgill]

Excellent learning. I am a silver member

[RBG]

this lecture and excel template provided is worth gold! i edited the existing template to add a lot more charts since i like looking at charts than read numbers, makes my past performance analysis a matter of 10-15 minutes so I can now focus on future growth drivers and risks of the business from the setup of past performance, instead of mindlessly reading about past performance. God bless you and your family Sir!

[explorerbasuofficial]

loved the session. thanks a lot for helping us with our valuable advice. looking forward for more of this. god bless you.

[pritesh]

You should have added dcf method it this sheet if it was possible

[arvindmanglik]

the companies performace over the time in terms of sales, profitability,margins, power to decide product price

[qhxowlw]

pl support i chek nestlay data show up to dec21

[kds]

Sir Happy Vijaydashmi To you, , ,
Just seen your vedio on "Stock fanancial manupulation", , So looking CFO/PAt for Avantel Stock.. what it interprits, , STock price is high and higher but this ratio is in negative since last 4 quarter

[bmuniverse]

Sir I am not getting the excel, how can I get it pls tell me

[sanjooghosh]

not finding share holding pattern page ? is it there?