SkillShare – Financial Ratio Analysis using Microsoft Excel-SkilledHares
English | Size: 585.42 MB
Category: Business
In this class, you will learn how to extract useful meaning and insights from a company’s financial statements. After all, financial reporting is just a bunch of numbers if you can’t find those valuable insights to make the best decisions for your organization.
Building on a basic knowledge of the four main financial statements – the balance sheet, income statement, cash flow statement, and statement of owners’ equity – this class will show you how to pull specific data from those documents to derive informative ratios.
For instance, by dividing the "Cost of Goods Sold" found on an income statement by the "Average Inventory" found on a balance sheet, you can derive the "Inventory Turnover Ratio". This ratio tells you how many times per year your total inventory is sold to your customer in the form of products. A high ratio indicates an efficient use of your inventory. A low ratio indicates potential problems like obsolescence, slow moving inventory, over-buying, etc.
Calculating these financial ratios and using them to compare one company to another, or one year to the previous year, is a remarkably effective way to diagnosis the strengths and weaknesses of a company.
Lastly, you don’t have to be a financial wizard to take this class or to use financial ratios in a useful way at your organization. The material in this class is accessible to someone with a basic understanding of accounting, yet what you learn will benefit you regardless of your title. Business owners, department managers, project engineers, administrators, personal investors, educators and a host of of career professionals will gain in this class skills that will help advance their careers.
Leave a Reply