Excel在财务预测中的应用

Application of Excel in Financial Forecast

在企业财务管理工作中,存在着大量的财务预测工作和不确定因素。通过财务预测有助于改善投资决策,提高企业对不确定事件的反应能力,从而减少不利事件出现带来的损失。随着Excel电子表的广泛使用,利用其稳定的性能、强大的功能来解决财务预测的问题则显得十分有效。

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.