Financial Ratios Using Excel
4.4 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,241 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial Ratios Using Excel to your Wishlist.

Add to Wishlist

Financial Ratios Using Excel

Learn the basics of financial ratios in about 30 minutes.
4.4 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,241 students enrolled
Created by Stefan Ignatovski
Last updated 7/2017
English
Current price: $12 Original price: $100 Discount: 88% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Describe the Excel Interface
  • Manipulate Worksheets (Spreadsheets)
  • Everything about cells
  • Format the cells
  • Percentages
  • Cell references
  • Charts basics
  • Liquidity Ratios
  • Efficiency Ratios
  • Leverage Ratios
  • Coverage Ratios
  • Profitability Ratios
  • Cash Flows Analysis
View Curriculum
Requirements
  • No previous knowledge is required
  • Bring your positive attitude
  • Have Microsoft Excel installed on your computer
Description

When we are learning something new, we always need to start with the basics.

This course will provide you with the basic skills to calculate and interpret the financial ratios of a company using Excel. After you complete this course you will be able to:

  • Work with multiple spreadsheets and manipulate them for your preferences
  • Use the cells easily and understand the basic functions
  • Know how to use the basic formulas
  • Know how to insert and use charts and spark lines
  • Retrieve financial statements of various companies
  • Use the liquidity, efficiency, leverage, coverage, and profitability ratios
  • Perform analysis of a cash flows statement
  • Able to continue to more advanced Excel and Financial Analysis courses

I encourage you to take notes, and work together with me during the course. This is very important for you to become confident with application of your knowledge. 

I believe that everyone should have the appropriate basic Excel skills and to perform basic financial analysis. 

Once you complete the course, review it so that other students can enjoy it too. Enjoy the course!


Who is the target audience?
  • Everyone is welcome to the course
  • Beginner Investors
  • Finance and accounting students
Compare to Other Financial Analysis Courses
Curriculum For This Course
29 Lectures
01:04:36
+
Prepare for the course
1 Lecture 02:26
+
The Basics of Excel
5 Lectures 18:55


Working within the Worksheet - Part 2
03:23

Basic Formulas
02:51

Basic Charts
04:09
+
Overview of the Financial Ratios
2 Lectures 08:53
Retrieving Financial Statements
07:15

Financial Ratios Overview
01:38
+
Liquidity Ratios
2 Lectures 05:39
Current Ratio
02:37

Quick Ratio
03:02
+
Efficiency Ratios
5 Lectures 09:10
Accounts Receivable Turnover
02:01

Average Collection Period
01:39

Fixed Asset Turnover Ratio
02:01

Total Asset Turnover Ratio
01:40

Inventory Turnover Ratio
01:49
+
Leverage Ratios
4 Lectures 03:37
Total Debt Ratio
01:29

Long-Term Debt Ratio
00:51

Debt to Equity Ratio
00:48

Long-Term Debt to Equity Ratio
00:29
+
Coverage Ratios
2 Lectures 03:32
Cash Coverage Ratio
01:24

Times Interest Ratio
02:08
+
Profitability Ratios
5 Lectures 04:42
Gross Profit Margin Ratio
01:05

Operating Profit Margin Ratio
00:50

Net Profit Margin Ratio
00:59

Return on Assets
00:56

Return on Equity
00:52
+
Summary of the Financial Ratios
1 Lecture 04:13
Ratio analysis summary
04:13
+
Analysis of the Cash Flows
1 Lecture 02:07
Cash Flows Analysis
02:07
1 More Section
About the Instructor
Stefan Ignatovski
4.4 Average rating
555 Reviews
7,186 Students
9 Courses
Helped Over 170,000 Students Worldwide

An Accounting Professor, Investor and Entrepreneur who teaches at multiple colleges in the US, including University of Washington. Stefan has also established multiple companies and invested in multiple start-up companies. Additionally, he is the author of the book "What College Didn't Teach You!". His area of expertise is concentrated in Accounting Forensics, which focuses on financial fraud, creative accounting, and anti-money laundering.

In every course Stefan makes, you will find the difference in teaching. He has his own way of creating interesting videos (less than 5 minutes, of course!) in which you will find everything you need to know about a specific topic. The DIFFERENCE is that his videos are fun to watch and will give you the desired "Aha!" moment. You will never forget the information, since each one is very descriptive. Visit the twitter profile for interesting updates.

Stefan's classes are very dynamic and make you eager to learn!