Profit Forecast Model Using Monte Carlo Simulation in Excel

Petru Balogh, Pompiliu Golea and Valentin Inceu
Additional contact information
Petru Balogh: „Dimitrie Cantemir” Christian University
Pompiliu Golea: „Dimitrie Cantemir” Christian University
Valentin Inceu: „Dimitrie Cantemir” Christian University

Romanian Statistical Review, 2013, vol. 61, issue 12, 33-40

Abstract: Profit forecast is very important for any company. The purpose of this study is to provide a method to estimate the profit and the probability of obtaining the expected profit. Monte Carlo methods are stochastic techniques–meaning they are based on the use of random numbers and probability statistics to investigate problems. Monte Carlo simulation furnishes the decision-maker with a range of possible outcomes and the probabilities they will occur for any choice of action. Our example of Monte Carlo simulation in Excel will be a simplified profit forecast model. Each step of the analysis will be described in detail. The input data for the case presented: the number of leads per month, the percentage of leads that result in sales, , the cost of a single lead, the profit per sale and fixed cost, allow obtaining profit and associated probabilities of achieving.

Keywords: Monte Carlo simulation; Probabilities; Profit forecast (search for similar items in EconPapers)
Date: 2013
References: Add references at CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://www.revistadestatistica.ro/wp-content/uploa ... RS_12_2013_A3_en.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:rsr:journl:v:61:y:2013:i:12:p:33-40

Access Statistics for this article

More articles in Romanian Statistical Review from Romanian Statistical Review Contact information at EDIRC.
Bibliographic data for series maintained by Adrian Visoiu ().