Learn Financial Ratio Analysis In Excel - Top 15 Ratios | Chris Benjamin | Skillshare

## Learn Financial Ratio Analysis In Excel - Top 15 Ratios

#### Chris Benjamin, Instructor, MBA and CFO

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
20 Videos (59m)
• Course Introduction

1:37
• Instructor Introduction

1:23
• Introduction To Excel

7:07

3:35
• Price Earnings Ratio

7:35
• PEG Ratio

2:29
• Price to Sales Ratio

3:24
• Price to Book Ratio

1:56
• Dividend Yield

4:21
• Dividend Payout Ratio

2:37
• Return on Assets

3:04
• Return on Equity

1:23
• Profit Margin

1:47
• Current Ratio

2:31
• Quick Ratio

1:45
• Debt to Equity Ratio

2:51
• Interest Coverage Ratio

3:33
• Asset Turnover Ratio

2:45
• Inventory Turnover Ratio

2:23
• Course Conclusion

0:43

**Templates Included!** Learn how to apply financial ratio analysis analytics to ANY companys financial statements

** New Course for 2018! **

Financial analysis can often seem confusing and laborious, BUT it does not have to be at all! Use the knowledge in this course to go from rookie to professional financial analyst.  You'll see it's not difficult at all, and you will have a powerful set of tools now to analyze company financial reports.  Aside from the introduction and conclusion, the course is entirely in Excel.  You will follow along as we download a set of financial results, create a ratio dashboard, and then do our financial analysis.

You will also be able to download the template used in the course which shows exactly what the formulas are for each ratio.

What We Do In The Course:

• Cover the top 15 financial ratios used by professionals to evaluate a companys financial statements
• Demonstrate basic Excel functions so you have the tools to do the calculations (they are NOT difficult at all)
• Show you how to download a companys financial statements directly into Excel from the SEC Website
• Create a dashboard for your financial ratios for easy comparison
• One by one, discuss what the ratio is, what it represents, and where to find the data
• Once the ratio is completed, we discuss what the results mean and how to interpret them
• And Much More!!!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, financial analysis, and Excel.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

10

Students

--

Projects

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int