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.

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 Best Practice includes
7 Excel Models

Prof. Ed Bodmer offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices 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!


4.9 / 5 (27 votes)

please wait...