The Application of Excel in Financial Statement Analysis — Constructing DuPont Analysis System Model

Abstract

Financial statements are an important part of corporate financial management. Through analysis of corporate financial statements, management can timely identify the strengths and weaknesses of the company and make appropriate financial adjustments in a timely manner. Excel is a powerful tabular analysis tool that sorts, filters, and aggregates large amounts of data, simultaneously. Taking the financial statements of By-Health Co., Ltd as an example, this paper constructs DuPont analysis system through Excel to analyze financial statements and explore the application of Excel in financial statements.

Keywords: DuPont Analysis System, Excel, Financial Statement Analysis

Article Review Status: Published

Pages: 47-55 (Download PDF)

Creative Commons Licence
This work by European American Journals is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License