Financial Ratios Using Excel
4.4 (16 ratings)
1,241 students enrolled
Wishlisted Wishlist

# Financial Ratios Using Excel

Learn the basics of financial ratios in about 30 minutes.
4.4 (16 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
• Access on mobile and TV
• Certificate of Completion

### Training 5 or more people?

What Will I Learn?
• Describe the Excel Interface
• 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
• 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:

• 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
Preview 02:26
+
The Basics of Excel
5 Lectures 18:55
Preview 03:48

Preview 04:44

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