Profit Forecast Model Using Monte Carlo Simulation in Excel
Journal Title: Revista Romana de Statistica - Year 2014, Vol 61, Issue 12
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.
Authors and Affiliations
Petru Balogh, Pompiliu Golea, Valentin Inceu
Keywords
Related Articles
- EP ID EP142022
- DOI -
- Views 103
- Downloads 0
The value of agricultural production by development region in 2013
In 2013, agricultural production increased compared to the previous year due to crop production. The agricultural production index in 2013 was 124.5% overall compared to 2012, 138.8% for crop production and 99.7% for ani...
OFFICIAL STATISTICS IN A MODERN SOCIETY
The modern democratic society cannot efficiently and rigorously function in the absence of a solid basis of relevant and reliable statistical data, allowing for an easy and user-friendly access. Representing a “public go...
Romanian Labour Market – Vulnerable persons and vulnerabilities
Romanian economy’s transition process began suddenly and was accompanied by disintegration of former political and economic system. In terms of GDP per capita, Romania has been one of the poorest countries in Central and...
Geodemographic Transformations Of The Rural Area In The Historic Region Of Moldova In Postcommunist Period
This paper examines geodemographic transformations of the rural area in the historic region of Moldova in postcommunism. The population of a territory, with its characteristics (number, natality, mortality, education and...
Suport empiric privind Teoria Cantitativă a banilor: România – un studiu de caz
Teoria cantitativă a banilor este una dintre cele mai importante secţiuni ale teoriei monetare. Cu toate acestea, din ce în ce mai mulţi economişti îi contestă actualmente validitatea. În acest articol vom încerca să ilu...