How to do Financial Analysis of a Company ?

[@harika218]

Hi Sir, These kind of real case study using financial statements in excel never explained in any you tube channel. You are teaching not just formulas but also how to do analysis using these parameters. really liked these video.

[@shriidharkulkarni6648]

Excellent video. You have a very friendly way of explaining. Even a 61-year-old person like me with below-average intelligence could find it interesting. Keep up the good work. Thanks.

[@prize5ighter]

That's very humble of you sir to admit. Thank you for inspiring that learning has no age.

[@sidharthsoren3232]

That's very inspiring Sir. Stil having this much of will to learn at this age.

[@user-ly4ut6xh7q]

Very inspiring of you to say that, Learning has no age limit🤍

[@prajwalsrivastava2306]

Hello sir can i have some career advice from you?

[@m7mdsul666]

Youre sitll youth and more powerfull than us bro 👍

[@k.ag.6372]

Debtor days is calculated by dividing 360/DEBTOR TURNOVER RATIO (in days). And Debtor turnover ratio is calculated by dividing CREDIT SALES(not total sales)/avergae debtors.

[@tboolah1]

When it comes to the complexity, Indians are the best ❤

[@Farsath999]

Absolutely Indian minds are really incredible.👌❤️

[@shashankk8936]

to make it more complex?

[@karthikraghu4260]

Hello team. Am a CA student. The explanation was to the point and good. Keep doing the same.

[@BalakrishnaK-it2be]

Realtime numbers and explanations are always the best a viewer can get. Thank you! Much helpful.

[@thewallstreetschool]

Glad it was helpful!

[@azizkhan938]

Thank you so much for making this insightful and practical video on financial analysis. The presenter demonstrated it in an easy to understand manner.

[@AdelitaWilliam-dl7ci]

Found your post interesting to watch. I can't wait to see your new videos soon. Good Luck with the upcoming update. This KZbin channel is very informative and effective.

[@RockyCanadian]

Thanks! My teacher uses this video in our college online classes!

[@amittekchandani]

exactly what I was searching the way to analyse the financials of the company to invest. thankyou for this. keep making videos... more power to u

[@poojabhambhu9687]

Sir I was have problem with p&l , balance sheet and cash flow reading but sir you solved it . Thanks sir.

[@jacksonroman1621]

I appreciate your approach of teaching.. To my understanding this just proves how much we need an edge as investors because playing the market like everyone else just isn’t good enough, we just need to hold onto our hopes and wait to see how things turn out because market movements are almost always unpredictable. In my portfolio, I'm noticing more red than green. I'm 47, and earn nothing less $150k per year, but nothing to show for it yet.

[@mathebulamkhize876]

Very true, a huge part of my portfolio growth has come during this bear market. I've been able to scale from $180K to $572K in a short period of time. I basically was just following the steps and guideline from my financial advisor. as long as you've professional help, you're good to go

[@stjepanhauser7595]

Mind if I ask you to recommend this particular coach you using their service? Seems you've figured it all out.

[@mathebulamkhize876]

Well i won't say i have........His name is "Nolan Velden Brent" can't divulge much. Most likely, the internet should have his basic info, you can research if you like

[@stjepanhauser7595]

he appears to be well-educated and well-read. I ran a Google search on his name and came across his website; thank you for sharing.

[@surajitdutta259]

Very very well explained, i never look deeply in any financials like this. Its up-grade my knowledge. Thank you very much. Waiting for next informatics video.

[@hehe4599]

OMG Thank you SO much for this video! everything is so well explained, simple to understand AND follow. Subscribed.

[@rohitmandhyan]

t = 23:00 there is a error in formula. Its written 365/(Sales/Average Inventories) but instead of Inventories it should be trade payables

[@amiramir-bh5dk]

Thanks for the video, why there is no subtitle option under the video? it says the subtitle is unavailable!

[@the_FourPetals]

Your explanation is very useful for me because recently I had join executive MBA and I don't have any knowledge of accounting niether my background is commerce but stil I jumped this field and now it's time to do my fully efforts . Also request for another videos in understanding language of another subject of excutive MBA.

[@bhaskarghosh5046]

This is what i searching for long time. Thank you for this.

[@rishabhmittal123]

Thanking sir for sharing knowledge with practical knowledge

[@Naik.Chinmay]

Your Smile in Initial part of video makes me happy to learn from you. good start.

[@sameepsakpal5261]

In inventory days - Why did you take sales instead of COGS? should it not expenses?

[@kashifullabaig4370]

Comprehend, very well explained. instead of reading number of books to understand this is the best way to get it practically

