Scenario Analysis Excel Template
Originally published: 17/04/2018 13:08
Publication number: ELQ-49336-1
View all versions & Certificate

Scenario Analysis Excel Template

A tool designed to identify possible future scenarios.

A simple scenario analysis can be managed in a spreadsheet where we can insert data and functions that represent our business model. In the example proposed, the spreadsheet contains the figured for an investment in a business intelligence system for a hotel chain and the cost and returns associated with this investment. In the first tab, the most likely scenario is presented, and with a simple what-if analysis we add a worst-case scenario and a best-case scenario.

This tool is used when organisations wish to identify any possible future scenarios. The methodology that comes with this tool will guide you through scenario analysis by using a worked example to illustrate.

This Best Practice includes
1 Scenario Analysis Excel Template

Alberto Scappini offers you this Best Practice for free!

download for free

Add to bookmarks


4.3 / 5 (24 votes)

please wait...