Instructor Led Overview Training Classes in Australia
From Navigator Project Finance
VBA for Financiers


...tly use VBA to build, debug and analyse financial models
Overview of core VBA skills
* The Visual Basic Environment
* Common elements of the VBA syntax
* Generating your own code versus recording a macro
* Programming standards
* Application: Navigating a model using VBA
How to test and debug VBA applications
* Break Points
* Immediate Window
* Watch Window
more...
Debt Modelling Masterclass


...ayment mechanics
Debt Service Reserve Account
* An overview of the elements of the Cashflow Waterfall focus on Seniority and practicality
* How to model Debt Service Reserve
* Accounts - with a focus on transparency
* The impact of including/excluding DSRA/c in the DSCR and LLCR
* Calculating and including the Interest earned on a DSRA/c in the Cashflow Waterfall
Day
more...
