Advanced Project Finance Modelling provides participants with the ability to understand project finance theory through creating and understanding project finance models.
Advanced elements of the course focus on sculpting with debit fees, taxes, balloon repayments and DSRA’s as well as resolving circularity using functions rather than copy and paste macros.
The general idea is that through building models in a hands-on environment, you will be better able to quantify risks of different types of projects and you will be able to use models to design the best debt, equity and contractual structure to build models.
The course is designed so that participants can build and interpret flexible models with useful summary statistics; so that model will be accurate with effective error checks that verify the model.
Attendees understand and program structured models that incorporate multiple cash flow waterfalls, alternative funding cascades, and sculpted repayment techniques; and so that models will be transparent and transparent to understand by users.
The course includes different kinds of risk analysis and presentation of summary statistics. Additionally, attendees learn how to use advanced techniques to resolve circular references associated with the funding of a project and debt sculpting that use VBA functions rather than macros.
Extend your project finance modeling knowledge, and learn to master debt modeling, reserve accounts and advanced modeling techniques that put you in control of the transaction.
Advanced Project Finance Modelling enables you to extend your debt modeling capabilities in order to drive the transaction process.
Bankers, sponsors, and investors all benefit from the powerful techniques for debt sizing, covenant monitoring and development of financial statements.
This Masterclass in Project Finance Modelling is aimed at financial analysts seeking a best practice approach to building a project finance model.
You might be interested in other Project Management programs as a next step.
YOU WILL LEARN HOW TO
This three-day advanced course in Project Finance Modelling enables you to extend your debt modeling capabilities to drive the transaction process.
Key benefits:
Understand project finance models in the context of finance theory related to mental issues associated with contract structuring, debt sizing, debt funding, debt repayment, debt servicing costs and credit enhancements.
Interpret models developed by other people and add master scenario pages to any model using case studies of actual models.
Create flexible models with useful summary statistics to evaluate alternative timing, operating assumptions, financial structures, re-financing and contract pricing.
Work through the challenging problems in project finance modeling including:
– Elaborate cash flow waterfalls with balloon payments and mini-perm structure
– Sizing of debt with capitalized interest and alternative drawdown schedule
– Flexible debt sculpting with income taxes
– Sizing of debt service reserves and use of DSRA in waterfall
– Re-financing of debt and mini-perm debt
– Debt service reverses that look ahead to future years
Understand the benefits of creating user-defined functions rather than copy and paste macros to resolve any circular reference problems in project finance models including funding problems and debt sculpting
Incorporate structural enhancements into models such as maintenance reserve accounts and gain insight into the costs and benefits of the alternative features such as cash flow sweeps, covenants, and debt service reserve accounts
Learn Excel techniques with some VBA to make better presentations from models and to make models more transparent and efficient
IMPORTANT COURSE INFORMATION
Participants who fully attend this course and complete the test on the last day will receive a Strategic Axis Professional Certificate (SAPC). SAPC certificates are regionally recognized and can be quite valuable when applying for more senior roles within the organization or outside.
Additionally, participants will receive Microsoft Certificate in Excel.
COURSE OUTLINE