Financial Ratios Using Excel

Learn the basics of financial ratios in about 30 minutes.

What you'll 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

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 preferencesUse the cells easily and understand the basic functionsKnow how to use the basic formulasKnow how to insert and use charts and spark linesRetrieve financial statements of various companiesUse the liquidity, efficiency, leverage, coverage, and profitability ratiosPerform analysis of a cash flows statementAble 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!


Overview

Section 1: Prepare for the course

Lecture 1 Introduction

Section 2: The Basics of Excel

Lecture 2 The Excel Interface

Lecture 3 Working within the Worksheet - Part 1

Lecture 4 Working within the Worksheet - Part 2

Lecture 5 Basic Formulas

Lecture 6 Basic Charts

Section 3: Overview of the Financial Ratios

Lecture 7 Retrieving Financial Statements

Lecture 8 Financial Ratios Overview

Section 4: Liquidity Ratios

Lecture 9 Current Ratio

Lecture 10 Quick Ratio

Section 5: Efficiency Ratios

Lecture 11 Accounts Receivable Turnover

Lecture 12 Average Collection Period

Lecture 13 Fixed Asset Turnover Ratio

Lecture 14 Total Asset Turnover Ratio

Lecture 15 Inventory Turnover Ratio

Section 6: Leverage Ratios

Lecture 16 Total Debt Ratio

Lecture 17 Long-Term Debt Ratio

Lecture 18 Debt to Equity Ratio

Lecture 19 Long-Term Debt to Equity Ratio

Section 7: Coverage Ratios

Lecture 20 Cash Coverage Ratio

Lecture 21 Times Interest Ratio

Section 8: Profitability Ratios

Lecture 22 Gross Profit Margin Ratio

Lecture 23 Operating Profit Margin Ratio

Lecture 24 Net Profit Margin Ratio

Lecture 25 Return on Assets

Lecture 26 Return on Equity

Section 9: Summary of the Financial Ratios

Lecture 27 Ratio analysis summary

Section 10: Analysis of the Cash Flows

Lecture 28 Cash Flows Analysis

Section 11: Conclusion

Lecture 29 Conclusion and Thank You!

Everyone is welcome to the course,Beginner Investors,Finance and accounting students