강의

멘토링

커뮤니티

Business & Marketing

/

Management

Financial Ratio Analysis Using Excel (Including Charts)!!

This video explains how to practically use Excel to analyze financial ratios. An Excel template used in the lecture is provided.

7 learners are taking this course

  • dymanagementlab
재무
Accounting
Financial Management
CFO

What you will gain after the course

  • Financial Ratio Analysis

  • Financial analysis

DY Management Research Institute

(Director Ryu Dae-young, Ph.D. in Business Administration/Management Consultant (Finance))

I am Ryu Daeyoung, who operates 'DY Management Research Institute' on YouTube and Naver Blog.

Based on my company experience and business administration studies, I want to help those working in related fields. I provide a very practical approach that can immediately help with cost accounting, management, accounting, finance, business planning, investment attraction, and overall management. If you want to collaborate on the courses I've uploaded or in my areas of expertise, please contact me via email!


※ Areas of Expertise:

  • Management/cost consulting, business feasibility review, financial business plan development, management simulation, financial projection development for investment attraction.

  • Excel practical training, Excel data visualization, work efficiency improvement using Excel. We'll cut your work time in half.

  • I welcome lecture requests, work requests, and Q&A related to specialized fields and YouTube videos.




Financial Ratio Analysis Using Excel (Including Charts)


This is a video analyzing company financial ratios. We provide the Excel template used in the video along with the video.

Once the financial statements (income statement, balance sheet) are organized, the Excel template automatically conducts ratio analysis from the perspectives of growth, stability, profitability, and efficiency using the revenue data.


The ratio analysis from four perspectives is as follows.


- Growth Potential :

Revenue growth rate, total asset growth rate, tangible asset growth rate, equity growth rate


- Stability :

Current ratio, debt ratio, borrowing dependency


- Profitability :

Net profit margin, Operating profit margin, Gross profit margin, Return on assets, Return on equity


- Efficiency:

Total Asset Turnover Ratio, Inventory Turnover Ratio, Accounts Receivable Turnover Ratio


Not only quantitative ratio analysis, but also the ratio analysis results are converted into points to visualize the degree of improvement compared to our company's past performance through charts. Comparisons between our company and competitors are also visualized through charts.


If you have a basic Excel template, even finance beginners can follow along without difficulty.

I'm providing you with the template and instructional video link. If you follow along with the video, you should be able to do it easily.














Recommended for
these people

Who is this course right for?

  • Finance Department

  • Management and Administration Department

  • Accounting Department

Need to know before starting?

  • Accounting Basics

Hello
This is

142

Learners

16

Reviews

5

Answers

4.7

Rating

16

Courses

유튜브와 N블로그에서 'DY경영연구소'를 운영하고 있는 류대영입니다.

제가 회사에서 경험한 것과 공부한 것을 바탕으로 관련 실무하시는 분들께 도움을 드리고자 합니다. 원가, 관리, 회계, 재무 사업계획, 투자유치, 경영 전반에 걸쳐 굉장히 실무적으로 바로 도움드릴 수 있는 접근을 해드립니다.

 

  • 유튜브 DY경영연구소 : www.youtube.com/@dy-4714

  • 네이버블로그 DY경영연구소 : https://blog.naver.com/udae025

 

※ 전문분야 :

  • 경영/원가컨설팅, 사업성검토, 재무 사업계획 수립, 경영 시뮬레이션, 투자유치 위한 재무프로젝션 수립.

  • 엑셀 실무교육, 엑셀 활용 데이터 시각화, 엑셀을 활용한 업무효율화. 작업시간을 반으로 줄여드립니다.

  • 전문분야 및 유튜브 영상 관련하여 강의/.작업요청/Q&A환영합니다.

 

Curriculum

All

3 lectures ∙ (26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

$17.60

dymanagementlab's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!