[@mohammadadnan2682]

I want to learn Financial Statement Projections. if we have 2 years actual data and how to project next three years using actual data..?

[@MariaGutierrez-zc2jv]

Try the financial modeling video on this channel.

[@najirpathan7520]

Hello, Explanation is very good and speed is also good so that average people can understand. keep it up. Thanks.

[@sachinparcha258]

I watched some other videos also but you're way of teaching is amazing you explain in a proper way ✨👌👌

[@rajgour3788]

Sir, you explained it so well that I inderstood every ratio and other terms. And sir i wanted you to make an excel video of all the major formulas you applied in this video.

[@just_be_abhinav]

6:24 umm... Sir but instead of doing copy and paste we can directly download these financials into excel

[@mousumiojha9077]

Hmmm really important since all students of class 12 CBSE need to know this .....hence thanks for the practical knowledge and skills

[@khushboorastogi4948]

Really very interesting video. Everything was explained in a very precise manner. I have never dropped any comment on youtube yet but your video really made me to do it. Thanks for the explanation. Would like to have more such videos.

[@meetsagarka6114]

Thank you so much for such excellent and informative video to study balance sheet of company

[@Keshi_perera11]

Clear explanations !! Thank you !!!

[@thewallstreetschool]

Glad you liked it

[@amolkulkarni6096]

Very good analysis in simple & understandable language

[@saurabhsinghrajput348]

very well explained , interactive and engaging tecahing methods, and absolute concept clearity. thanks 🥰🥰😊

[@numaankhan1252]

Hello Sir, I don't know if I'm correct but there is a slight mistake done in the analysis where you took Trade payable in Debtors Days instead of Trade receivables. Please Correct me if I am wrong. I want to learn more in depth about financial analysis.

[@lkpmerchant]

Extremely useful .True value addition

[@newhandle222]

Learned a lot from this video . Highly appreciate it.

[@Exceltrainingvideos]

Well explained!

[@khaledhossain4642]

Dear sir, happy to see you .. I have gone through your lectures on Visual Basic many time .. thanks sir

[@ajaysherkhane8797]

Informative video. It would be more helpful if you add on assumptions and build future projections. Thanks!

[@KunalKumarSahu-ld4ug]

19:43 just a small correction sir, you said trade payables and selected trade receivables

[@rdj008]

I didn't understand cash flow from operations and from financing can you explain this in detail please

[@ayso1320]

Very informative video but needed future projections as well.....!

[@ameeshanasir]

Comprehensive one .looking for more tutorials like these !

[@ayso1320]

Sir , why u had not included Cash Equivalents in WORKING CAPITAL calculations ???

[@anandkumar-xu3yq]

It can not be. Because cash and cash equavelent are allready part of opening and closing cash flow

[@yashawanthyash3263]

Cash and cash equivalents are a part of current assets and must be taken into consideration while calculating net working capital.

[@anushkakaushik806]

debtors days i am not able to calculate'in formula bar it is not showing input value.

[@anishsoni9929]

Can anyone tell me what is the difference between financial analysis, financial statement analysis and financial ratio analysis , and I beleive he has taught us ratio analysis???

[@VikasKothari-k8o]

Sir Please let me know why you have done -1 in Sales Growth Formula

[@yashkirankaur5054]

Sir in case if non controlling interest is given in the balance sheet.Then how to calculate net working capital.We have to add it or just ignore that item.

[@Mad1080]

How do you planing and analysis and what is the 1st step.

[@Emran.iFarmer]

Very very well explained.

[@thewallstreetschool]

Glad you liked it

[@damienmussard1821]

Hello, excellent video. Can I ask you to activate the youtube's subtitles please ? I am french and sometimes I miss some word that I can't understand. Thanks in advance.

[@sohamd340]

We can use export to excel feature also ??

[@investordas]

Thank You Sir, Very HelpFull Video .. .. . .

[@rahulpatell]

Best! Really understood every concept of it.

[@ritwikghosh8174]

I just open my note book and take a pen, pencil and scale and start writing down every aspect and watching this video like tution ❤️

[@Peds89161]

What a fantastic tutorial

[@thewallstreetschool]

Thank you! Cheers!

[@kartikeyakaushik4881]

Enriching and knowledge enhancing. Great delivery and content

[@abdulmajidmohammed2059]

Thank you so much while am continuing to watch why cash and cash equivalent not current assets

[@ramya7483]

What to do if we won't have trade receivable to calculate debtor days and for inventory also

[@humanrace6224]

Earned my subscription 🥳

[@DeepakKumar-sd7se]

