文档介绍：EXCEL在企业财务管理中的应用
THE APPLICATION OF EXCEL IN CORPORATE FINANCIAL MANAGEMENT
专业:
会计学
姓名:
林志娟
指导教师:
邵雷老师
完成日期:
2013年4月18日
摘要
Excel是一种功能强大的电子表格软件,它能够利用自身的多功能工具将杂乱的数据筛选整理成可用的信息之后进行分析、交流以及分享得到的结果。由于它在数据的处理、统计分析和辅助决策操作方面的作用,所以被广泛地应用于管理、财经、金融等多个领域。熟练掌握运用Excel建立各种财务管理模型的方法,有助于财务管理人员在复杂多变的理财环境中迅速准确地判断,合理地决策,从而高效地开展财务管理工作。
本文通过对前人研究成果的整理、分析,首先详细的介绍了Excel的功能和特性,比如它的强大的表格处理功能、绘图和图形处理功能、函数运算工具等,通过这些功能的介绍我们可以深入的了解Excel的特性;其次我们通过Excel和财务软件的对比来说明Excel在企业财务管理中的必要性和适用性;最后重点说明Excel在企业财务管理中的具体应用,它包括Excel中的数据的分析和处理,数据处理包括排序功能,数据处理则会运用到单变量分析工具和模拟运算表工具;在企业投资决策中的应用,例如利用Excel进行固定资产的折旧;在Excel中运用比率分析法进行财务分析;Excel也能在企业的筹资决策中发挥作用,比如长期借款的还本付息模型、资本成本的计算以及长期筹资决策方法等。
关键词:EXCEL; 投资决策; 财务分析
ABSTRACT
Excel is a powerful spreadsheet software, it can filter mixed data pile to the available information with the use of multifunctional tool, and then analysis,exchange and share the of its function in the data processing, statistical analysis and decision operation, it is widely used in management finance and other in using Excel to create a variety of financial management model, can helps the financial management staff make a quick and accurate determine and then make a rational decision in plex and ever-changing financial environment, so have an efficient conduct of the financial management.
In this paper, through the collation and analysis of the results of previous studies, the first part have a detailed introduction of the functions and features in Excel, such as the powerful forms processing capabilities, drawing and graphics capabilities, function calculation tools, through the introduction of these features we can in-depth understanding of the features of Excel; in the following second part parise the difference of Excel and financial software to illustrate the necessity and applicability of Excel in corporate financial management; and then the third part highlights the specific applications of Excel in corporate financial management, including Exce