Words cannot describe how appreciative I am for you doing such a series, slightly off Excel but delving into actual Finance principles. We don't even work for the same company, but I'd nominate you as "Employee of the Month" just for that!
You have no idea how refreshing this is to grasp this kind of information. This video saves a lot of time learning the necessary information compared to some college courses.
How I wish again and again that these videos could have been there, when I was studying Accounting in college! Thank you Leila for the great explanation of these concepts. It was a welcome refresher! 😊👍
I cannot say enough about how good this lady is. I have watched to over 100 such videos. Many of them drag it out to fill 20 minutes. Turns out, if the videos are longer, they make more money. This lady stays to the point makes it clear. Maybe I am biased, because I have an accent too.
Outstanding video. Best explanation of a Balance Sheet I’ve watched or have explained. As a bookkeeper, I look at BS frequently and this was the clearest explanation. Well done Leila
Just started my accounting module on ratio analysis and this video showed up, really useful explanation using a real company's balance sheet. It would be great if you made a video on Apple's P&L and cashflow.
I really appreciate the easy way of understand your tutoring rather than my four years in university this teach me many ideas, thnks for your enthusiastic way of teaching us 100%
Beautiful Leila. Really wonderful. One request however, is it possible to have you briefly present on Debtors and Creditors Control? That would really help. Thanks.
Thanks so much. I’ve run my own companies for years now and I always glean one of two things from your videos that help me understand just a little bit more
Thank you for ALL your videos. I have learned so much in one day than I have in months. Your a great teacher so please don’t ever stop making content that is helping so many of us excel in the field. I can’t thank you enough 🙏🙏
Accountant here, excellent video for beginners. Just to add some context to apple's excellent Cash conversion cycle; when companies outsource manufacturing, raw materials/component parts are not reflected on the statements and therefore only finished products are reflected as 'Inventory'. Meaning the inventory days becomes much smaller. Additionally, we're all aware that Apple stocks are high valued. They have a market capitalization of about 2trillion. Market capital cap refers to the total value of all shares at market price. The value of stocks reflected on the balance sheet is par. That means its the price the stock was issued at by Apple to the public. The price of Apple stocks on the secondary market(stock market) is higher than par because investors value the stock to be worth more than it was issued at.
Thanks for all you do Leila. This is kinda a refresher course for a Chartered Accountant like me. I hope to see videos on Statement of Cash flow and the likes. Again, thank you
Excellent video for non financial users! I work in public accounting and studying for my CPA and your video is a good overview of some relevant ratios. Looking forward to more
Excellent video, @Leila Gharani. Much clearer than my graduate school class in financing and accounting. Please keep making more of these kinds of videos. Thank you.
Leila..Absolutely bests ratio and balance sheet explained. Complex balance sheet analysis made simple. Your explanation is just as good as soothing running water to ears. Thankyou for sharing you knowledge... 👍🏾
U are honestly the best ! ever since I watch your vids, it has been very clear !! Pls do more of this kind of vids especially financial statements and dive more technically ~~
hi Leila, I really love your vlogs! Can I request for a vlog about computation of Internal Rate of Return, Yield to Maturity and Net Present Value of Treasury Bonds and Bills and how to identify the best to buy. Hopeu can grant my wish! All the best!
Great intro into Apple's financial statements, Leila: showing payable days at 83 means for you as a supplier you need a huge amount of cash for prefinancing your production while making business under hard limits (cost, quality control) with Apple. The guys in Los Altos are collecting cash from customers and suppliers. Didn't know that yet.
Agree. And that a requirement in the automotive industry '' paying for packaging and raw materials from the clients 😅 and waiting for extra penny's on every delivery '' buy and resale strategies
I already know these for years now. To a supplier, Apple is a "bad" customer as they squeeze them the cost, and demand quality n long payment term. However, many suppliers can't lose Apple as this is their biggest customer. And this Tier-1 suppliers, use the same "method" and demand the same to their Tier-2 suppliers and so on. And this is the real world.... What surprise me is that they are paying their suppliers in such a long time........
Laila, i am as a CFO would like to say you are really Fantastic and i wish to meet you one day to learn from you more in my long life of work, congratulations always
Thanks for the video Leila very informative in every aspect, the only thing I dont understand is where you found access to the excel version of Apples balance sheet, as I cannot find it anywhere? Thanks
Hello, could you please provide a video on “mapping the financial statements”. For example how to form a cash flow statement from balance sheet and p&l statement…
You should try teaching Quantum Mechanics, most art students may shift careers. Also, please teach us to write research reports for fintech companies. I feel Powerpoint is better than word coz of graphs and graphics, but you are the teacher 😇
Nice introduction for understanding of financials.. one thing I want to add is that the important thing is cash position. Thats why we analyze both BS and PL. Companies can increase its sales and make profit; yet, what about collections? How the company sustain its business operatins? How operations are financed? Thus, please learn how to read cash flow statement, because everything is about cash flow.. and maybe leyla can make a video how to read cash flow statement..
Excellent video Leila. Simple, straight, informative and meaningful. I personally loved those ratios viz. Inventory Days, Receivable Days, Payable Days. Thanks !. Wish you happy Christmas and healthy n prosperous year ahead. Love from India !!!
Leila great video as always. AAPL inventory days = 9 Does it mean they don’t keep stocks? Doesn’t that mean the supply chain disruptions are going to affect them more than Other companies? Or does it mean these guys are extremely efficient? Thanks in advance.
Great video! Concise and to the point with a visual aid. Awesome! Did you make a video for the income statement and cash flow statement? If so, please share.
Great video as always, Leila! Quick question - For Inventory Days and Receivable Days, why do we take the average of the 2 periods but only used the recent COGS and Sales?
Because inventory and receivables is the value of just one day (the day the balance sheet was created for). COGS and sales is the value for an entire year. So, it's generally recommended to at least take a value from another day into account for the balance sheet items.
Leila, another well delivered tutorial, thank you. May I suggest content for another tutorial? I'd like to know if and how I can apply standard formatting (font, font size, paragraph alignment, and line spacing, etc) to all MS Word docs on my hard drive without having to open each file individually and apply the desired formatting. It would also be good to add in a command that converted older file formats, such as Word 97-2003, to the latest format without having to open and save each file in the new version. Thank you.
Hello Mam, Good to see you, I have learned many more from your videos. Whenever I see your videos must learn anything. Please tell me which Office you have and use??? Office 365 Office 2021 Office 2016 and also tell me which office you recommend ??
@@LeilaGharani OKay Mam, Thank you So much for your Response. Mam Can we gat office 365 Free ?? If Yes, then Mam must make a video on it Please... Thank you.
Hi Leila, how reliable is to compare inventory and payable days between different companies? Do specific rules exist to calculate the cost of sales for listed companies? I worked for a short time in finance for a non listed company and depending what you consider cost of sales, the ratios could change a lot.
Download my workbook to follow along here 👉 pages.xelplus.com/ratios-excel-file
Words cannot describe how appreciative I am for you doing such a series, slightly off Excel but delving into actual Finance principles. We don't even work for the same company, but I'd nominate you as "Employee of the Month" just for that!
Seconded!
Yes!!!!! I Third this! You rock - I have gained so much from you 😃
She’s awesome!!! How in the heck does she explain this better than my professors did in college???
You have no idea how refreshing this is to grasp this kind of information. This video saves a lot of time learning the necessary information compared to some college courses.
How I wish again and again that these videos could have been there, when I was studying Accounting in college! Thank you Leila for the great explanation of these concepts. It was a welcome refresher! 😊👍
Thank you Leila, outstanding as always. An entire series on this topic would be fantastic.
I cannot say enough about how good this lady is. I have watched to over 100 such videos. Many of them drag it out to fill 20 minutes. Turns out, if the videos are longer, they make more money. This lady stays to the point makes it clear. Maybe I am biased, because I have an accent too.
Outstanding video. Best explanation of a Balance Sheet I’ve watched or have explained. As a bookkeeper, I look at BS frequently and this was the clearest explanation. Well done Leila
Awesome, thank you Henry!
@@LeilaGharani You are beautiful :)
No one cares about money. Only what ideas we have in our minds. We all share thoughts.
Thanks for this. As someone who doesn’t have a finance background, my knowledge of balance sheets is limited, but your video was very informative.
I would really appreciate a video on how the P&L, Balance Sheet, and Cash Flow statements flow between each other.
She's brilliant in every field 🔥
To The World You May Be Just a Teacher But To Your Students You Are A Star
Was postponing the balance sheet thing for years, but could not do it anymore seeing such an outstanding lesson. Merci Leila
Just started my accounting module on ratio analysis and this video showed up, really useful explanation using a real company's balance sheet.
It would be great if you made a video on Apple's P&L and cashflow.
I really appreciate the easy way of understand your tutoring rather than my four years in university this teach me many ideas, thnks for your enthusiastic way of teaching us 100%
You genuinely have a simple way to explain and presents concepts to a broad audience. Kudos.
Beautiful Leila. Really wonderful. One request however, is it possible to have you briefly present on Debtors and Creditors Control? That would really help. Thanks.
Thanks so much. I’ve run my own companies for years now and I always glean one of two things from your videos that help me understand just a little bit more
مرسی لیلاا خیلی زیاد دنبال همچین آموزشی بودم. واقعا کمک کننده بودش
Thank you for ALL your videos. I have learned so much in one day than I have in months. Your a great teacher so please don’t ever stop making content that is helping so many of us excel in the field. I can’t thank you enough 🙏🙏
Thank you so much!
what a great video - explaining a very complex financial analysis for everyone to understand. Thank you for sharing such hard earned knowledge.
Accountant here, excellent video for beginners.
Just to add some context to apple's excellent Cash conversion cycle; when companies outsource manufacturing, raw materials/component parts are not reflected on the statements and therefore only finished products are reflected as 'Inventory'. Meaning the inventory days becomes much smaller.
Additionally, we're all aware that Apple stocks are high valued. They have a market capitalization of about 2trillion.
Market capital cap refers to the total value of all shares at market price.
The value of stocks reflected on the balance sheet is par. That means its the price the stock was issued at by Apple to the public. The price of Apple stocks on the secondary market(stock market) is higher than par because investors value the stock to be worth more than it was issued at.
Not for a Single minute it feels complex to understand, we come to know about a lot more ratios in this video. Thankyou very much mam :)
So nice of you!
Thanks for all you do Leila. This is kinda a refresher course for a Chartered Accountant like me. I hope to see videos on Statement of Cash flow and the likes. Again, thank you
Glad you liked it!
Engineering major but we have an accounting subject. This video helped me a lot in my coursework. Kudos, Leila. Thanks.
Excellent video for non financial users! I work in public accounting and studying for my CPA and your video is a good overview of some relevant ratios. Looking forward to more
Great to hear!
Excellent video, @Leila Gharani. Much clearer than my graduate school class in financing and accounting. Please keep making more of these kinds of videos. Thank you.
Thank you! Will do!
Leila..Absolutely bests ratio and balance sheet explained. Complex balance sheet analysis made simple. Your explanation is just as good as soothing running water to ears. Thankyou for sharing you knowledge... 👍🏾
Wow! The statements won't be intimidating anymore...Thank you Leila.
You don't know how happy i am. I learned a lot from this that's not on the modules given by our prof😭! Thankyou
Glad it was helpful!
U are honestly the best ! ever since I watch your vids, it has been very clear !! Pls do more of this kind of vids especially financial statements and dive more technically ~~
I really appreciate these videos to get a deeper understanding of Accounting. Thanks so much Leila.
You're so welcome!
hi Leila, I really love your vlogs! Can I request for a vlog about computation of Internal Rate of Return, Yield to Maturity and Net Present Value of Treasury Bonds and Bills and how to identify the best to buy. Hopeu can grant my wish! All the best!
I'll think about it. Many thanks for the suggestion!
please make some more videos on finance . u have super skill of explaining things and making them simple.
thanks
Very helpful video for beginners! Its amazing how you make complex financial concepts easy to understand and follow! Great job!
Awesome, thank you!
your way of explaining is so good, thank you!
I am 74 and use hyperlinks to access external files, but you just opened my eyes two clicking into the different tabs of the spreadsheet. Thank you,
Happy to help :)
Great intro into Apple's financial statements, Leila: showing payable days at 83 means for you as a supplier you need a huge amount of cash for prefinancing your production while making business under hard limits (cost, quality control) with Apple. The guys in Los Altos are collecting cash from customers and suppliers. Didn't know that yet.
Agree. And that a requirement in the automotive industry '' paying for packaging and raw materials from the clients 😅 and waiting for extra penny's on every delivery '' buy and resale strategies
I already know these for years now. To a supplier, Apple is a "bad" customer as they squeeze them the cost, and demand quality n long payment term. However, many suppliers can't lose Apple as this is their biggest customer. And this Tier-1 suppliers, use the same "method" and demand the same to their Tier-2 suppliers and so on. And this is the real world.... What surprise me is that they are paying their suppliers in such a long time........
This is an excellent and simplified way of explaining the B/S and what to look for in often confusing SEC Filings. TY!
Laila, i am as a CFO would like to say you are really Fantastic and i wish to meet you one day to learn from you more in my long life of work, congratulations always
This is an awesome video. Thank you Leila. Looking forward to your P/L and Cashflow videos,
Great presentation, Leila. One comment - for the inventory days formula, I’d take the COGS of products only.
Topic is wide but interesting. I have to watch over and over. Thanks
Thanks for the video Leila very informative in every aspect, the only thing I dont understand is where you found access to the excel version of Apples balance sheet, as I cannot find it anywhere? Thanks
Leila, I like to watch your videos, you are EXCELLENT. You explain everything in detail. Great job.
Glad you like them!
Hello, could you please provide a video on “mapping the financial statements”. For example how to form a cash flow statement from balance sheet and p&l statement…
This was amazing, I'm in love with your channel after this one single tutorial! I just subscribed, thank you so much.
Awesome! Thanks for subbing!
Thank you for this video! I have a question, where are the Net Fixed Assets in this statement? are they the non-current assets?
Cool... Very loud and clear explanation 👍👍👍
Thank You Leila, you made it looks very easy to assimilate!
Much appreciated.
This is so helpful! You've done a great job of simplifying the statement
I've already shared with several others
Thank you so much!!
Awesome, thank you!
Thank you for your simplicity. Best teacher ever 🇰🇪❤
You should try teaching Quantum Mechanics, most art students may shift careers.
Also, please teach us to write research reports for fintech companies. I feel Powerpoint is better than word coz of graphs and graphics, but you are the teacher 😇
Nice introduction for understanding of financials.. one thing I want to add is that the important thing is cash position. Thats why we analyze both BS and PL. Companies can increase its sales and make profit; yet, what about collections? How the company sustain its business operatins? How operations are financed? Thus, please learn how to read cash flow statement, because everything is about cash flow.. and maybe leyla can make a video how to read cash flow statement..
Fully agree! I do have a video about cash flow actually: th-cam.com/video/hMBN6yTIDb0/w-d-xo.html
Excellent video Leila. Simple, straight, informative and meaningful. I personally loved those ratios viz. Inventory Days, Receivable Days, Payable Days. Thanks !. Wish you happy Christmas and healthy n prosperous year ahead. Love from India !!!
Thanks Sachin! Happy New Year to you too!
This was terrific. Can't wait for the video on the Income Statement and ratios.
Leila great video as always.
AAPL inventory days = 9
Does it mean they don’t keep stocks?
Doesn’t that mean the supply chain disruptions are going to affect them more than Other companies? Or does it mean these guys are extremely efficient?
Thanks in advance.
Great video! Concise and to the point with a visual aid. Awesome! Did you make a video for the income statement and cash flow statement? If so, please share.
I think lots of people would be shocked and amazed if you were to do an analysis of Tesla. 🤣
Thank you for all the knowledge you share, very smart woman, thx again 👍
Thankyou so much Leila, looking forward to cashflow and profit and loss analysis
This is amazing. Please do more of these financial related Excel stuff
Perfect, very simple and objective! Thanks!
Excellent! Please do more videos like this! Thank you.
Thank you so much !! I wish you create a course on Accounting and Finance !!!
I'll think about it. Thanks for the suggestion!
Your analysis is always so spot on and very educative for me. Thanks for sharing these insights
You are so welcome!
Great video as always, Leila! Quick question - For Inventory Days and Receivable Days, why do we take the average of the 2 periods but only used the recent COGS and Sales?
Because inventory and receivables is the value of just one day (the day the balance sheet was created for). COGS and sales is the value for an entire year. So, it's generally recommended to at least take a value from another day into account for the balance sheet items.
@@LeilaGharani got it, thanks for taking the time to reply!
Very helpful . Nicely explain, waiting for more such videos related to financial statements analysis
Awesome insight @Leila, thanks for doing this.
Thank you leila. can you share the excel sheet too?
More finance videos like this please
Will do :)
Leila -- That was outstanding!
Thank you!
Thanks for this …really helpful ..please keep sharing many more like this
Do you have some examples of rapport of financial analysis? I want to improve my vocabulary ( how to write a rapport) .
Thank you in advance.
Leila, another well delivered tutorial, thank you. May I suggest content for another tutorial? I'd like to know if and how I can apply standard formatting (font, font size, paragraph alignment, and line spacing, etc) to all MS Word docs on my hard drive without having to open each file individually and apply the desired formatting. It would also be good to add in a command that converted older file formats, such as Word 97-2003, to the latest format without having to open and save each file in the new version. Thank you.
Please do a video on Income Statement and Cash Flow!!! Plssss
Outstanding job on the topic, very insightful.
Hello Mam,
Good to see you, I have learned many more from your videos. Whenever I see your videos must learn anything.
Please tell me which Office you have and use???
Office 365
Office 2021
Office 2016
and also tell me which office you recommend ??
Thank you. I use Office 365 and I recommend Office 365 (professional / enterprise) version.
@@LeilaGharani OKay Mam, Thank you So much for your Response. Mam Can we gat office 365 Free ?? If Yes, then Mam must make a video on it Please...
Thank you.
You can use it for free on the web: th-cam.com/video/p9FtLTCyFi0/w-d-xo.html
Excellent video, congratulation for this amazing class! I'll follow your teaching way and repass them to my students in Brazil. Thank you!
Outstanding insights leila.Amazing
Fantastic video. I learned quite a bit. Thank you
More content like this please! 🙏🏼🙏🏼
👍
If you make a complete course on financial statement, I'll buy it!
Thank for your wonderful information
It would be great if you can provide regards to Income statement review
Great 👌
The way in which you discuss the ratios are also awesome.
Wowww that was just beautifully done as usually. Please if you can make a series of this, I am sure it will be so helpful.
Thanks, Joseph! I'll see what I can come up with :)
Hi, your Excel tutorials are very informative. Please make more videos on that.
From, India (BHARAT)
Helpful video ma’am 👍🏻keep sharing such content
Thank you, will do!
Hi, how do you do to show the tags with formulas? Thanks!
This is so useful, thanks!
Thank you for such a wonderful explanation
Can you do a Disney one? Loveee how you explain, it’s so easy to understand
Great video, thank you Leila.
Hi Ms Leila, i hope you can help in ecxluding cell when printing
Thank you that was very insightful.
Hi Leila, how reliable is to compare inventory and payable days between different companies? Do specific rules exist to calculate the cost of sales for listed companies?
I worked for a short time in finance for a non listed company and depending what you consider cost of sales, the ratios could change a lot.
I would also love to see a videos on home budgeting and open source applications that that we would use
Thank you so much 💓
I hope you make more videos like this
Thank you Leila, always on point!
Thx Leila. This video is amazing!
This is so good as a layman like me can also understand. Great video ever seen