Project Finance Foundations – Power Point Slides
The idea of this course is to think differently about the essence of project finance and work through some case studies with different contract structures. When teaching the course I put some of the files we use on this website. The button below includes the power point slides that I use. The power point slides discuss various theoretical issues related to project finance and also some famous case studies that I use to address some of the nuanced issues and that also illustrate problems when the financing of projects and the ideas of effectively using contracts to allocate risk are not applied. The power point slides below are designed for participants who do not have much experience in project finance. An alternative set of slides is designed for more advanced project finance issues.
.
.
Power Point Slides for Project Finance Foundation Course with Theory and Case Studies
.
An example that is a little forgotton now is the manner in which subsidies were set to encourage the development of renewable energy. Contracts were structured to provide incentives to achieve good capacity factors (yield) and at the same time the contracts (feed in tariffs) allowed investors to raise financing. The financing was a crucial verification on the feasability of the projects. Below the button I have included an example of how project finance theory combined with governement policy can change the world. The German government decided to push development of solar power through allow fixed and low risk prices for solar power to be offered to investors. If solar power developers produced energy, they were paid — of course they had to produce the power. The rates are shown on the left graph. By offering a stable cash flow but also giving incentives to prodce power, the program promoted development of solar power (it was not all a success because the construction of solar power moved to Asia).
.
I have included a couple of graphs related to project finance ideas and policy below. The German government impleted a feed-in tariff to specifically impose certain risks on developers — risks of putting projects where the sunlight is best. It made the tariffs simple so that they could be financed. The tariffs were very high at first as you can see by comparing the feed-in tariffs to the electricity prices at the time. This case provides a basis for discussing risk allocation, cost of capital, achieving debt financing and government policy.
.
.
Financial Model Excel Files for Foundation Course
.
In the project finance foundations course I have included some financial modelling files to demonstrate the issues. These files also include discussion of the case study and the primary issues identified by case study writers. The files are designed so that partipants can focus on critical issues of measuring return with IRR and risk with DSCR. There where will be a few excel formulas but the models will be primarily related to thinking about analysis — debt structuring, credit risk analysis and understanding the perspective of equity investors.
The first file below is and excel file with some excel exercises designed to allow you to understand the meaning of IRR (as the growth rate of cash flow) and the DSCR as a measure to evaluate the buffer in cash flow that covers the year to year risk of projects. The that is a relatively simple model. We will use this file to illustrate various ideas related to measuring risk and return and issues such as the project IRR versus the equity IRR.
.
.
In addition to the excel file used to work through mechanical issues assoicated with project finance, I have included four financial models developed for the cases that are used to quantify some of the policy, and risk issues associated with the cases. The case study files with financial models include a model of the Ras Laffan project in Qatar, the Petrozuata project in Venezuela, the Dabhol project in India and Eurotunnel project. I call the cases oldies but goodies because of the way each case hilights particular issues with project finance concepts, risk analysis, government policy and contract structuring. The first case below is for Ras Laffan and Petrozuata which introduce reasons for project finance versus other financing such as govermnent financing. My notes on these cases are discussed in the power point slides.
.
Financial Model File for Qatar Ras Laffan LNG Model from S&P Projections without Equity Cash Flow
.
.
The next case moves through issues associated with contracts and how to evaluate the economics of contracts as well as the structuring of contracts between parties in the context of electricity generation. This is the case named Dahbol which was a famous case involving a plant near Mumbai India and Sponsors from the U.S. The case questions methods for bidding and the reasonableness of the ultimate results of contracts.
.
.
The the final case discussed in the Foundations course is for the famous Eurotunnel project. The case prompts questions of what kind of risks should be supported by the government in favour of encouraging public policy (like taking the train) and what kind of risks should be taken by private sponsors. As with the other cases, you are encouraged to ask what could have been done differently with hindsight to avoid the problems that occured. These issues involved question of contract structures (the construction contract), the ownership structure and allocation of traffic risk.
.
.
Term Sheets, Contracts and Credit Write-ups used in Discussion of Project Finance Foundations
.
The file attached to the button below is a file that illustrates different financial issues that are used in the remainder of the course. The file attached to the first button is an example term sheet. If you work through the document and understand the language it would be a good thing to do.
.
PDF File with Term Sheet for Loan Agreement that Illustrates Various Financial Structuring Items
.
The file attached to the button below is an example of how lenders assess risks of a project. The file attached to the button below is meant to demonatrate how lenders can have more background on a project than developers because of the history of how they assess projects. They have databases, experience with other projects, they hire experts, they have consistent ways to evaluate risk and so forth ..
.
Example of Analysis of Solar Project with Independent Engineer and Sensitivity Analysis
.
Once the ideas of risk allocation to encourage efficiency and social objectives are established, contracts apply the ideas. To discuss how the objectives translate to contract language, actual contracts are reviewed. The discussion of contrat structure uses examples of contracts that are public or disguised. The button attached to the Purchased Power Agreement (“PPA”) contract has some standard langauage that works through different terms designed to allocate risk. The second contract is an example of and Engineering, Procurment and Construction (“EPC”)contracts.
.
Example of EPC Contract for Discussion why Provisions Such as Liquidated Damanges and Focre Majure
.
Example of PPA Contract for Pricing Provisions Capacity Payment, Energy Payment and Inflation
.
Example of PPA Contract Terms including Performance Ratio and Pricing Mechanisms and Other Aspects
.
A third contract that is typical in project finance is the Operating and Maintenance Agreement. This agreement can be made with a different special purpose vehicle of the sponsor. You can evaluate whether how the O&M agreement corresponds to the PPA agreement.
.
Example of O&M Contract Terms including Performance Ratio and Pricing Mechanisms and Other Aspects
.
.
Excel Files with Corproate Financial Analysis Used to Illustrate Project Finance Concepts
The power point slides attached to the button below include three historic case studies that I like to discuss that address some key ideas about incentives, contracts, acceptable risks, financing structures and other issues that I address. The case studies include the Ras Laffan project in Qatar where the project finance structure arguably allowed the country to get the world cup and do other things that could not have occured in a traditional goverment ownership structure. The second case, the Dabhol plant in India allows us to discuss contracts, incentives and affordability issues. This case was a famous failure. The third case, Eurotunnel, prompts us to discuss efficient contract structures, output versus availablity risk and other issues.
.
.
The file below includes power point slides for my analysis of Orsted which is an effective contrast between corporate finance and project finance and suggests that the analysis done by an outside party to the company making the equity investment — the lenders — provides a crucial test of whether a large invesment makes sense.
.
.
The file below is an excel file with analysis of corporate finance. The files compare renewable energy companies to other more traditional corporations.
.
.
.
Pre-Course Materials for Project Finance Foundation
Alternative Project Finance Definition … finding money from a bank (not associated with your company) and/or an investor for a capital investment where you can prove (through nonrecourse loans and equity cash flow evaluation) that the project is economic on a stand-alone basis and has acceptable risks where debt and equity is structured corresponding to the risks, the timing and the pattern of cash flows from the project. Long-term financing is achieved through demonstrating mean reversion in cash flow and/or use of long-term contracts can meet debt service and provide a reasonable growth rate in cash flow to investors.
.
.
Project Finance and IRR
The file attached to the button below addresses the definition calculation and nuances of the IRR. The file demonstrates that the IRR is a growth rate when measuring stocks or when measuring the IRR earned from an LBO where there is one date for the investment and one date for the exit value (i.e. there are no intermediate dividends). The file demonstrates that the biggest problem with the IRR is in the context of project finance where there are a lot of dividends and the implicit assumption is that the dividends are re-invested at the same rate as the IRR itself. (I have an alternative to this where the risk premium is computed, but it is not used much). I also reconcile the IRR and the ROI in the sheet using economic depreciation and demonstrate that you can use this method to compute performance measures.
.
.
.
The final file for the first session compares companies investments in renewable energy project finance to other companies such as oil companies. The file use the financial database that is described in detail on the database menu. When you compare the ROE to the price to book ratio or the EV/EBITDA ratio, you can see how the value of project financed investments are high compared to the cash flow produced by things that have more volatile cash flows.
.
.
.
Project Finance and Cost of Electricity
.
I have worked matching a project finance model and equations that use the PMT and PV functions to compute the levelised cost of electricity. The file attached to the button below includes a data set with the Lazard operating assumptions and many different financial inputs. The file demonstrates the importance of project finance in evaluating the cost structure of capital intensive investments.
.
.
.
.
Solar Resource Analysis for Solar Case Study
.
The two files below are for introduction to the solar case study. The first file is for the Middle East and the second file is for northern Europe. You can see the dramatic difference in solar patterns. These files will be used to discuss the performance ratio that can be part of EPC and O&M contracts. The video below works through the example and how to find the data. The analysis uses temperature coefficients and estimated temperature that hits the panel.
.
Partner Files to So You Do Not Waste Time on Formatting and Using the Paint Brush
I have included two files that are used to make the excel exercises work more smoothly. The first is a file called Read PDF which allows you to grab data from PDF files and then convert the data to excel files. To run this file you copy stuff from the pdf file and then operate the macro with SHIFT, CNTL, A. When you copy data from a PDF to excel, make sure that you copy and paste special as UNICODE text. There are different formats that you can use to resolve the PDF. If you are reading from the Lazard LCOE stuff you can use the first green box. If you are reading from the PVGIS you can use the second green box.
The second file is a file that has a whole lot of macros to prevent you from wasting time on formatting and copying formulas to the right. This file is called GENERIC MACROS. I have revised the generic macro file in the link below so that you are not prevented to open it because of something called the auto open — a macro that operates when you open the file and excel considers dangerous. When working through the exercises, it would help a lot if you have this file open and enable the macros. The big things that this GENERIC MACRO allows are to press SHIFT, CNTL, R to copy to the right and also CNTL, ALT, C to open the window that has a whole lot of formatting options. There are a lot more utility macros in the GENERIC MACROS file. You can go to https://edbodmer.com/excel-utilities-and-backpack/generic-macros-file/ and see some of the other stuff including a few user defined functions.
.
.
.
Excel File with Exercise for Analysis of Capital Intensive Water Pipelines Including Levelised Cost
.
.
PDF File with Outline for Project Finance Master Class with Analysis of Different Types of Projects
.
The file attached to the button below includes power point slides on general project finance issues that discuss the essence of project finance (it is not just a kind of debt) and more technical issues about project finance.
.
.
Exercise for Project Finance Theory and Renewable Course with Re-financing and Debt Sizing Analysis
.
.
Working File for Levelised Cost of Electricity Analysis with Solar Data and LCOE Calculations
.
Parked Files
.
The first file below is and excel file that is a relatively simple model. We will use this file to illustrate various ideas related to measuring risk and return and issues such as the project IRR versus the equity IRR. The file contains macros and you will probably have to de-block the macros when you open the file.
.
.
I am so honoured to be able to come to LBS and discuss project finance along with practical modelling. The page includes slides I use for our session as well as exercises that demonstrate theoretical points and databases. As with other pages for the subjects I also include some of the utility files — the generic macro file and the read pdf file.
.
.
.
.
.
Exercise for Project Finance Theory and Renewable Course with Re-financing and Debt Sizing Analysis
.
.
.
.
The file attached to the button below includes a term sheet that we use in the course to understand and not be intimidated by various elements.
.
.
Excel File with Comparison of Alternative Models for Computing Solar Resouce with Saudi Example
.
.
.