How to do Financial Analysis of a Company ?

Поділитися
Вставка
  • Опубліковано 23 січ 2025

КОМЕНТАРІ • 290

  • @harika218
    @harika218 2 роки тому +31

    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
    @shriidharkulkarni6648 3 роки тому +141

    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
      @prize5ighter 3 роки тому +10

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

    • @sidharthsoren3232
      @sidharthsoren3232 3 роки тому +5

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

    • @user-ly4ut6xh7q
      @user-ly4ut6xh7q 3 роки тому +4

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

    • @prajwalsrivastava2306
      @prajwalsrivastava2306 2 роки тому +2

      Hello sir can i have some career advice from you?

    • @m7mdsul666
      @m7mdsul666 2 роки тому

      Youre sitll youth and more powerfull than us bro 👍

  • @BalakrishnaK-it2be
    @BalakrishnaK-it2be 8 місяців тому +2

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

  • @karthikraghu4260
    @karthikraghu4260 3 роки тому +20

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

  • @tboolah1
    @tboolah1 2 роки тому +43

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

    • @Farsath999
      @Farsath999 5 місяців тому

      Absolutely
      Indian minds are really incredible.👌❤️

    • @shashankk8936
      @shashankk8936 4 місяці тому

      to make it more complex?

  • @azizkhan938
    @azizkhan938 4 місяці тому +2

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

  • @k.ag.6372
    @k.ag.6372 Рік тому +5

    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.

  • @RockyCanadian
    @RockyCanadian Рік тому +1

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

  • @AdelitaWilliam-dl7ci
    @AdelitaWilliam-dl7ci Рік тому +1

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

  • @amittekchandani
    @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
    @poojabhambhu9687 2 роки тому

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

  • @surajitdutta259
    @surajitdutta259 3 роки тому +2

    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.

  • @bhaskarghosh5046
    @bhaskarghosh5046 3 роки тому

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

  • @the_FourPetals
    @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.

  • @rishabhmittal123
    @rishabhmittal123 Рік тому +1

    Thanking sir for sharing knowledge with practical knowledge

  • @mousumiojha9077
    @mousumiojha9077 3 роки тому

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

  • @kashifullabaig4370
    @kashifullabaig4370 3 роки тому

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

  • @najirpathan7520
    @najirpathan7520 2 роки тому

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

  • @Naik.Chinmay
    @Naik.Chinmay 3 роки тому

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

  • @saurabhsinghrajput348
    @saurabhsinghrajput348 2 роки тому

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

  • @hehe4599
    @hehe4599 Рік тому +1

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

  • @amolkulkarni6096
    @amolkulkarni6096 5 місяців тому

    Very good analysis in simple & understandable language

  • @Keshi_perera11
    @Keshi_perera11 10 місяців тому +2

    Clear explanations !! Thank you !!!

  • @khushboorastogi4948
    @khushboorastogi4948 2 роки тому +2

    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
    @meetsagarka6114 2 роки тому

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

  • @sachinparcha258
    @sachinparcha258 3 роки тому +1

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

  • @rajgour3788
    @rajgour3788 4 місяці тому

    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.

  • @jacksonroman1621
    @jacksonroman1621 Рік тому +80

    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
      @mathebulamkhize876 Рік тому +1

      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
      @stjepanhauser7595 Рік тому +1

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

    • @mathebulamkhize876
      @mathebulamkhize876 Рік тому +1

      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
      @stjepanhauser7595 Рік тому +1

      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.

  • @Exceltrainingvideos
    @Exceltrainingvideos 3 роки тому +9

    Well explained!

    • @khaledhossain4642
      @khaledhossain4642 3 роки тому

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

  • @investordas
    @investordas Рік тому

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

  • @Emran.iFarmer
    @Emran.iFarmer 10 місяців тому +2

    Very very well explained.

  • @Manjunathambig5
    @Manjunathambig5 2 роки тому

    Well explained sir..keep uploading more video.

  • @rahulpatell
    @rahulpatell 2 роки тому

    Best! Really understood every concept of it.

  • @DeepakKumar-sd7se
    @DeepakKumar-sd7se Рік тому

    Many thanks for such a good explanation..

  • @lkpmerchant
    @lkpmerchant 3 роки тому +1

    Extremely useful .True value addition

  • @ritwikghosh8174
    @ritwikghosh8174 2 роки тому

    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 ❤️

  • @ameeshanasir
    @ameeshanasir 3 роки тому +2

    Comprehensive one .looking for more tutorials like these !

  • @newhandle222
    @newhandle222 3 роки тому

    Learned a lot from this video . Highly appreciate it.

  • @ayso1320
    @ayso1320 3 роки тому +2

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

  • @akankshamishra7319
    @akankshamishra7319 2 роки тому

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

  • @Peds89161
    @Peds89161 11 місяців тому +2

    What a fantastic tutorial

  • @humanrace6224
    @humanrace6224 Рік тому +1

    Earned my subscription 🥳

  • @uptown7930
    @uptown7930 Рік тому

    Great video I learn a lot. Thanks Bro

  • @pranjaltapadiya1596
    @pranjaltapadiya1596 3 роки тому +1

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

  • @dipankarsonar
    @dipankarsonar 2 місяці тому +1

    excellent sirji excellent

  • @kartikeyakaushik4881
    @kartikeyakaushik4881 2 роки тому

    Enriching and knowledge enhancing. Great delivery and content

  • @shrutikanade5633
    @shrutikanade5633 Рік тому

    Its really excellent video i learnt a lot thank you!

  • @bipinyadav100
    @bipinyadav100 2 роки тому

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

  • @keilaherbruger9436
    @keilaherbruger9436 2 роки тому

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

  • @muruli742
    @muruli742 Рік тому

    Good story telling easily understandable ,super 👍

  • @rajatpatel2415
    @rajatpatel2415 3 роки тому

    Well explained, looking for more video like this

  • @netal_soni
    @netal_soni 2 роки тому

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

  • @00011164
    @00011164 Рік тому

    Ver well explained, Thank you.

  • @lalithasenthilkumar6265
    @lalithasenthilkumar6265 2 роки тому

    Very good and informative.👍

  • @bhagwatpdgupta5173
    @bhagwatpdgupta5173 2 роки тому

    Cumulative calculation was awesome

  • @PankajKumar-nc8hq
    @PankajKumar-nc8hq 3 роки тому +1

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

  • @amritamamsclasses
    @amritamamsclasses 2 роки тому

    Siir videos are really very helpful , i do refer the same to my students

  • @Maharashtra_Beats
    @Maharashtra_Beats 2 роки тому

    Excellent videos , I like the method of teaching

  • @MagicSpokenEnglish
    @MagicSpokenEnglish Рік тому

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

  • @ajaysherkhane8797
    @ajaysherkhane8797 3 роки тому +13

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

  • @divyas318
    @divyas318 5 місяців тому

    Amazing content. Thank you

  • @prasathmathi7348
    @prasathmathi7348 11 місяців тому

    It's useful for new beginners

  • @Maverick.87
    @Maverick.87 3 роки тому +1

    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

  • @sarahli345
    @sarahli345 Рік тому

    Thank you. Very informative

  • @abdulmajidmohammed2059
    @abdulmajidmohammed2059 2 роки тому

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

  • @babukr3318
    @babukr3318 Рік тому

    Excellent info, well presented. Appreciate your efforts. Keep it up👏

  • @cryptolover9739
    @cryptolover9739 2 роки тому

    Love the way you explain

  • @bodla12rao
    @bodla12rao Місяць тому

    nice explanation sir

  • @naseemanasi1431
    @naseemanasi1431 Рік тому

    Great vedio

  • @saravanan9042
    @saravanan9042 3 роки тому

    Very informative video. Thank you.

  • @manishkothari6710
    @manishkothari6710 2 роки тому

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

  • @tradewidtejas2249
    @tradewidtejas2249 Рік тому

    nice expatiation sir thanks for video

  • @vinayvarghese9426
    @vinayvarghese9426 2 роки тому

    Good video. Very explanatory.

  • @kumtrading
    @kumtrading Рік тому

    Great explanation

  • @atiqbhatti51
    @atiqbhatti51 3 роки тому

    excellent Video. Great explanation of the topic

  • @amiramir-bh5dk
    @amiramir-bh5dk Рік тому +1

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

  • @ketanbhosale3918
    @ketanbhosale3918 Рік тому

    Excellent video

  • @rachanassapne9533
    @rachanassapne9533 3 роки тому

    Nice very informative and learnt very much with this one thq 🙏🏻

  • @PRIYASINGH-cw9hu
    @PRIYASINGH-cw9hu 2 роки тому

    Very good and well explained video!!

  • @mbastoryteller921
    @mbastoryteller921 2 роки тому

    a very very important video

  • @just_be_abhinav
    @just_be_abhinav 5 місяців тому +1

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

  • @alammohammadnaushad330
    @alammohammadnaushad330 Рік тому

    very nice presentation

  • @anujlahoty8022
    @anujlahoty8022 3 роки тому +1

    Very nice and informative lecture. Loved it!

  • @rdj008
    @rdj008 Рік тому +1

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

  • @sameepsakpal5261
    @sameepsakpal5261 2 роки тому +1

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

  • @vivekviek1315
    @vivekviek1315 2 роки тому

    Simply awesome!

  • @dpl7259
    @dpl7259 3 роки тому

    wonderful sir. It was simple and easy to understand.

  • @gankimagoliguerfiehanoi7146
    @gankimagoliguerfiehanoi7146 8 місяців тому

    Very detailed video

  • @numaankhan1252
    @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.

  • @aashijesani7030
    @aashijesani7030 3 роки тому

    Great video, easily understandable.

  • @sumonahmed6283
    @sumonahmed6283 3 роки тому

    Really excellent

  • @rohitmandhyan
    @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

  • @michloanton5721
    @michloanton5721 2 роки тому

    Very good one. Kindly give some time when u do excel calculations.

  • @anishsoni9929
    @anishsoni9929 Рік тому +1

    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???

  • @kajalgandhi1428
    @kajalgandhi1428 3 роки тому +3

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

  • @arpandoshi9878
    @arpandoshi9878 2 роки тому

    Ultimate 👌🙏

  • @nikitasangroula9313
    @nikitasangroula9313 3 роки тому

    informative and nicely explained

  • @mohammadadnan2682
    @mohammadadnan2682 3 роки тому +9

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

  • @viragsharma5663
    @viragsharma5663 Рік тому +1

    Excellent Thanks

  • @margaritageorgieva7693
    @margaritageorgieva7693 2 роки тому

    very good video😉