Instructor Led Analysis Training in New South Wales, Australia

Debt Modelling Masterclass ...* array programming applications * advanced scenario analysis * and many opportunities to discuss advanced topics in financial modelling Day one Review of the Project Finance Modelling course model and its key features and shortcomings. Debt Modelling * Create a Robust Copy & Paste Macro to solve a circular reference due to Interest on an Average Balance *  more...

Project Finance Modelling A ... Efficient to calculate, and capable of rapid sensitivity analysis * Robust and dynamic to survive a transaction * Cost-effective to be a auditeda ™ by an independent third party The Excel Environment * Optimising the a Calculationa ™ settings * Essential Excel shortcuts/ tips and tricks Model Infrastructure * Set-up of the overall infrastructure  more...

International Project Finance ...objectives and risks of key parties * Undertake risk analysis of projects in mining, power, PPP infrastructure and oil & gas * Key sources of funding including Export Credit Agencies / Multilaterals * Analysis of key legal risks in projects * Efficient management of currency, interest rate and commodity price risks * A structured approach to Due Diligence and analysis  more...

VBA for cashflow models ...merical problems and create user friendly and transparent analysis. However if it is not used appropriately it can cause more problems than it solves. Do you need VBA macros in your financial models? This course gives you the skills and confidence to write your own code and expand your analytical skill set beyond the standard Excel functionality. It is targeted at analysts who need to build  more...

Business Case Modelling Using Excel ...gh the most efficient ways of building efficient cashflow analysis models in Excel to answer critical questions, provide what-if analysis and comparison of different scenarios. This course covers a range of situations including expansions, capital investments, acquisitions and contract negotiations and will give you the tools and confidence to build your own models to analyse any business  more...

Data Analysis and Reporting Workshop Many of us struggle to make sense of all the data that is available in this information age. With such a deluge of reports and statistics which dona ™t mean anything or cana ™t be made sense of, ita ™s no wonder that data is often misinterpreted or not communicated at all. This course will help you understand how to a tamea your data and make it work for you! Learn how to  more...