Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Ratios Using Excel
Start Here
Introduction to the Course (2:26)
The Basics of Excel
The Excel Interface (3:48)
Working within the Worksheet (Part 1) (4:44)
Working within the Worksheet (Part 2) (3:23)
Basic Formulas (2:51)
Basic Charts (4:09)
Overview of the Financial Ratios
Retrieving Financial Statements (7:15)
Financial Ratios Overview (1:38)
Liquidity Ratios
Current Ratio (2:37)
Quick Ratio (3:02)
Efficiency Ratios
Accounts Receivable Turnover (2:01)
Average Collection Period (1:39)
Fixed Asset Turnover Ratio (2:01)
Total Asset Turnover Ratio (1:40)
Inventory Turnover Ratio (1:49)
Leverage Ratios
Total Debt Ratio (1:29)
Long-Term Debt Ratio (0:51)
Debt to Equity Ratio (0:48)
Long-Term Debt to Equity Ratio (0:29)
Coverage Ratios
Cash Coverage Ratio (1:24)
Times Interest Ratio (2:08)
Profitability Ratios
Gross Profit Margin Ratio (1:05)
Operating Profit Margin Ratio (0:50)
Net Profit Margin Ratio (0:59)
Return on Assets (0:56)
Return on Equity (0:52)
Summary of the Financial Ratios
Ratio Analysis Summary (4:13)
Analysis of the Cash Flows
Cash Flows Analysis (2:07)
Conclusion
Conclusion and Thank You! (1:22)
Total Debt Ratio
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock