Skip to main content
Hi Mahendra
Please look at this forum question that Michael answered, in terms of using the module mirroring capability in Modano to incorporate multiple scenarios.
https://www.modano.com/forum/not_scenario_modelling_all_cases_visible_results_side_side_base_case_scenario_1_scenario_2
Let me know if you have any further questions.
regards Simon Selkrig
Hi Simon,
Thanks for the response. The module mirroring would replicate the modules and also it will create separate financial statements for each different scenarios.
What I would like to achieve is to create a scenario - like in Project feasibility - Time series assumption sheet. with all assumptions in place by just selecting dropdown of scenarios. we can see the results of simulation (revenue, expense assumptions). I checked all the modules by searching scenario but could not find it.
It would be really great. if you can guide how did you achieve SCENARIOS in Project feasibility - Time series assumption sheet - template
Hi Mahendra,
Here's an example of how you might do it. It's not done in the same way as the time series example from Project Feasibility, but it's still a scalable option in that you can just add a scenario category and drag the formulas to the right.
I'm sure Mike and the team will have better ways to do it, but this is one option we use.
Jun
That's an extremely impressive example model Jun Yan, I'm really impressed with all the cool customizations you've made. Awesome stuff.
Hi Mahendra,
I've attached a very basic example, it's nowhere near as impressive as the example provide by Jun / Ravit Insights above, but it does give you some starting guidance with regards to the incorporation of scenario analysis using a dedicated period titles set to facilitate scalability (i.e. the automated addition of new scenarios).
As evidenced by this thread, there are a huge number of ways you can incorporate scenario analysis into your models, and the best approach in each case really comes down to your requirements.
For project finance modelling, scenarios are fundamental, and most project finance models I've seen/built use a centralized scenario analysis sheet which provides for incremental changes to assumptions throughout the model, usually one for all time series periods for each piece of data - e.g. a % increase or decrease in revenue across all forecast time series periods. This is what I've done in the attached example, albeit very simply. The concept is the same when applied to a much larger number of assumptions.
Another approach altogether, as mentioned above by Simon Selkrig, is using duplicate (or mirrored) modules to create multiple scenarios, which has the benefit of allowing pretty much any assumption in any time series period to be entered for each scenario. But this approach hugely increases the size of your model, and over time we've found many users don't want to run scenarios on every single assumption - i.e. they're often happy to enter an incremental increase or decrease for all forecast time series periods as per the attached example.
The approach provided by Jun / Ravit Insights above is extremely cool in that it incorporates scenario analysis into an output dashboard. This approach doesn't use a time series period titles set, so isn't as easily scaled by the user because it requires them to understand how to fill right (which shouldn't be an issue), but many users love having scenario analysis embedded within dashboards like this so it's definitely a very popular (and impressive approach).
We're in the process of incorporate scenario analysis into our generic module libraries, along with a huge range of other new content. So as long as you're subscribed to the Modano newsletter you'll receive updates as we release new content.
M.
Thanks Mike!
It's not a complete product as it's meant to be an example of the methodology, but yes, the team here spends a decent amount of time trying to find ways to maximise the use of scalability in the package!
Awesome approach, Jun!
I've just realized that we provide another great example of how scalable scenario analysis can be included in a modular workbook in the Project Appraisal premium content add-on. You can preview the example model by clicking here, and here's what it looks like:
This approach supports adding infinite modules into the scenario manager, and separates them cleanly into compactable module components - e.g. Revenue, Salaries & Wages, Core Opex and Capital Expenditure modules in the above example.
We'll be incorporating this functionality into our libraries over the next 6 - 12 months, and use a similar approach in our upcoming project finance content.