DCF (Discounted Cash Flow) Excel Monte Carlo Simulation Model

A simplified DCF (Discounted Cash Flow) Monte Carlo Simulation model in Excel

by Hans Ensing
Managing Director Syleus and Partners

13 reviews428 views|Start the discussion!|Bookmark

Description
Welcome to our simplified DCF Monte Carlo Simulation model.

Syleus and Partners have developed a financial toolbox for excel applications.

This spreadsheet shows the use of our user-defined function FinBoxMonteCarlo.

Through combining all customized financial functions, our toolbox provides any financial expert the right instrument to solve every financial puzzle.
Our used toolbox function in this spreadsheet uses our Monte Carlo function based on a minimum and maximum value with a normal distribution.

Our Beta generator calculates the statistical information that includes minimum, maximum and mean-value of the simulation. Moreover, the full version also reports other statistical information, like standard deviation, heteroscedasticity, media, mode or other statistical information.

A full model will be shortly available and if you are interested you can sign-up for our mailing list.
This demonstration model uses only 5 Monte Carlo variables, but the full version can handle multiple variables. Moreover, our statistical report shows the results of only one output variable, the full addition does not have this limitation.

We have included many other financial customized functions In our Financial toolbox. For example, we have a Monte Carlo Simulator based on a worse, best and mean case generator. All our models are bundled in one application and the financial customized functions are integrated.

This business tool includes
1 Excel spreadsheet