利用EXCEL进行财务预测的回归分析

EXCEL for Regression Analysis on Financial Projections

财务预测是财务管理工作中的一项十分重要的工作,对企业投资、预算等决策非常重要。财务预测的回归分析,是利用一系列的历史资料求得各资产负债表项目和销售额的函数关系,据此预测计划销售额与资产、负债数量,然后预测融资需求。利用Excel能够有效地解决财务预测的回归分析的问题。本文以销售额的多元回归分析预测为例来说明Excel在财务预测回归分析中的应用。

Financial projections of financial management is a very important work,to the enterprise investment,the budget decision is very important.Financial projections of regression analysis,by using a series of historical data in each balance sheet items and sales forecast,according to the function relation with the sales plan assets,liabilities,and predict financing needs.Excel can effectively solve financial projections of regression analysis.Based on the multiple regression analysis forecasting sales as an example to illustrate the Excel in financial projections of regression analysis.