首页 | 本学科首页   官方微博 | 高级检索  
     

Excel在财务预测中的应用
引用本文:吴代文.Excel在财务预测中的应用[J].湖南工业职业技术学院学报,2009,9(5):46-48.
作者姓名:吴代文
作者单位:湖南工业职业技术学院,湖南长沙,410208
摘    要:在企业财务管理工作中,存在着大量的财务预测工作和不确定因素。通过财务预测有助于改善投资决策,提高企业对不确定事件的反应能力,从而减少不利事件出现带来的损失。随着Excel电子表的广泛使用,利用其稳定的性能、强大的功能来解决财务预测的问题则显得十分有效。

关 键 词:电子表格  预测模型  线性回归

Application of Excel in Financial Forecast
WU Dai-wen.Application of Excel in Financial Forecast[J].Journal of Hunan Industry Polytechnic,2009,9(5):46-48.
Authors:WU Dai-wen
Affiliation:WU Dai - wen (Hunan Industry Polytechnic, Changsha 410208, Hunan)
Abstract:According to the history data of financing activities, real condition and demand and future financing activities and achievements of enterprise, the financial forecast makes scientific estimate and measures. It is one of the financial control links. Its major tasks are follows: measuring and calculating various economic effect to provide reliable basis, estimating that development of financial affairs income and expenses to ascertain operation objectives, determining various quota and standard for working out plans, breaking up plan targets. In enterprise financial control job, there are a large amount of uncertain factor and financial forecast job. Investment decision would be improved and the reaction ability to uncertain event would be increased by the financial forecast to decrease the loss. It is effective to use the stable and strong function of Excel to solve the financial forecast problem.
Keywords:Excel  forecast mode  linear regression
本文献已被 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号