The four day course will provide delegates with a thorough understanding of the:
-
Theory and Modelling of Corporations and Project Finance Investments.
-
Comparison of Useful Ratios in Project Finance and Corporate Finance.
-
Alternative Risk Assessment Techniques in Corporate and Project Finance.
-
Common Valuation Mistakes in Valuation of Stocks and Projects.
-
Structure and Creation of Corporate Models.
-
Structure and Creation of Project Finance Models.
-
Complexities in Analysis of Terminal Value.
-
Complexities in Valuation and Credit Assessment of Project Financings.
Methodology
Added Sessions on Financial Modelling in Excel. The course uses case studies, hands-on analysis and template models as the primary teaching tools. However, in teaching this course in the past, we have found that some participants are interested in practical mechanics of excel (macros, combo boxes, offset and indirect functions). Added sessions will be held after 5:00 PM to provide instruction on many practical excel topics.
Course Background
Other than the instruction in how to build, use and analyze financial models, participants in the course will receive a comprehensive suite of financial modeling software on a compact disk that includes a number of template models and excel addins. The software consists of corporate models that accept historic financial data and generate alternative valuation measures; M&A models that consolidate two companies using alternative financing assumptions and produce accretion and dilution estimates; project finance models that measure the effect of alternative elements in a cash flow waterfall including debt service reserves, junior debt, covenants, defaults and pre-payments; LBO models that measure the debt capacity of a transaction; option pricing models that account for alternative structures; and debt valuation spreadsheets, Monte Carlo simulation models, tornado diagram and sensitivity analysis.
Supported by:
Day 1
Valuation in Corporate and Project Finance
Overview
This part of the course introduces key themes and concepts that will be used throughout the four-day session. Measuring and managing risk as well as translating risk into valuation for decision making will be emphasized along with strategic and economic drivers of value. Valuation covers mechanical aspects of valuation, the meaning of financial ratios used in valuation, appropriate use of multiples (P/E versus EV/EBITDA), choosing among alternative techniques and assuring that the valuation techniques make sense.
Topics Include:
Agenda
-
Valuation Overview.
-
Discounted Cash Flow.
-
Cost of Capital and Adjusted Present Value.
-
Sensitivity Analysis and Scenario Analysis.
-
Case Study of Valuation and Financial Modelling (IPO case).
Overview of Course and Major Themes
-
Tension between judgment and quantitative analysis.
-
Use of free cash flow in decision making versus earnings comparisons.
-
Importance of models in risk assessment and decision making.
-
Conflict between enterprise valuation and equity valuation.
Financial Ratios in Corporate Valuation
Overview
-
Financial Statement Review.
-
Financial Indicators of Value.
-
Price Earnings Ratio, Return on Investment and Value Creation.
-
Free Cash Flow.
-
Case Study.
Corporate Valuation Overview and Mechanics
Before delving into the details of valuation models, general categories of valuation models will be introduced and a foundation in valuation mechanics will be established. The discussion will focus on how value is created by a company.
-
Alternative Valuation Techniques.
-
Discounting in Practise.
-
Valuation of Risky Bonds.
-
Derivation of P/E Ratios.
Corporate Valuation Overview and Modelling
In this section participants learn the state of the art in valuation theory and practice. The discussion and case studies focus on which valuation method is most appropriate for alternative business circumstances.
-
Valuation Using Multiples.
-
Valuation Using Discounted Free Cash Flow.
-
Rationale for Alternative Terminal Value Approaches.
-
Valuation from Earnings Growth.
- Case Study on Implementation of Valuation.
Cost of Capital and Adjusted Present Value
After analyzing valuation techniques, application of cost of capital is discussed with emphasis on application of discount rates in real world circumstances. The final topic addresses adjusted present value where all-equity cost of capital is applied.
-
Survey of Cost of Capital Techniques.
-
Cost of Capital Used in M&A.
-
Weighted Average Cost of Capital.
-
Data tables and Valuation.
-
Application of CAPM.
- Adjusted Net Present Value.
Day 2
Valuation of Debt and Equity in Project Finance
In the second part the course addresses valuation in project finance applications. Project finance is a unique financial product with significant financial management implications related to risk analysis, debt sizing, contract valuation and options analysis. Topics included in the project finance part of the course include:
-
Structured Finance Overview and Terms.
-
Debt Structuring and Debt Sizing in Project Finance and Leveraged Buyouts.
-
Contract Valuation in Project Finance.
-
Probability of Loss, Loss, Given Default and Yield Spread.
Project Finance Overview and Terms
The discussion of project finance begins with introductory comments about the costs and benefits of project finance with an emphasis on measuring and valuing risk. A case study is used to introduce a number of subjects
-
Overview of Project Finance Terms.
-
Applications and Contracts in Project Finance.
-
Project Finance Case Study.
Valuation and Credit Analysis in Project Finance
-
Overview of Project Finance Models.
-
Free Cash Flow and Equity Cash Flow.
-
Equity and Project IRR.
-
Debt Service Coverage and LLCR.
-
Debt Sizing Case Study.
Debt Structure and Waterfalls in Project Finance Debt
Debt structure in project finance can be quite complex and affected by a number of credit enhancements including covenants, debt service reserves, waterfalls and contracts. Credit enhancements are addressed using a case study and a comprehensive project finance model template.
-
Credit Enhancements in Project Finance.
-
Debt Service Reserves.
-
Project Finance Covenants.
-
Senior and Subordinated Debt.
-
Liquidated Damages.
- Case Study of Debt Valuation.
Valuation Case Study in Project Finance
After working through project finance issues, participants work through a comprehensive case study to value a project and determine the credit quality of the debt tranches. The case includes establishing economic drivers, revenues and expenses and the financial structure of the project. Case Review
Day 3
Corporate Modelling
The third part covers financial modelling for valuation. Topics covered in the second day include:
-
Modelling Overview and Major Themes.
-
Corporate Financial Model Structure and Objectives.
-
Design and Building of a Corporate Model from A to Z.
Corporate Model Structure
Forecasting models are the centrepiece of most valuation, merger and acquisition and project finance analyses. Therefore, the course begins with by establishing a solid foundation in modelling. Some of the common errors made in valuation from corporate models will also be discussed. The errors do not address mechanical aspects of the model but rather conceptual and logic mistakes from a business perspective. In discussing model structure, the course covers:
-
Model Objectives.
-
Review of Actual Models
-
Mistakes in Modelling (base case definition, ignoring financial ratios, capital expenditure consistency, growth rates, business cycles).
-
Model Structure for Alternative Transactions (corporate models, project finance models, leveraged buyout models and merger and acquisition models).
-
Model Layout (inputs, working analysis, debt structure, financial statements).
-
Financial Statement Analysis for Modelling.
-
Model Complexities (depreciation, taxes, circularity, minority interest, deferred taxes).
Corporate Model Structure
So as to become proficient in interpreting financial statements and financial models and in order to be comfortable in using template models, participants will construct a corporate model from A to Z. The model exercise includes a discussion of spreadsheet conventions such as the positive number convention, organization of spreadsheets, use of range names and construction of “cork screw” accounts.
-
Objectives of Well Designed Models.
-
Model Organisation (sheet order, repeating inputs, sheet colours, sheet columns).
-
Spreadsheet Conventions (positive number, switches, cork-screws, switches).
-
Simple formulas (formula length, max and min statements, range names).
-
Model Documentation (macro names, column titles, units).
-
Auditing and Error Checking.
-
Model Construction Case Study.
-
Construction of Working Analysis, Debt Structure and Financial Statements.
-
Calculation of Debt and Cash Plugs.
-
Use of History in Forecast.
-
Scenario and Sensitivity Analysis.
- Template Corporate Model.
Day 4
Project Finance Modelling
The fourth part covers financial modelling for valuation. Topics covered in the second day include: After the introductory discussion, participants construct a basic project finance model to become familiar with the structure of a project finance model, equity cash flow and free cash flow. The model is then used to demonstrate how interest during construction, multiple equity sources and target debt service cover can be added to a model. Once the fundamental model is built, it is used in the context of simple applications involving debt capacity, contract pricing, debt structuring, break-even analysis and probability of default. Construction of a simple model involves the following:
Basic Mechanics of Project Finance Models
-
Separation of construction period from operating period.
-
Sources and uses of funds statement during the construction period.
-
Cash flow, net income, equity balance, construction financing and income taxes.
-
Internal rate of return on the project and central concept of free cash flow.
-
Construction of a balance sheet and use of a balance sheet in auditing the model.
Project Finance Model Accounting and Financing
Use of Project Finance Model Measurement of Debt Capacity
Course summary and close
-
The Course Director has created innovative forward pricing, productivity measurement and investment valuation software for consulting clients throughout the United States. He has taught energy economics and finance throughout the world, and formulated significant government policy and corporate strategy in the U.S.
His consulting clients include investment banks, commercial banks, research institutions and government agencies on a wide variety of complex valuation and advisory matters. He has constructed a unique framework for electricity price forecasting and valuation using production cost modelling techniques combined with option price theory and Monte Carlo simulation.
He is also an adjunct professor at leading University where he teaches courses in microeconomics. Along with his practical experience that covers a multitude of major advisory projects, he has taught specialised courses in financial modelling, electricity pricing, option valuation, mergers and acquisitions and contracting to investment banks, commercial banks, industrial corporations and electric utility companies.
He was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He has used the models in providing expert testimony on subjects ranging from capital structure to investments in multi-billion dollar nuclear plants to complex valuation of new investments.
He received an MBA degree specialising in econometrics (with honours) from the University of Chicago and a BS degree in finance from the University of Illinois (with highest university honours). He has written many articles and is in the process of completing a textbook on valuation of electricity assets.
Courses run by this instructor
Interested in holding this course in-house? Please fill out your details and a member of our team will be in touch with more information.
3-5 Dec 2013 (Johannesburg, South Africa)
A three-day financial training course on the valuation of mining companies.
2-13 Sep 2013 (Johannesburg, South Africa)
This 10 day intensive practical programme features everything you need to know about project finance.
28-30 Oct 2013 (Johannesburg, South Africa)
29-31 Jan 2014 (Johannesburg, South Africa)
20-22 Oct 2014 (Johannesburg, South Africa)
A 3-day financial training workshop on Renewable Energy Project Finance where you will learn about structuring renewable energy projects, risk assessment and allocation in renewable and much more.
22-24 Nov 2013 (Johannesburg, South Africa)
The aim of this intensive 3-day training course is to provide participants with exposure to leveraged and mezzanine financing techniques in the context of M&A and private equity structures. Delegates will be introduced to international practice in executing leveraged transactions, which will include due diligence, accounting issues and valuation techniques. Case studies will include opportunities to structure leveraged finance transactions.
11-14 Nov 2013 (Johannesburg, South Africa)
A 4-day course designed to support analysts within an organisation’s project finance, business development and treasury divisions to create and analyse financial models on a consistent and focussed basis.
22-26 Jul 2013 (Nairobi, Kenya)
3-6 Feb 2014 (Accra, Ghana)
A four day financial training course on Oil & Gas Project Finance where you will learn how suitable financial structures for oil, gas and electricity projects are created.
10-12 Feb 2014 (Lagos, Nigeria)
This three-day workshop will increase participants' understanding of the process leading to the creation of a suitable financial structure for various types of cross border telecom projects and transactions.
25-29 Nov 2013 (Johannesburg, South Africa)
A 5-day case study based workshop exploring more advanced issues in company valuation and financial modelling.
23-27 Sep 2013 (Nairobi, Kenya)
A 5-day case study based workshop exploring more advanced issues in company valuation and financial modelling.
26-28 Aug 2013 (Johannesburg, South Africa)
27-29 Jan 2014 (Johannesburg, South Africa)
25-27 Aug 2014 (Johannesburg, South Africa)
A practical and highly interactive 3-day training course, incorporating numerous case studies to enhance delegates understanding on the production and transformation of agricultural products and their distribution.
16-18 Sep 2013 (Johannesburg, South Africa)
A 3–day training course dedicated to the valuation, structuring, financing and negotiating of merger and acquisition transactions.
3-5 Dec 2013 (Nairobi, Kenya)
This 3-day programme focuses upon how the toolkit of conventional business analysis can be linked sequentially and logically with the principles of financial economics. It will provide critical insight into how the tools and techniques of conventional business analysis can and must be adapted.
8-11 Jul 2013 (Johannesburg, South Africa)
This 4–day Corporate Finance Applications course is
a practical "how to" programme dealing with numerous disciplines within the subject of corporate finance.
2-5 Dec 2013 (Lagos, Nigeria)
1-4 Dec 2014 (Lagos, Nigeria)
A four day financial training course on Oil & Gas Project Finance where you will learn how suitable financial structures for oil, gas and electricity projects are created.
8-11 Oct 2013 (Nairobi, Kenya)
A 4-day intermediate training course covers a wide range of knowledge and experience of project finance and public private partnership.
5-8 Aug 2013 (Nairobi, Kenya)
A comprehensive 4-day training course, featuring case studies across a range of industries to help course participants practice corporate valuation techniques.
15-17 Oct 2013 (Lusaka, Zambia)
A 3-day financial training course on corporate loan restructuring. With tough liquidity conditions finance professional are required to quickly identify what is causing borrowers problems and provide the most appropriate and costeffective finance solution.
19-21 Aug 2013 (Johannesburg, South Africa)
A comprehensive 3- day course for all financial professionals in banking, corporate finance,
strategic and financial advisory, consulting, M&A departments and private equity houses.
21-24 Oct 2013 (Johannesburg, South Africa)
This 4-day workshop takes a hands-on approach to financial analysis and cash flow techniques.
23-25 Jul 2013 (Johannesburg, South Africa)
This 3-day course has been designed to provide the participants with a complete overview of the venture capital industry and its workings.
2-4 Sep 2013 (Johannesburg, South Africa)
The 3-day Advanced Project Finance Workshop focuses on the core skills of risk analysis and structuring, with a special emphasis on political risk. Team case presentations neatly wrap together these skills along with the analysis and sensitivities of the team case-study Excel models.
5 Sep 2013 (Johannesburg, South Africa)
A 1-day course on Oil&Gas/LNG Project Finance. Industry fundamentals will be covered, together with the key metrics and due diligence issues alongside numerous case studies. International best practices will be delivered comprehensively.
6 Sep 2013 (Johannesburg, South Africa)
A 1-day on course Power Project Finance. Industry fundamentals will be covered, together with the key metrics and due diligence issues alongside numerous case studies. International best practices will be delivered comprehensively.
9 Sep 2013 (Johannesburg, South Africa)
A 1-day on course Infrastructure Project Finance. Industry fundamentals will be covered, together with the key metrics and due diligence issues alongside numerous case studies. International best practices will be delivered comprehensively.
10 Sep 2013 (Johannesburg, South Africa)
A 1-day course on Mining Project Finance. Industry fundamentals will be covered, together with the key metrics and due diligence issues alongside numerous case studies. International best practices will be delivered comprehensively.
11 Sep 2013 (Johannesburg, South Africa)
A 1-day course on Project-Finance Risk and Recovery, examining projects that have gone wrong, including a review of the credit factors/reasons why these deals would go wrong - incorrect 'project concepts'.
12-13 Sep 2013 (Johannesburg, South Africa)
A 2-day course on Building Project-Finance Models, looking at the key financial ratios and credit analysis as well as the forecast basis for any cashflow projection. This course is designed as a 'Build-your-own-model-from-scratch' with the final model used in a course bidding contest.