运用Excel建立本量利分析模型

Applying Excel to Establish CVP Analysis Model

本量利分析是财务管理中的一项重要内容,本文运用Excel设计出适合单种产品以及多种产品的本量利分析模型,给财务管理教学工作以及本量利分析工作带来便利。

CVP （Cost - Volume - Profit） analysis is an important part in financial management. This paper applied Excel to design the CVP analysis model, which was applicable to single or multiple products and made financial management teaching and CVP analysis easier and more convenient.