Next step: analyzing the balance sheet in more detail for each line item. See how that works in my balance sheet analysis of Apple: ua-cam.com/video/J_1F8GoLOI8/v-deo.html Want access to the vertical analysis Excel template? Become a channel member: ua-cam.com/channels/QQJnyU8fALcOqqpyyIN4sg.htmljoin
You are most welcome! Enjoy using it. Have a look at the related video on horizontal analysis as well: ua-cam.com/video/8hLjVoKbKZ8/v-deo.html&pp=gAQBiAQB
Hi! Correct, people usually analyze income statement and balance sheet using horizontal and vertical analysis, but not the cash flow statement. Regarding vertical analysis, I would not know what to relate cash flow to. For the balance sheet, you make everything relative to total assets (in other words, total assets = 100%). For the income statement, relative to revenue (revenue = 100%). For cash flow.... I don't know! For horizontal analysis, I could see the use of analyzing CFOA in the cash flow statement horizontally on the aggregated level (so not at the line item level), but not for the other sections.
Next step: analyzing the balance sheet in more detail for each line item. See how that works in my balance sheet analysis of Apple: ua-cam.com/video/J_1F8GoLOI8/v-deo.html
Want access to the vertical analysis Excel template? Become a channel member: ua-cam.com/channels/QQJnyU8fALcOqqpyyIN4sg.htmljoin
Amazing way of explaining. Thank you.
You are most welcome! Enjoy using it. Have a look at the related video on horizontal analysis as well: ua-cam.com/video/8hLjVoKbKZ8/v-deo.html&pp=gAQBiAQB
Great video! Thanks
Glad you liked it! Have a look at the related video on horizontal analysis as well: ua-cam.com/video/8hLjVoKbKZ8/v-deo.html
Too goodd video u make
Thank you so much, Maria!!! 😀 Did you check out the related video on horizontal analysis as well: ua-cam.com/video/8hLjVoKbKZ8/v-deo.html
What about cash flow, there is no video with horizontal and vertical analysis of cash flow 😢
Hi! Correct, people usually analyze income statement and balance sheet using horizontal and vertical analysis, but not the cash flow statement. Regarding vertical analysis, I would not know what to relate cash flow to. For the balance sheet, you make everything relative to total assets (in other words, total assets = 100%). For the income statement, relative to revenue (revenue = 100%). For cash flow.... I don't know! For horizontal analysis, I could see the use of analyzing CFOA in the cash flow statement horizontally on the aggregated level (so not at the line item level), but not for the other sections.
you. are. the. fucking. best. i love you
Nice to hear that! Thank you.
How do I do this without excel?
On a calculator. Gross Profit of 91.4 divided by revenue of 116.6 is 78%. R&D of 35.3 divided by revenue of 116.6 is .... Etcetera.
@@TheFinanceStoryteller I appreciate you for responding to this sir🫡💜