Yield Curve Simulation Excel Model & Automated Commentary

Description
This model is intended to show the level of automation that is possible (and has been possible for some time) both inside and outside of an Excel model.

The power of Monte Carlo simulation is heavily under utilised and this model will demonstrate how its possible to simulate 1000's of iterations whilst visually seeing the impact of those without a human turning the handle each time.

The level of volatitilty on something like interest rate can then be seen and understood much more clearly whilst also enabling the user not to get too bogged down into the detail of whats going on (unless they want to).

This leverages all the power of Excel, Powerpoint and the presentation skin and then Modeler which connects the 2 applications together to enable visualisation of modeling.

This is part of a broader topic of visual influencing which is now possible to enable better decision making by those that are not highly skilled in Excel or at risk of breaking the Excel model every time they change something.

The abiilty to change live during a meeting will also save time, provide a better and more engaging meeting and provide a way in which decisions can be made collaboratively rather than just by those that control the model (which is often the case).

The visualisation also shows whether there are any issues with the underlying logic or assumptions in the model as its possible to see trends visually and live.

All decisions made can then be emailed immediately during or post the meeting in the form of a pdf with annotation if required.