Monte Carlo Simulation for a 3-way financial Excel model.

A full Monte Carlo Excel Simulation Financial Model with dashboards.

Original Tool:  Demo Financial Model (Xero integrated)  by Lance Rubin

cashflow modelingdynamic decision makingfinancial modelingfinancial modellingmodanomodel citiznmonte carlosimulation and scenarios

Description
This is a fully integrated 3-way model to the cloud accounting package called Xero. The model has a simulation dashboard which allows users to set a range between which key assumptions can change or are likely to be.

There is a dropdown box to allow you to chose the particular scenario.

If there is a need to narrow the range simply insert changes to the assumption blocks within the range.

The model has been built on the Modano platform.

See a link to the Future of Financial Modeling and the specific video on this model.

This business tool includes
1. Excel financial model built on Modano, 1 Explanatory Video

Acquire business licence for $35.00

Add to cart

Discuss

Further information

To educate and create awareness of the power of both Modano and Excel to build completely customised simulation scenarios for a range of assumptions.

Predicting cashflow shortages and surpluses for a business.

Understanding valuation and what some of the key factors that can impact it.

Providing advice to a business on potential outcomes and for key decision making

For purposes other than those stated or described in the model.

Reviews

  • No review yet!

Discussion feed for Monte Carlo Simulation For A 3-way Financial Excel Model.

The user community and author are here to help. Go ahead!

  • Jason Burdett MBA MAICD
    Great demonstration of the power of Modano once again Lance, two things a number of the variables used in the Monte Carlo simulation are somewhat correlated ? Does the model allow for this, if not then the model is somewhat compromised with "double-dipping" using the sim. My other question is what distribution is used for the input variables? some of these would suit a Triangular distribution I would have thought ? Thanks again for your contributions and Cheers
    Jason
    2arrow_drop_uparrow_drop_downReply reply
    • Lance Rubin
      Hi Jason, thanks for the 2 great questions. Glad you liked it. You are spot on.

      1) There are variables that are correlated but I chose to keep this simple purely for demonstration purposes. It is of course possible to create customised logic within Modano to enable this to occur if one chooses.

      2) As the video states there is no probability distribution or weighting attached to the variables and yes ordinarily one would, but again this wouldn't be difficult to add, I was merely trying to demonstrate that it is possible to run a simulation within Modano, similar to just normal Excel.

      All the best
      Lance
      1arrow_drop_uparrow_drop_downReply reply
    please wait...