Last version published: 09/12/2019 09:52
Publication number: ELQ-43059-3
View all versions & Certificate
Sensitivity and Scenario Analysis Excel Template with VBA
This workbook and this manual are designed to help you build a sensitivity analysis into your models using VBA.
FinExMod offers you this Best Practice for free!
download for free
Add to bookmarks
To easily integrate sensitivity and scenario analysis in financial models
You have a financial model and you want to include a sheet dedicated to sensitivity and scenario analysis
You want the model to automatically run sensitivities by pressing a button
You need to run another macro while running sensitivities
Write a review
People using this Best Practice also downloaded
Financial Model Detective Book: Hints and Tricks on how to Review Project Finance modelsThis book describes how to carry out a financial model review in a systematic and methodical way.149add_shopping_cart$29.99by FinExMod
Sensitivity Analysis Template Using Data TableThis workbook and this manual are designed to help you build a sensitivity analysis into your models.256add_shopping_cart
Building Integrity Checks in Project Finance Models (Manual & Template)This is a spreadsheet that can be integrated in any project finance model. It contains most comment integrity checks.246add_shopping_cart
Q&A Tracking Sheet for a Financial Model (Excel)This is sheet can be inserted with the financial model to keep track of Q&As on the financial model.363add_shopping_cart
Financial Model audit check list - spreadsheetThis is an audit or productivity tool that you can use while reviewing someone else’s models.1,498add_shopping_cart
Timing Flags and Master sheet in a Project Finance ModelContains necessary flags, counters and switches to build in flexibility in your project finance models197add_shopping_cart
Financial Model Version TrackerFinancial model tracker is a tool enables you to keep a track of the changes through multiple versions99add_shopping_cart
Typical Cash Flow Waterfall (Excel Template and PDF manual)Contains a typical cash flow waterfall and covers the concept of cash flow waterfall28add_shopping_cart
Any questions on Sensitivity And Scenario Analysis Excel Template With VBA?
The user community and author are here to help. Go ahead!