Skip to main content
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.
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.