Predicting 5 Years Cash Flow & Operating Profit using Monte-Carlo Simulation

Business has various complexities and dynamics, and these dynamics may have significant impacts on outcome. One cannot predict accurately on these dynamics but certainly and gauge a possible range. If you like to see the results of these ranges either on a random basis on the probability basis, then Monte-Carlo simulation is the Answer. I have developed a financial modeling which will able to predict five-year cash flow and operating Profit based on variables you define. The model will run a 5000 times iteration to simulate a randomized variable based your defined ranges and show the 95th percentile of possible outcome.

Here are some of the Key Assumptions you will have to Input based on your Judgment

Once you fill up all the Key Assumption, play around with different outcome by pressing F9 (Function 9) on your keyboard to run the simulation and look at the Output

Feel free to contact me to understand more about the calculation