Practical Management Learned Through Excel! A-Z (Part-II)

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 business administration. I will provide a very practical and immediate approach to help with cost, management, accounting, financial business planning, 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 feasibility 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.

This lecture was produced as a lecture video by organizing the necessary parts for business operation or company work into Excel data. It will probably be a necessary data package for those who are working or small and medium-sized business managers.

Because there is a lot of material and lectures, I divided it into two parts.

It consists of Part-I & Part-II of Practical Management Learning with Excel.

***** Practical Management Learning with Excel Part-I ******

This lecture is divided into three parts.

One free video is provided for each part. Please be sure to check the free video before purchasing.

I. Understanding Business Processes through Accounting

1. Process-1 (Purchase of raw materials > Manufacturing > Sales)

- Purchase of raw materials > Input of raw materials > Input of processing cost > Cost → Input of work-in-process > Product completion > Product shipment > Sales billing processing > Accounts receivable collection > Sales and administrative expenses incurred

Through the above business, we will explain how the manufacturing cost flow, consolidated balance sheet, income statement, and financial statements are created.

2. Process-2 (Additional equipment purchase, interest expense, corporate tax)

3. Process-3 (Startup, Add Dividend)

4. Process-4 (Inventory, Receivables, etc.) : Inventory Asset Receipts and Payments Statement

Many employees only know about the work they do at their company.

If you understand how the entire company process flows through this Excel data and lecture, your perspective on future company life will greatly broaden.

We especially help people in non-accounting positions such as sales, logistics, and production management develop a holistic perspective.

II. Management Analysis

We provide explanations and Excel templates of various management methods required for practical business operations.

If you use the Excel template according to the buyer's company, you can easily improve the company's management level.

1. Break-even point analysis (BEP analysis)

2. Financial ratio analysis

3. Manufacturing cost analysis: Variable cost analysis (quantity difference, unit difference, unit price difference)

4. Analysis of unit processing cost

Because there is a lot of material and lectures, I divided it into two parts.

Below is the content of the Part II product, Practical Management Learning with Excel.

***** Practical Management Learning with Excel Part-II ******

5. Auxiliary sector cost calculation

6. Expense distribution and processing costs by product

7. Cost reduction indicators and performance aggregation

8. Inventory management and inventory evaluation

III. Management Decision Making

We will explain the management approach to decision making that needs to be done while running a business. Again, you can easily use the video and the Excel template provided to apply it to your company right away.

By purchasing this set of materials, your management know-how will be upgraded to the next level. I highly recommend this as a must-have for financial managers such as CFOs and management team leaders.

1. Investment feasibility analysis

2. Estimation of cost of equity capital and weighted average cost of capital

3. Corporate Value Evaluation

4. Price-earnings ratio (PER), price-book ratio (PBR)

5. Make or Buy (In-house production or outsourcing)

6. Sell or Not (Sell or Not?)