How to do Financial Analysis of a Company ?
Вставка
- Опубліковано 20 вер 2024
- Subscribe to our channel for regular tips on CFA, FRM, and Investment Banking.
Follow us on:
Linkedin: / the-wallstreet-school
Facebook: / thewallstreetschool
Instagram: / the.wallstreet.school
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.
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.
That's very humble of you sir to admit. Thank you for inspiring that learning has no age.
That's very inspiring Sir. Stil having this much of will to learn at this age.
Very inspiring of you to say that, Learning has no age limit🤍
Hello sir can i have some career advice from you?
Youre sitll youth and more powerfull than us bro 👍
When it comes to the complexity, Indians are the best ❤
Absolutely
Indian minds are really incredible.👌❤️
to make it more complex?
Realtime numbers and explanations are always the best a viewer can get. Thank you! Much helpful.
Glad it was helpful!
Hello team. Am a CA student. The explanation was to the point and good. Keep doing the same.
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.
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
Mind if I ask you to recommend this particular coach you using their service? Seems you've figured it all out.
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
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.
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.
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
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.
Sir I was have problem with p&l , balance sheet and cash flow reading but sir you solved it .
Thanks sir.
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.
Thanks! My teacher uses this video in our college online classes!
OMG Thank you SO much for this video! everything is so well explained, simple to understand AND follow. Subscribed.
Hmmm really important since all students of class 12 CBSE need to know this .....hence thanks for the practical knowledge and skills
Comprehend, very well explained. instead of reading number of books to understand this is the best way to get it practically
I watched some other videos also but you're way of teaching is amazing you explain in a proper way ✨👌👌
wonderful sir. It was simple and easy to understand.
This is what i searching for long time. Thank you for this.
Thanking sir for sharing knowledge with practical knowledge
Your Smile in Initial part of video makes me happy to learn from you. good start.
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 ❤️
Very good analysis in simple & understandable language
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.
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.
very well explained , interactive and engaging tecahing methods, and absolute concept clearity. thanks
🥰🥰😊
Hello,
Explanation is very good and speed is also good so that average people can understand. keep it up.
Thanks.
Clear explanations !! Thank you !!!
Glad you liked it
In inventory days - Why did you take sales instead of COGS? should it not expenses?
I didn't understand cash flow from operations and from financing can you explain this in detail please
Amazing content. Thank you
Very informative video but needed future projections as well.....!
Thanks for the video, why there is no subtitle option under the video? it says the subtitle is unavailable!
Thank you so much for such excellent and informative video to study balance sheet of company
Learned a lot from this video . Highly appreciate it.
Informative video. It would be more helpful if you add on assumptions and build future projections. Thanks!
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
Comprehensive one .looking for more tutorials like these !
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???
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
It was wonderful analysis ever.
I have never seen such an analysis on excel with detailed understanding. 👏🏼👏🏼👏🏼
Well explained!
Dear sir, happy to see you ..
I have gone through your lectures on Visual Basic many time .. thanks sir
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.
Thank you for this video. If you don't mind... Plz pronounce crores in the correct way. You pronounce like carore... It takes me a few minutes to identify what the carore is. Finally i understood it's crore.
Extremely useful .True value addition
Very very well explained.
Glad you liked it
woah... what a video thank you for the precious knowledge!
Cumulative calculation was awesome
THANK YOU SO MUCH FOR THIS VIDEO IT HELPED ME SO MUCH WITH THE ASSIGNMENT THANK U
Awesome video... I have learnt a lot from it... love you for this analysis...and educating us...
love how the guy voicing "T"
I thought only I am noticing it ,But it was rather annoying for me in the later videos,because I was able to concentrate only on that "T"
make video on advanced financial analysis of any company...
Nice explanation for beginners..
Only suggestion was to increase the size of sheet since there was lots of space..
I want to learn Financial Statement Projections. if we have 2 years actual data and how to project next three years using actual data..?
Try the financial modeling video on this channel.
Enriching and knowledge enhancing. Great delivery and content
What a fantastic tutorial
Thank you! Cheers!
Thank you so much while am continuing to watch why cash and cash equivalent not current assets
Very good video! The easiest and best I have seen! Thank you!
This share i.e. today on 496 🔥🔥
Best! Really understood every concept of it.
19:43 just a small correction sir, you said trade payables and selected trade receivables
Many thanks for such a good explanation..
Sir Please let me know why you have done -1 in Sales Growth Formula
Thank You Sir, Very HelpFull Video .. .. . .
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
t = 23:00 there is a error in formula. Its written 365/(Sales/Average Inventories) but instead of Inventories it should be trade payables
Earned my subscription 🥳
But whats there of analysis calculation, investment in assets ie machines , employee means more production, more production means more number of sells, and increase in sale means increase in turnover, this is common attribute to business, or any job, you kindly make a video of what to do in an office if the job role is financial data analyst , or is this video is all the work thing that needs been for to do, and teach that OPM , found no revenue figure in those data, thank you ✌
Excellent info, well presented. Appreciate your efforts. Keep it up👏
Well explained sir..keep uploading more video.
Thanks... This video is really very helpful..
Excellent explanation. But sir how do we report this analysis of financial statement in the form of report?
Excellent video
Thank you very much!
Siir videos are really very helpful , i do refer the same to my students
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.
Good story telling easily understandable ,super 👍
Excellent videos , I like the method of teaching
Very good one. Kindly give some time when u do excel calculations.
Well explained, looking for more video like this
Sir , why u had not included Cash Equivalents in WORKING CAPITAL calculations ???
It can not be. Because cash and cash equavelent are allready part of opening and closing cash flow
Cash and cash equivalents are a part of current assets and must be taken into consideration while calculating net working capital.
Its really excellent video i learnt a lot thank you!
Ver well explained, Thank you.
It was a wonderful explanation... sir I have a doubt... I believe when we calculate debtors days we must take only credit sales but not cash sales...
Secondly we cannot see last year's debtors when you take average debtors
6:24 umm... Sir but instead of doing copy and paste we can directly download these financials into excel
Love the way you explain
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!!!
Great video I learn a lot. Thanks Bro
debtors days i am not able to calculate'in formula bar it is not showing input value.
We can use export to excel feature also ??
Thank you. Very informative
Sir please make video on tools and techniques for analysis all financial statements
Nice very informative and learnt very much with this one thq 🙏🏻
OPM calculation you didnt show like slaes growth , where (latest sale/ past sale )-1 = 31% , kindly show it , computer operator pre calculated it, am unable to understand , formula says (operating profit / revenue )× 100 , couldn't find row or column of revenue , show that from this datum, Op is 4 for 2010 , so according to formula Op / rev ×100 = 12 , then rev is 33.3 , there is no coloumn and row in the excell that showing revenue proposal ✌
nice expatiation sir thanks for video
Hello, plz share an video on how to write good equity research report for investors perspective
informative video thank you very much sir, and sir also prepare videos on value added EVA MVA SVA AND CVA it will be very helpful to me and all investors who look for beyond
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.
It's useful for new beginners
Very good and informative.👍
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.
Great content! Kindly explain the difference between ROC, ROIC & ROCE and similarly between PAT & NOPAT. Many thanks!