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

Scenario Analysis Excel Template

A tool designed to identify possible future scenarios.

best casefuture scenariosscenario analysisscenariossimulationswhat if analysisworst case

Description
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 business tool includes
1 Scenario Analysis Excel Template

Alberto Scappini offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools from Alberto Scappini

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Scenario Analysis Excel Template?

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

please wait...