Many thanks for such a good explanation..

[@Maverick.87]

Thank you for a helpful video.pls make videos to increase our knowledge in the same regard. Pls make video on how to ANALYSE THE MANAGEMENT

[@mihidase]

Am I reading it wrong? In Mar-2016: Land-0.29 Building-2.21 Plant Machinery-10.64 Equipments-0.14 Totalling: 13.3 Cr, while Fixed Assets shows only 3 Cr? As per Investopedia - FATR= Average Fixed Assets/Net Sales

[@pranjaltapadiya1596]

woah... what a video thank you for the precious knowledge!

[@Manjunathambig5]

Well explained sir..keep uploading more video.

[@shihabshahriar7874]

commulative cashflow from operating and commulative net profit are confused me can you please explain me

[@akankshamishra7319]

Thanks... This video is really very helpful..

[@bipinyadav100]

Awesome video... I have learnt a lot from it... love you for this analysis...and educating us...

[@krishbryanrao8003]

will share price movement( demand & supply) have any effect on financials of the company.

[@kajalgandhi1428]

make video on advanced financial analysis of any company...

[@SMRUTISNIGDHABISSOYI-e8x]

why you are not taking cash equivalents into current assets?

[@keilaherbruger9436]

Very good video! The easiest and best I have seen! Thank you!

[@netal_soni]

THANK YOU SO MUCH FOR THIS VIDEO IT HELPED ME SO MUCH WITH THE ASSIGNMENT THANK U

[@PankajKumar-nc8hq]

It was wonderful analysis ever. I have never seen such an analysis on excel with detailed understanding. 👏🏼👏🏼👏🏼

[@naseemanasi1431]

Great vedio

[@dipankarsonar]

excellent sirji excellent

[@prakharnahar]

How to do the same using annual reports from bse website

[@manishkothari6710]

Nice explanation for beginners.. Only suggestion was to increase the size of sheet since there was lots of space..

[@cryptolover9739]

Love the way you explain

[@veera6229]

@28:32 out of 26 crores net profit , how can 30 crores be cash ?

[@00011164]

Ver well explained, Thank you.

[@uptown7930]

Great video I learn a lot. Thanks Bro

[@gopinathmaravan]

Sir, why can't you use Expenses for Purchases instead of using sales. Similarly, why can't we use difference of inventory between 2 years instead of sales in inventory turnover ratio

[@jameschester5530]

Is that excel workbook available?

[@chancelittle4863]

Xcellent Video. However unable to read the text you show in video. If you can post the excel spreadsheet you are using, it would be easier to follow. Thanks.

[@shrutikanade5633]

Its really excellent video i learnt a lot thank you!

[@nirbhaybapna8001]

I tried doing an analysis based on the above for MDL and my figures did not match specially for ROCE and Inventory days. Can I send my sheet and seek guidance.

[@nirmalbalajidn7086]

How the company benefits from Share market ? Is BSE and NSE will pay some amounts to the company ?

[@GullBadani]

Excellent explanation. But sir how do we report this analysis of financial statement in the form of report?

[@priyakamriya5829]

while calculating creditors days you put bracket before 365 instead of putting it after /, please do reply me if I'm not correct

[@divyas318]

Amazing content. Thank you

[@prashansagupta1562]

do we take consolidated or standalone for DCF valuation Model ?

[@biswadeepghosh2365]

Why Cash has not been considered in Current Asset while Calculating Net working Capitals??

[@86nayankanisk]

Cash is excluded as it is a non-operating asset. Normally in companies, cash does not just sit idle as it is invested in short term securities, etc. hence does not make sense to include in working capital cycle. There is a healthy discussion on www.analystforum.com/t/net-working-capital-include-cash-or-not/82213/7

[@AaronPackeys]

@@86nayankanisk Please can you check the Creditor Days again, I think there is a problem with formula

[@kumarsarwesh8564]

sir, creditor days calculation seems wrong, please check

[@sehancherian]

Hi I had the same doubt. I feel much better now thanks

[@sarahli345]

Thank you. Very informative

[@lalithasenthilkumar6265]

Very good and informative.👍

[@prasathmathi7348]

It's useful for new beginners

[@MagicSpokenEnglish]

great....great...great video. thanks a lot

[@Maharashtra_Beats]

Excellent videos , I like the method of teaching

[@tradewidtejas2249]

nice expatiation sir thanks for video

[@Mad1080]

This is data we have taken from screener... If we wanted to prepare this data.. Like all 3 financial statements and from that ratio's.. Later analysis... How?? Please guide us on this Sir!!!