Financial Ratio Analysis using Microsoft Excel | Ray Harkins | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# Financial Ratio Analysis using Microsoft Excel

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### Lessons in This Class

17 Lessons (1h 49m)

7:28

4:46

5:34

2:24

8:28

7:43

1:56

7:13

5:35

2:57

8:32

11:38

3:03

12:28

10:00

5:43
• ### 17. F 17 Conclusion to Course

3:07
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

29

Students

--

Projects

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.

### Ray Harkins

Senior manufacturing professional

Teacher

Ray Harkins is a senior manufacturing professional with 25 years experience in manufacturing engineering, quality management, and business analysis.  During his career, he has toured hundreds of manufacturing facilities and worked with leading industry professionals throughout North America and Japan.  He is a senior member of the American Society of Quality, and holds their Quality Engineering, Quality Auditing and Calibration Technician certifications.  Ray has written extensively for national trade publications on the topics of quality engineering and career management.

See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects