Excel工作表中线性财务预测模型的创建与应用

In Excel Work Sheet Linear Finance Forecast Model Foundation and Application

根据销售预测结果,利用历史资料和Excel中回归分析函数Linest创建财务预测模型,可以确定企业未来的外部融资需求。本文介绍了这种模型的创建与应用。

According to sales forecast result, Using historical material and Excel regression analysis of the function of Linest foundation finance forecast model, might determine the enterprise future exterior financing demand. This article introduced this kind of model foundation and the application,