Title: To Establish the Profit Sensitivity Analysis Model by Excel
Abstract: Profit is a comprehensive economic indicator of an enterprise,and it reflects the enterprise′s operating results for a period.During the formation of profit,there are many uncertain factors that will have impacts on profit.The effect degree and the sensitivity of profit of each factor are different.The sensitivity analysis is a method that discusses the influence of a single variable,such as price,or combined variable(price,sales are both subject to change) on the profit.In this paper,the influence of each variable factor on profit is discussed with EXCEL analysis tools.Then the profit sensitivity analysis model and dynamic charts are established on this basis.
Publication Year: 2010
Publication Date: 2010-01-01
Language: en
Type: article
Access and Citation
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot