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: November 30, 2020.

Good for you if you use or plan to use spreadsheet software like Excel for financial analysis, and modelling; want to understand the concept of liquidity and firm performance; are a (personal/business) financial decision maker needing to learn financial statement analysis; calculate financial ratios but do not know how to create an Excel model of those calculations or how to interpret those; are planning for being a professional financial analyst; are a manager, investor, creditor, supplier, regulator, or any other stakeholder of a business organization.

THIS COURSE IS THE PERFECT ONE FOR YOU TO START.

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.