| 基于EXCEL的财务报表信息分析模型的设计与实现 |
| |
| 引用本文： | 孙楠楠,杨毅.基于EXCEL的财务报表信息分析模型的设计与实现[J].山东商业职业技术学院学报,2010,10(6):27-31. |
| |
| 作者姓名： | 孙楠楠 杨毅 |
| |
| 作者单位： | 山东商业职业技术学院,山东济南250103 |
| |
| 摘 要： | 利用Excel报表模型设计功能,在财务数据输入、数据分析、模型构造的基础上建立完整快捷的信息录入和分析模型。以财务数据输入为起始,在创建Excel模板的基础上建立资产负债表、损益表模型,并分别对资产负债表和损益表进行结构分析和相关财务指标分析,阐述资产负债表模型、损益表模型的设计与实现,并在此基础上进行综合财务分析即杜邦分析,综合资产负债表和损益表数据以及分析指标进行全面的财务分析,以得出综合的财务状况数据以及通过因素分析发现问题所在。
|
| 关 键 词： | Excel 资产负债表模型 损益表模型 杜邦分析 |
The Design and Application of Financial Statements Information Analysis Models under the IT Environment |
| |
| SUN Nan-nan,YANG Yi.The Design and Application of Financial Statements Information Analysis Models under the IT Environment[J].Journal of Shandong Institute of Commerce and Technology,2010,10(6):27-31. |
| |
| Authors: | SUN Nan-nan YANG Yi |
| |
| Institution: | (Shandong Institute of Commerce and Technology,Jinan,Shandong 250103,China) |
| |
| Abstract: | Using the design function of Excel templates and on the basis of financial data entry,data analysis and model structure,this thesis tries to establish complete and rapid model of information input and analysis.Starting with financial data entry and on the basis of establishing Excel model,this thesis establishes Excel templates balance sheet,profit and loss models and analyses the balance sheet and profit and loss account respectively for structural analysis and related financial indicators analysis.On the basis of these,it is a comprehensive financial analysis Dupont analysis,the consolidated balance sheet and profit and loss data as well as analysis of a comprehensive financial analysis of indicators.From this,the integrated financial situation data can be concluded,as well as the problem can be found trough factor analysis.Combining with examples,comprehensive financial analysis can be drawn with this method.Financial data interface software technology is described briefly at last,which is used to solve the problem of various financial data transformation and information exchange between software systems. |
| |
| Keywords: | excel template balance sheet model profit and loss model Dupont Analysis Method |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
