Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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)
    • 023FRAIE Section 01a Course Introduction

      1:37
    • 023FRAIE Section 01b Instructor Introduction

      1:23
    • 023FRAIE Section 01d Introduction To Excel

      7:07
    • 023FRAIE Section 01e Downloading Financials from SEC

      3:35
    • 023FRAIE Section 02a Price Earnings Ratio

      7:35
    • 023FRAIE Section 02b PEG Ratio

      2:29
    • 023FRAIE Section 02c Price to Sales Ratio

      3:24
    • 023FRAIE Section 02d Price to Book Ratio

      1:56
    • 023FRAIE Section 02e Dividend Yield

      4:21
    • 023FRAIE Section 02f Dividend Payout Ratio

      2:37
    • 023FRAIE Section 02g Return on Assets

      3:04
    • 023FRAIE Section 02h Return on Equity

      1:23
    • 023FRAIE Section 02i Profit Margin

      1:47
    • 023FRAIE Section 02j Current Ratio

      2:31
    • 023FRAIE Section 02k Quick Ratio

      1:45
    • 023FRAIE Section 02l Debt to Equity Ratio

      2:51
    • 023FRAIE Section 02m Interest Coverage Ratio

      3:33
    • 023FRAIE Section 02n Asset Turnover Ratio

      2:45
    • 023FRAIE Section 02o Inventory Turnover Ratio

      2:23
    • 023FRAIE Section 03a Course Conclusion

      0:43

About This Class

**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

1

Student

--

Projects

0

Reviews (0)

Chris Benjamin

Instructor, MBA and CFO