|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
|
| Training Providers
| Regions
| Training Search
| Advertise Training Seminars
| Login
|
|||||||||||||||||
Training Provided by Navigator Project FinanceIf you can build a basic model but still find yourself wanting to learn more in order to deliver peak performance, you should participate in the Debt Modelling Masterclass. This course builds on the key concepts obtained in the Project Finance Modelling course.The course includes critical components of the debt section of a project finance model * increased optionality in debt repayment methods * Debt service reserve accounts (DSRA) * 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 * Calculating Interest on an Average Balance without a circular reference and without Visual Basic * Principal Sculpting Algebraic solution of repayment for a constant / target DSCR (without Visual Basic) * Principal Sculpting - Building a Graphical User Interface to control sculpted principal repayment * Establishing efficient mechanics for debt focused cash sweep payback calculations without complicating Debt Accounts mechanics * Discussion on commonly documented Pre-Payment methods using Inverse Order of Maturity and Pro Rata repayment 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 two General Discussion on the practicalities and pitfalls of advanced debt modelling Advanced Cashflow Modelling * Straight line depreciation without using matrices keep your audit costs low * Using a 1D Data to value the IRR and NPV benefits of the Interest Tax shield * 2D Data Table and project finance applications get a head start in negotiations * Create Cashflows for each Scenario so they are live all of the time, without Visual Basic. Equity & Project Returns * Group NPVs in 0-5 years, 6-10 years, etc * Cumulative IRRs/NPVs * Multiple IRR problem - discussion of possible and practical solutions Advanced Graphing * Dynamic highlights of minimum/maximum in a graph * Setting up a default chart/library of charts * Custom symbols for professionally designed graphs Finishing Touches * Professional Level Integrity Checks * Is it possible to create Data Tables with off-sheet references? We show you how it can be done. * Custom symbols for professionally designed graphs Training Avaliability and Delivery
Related Keywords: debt service reserve account project finance modelling cash sweep data tables pre payments refianince annuity cfads llcr copy paste macro principal sculpting 2d data tables cashflow scenarios About Navigator Project Finance - Training Provider
Navigator Project Finance - Navigator Project Finance : Financial Modelling for Intelligent Teams
Navigator is the market-leading supplier of global project finance modelling solutions:
* bespoke financial modelling
* comprehensive training courses
* independent model reviews
* consulting services
Navigator understands every stage of the global project finance process and have a methodology proven by...
More Training from Navigator Project Finance | |||||||||||||||||
Custom Search
| |||||||||||||||||
| Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 07/22/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|
| Are you a Debt service reserve account training provider? |
| You could be on this page today - for FREE! |
