Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Finance & Accounting Money Management Tools Financial Statement

Financial Statement Analysis – Ratio Analysis

Horizontal analysis, vertical analysis, ratio analysis-liquidity & efficiency, solvency, profitability, & market ratios
Rating: 4.4 out of 54.4 (654 ratings)
42,139 students
Created by Robert (Bob) Steele
Last updated 8/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • List and describe the tools for financial statement analysis
  • Understand, calculate, and analyze horizontal analysis
  • Explain, calculate and analyze vertical analysis
  • List and describe the categories of ratio analysis
  • Describe liquidity ratios
  • Examine solvency ratios
  • Explain profitability ratios
  • Discuss market prospects ratios
  • Calculate and analyze current ratio, acid-test ration, and accounts receivable ratio
  • Analyze and compute inventory turnover ratio, days’ sales uncollected, days’ sales in inventory, and total asset turnover
  • Discuss and calculate debt ratio, equity ratio, debt-to-equity ratio, and times interest earned
  • Explain and compute profit margin ratio, gross margin ratio, and return on total assets
  • Describe and calculate return on equity, book value per common share, and earnings per share
  • Calculate and analyze price earnings ratio and dividend yield
  • Discuss and analyze the components of a financial statement analysis report

Requirements

  • Understanding of basic accounting terms

Description

Learn tools to analyze financial statements, including vertical analysis, horizontal analysis, and ratio analysis.

This course will provide resources such as downloadable PDF files and preformatted Excel spreadsheet to help understand and apply the concepts.

We will list and describe the tools for financial statement analysis, including vertical analysis, horizontal analysis, and ratio analysis.

Below is more detail about the concepts we will learn.

This course will help us understand, calculate, and analyze horizontal analysis. Horizontal analysis is used to compare financial data and performance of a company across time and is a common and intuitive form of analysis.

We will explain, calculate, and analyze vertical analysis. Vertical analysis also termed common size financial statements, displays all items as percentages of a common base figure instead of absolute numbers. Vertical analysis is very useful to compare financial statements for companies of different sizes.

The course will list and describe the categories of ratio analysis. Ratio analysis is a common form of financial statement analysis used to obtain a quick indication of a business’s financial performance in different areas. Ratios are often grouped into categories, including liquidity ratios, solvency ratios, profitability ratios, and market prospects ratios.

We will describe liquidity and efficiency ratios. We will list liquidity and efficiency ratios, perform calculations, and analyze their use.

The course will examine solvency ratios, listing solvency ratios, calculating solvency ratios, and analyzing their use.

We will Explain profitability ratios. The course will list profitability ratios. We will perform calculations and analysis of profitability ratios.

We will discuss market prospects ratios, listing out the market prospect ratios, discussing the formulas, and analyzing the use of market prospect ratios.

The course will calculate and analyze current ratios, acid-test ration, and accounts receivable ratios.

We will analyze and compute inventory turnover ratios, days’ sales uncollected, days’ sales in inventory, and total asset turnover.

The course will discuss and calculate the debt ratios, equity ratios, debt-to-equity ratios, and times interest earned.

We will explain and compute the profit margin ratio, gross margin ratio, and return on total assets.

The course will describe and calculate return on equity, book value per common share, and earnings per share.

We will calculate and analyze price earnings ratio and dividend yield.

The course will discuss and analyze the components of a financial statement analysis report. We will explain what software can do for us and what software cannot do.

Who this course is for:

  • Accounting students
  • Business owners & professionals
  • Anyone who whats to learn accounting

Course content

