Financial Analysis in Excel: Liquidity Ratios
4.3 (5 ratings)
29 students enrolled

# Financial Analysis in Excel: Liquidity Ratios

Learn Excel modelling to analyze financial statements for a comprehensive assessment of a firm's liquidity performance
4.3 (5 ratings)
29 students enrolled
Created by Md Mohan Uddin
Last updated 10/2019
English
English [Auto-generated]
Current price: \$13.99 Original price: \$19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 36 mins on-demand video
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

What you'll learn
• Explain different liquidity ratios
• Mathematical definitions of the liquidity ratios
• Calculate the liquidity ratios in Excel using publicly available financial statements
• Interpret the liquidity ratios of a firm
• Assess a firm's liquidity performance over time and in comparison to cross-sectional standards
Requirements
• Ability to use internet and computer
Description

Financial Analysis in Excel: Liquidity Ratios

Learn Excel modelling to analyze financial statements for a comprehensive assessment of a firm's liquidity performance

Last Update: October 24, 2019.

> Do you use or plan to use spreadsheet software like Excel for financial analysis, modelling, and valuation?

> Do you have issues in understanding the concept of liquidity and firm performance?

> Are you a (personal/business) financial decision maker who needs to learn financial statement analysis?

> Do you calculate financial ratios but do not know how to create a model of those calculations in Excel?

> Do you calculate financial ratios but do not know how to interpret those?

> Are you planning for being a professional financial analyst like CFA in the area of Finance?

> Are you a manager, investor, creditor, supplier, regulator, or any other stakeholder of a business organization?

If your answer is 'YES' to any one of the above questions, THIS COURSE IS THE PERFECT ONE FOR YOU TO START WITH...

What you'll learn:

1. Explain different liquidity ratios

2. Mathematical definition of the liquidity ratios

3. Calculate the liquidity ratios in Excel using publicly available financial statements

4. Interpret the liquidity ratios of a firm

5. Assess a firm's liquidity performance over time and in comparison to cross-sectional standards

This course consists of several video lectures that will be updated over time and based on students' requests, quizzes at the end of every section for testing your level of understanding, and additional resources. The lectures contain explanations of necessary concepts along with examples and illustrations.

The instructor welcomes his students for continuous discussion with him. Any sort of input for improving the course is also appreciated. He also expects your positive and genuine review and rating of the course.

Who this course is for:
• Beginners interested to learn financial and performance analysis in Excel or other spreadsheet software
Course content
Expand all 9 lectures 36:19
+ Introduction
2 lectures 15:16

Overall Introduction to the course.

Preview 02:31

Liquidity is one of the several dimensions of firm performance. This lecture defines and explains the concept of liquidity and discusses the significance of assessing liquidity performance in from the perspective of internal management, creditor, supplier, customer, and investor.

Liquidity and the significance of liquidity performance
12:45
+ Getting the Excel workbook ready
2 lectures 07:49

The financial statements are freely available in the US Securities and Exchange Commission EDGAR database. After completing this lecture students will be able to download the annual report of the firm to be analyzed. The annual report contains the financial statements and other financial information that would be needed for the analysis.

05:01

The downloaded Excel file contains much information about the company in many worksheets. After completing this lecture, students will be able to extract only the needed financial statements in a working Excel workbook. This is useful to save the analyst from information overload.

Preview 02:48
+ Current Ratio / Working Capital Ratio
1 lecture 02:36

Current ratio, also called working capital ratio is one of the most used liquidity ratios for the general assessment of the liquidity performance of a firm. After completing this lecture students should be able to calculate current ratio of a firm from it's financial statement data in Excel spreadsheet by linking the appropriate cell in the appropriate Excel formula.

Calculating current ratio / working capital ratio in Excel
02:36
+ Quick Ratio / Acid-Test Ratio
1 lecture 01:43

Quick Ratio, also called Acid-Test Ratio, is one of the most used liquidity ratios for the assessment of the liquidity performance of a firm. After completing this lecture students should be able to calculate Quick Ratio of a firm from it's financial statement data in Excel spreadsheet by linking the appropriate cell in the appropriate Excel formula.

Calculating Quick Ratio / Acid-Test Ratio in Excel
01:43
+ Cash Ratio / Absolute Liquidity Ratio
1 lecture 01:29

Cash Ratio, also called Absolute Liquidity Ratio, is the strictest liquidity ratio for the assessment of the liquidity performance of a firm. After completing this lecture students should be able to calculate Cash Ratio of a firm from it's financial statement data in Excel spreadsheet by linking the appropriate cells in the appropriate Excel formula.

Calculating Cash Ratio / Absolute Liquidity Ratio in Excel
01:29
+ Operating Cash Flow Ratio
1 lecture 02:46

Operating Cash Flow Ratio is another liquidity ratio for the assessment of the liquidity performance of a firm. After completing this lecture students should be able to calculate Operating Cash Flow Ratio of a firm from it's financial statement data in Excel spreadsheet by linking the appropriate cells in the appropriate Excel formula.

Calculating Operating Cash Flow Ratio in Excel
02:46
+ Defensive Interval Ratio
1 lecture 04:40

Defensive Interval Ratio is another liquidity ratio for the assessment of the liquidity performance of a firm. After completing this lecture students should be able to calculate Defensive Interval Ratio of a firm from it's financial statement data in Excel spreadsheet by linking the appropriate cells in the appropriate Excel formula.

Calculating Defensive Interval Ratio in Excel
04:40