Excel Blackbelt: New versions of old functions – What to do now?
The function library of Excel keeps developing, and it can be challenging to stay on top of which changes are relevant in your particular situation. Learning more about the latest development enables you to get more out of Excel in general, and also to understand any potential issues your clients or other stakeholders may have with the new functionality due to compatibility issues.
Transaction Due Diligence / Drive Insights and Assurance from a Vendor Model
Using the financial model for an upcoming transaction, the due diligence process can provide deeper insight of the risks and reward of the deal.
Advanced Technique: Delta Sheets – Strengthen the Analysis of Financial Models
Systematic technique to visualise key driver impact on commercial outputs. In this webinar, Mazars’ financial modelling Partners Tom Brichieri-Colombi and Jerome Brice will provide insight into how to utilise the powerful analytical technique of Delta Sheets to interrogate and provide commercial insight into your own infrastructure models or those provided to you for review.
Recommendation: Use Sparklines in your Financial Models
Ever since Edward Tufte formalised the concept of Sparklines into sparklines as “data-intense, design-simple, word-sized graphics”, the inclusion of Sparklines in Financial Models have been a much debated and controversial theme. With recent developments in Excel, we now have Sparkline functionality at our fingertips, yet broader adoption has not yet occurred. This webinar will inspire you to get started, with the benefit of deeper insights, reduction in error rates and faster understand of your presentations by the target audience.
Mastering Flags: Build dynamic & flexible timing architecture in an Excel financial model
Almost all financial models have critical functionality linked to specific timing events. These frequently include Financial Close date (project finance), Transaction date (M&A), Construction start (greenfield projects) and ongoing timing events (e.g. maintenance capex). By working in a structured way with timing flags in a model, this type of logic can be built in a transparent and flexible way, enabling decision makers to gain increased trust in the forecasts, and allowing financial modellers to implement more comprehensive functionality faster and with less errors.
Financial Modelling: From Bid to Operations (including ‘actual’ financial statements)
Following a successful financial transaction (project finance, bid, M&A, re-financing, etc), it is regarded best-practice to convert the Transaction Model to an Operations Model.
In this webinar we demonstrate which functionality to strip out of the model after a transaction to make the model better suited for asset management, discuss the different approaches to incorporate Historical Financial Statements (‘Actuals’) in the financial model and showcase a full-scale operation model, associated switches, integrity checks and additional functionality.
Sensitivity analysis of a financial model that you didn’t build yourself
For anyone working in credit analysis, project finance or with investments, performing scenario and sensitivity analysis of a third party financial model is part of your daily life. If not performed efficiently, it can be an incredibly time consuming task and there is a great risk of manual error given the highly repetitive nature of the task.
In this webinar we demonstrate a number of approaches which provides you with a systematic process to sensitivity and scenario analysis of a third party model, i.e. a financial model developed by someone else.
LLCR – Financial Modelling and Analysis
The loan life coverage ratio or loan life cover ratio (LLCR) is one of the most commonly used debt metrics in project finance and also often used in corporate debts. Unlike period-on-period measures such as the debt service cover ratio (DSCR), the LLCR provides the lenders with a measure of the number of times the project cash flow over the scheduled life of the loan can repay the outstanding debt balance.
This webinar looks at the LLCR calculation, common errors and oversights made when modelling LLCR, and a method to check the calculation.
Model Integrity – Learn from the Experience of +1,000 Model Audits
Achieving accurate forecasting in your financial models is essential to provide confidence for investment decisions, strategic option evaluation and project finance processes. Based on our experience from auditing well over 1,000 financial models from every corner of the world, this webinar will help you learn more about the process, and give you inspiration for how you can improve your own processes to achieve an increased quality.
HoldCo Portfolio Debt Structuring – Financial Modelling and Risk Analysis
To support the growing trend of introducing holdco / portfolio level debt structures in the renewable energy sector, our next webinar shares our experience financial modelling and risk analysis. Additional debt at HoldCo level changes the risk profile, and requires additional measures of risk to support the asset level metrics.
Infrastructure Analysis – Financial Modelling of ‘Cash Sweep’
To fully master the Infrastructure sector it is essential to have a clear grasp on the concept of ‘Cash Sweep’. By understanding the rationale of this concept, and the implications for sponsors, financiers and other stakeholders, you will be better equipped for a career in infrastructure financing.
Financial Modelling and Analysis of Levelised Cost of Electricity
The Levelised Cost of Electricity (LCOE), sometimes referred to as Levelised Energy Cost (LEC), is an essential metric in the world of electricity generation. This webinar will demonstrate how to best calculate this metric in a financial model and illustrate a number of common pitfalls to avoid.
Functional Requirements in a Bankable Financial Model for a Solar Project
This webinar reviews the various components required at each stage to give you increased confidence when preparing a fit-for-purpose financial model for feasibility analysis, a financing transaction, a valuation, or for reporting of financial performance.
Financial modelling and analysis of M&A in the mining sector
After a few years of tough decisions, doomed prices and deferred investment, mining sector is coming to life and is on the radar of M&A activity again. Accurate and flexible financial models are a must in the situation of price volatility, capital allocation dilemmas and competition for financing.
Corality™ Financial Modelling: Integrity Checks
Working with a structured approach to monitoring Hard Errors, and Commercial Signals in a financial model will increase the level of confidence in your projections. This webinar will illustrate the Corality™ approach to error management and how to bring the attention of a Decision Maker to certain commercial outputs.
Creating Sensitivity Tables for Infrastructure Project Analysis
Using powerful Excel techniques, sensitivity and scenario tables can be used to prepare credit and investment submissions, but also to interrogate the robustness of a financial model.
Financial Modelling of Construction Delays in Renewable Energy
Master the modelling and analysis of the financial impact of a construction delay in a renewable energy project.