12 sections • 139 lectures • 24h 38m total length

  • Preview08:36
  • Preview00:08
  • Preview13:25
  • PDF - 120 Types of Analysis
    00:08
  • Preview09:18
  • Multiple Choice Question 1 - Financial Statement Analysis
    04:44
  • Accounting Comic Break
    00:15

  • 2 Horizontal Analysis
    00:57
  • PDF - 305 Horizontal Analysis
    00:08
  • 305 Horizontal Analysis
    15:02
  • Excel Worksheet Download
    00:05
  • Worksheet- 305 Horizontal Analysis
    15:23
  • PDF - 310 Trend Analysis
    00:08
  • 310 Trend Analysis
    15:23
  • Excel Worksheet Download
    00:05
  • Worksheet - 310 Trend Percents
    22:03
  • Multiple Choice Question 2 - Financial Statement Analysis
    03:52
  • Accounting Comic Break
    00:16

  • 3 Vertical Analysis Common-Size Statements
    01:14
  • PDF - 355 Vertical Analysis Common-Size Statements
    00:08
  • Preview19:10
  • Excel Worksheet Download
    00:05
  • Worksheet - 355 Vertical Analysis
    27:33
  • Excel Worksheet Download
    00:05
  • Worksheet - 357 Common Size Financial Statements
    17:59
  • Multiple Choice Question 3 - Financial Statement Analysis
    02:51
  • Multiple Choice Question 4 - Financial Statement Analysis
    04:36
  • Discussion Question 1 - Financial Statement Analysis
    1 question
  • Accounting Comic Break
    00:15

  • 4 Liquidity Ratios
    02:05
  • List of Ratios
    00:06
  • PDF - 410 Liquidity Ratios Part 1
    00:08
  • 410 Liquidity Ratios Part 1
    23:15
  • PDF - 415 Liquidity Ratios Part 2
    00:08
  • 415 Liquidity Ratios Part 2
    18:25
  • Excel Worksheet Download
    00:05
  • Worksheet - 410 Liquidity and Efficiency Ratios
    21:58
  • PDF - 420 Current ratio, quick or acid ration, and working capital-Accounting
    00:08
  • 420 Current ratio, quick or acid ration, and working capital-Accounting
    33:32
  • Excel Worksheet Download
    00:05
  • Worksheet - 420.10 Current ratio, quick ratio, acid-test ratio, working capital
    15:06
  • Worksheet - 420.20 Current ratio, quick ratio, acid-test ratio, working capital
    15:11
  • Worksheet - 420.30 Current ratio, quick ratio, acid-test ratio, working capital
    17:47
  • Multiple Choice Question 5 - Financial Statement Analysis
    05:50
  • Multiple Choice Question 6 - Financial Statement Analysis
    04:51
  • Discussion Question 2 - Financial Statement Analysis
    1 question
  • Accounting Comic Break
    00:15

  • 5 Solvency Ratios
    02:19
  • List of Ratios
    00:06
  • PDF - 505 Solvency Ratios
    00:08
  • 505 Solvency Ratios
    13:45
  • Excel Worksheet Download
    00:05
  • Worksheet - 505 Solvency Ratios
    13:18
  • Multiple Choice Question 7 - Financial Statement Analysis
    04:20
  • Multiple Choice Question 8 - Financial Statement Analysis
    05:29
  • Discussion Question 3 - Financial Statement Analysis
    1 question
  • Accounting Comic Break
    00:16

  • 6 Profitability Ratios
    02:14
  • List of Ratios
    00:06
  • PDF - 605 Profitability Ratios
    00:08
  • 605 Profitability Ratios
    13:34
  • Excel Worksheet Download
    00:05
  • Worksheet - 605 Profitability Ratios
    13:31
  • Multiple Choice Question 9 - Financial Statement Analysis
    09:22
  • Multiple Choice Question 10 - Financial Statement Analysis
    05:10
  • Discussion Question 4 - Financial Statement Analysis
    1 question
  • Accounting Comic Break
    00:15

  • 7 Market Prospects Ratios
    02:38
  • List of Ratios
    00:06
  • PDF - 705 Market Prospects Ratios
    00:08
  • 705 Market Prospects Ratios
    11:20
  • Excel Worksheet Download
    00:05
  • Worksheet - 705 Market Prospects
    08:11
  • Multiple Choice Question 11 - Financial Statement Analysis
    05:24
  • Multiple Choice Question 12 - Financial Statement Analysis
    05:00
  • Discussion Question 5 - Financial Statement Analysis
    1 question
  • Accounting Comic Break
    00:15

  • 8 Ratio Analysis Practice Problem
    00:51
  • List of Ratios
    00:06
  • Excel Worksheet Download
    00:05
  • Worksheet = Ration Analysis Practice Problem
    29:50
  • Multiple Choice Question 13 - Financial Statement Analysis
    05:17
  • Multiple Choice Question 14 - Financial Statement Analysis
    09:13
  • Discussion Question 6 - Financial Statement Analysis
    1 question
  • Accounting Comic Break
    00:15

  • 9 Financial Statement Analysis Report
    02:26
  • 902 Financial Analysis Data Online
    04:00
  • 905 Financial Analysis Sample Reports Overview
    16:25
  • 910 Financial Analysis Sample Reports Traditional Performance Evacuation
    03:38
  • 915 Financial Analysis Sample Reports Ratio Analysis Profitability
    05:53
  • 920 Financial Analysis Sample Reports Ratio Analysis Solvency
    02:44
  • 925 Financial Analysis Sample Reports Ratio Analysis Liquidity
    05:58
  • 930 Financial Analysis Sample Reports Recommendations
    06:58
  • 955 Financial Statement Data Online
    05:19
  • Multiple Choice Question 15 - Financial Statement Analysis
    05:44
  • Multiple Choice Question 16 - Financial Statement Analysis
    02:33
  • Accounting Comic Break
    00:16

  • 305 Ratio Analysis Introduction
    23:43
  • 315 DuPont System of Analysis
    26:15

Instructor

Robert (Bob) Steele
CPA, CGMA, M.S. Tax, CPI
Robert (Bob) Steele
  • 4.4 Instructor Rating
  • 16,923 Reviews
  • 352,776 Students
  • 97 Courses

Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.  

Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).  

Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.  

In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele's teaching philosophy is to make content applicable, understandable, and accessible.  

Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.  

Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.  

Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.  

Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.  

The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.  

Mr. Steele makes learning accounting accessible by making use of technology and partnering with teaching platforms that have a vision of spreading knowledge like Udemy.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.