Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
  • Scenario Analysis - Using Macros
Originally published: 30/04/2018 13:26
Publication number: ELQ-62486-1
View all versions & Certificate
certified

Scenario Analysis - Using Macros

Excel Files to show you how to do Scenario Analysis using Macros.

data tablesmacrosscenario analysissolar sensitivity analysistiming in budget model

Description
Scenario analysis is the process of estimating the expected value of a portfolio after a given period of time in the assumption that any changes in the values of the portfolio's securities or key factors take place, such as a change in interest rate. It is commonly used to estimate changes to a portfolio's value response to an unfavourable event. It can be used to determine the worst-case scenario.

The Excel files associated with this tool are the following:

- Solar Sensitivity Analysis
- Timing in Budget Model
- Graphs from Data Tables: uses a macro with a goal seek and a macro table
- Data Tables with Macros and Range Names: shows how to speed up data tables with range names
- Data Tables from Macros: shows how to make a more flexible data table with macros
- Goal Seek and Macro: reviews data tables in the context of structured finance
- One Way Data Tables from Macros: uses a macro to create a one way data table

This business tool includes
7 Excel Models

Prof. Ed Bodmer offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Jiby Pathrose(last updated: 07/12/2018 04:03)
  • Thomas Fang(last updated: 13/11/2018 20:42)
  • Kingsley Valentine Uzogor(last updated: 08/11/2018 02:54)
  • FinExMod(last updated: 24/05/2018 08:01)
    Brilliant tool
    I have been using the scenario analysis sheet across all my models and have received great feedback from my user. You can set it up in couple of easy steps and keep track of different scenarios. I can't believe this is offered for free. Thanks!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Prof. Ed Bodmer

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Scenario Analysis - Using Macros?

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

please wait...