Financial Modelling Training Guide DWPF
Financial Modelling Training Guide DW PF DWPF can provide you with tailored financial modelling and project finance training solutions. The suggested course outlines can form the basis to develop and structure tailored training courses to meet your needs. Courses Foundation in Project Finance Modelling Add On: P3/PPP and Infrastructure Projects Advanced Modelling for Project Finance Add On: Renewable Energy Project Modelling Project Finance Modelling Sprint Our courses are set in a small workshop environment and are highly interactive. You will learn to code formulas from scratch and build a cash flow model from the bottom up. Karina Tam Head of Training
FOUNDATION IN PROJECT FINANCE MODELLING This 2-day course is designed for participants who would like to build, review or analyse project finance models. Participants will create a discounted cash flow model from scratch using best practice methodology and along the way, practice powerful Excel techniques and shortcuts. Financial models in the context of project finance Discuss the role of the financial model in a project finance transaction Understand what differentiates a “good” model from a “bad” one Apply industry accepted best practice principles Discuss the 3Fs – foundation, formatting, formula Learn tips and shortcuts to improve efficiency and reduce errors Model development Discuss different debt repayment options and add a switch to allow users to evaluate the repayment methods Incorporate costs of debt including upfront fees and commitment fees Ratios and returns Calculate equity and project returns Perform returns (NPV and IRR) analysis and understand their drivers and pitfalls to different calculation methods Analyse key project finance ratios including DSCR and discuss the requirements from lenders Plan the model layout, structure, flow and periodicity/timing Design a user-friendly input sheet and create drop down lists, data validation and custom formatting Understand the phases of a typical project and create flexible timing and flags Write clear and concise formulas using binary flags, switches, and range names. Discuss the pros and cons of these techniques Learn the common Excel functions and understand when to use them Perform sensitivity analysis and build a powerful scenario manager Create data tables to perform project analysis Introduction to optimising the funding mix using data tables Capital expenditure Reviewing and troubleshooting (optional time permitting) Discuss how to layout construction costs in a transparent and flexible way Add flexible contingency cost calculation Scenario and sensitivity analysis Consider the cash flow drivers and calculate production and revenue Calculate fixed and variable operating costs Understand real vs nominal values and use escalation index Add checks to the model to reduce the risk of errors Where to start reviewing a model and what to look out for How to navigate around a model and interrogate formulas Model circularity - What is it? Why is it not accepted How to eliminate it? Discuss types of Excel errors and how to fix them Use a delta worksheet to analyse changes and spot potential errors Funding the project Charting and presentation (optional time permitting) Operations phase Understand the structure of the cash flow waterfall Discuss typical funding options and drawdown approaches seen in typical transactions Pick up quick charting tips and pointers Create dynamic and flexible charts The models you learn to build on this course are robust, flexible and easy to use FOUNDATION IN PROJECT FINANCE MODELLING
ADVANCED MODELLING FOR PROJECT FINANCE This 2-day course is designed for participants who would like to learn advanced analytical techniques used in the project finance industry. Participants will build upon the Foundation course model and add additional funding sources and covenants. Basic VBA coding will be written from scratch to debt size and prevent model circularities Add additional scenarios and sensitivities Tax, depreciation and financial statements Calculate the optimal debt capacity and optimise the capital structure Introduction to the VBA environment Write basic VBA coding from scratch Grouping asset classes and using a streamlined approach to straight-line depreciation Calculate tax losses and carry-forward tax losses Consider the impact of thin capitalisation rules and apply a typical calculation to the deductibility of the shareholder loan interest Building integrated financial statements and ensuring the balance sheet balances Add lender’s required modelling features Refinancing Build a Debt Service Reserve Account using advanced Excel formulas Discuss the use of other reserve accounts such as maintenance reserve account Understand how circularities can be eliminated Review commonly used project finance ratios Calculate cash sweeps and lock-ups Consider typical refinancing scenarios and discuss case studies of recent transactions Review commonly used Excel formulas for modelling Add a construction delay scenario and review the scenario manager Optimise the funding mix Different funding sources and interest rate swaps Consider the modelling of multiple funding sources and hierarchy Discuss the use of shareholder loan and its impact on shareholder return Add shareholder loan to the model, and calculate rolled up interest and repayments The best practice techniques and tips garnered from the course has helped take financial modelling within our organisation to another level Add refinancing scenarios to the model incorporating refinancing fees Multi-asset and portfolio model techniques Discuss the different approaches to multi-asset and portfolio modelling Learn Excel functions which are useful when creating multi-asset models Use Excel-based case studies to illustrate and apply these modelling techniques Operational and business models (optional time permitting) Consider different model timing including actuals period and business planning period Use Excel-based case studies to illustrate the addition of actual data to a forecast model ADVANCED MODELLING FOR PROJECT FINANCE
P3/PPP AND INFRASTRUCTURE PROJECTS AND RENEWABLE ENERGY PROJECTS In addition to our popular 2-day Foundation and Advanced courses, DWPF can provide you with tailored financial modelling and project finance training solutions with industry specific add on modules. P3/PPP and Infrastructure Projects This one-day course add on is a highly interactive session where participants can further their modelling skills with an infrastructure relevant case study. Consider pre-operational revenues and milestone payments Discuss different funding sources including government funding contributions and subsidies Model availability payments and incorporate lifecycle costs Renewable energy Projects This one-day course add on will boost the renewable energy professional with relevant and industry specific modelling skills. Consider pre-operational revenues and ramp up phase Discuss the modelling and funding requirements of different renewable technologies Understand how to model different pricing regimes including offtake agreements, merchant revenue and contract for difference (CfD) Understand how to interpret a technical report and incorporate relevant extracts into the model including seasonality profiles, yields and degradation sensitivity factors P3/PPP AND INFRASTRUCTURE PROJECTS /RENEWABLE ENERGY PROJECTS
PROJECT FINANCE MODELLING SPRINT This 30-day intensive educational experience blends an online self-study programme, critical livestream classes with professional trainers, as well as homework with graded feedback and Q&A. The full course is broken into two 2-week courses as shown below. Blueprint for Project Finance Advanced Project Finance Pre-learning : Master Excel with Excel DNA - a data backed program for learning formula, tools, and shortcuts to become a bulletproof modeller. Continuing from the Blueprint model, pull together the elements to deliver a bankable financial model. Main learning : Learn essential PF theory, and with an onshore wind farm case study, build from scratch an infrastructure cashflow model. Build from scratch: Timing sheet for flexibility Construction, sources & uses Operations; revenue, opex & escalations Debt: annuity, sculpting, DSCR & LLCR calculations Cashflow Waterfall: calculate CFADS in a waterfall Equity returns & project returns Scenario manager & data table for sensitivity analysis & optimisations Learn how to adapt the wind model for solar project finance, and the key changes to make for infrastructure projects Learn from world class instructors how to build best practice finance models, and apply investment committee style scenario analysis to a project finance model. Learn the relationship between debt sculpting & debt sizing to a Term sheet Write macros to size debt quickly Incorporate a DSRA & discuss a DSRF Bring in and discuss refinancings Add in a shareholder loan / subordinated debt to the financing structure Calculate working capital, corporate tax & depreciation using straight line, reducing balance, or MACRS methodology Bring together a P&L & balance a Balance Sheet And more in the extensions program Learning commitment Learning commitment 4 hours live sessions 11 hours self-study content 4 hours live sessions 8 hours self-study content PROJECT FINANCE MODELLING SPRINT
DWPF GLOBAL COVERAGE NORWAY CANADA UK NETHERLANDS SWEDEN GERMANY POLAND USA IRELAND FRANCE TURKEY SPAIN MOROCCO ITALY MIDDLE EAST ETHIOPIA AUSTRALIA SOUTH AFRICA PROJECTS Healthcare Transport Ports Oil & Gas Water Energy Wind energy Solar Utilities Waste CONTACT Agnes Chan 44 (0) 20 7514 8648 chana@dwpf.com Karina Tam 44 (0) 20 7514 8647 tamk@dwpf.com Social Infrastructure
DWPF can provide you with tailored financial modelling and project finance training solutions. The suggested course outlines can form the basis to develop and structure tailored training courses to meet your needs. Courses Advanced Modelling for Project Finance Foundation in Project Finance Modelling Add On: P3/PPP and Infrastructure Projects .
Financial Statements Modelling www.bestpracticemodelling.com Page 5 of 40 Financial Statements Module Location 1.2. Financial Statements Modelling Overview The modelling of the financial statements components of an entity is a unique area of spreadsheet modelling, because it involves the systematic linking in of information from
FAST Financial Modelling (T101) is a 2-day 'in-person' financial modelling course for people who need to build, modify, or run financial models. It teaches the core financial model design and construction techniques that every modeller should know. It is appropriate to financial modellers in the corporate, business modelling, banking .
Kenny is currently working on the first crowd-sourced "Financial Modelling Handbook" based on the FAST standard. Please join in. ABOUT F1F9 F1F9 provides financial modelling and business forecasting support to blue chip clients and medium-sized corporates. We also teach financial modelling skills to companies around the world.
Preliminary Financial Statements Development 2.1. Important Comment This practical spreadsheet modelling exercise has been constructed by BPM Financial Modelling in order to provide a guide to understanding the development of dynamic, linked three-way financial statements - i.e. Income Statement, Balance Sheet and Cash Flow Statement.
Dynamic and static financial models are mathematical modeling tools. Evaluating the risk of a financial investment is essential for investors. Financial modelling methods are used to conduct investment analysis supporting mining engineers and investors in decision making. In this paper different financial modelling methods are discussed.
and simplified method to describe masonry vaults in global seismic analyses of buildings. Fig. 1 summarizes three different modelling techniques for ma sonry modelling, respectively, mi cro- , macro- and simplified micro modelling. In the case a micro modelling approach is take n, the challenge is to describe the complex behavior of the
Agile Modelling is a concept invented in 1999 by Scott Ambler as a supplement to Extreme Pro-gramming (XP) [Source: Agile Modelling Values]. Strictly defined, Agile Modelling (AM) is a chaordic, practices-based methodology for effective modelling and documentation [Source: Interview with SA by Clay Shannon].
Scrum 1 Agile has become one of the big buzzwords in the software development industry. But what exactly is agile development? Put simply, agile development is a different way of executing software development teams and projects. To understand what is new, let us recap the traditional methods. In conventional software development, the product requirements are finalized before proceeding with .
