Financial Ratio Analysis Using Excel (Including Charts)!!

DY Management Research Institute

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

• YouTube: www.youtube.com/@dy-4714

• N Blog: https://blog.naver.com/udae025

• Email: daeyoung.lyu@gmail.com

This is Daeyoung Ryu, who runs the 'DY Management Research Institute' on YouTube and N Blog.

I would like to help those who are working in related fields based on my experience in the company and what I have studied in management. I will provide you with an approach that can help you in a very practical way, from cost, management, accounting, financial business plan, investment attraction, and overall management. If you would like to collaborate on a lecture I have posted or my area of expertise, please contact me by email!

※ Areas of expertise:

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

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

• We welcome lectures/work requests/Q&As related to specialized fields and YouTube videos.

Financial ratio analysis using Excel (with charts)

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

Once you have organized your financial statements (income statement, balance sheet), the Excel template will automatically perform ratio analysis using revenue in terms of growth, stability, profitability, and efficiency.

The four-faceted ratio analysis is as follows:

- Growth potential :

Sales 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 total assets, return on equity

- Efficiency:

Total asset turnover ratio, inventory turnover ratio, accounts receivable turnover ratio

In addition to quantitative ratio analysis, the results of the ratio analysis are visualized in charts to show the extent of improvement compared to our past performance. Comparisons between our company and competitors are also visualized in charts.

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

I will provide you with a template and a video link showing how to write it. If you follow the video, you will be able to do it easily.