Channel: Leila Gharani

Category: Education

Tags: excel financial ratiosmicrosoft excel tutorialsbalance sheet analysisaccountingexcel for analystsxelplusvisadvanced excel tricksxelplusapple balance sheetbalance sheet samplesample balance sheetbalance sheet analysis for beginnersbalance sheet tutorialexcel tips and tricksbalance sheetmicrosoft excelleila gharaniexcel 2016excel 2019balance sheet tutorials in accountingmicrosoft 365excel 2013excel online courseexcel 365finance

Description: Get Access to My Course "Fundamentals of Financial Analysis" HERE: courses.xelplus.com/p/financial-analysis Understanding a Balance sheet is not easy. To make it interesting let's check out Apple’s latest financials and I’ll explain how to properly read and analyze a balance sheet in the process. Financial statements can be confusing and intimidating. But balance sheets are crucial to understanding a business and seeing if it's financially strong. In this video you'll learn how to read a balance sheet and how to calculate some important ratios. We'll cover the current ratio, debt ratio, working capital days, and the cash conversion cycle. 🌍 My Online Excel Courses ► xelplus.com/courses 00:00 How to Read and Analyze a Balance Sheet 00:34 10-K and 10-Q Reports 01:13 Assets 03:06 Liabilities 05:23 Equity 07:54 Ratios in Financial Analysis 08:26 Current Ratio 09:49 Debt Ratio 11:20 Inventory Days 12:32 Receivable Days 13:09 Payable Days 13:39 Cash Conversion Cycle 14:19 Summary 🎬 LINKS to related videos: How the Balance Sheet Works: youtu.be/aA8nVYNonV4 Financial Leverage Explained: youtu.be/iWynyGg0TZc 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel #Finance