Financial Ratio Analysis Using Excel (Including Charts)!!

We are conducting a practical Excel course for workplace use. This is a fully hands-on, business-oriented Excel training.

We'll take a very practical and easy approach to cost accounting and management analysis using Excel, which you may have found difficult before. This course covers the following topics: - Cost Accounting from Basics to Practice: Step-by-step learning from cost concepts, standard costs, actual costs, to indirect cost allocation - Understanding Financial Statements and Accounting Flow: From manufacturing cost flow to accounting treatment and financial statement generation process - Strategic Pricing Methods: Pricing strategies by market type and profitability analysis by product - Analyzing Management Indicators with Excel: Break-even point analysis and financial ratio analysis practice - Management Decision-Making Based on Management Accounting: Short-term/long-term business planning and business feasibility analysis practice

We approach cost accounting and management analysis, which you may have found difficult, in a very practical and easy way using Excel. This course covers the following topics: - Cost Calculation from Basics to Practice: Step-by-step learning from cost concepts, standard costs, actual costs, to indirect cost allocation - Understanding Financial Statements and Accounting Flow: From manufacturing cost flow to accounting processing and financial statement creation process - Strategic Pricing Methods: Pricing strategies by market type and profitability analysis by product - Analyzing Management Indicators with Excel: Break-even point analysis and financial ratio analysis practice - Management Decision-Making Based on Management Accounting: Short-term/medium-to-long-term business planning and business feasibility analysis practice

We take a practical and easy approach to cost accounting and business analysis—topics that often feel difficult—by utilizing Excel. This course covers the following topics: - From Cost Accounting Basics to Practice: Step-by-step learning from cost concepts to standard costing, actual costing, and overhead allocation. - Understanding Financial Statements and Accounting Flows: From manufacturing cost flows to accounting treatments and the financial statement preparation process. - Strategic Pricing Methods: Pricing strategies by market type and profitability analysis by product. - Analyzing Business Indicators with Excel: Hands-on practice with break-even point (BEP) analysis and financial ratio analysis. - Management Decision-Making Based on Managerial Accounting: Hands-on practice with short-term/long-term business planning and feasibility analysis.

I will explain how to conduct a break-even point analysis using Excel and financial statements. The Excel template used in the lecture is provided for free.

I will explain how to calculate costs and profit/loss for each menu item in restaurants, cafes, and the food service industry using Excel. I am providing the Excel template explained in the lecture for free.

I will explain how to create a 5-year financial business plan using Excel for startup fundraising and IR pitches. A free Excel template is also provided.

Explaining how to value a company using Excel for startups/venture companies. Providing Excel templates. 5-year financial statement projection → RIM model / EVA model / DCF model valuation

We provide an Excel template and instructional video for calculating product costs for your company. It is ready for immediate practical application.

Many small and medium-sized enterprises may be experiencing difficulties in calculating proposal prices. Understand the proposal price calculation criteria explained in this lecture and use the provided Excel template to easily and accurately calculate the proposal price.

This course covers feasibility (economic) analysis for new business ventures or investments within a corporate setting. I will explain the practical process using Excel and provide actual Excel templates as part of the course materials.

A person with 20 years of experience in business management explains everything from A to Z of practical business management using Excel. We provide videos and Excel templates for business management that can be used immediately in your company. If you use Excel while watching the video, you can immediately use the business management tools necessary for company operation.

A professional with 20 years of experience in business management explains everything from A to Z about practical management using Excel. We provide videos along with business management Excel templates that can be used immediately in the workplace. By using Excel while watching the videos, you can instantly implement the essential management tools required for running a company.

This lecture covers how to conduct external environmental analyses and internal capability analyses to formulate corporate strategies based on the results. It provides a comprehensive overview of various business analysis tools.

I will explain cost concepts in simple terms for those handling cost accounting at work, preparing for a startup, or running a small to medium-sized enterprise.

This course covers feasibility (economic) analysis for new business ventures or investments within a corporate setting. I will explain the practical process using Excel and provide actual Excel templates as part of the course materials.

Many small and medium-sized enterprises may be experiencing difficulties in calculating proposal prices. Understand the proposal price calculation criteria explained in this lecture and use the provided Excel template to easily and accurately calculate the proposal price.

You can acquire methods for evaluating corporate management capability through financial statement analysis, accurately and systematically gain the most fundamental knowledge of corporate finance-related areas, and improve practical financial management skills based on this knowledge. Furthermore, by understanding the key contents of financial statement components and the interrelationships between components, even those who did not major in accounting can easily understand financial statements and utilize them for decision-making.

The content has been structured to help improve job competency by covering the accounting knowledge necessary for work performance, from basic concepts up to the composition stages of financial statements. We have explained double-entry bookkeeping concepts and content related to financial position and business performance by incorporating various practical cases.

A company's management status can change daily due to the recently rapidly evolving economic environment. This course is a practical management analysis training that utilizes financial information, mainly financial statements, along with various internal and external company data, to examine the appropriateness of business activities or evaluate corporate capital. This is valuable for the corporate management strategies of executives and practitioners, as well as for investors to make informed investments.

A bible for entrepreneurs, including startups, IT, and one-person startups. You will be able to acquire core basic knowledge and practical know-how :)

An essential course for future founders & business owners daunted by taxes! It's organized around practical application, from business registration to labor cost processing and VAT filing.

The Level 2 Computerized Accounting Certificate is a certificate that evaluates the ability to use accounting information. This course aims to pass the Level 2 Computerized Accounting Exam using the K-Leap program organized by the Korea Association of Certified Public Accountants. This is a course for accounting beginners that teaches accounting principles and the ability to use the K-Leap program.

The Level 2 Computerized Accounting Certificate is a certificate that evaluates the ability to use accounting information. This course aims to pass the Level 2 Computerized Accounting Exam using the K-Leap program organized by the Korea Association of Certified Public Accountants. This is a course for accounting beginners that teaches accounting principles and the ability to use the K-Leap program.