This page includes background for project finance analysis and theory courses. The project finance theory includes the essence of project finance, selected case studies, debt financing structure and the theory of debt contracts. I begin courses by discussing what is finance — something I was never taught in business school classes. I suggest that finance is about making an investment. An investment could be a buying a stock; it could be buying a whole company as part of an acquisition program; it could be making capital expenditure for a factory; it could also be the time taken to go to the heath club; it could be the cost and time taken to go to the dentist to have your teath cleaned; it could be the opportunity cost and out of pocke cost of getting an education; it could be the gambling. For each of these investments, you have to wait to get the benefits. If you have to wait, the benefit of an investment is uncertain. You do not know whether the stock will increase and pay you dividends; you do not know if your excerise make you healthier and/or more beautiful; you do not know with certainty whether the capital expenditure will produce more money that you paid for it …
The idea of finance is to perform a cost and benefit analysis. This cost and benefit comparison can also be termed the rate of return. The problem in finance and with so many decisions in your life is that when considering the future benefits that by definition have some associated uncertainty, you need to make some kind of assessment of the risk associated with realising the benefits. This is what finance is about. It is about why London has such a good public transporation system while you could not image life without a car in Silicon Valley. It is about wondering how people constructed incredible catheridials while we now build data centers. Somebody had to make a whole lot of assessment of the cost and benefits of investments.
A theme of the project finance course is that project finance is much more than just another kind of debt. I suggest the debt financing of the project defines the value of the project and the cost of capital for an investment which is a cost and benefit technique for really important long-term investments. Project finance deals with difficult issues of cost of capital and risk measurement in a unique way. As with other pages, this webpage includes a number of files attached to different buttons which include PowerPoint slides and a number of excel files that are used to demonstrate various theoretical issues. The initial section covers the difference between project finance and corporate finance, arguing that project finance should be the foundation of much of the study of finance. The course then moves to four mini-case studies that are designed to demonstrate the structure, contracts, economic analysis and other issues associated with project finance. I have tried to select historic case studies that were spectacular successes or failures. In the subsequent section I move to contract analysis, including the loan agreement. Finally, I discuss the upsides in project that arise from reduction in risk.
Project finance can involve important public policy issues where capital intensive assets my need goverment support to promote an industry. When public policy issues are combined with project finance, investments can be encouraged along with providing incentives for owners to act in an innovative manner. 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.
As part of my new book on re-thinking finance I have a section devoted to project finance. A few of the introductory chapters to explaining project finance and the foundations of IRR and DSCR are discussed in the excerpt attached to the button below.
.
.
.
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 next buttons are attached to excel exercises we use to demonstrate the concepts. The buttons below are attached to a files with power point slides that discuss various theoretical issues related to project finance. The first files work through foundation issues and the second button is attached to power point slides that include the case studies.
.
Power Point Slides with Discussion of Project Finance Foundation and 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.
.
.
Backup Files Referred to in Discussion of Project Finance Foundations
.
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.
.
.
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 meant to demonatrate how lenders can have more background on a project than developers. 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
.
The file attached to the button below may not seem to have too much to do with project finance. It is my general file on downloading stock prices and includes the IRR’s, volatility and betas for many stocks. I use the file to discuss general issues about IRR and growth and also how dividends come into play in the calculaiton of IRR using adjusted stock prices.
.
Excel File that Uploads Stock Price Data from Finance.Yahoo Economic Data from FRED using Python
.
The discussion of contrat structure uses examples of contracts that are public or disguised. The button attached to the PPA contract below has both and output based contract and a capacity based contract in the context of a battery plus solar project. The contracts raise risk allocation issues.
.
.
Back-up Files for Discussion of Case Studies
.
The files below include some back-up for the case studies. These files include data for the production of wind for Orsted projects; a Standard and Poor’s write-up of the Ras Laffan project; Excel files for the Dahbol project and the initial offering memorandum for the Eurotunnel project. This file is used to introduce the Ras Laffan case with analysis of commodity prices. You are supposed to look for volatility and mean reversion in the prices and make a judgement as to what is acceptable.
.
.
This file contains the pre-sale report for Ras Laffan which was used as a credit write-up and discussed the risks of the project. The idea of this report is just to skim through the discussion of risks and look at the presentation of the financial model.
.
.
This file is the financial model for Ras Laffan with alternative oil prices. You are to use this file to evaluate the cost structure of the project and to compute the break-even oil prices by yourself. When you compute the break-even price, you need to subtract the transport cost to derive the cost realized by the project. In formula terms: Worldwide Gas – Transport Cost = Gas to Project. This can be computed with a simple oil to gas ratio of about 6 bbl per MMBTU. This means if the oil price is 60 then the gas price is 10. If the trasport cost is 3 then the net gas to Ras Laffan is 7.
.
.
The button below is for the Dahbol case. You are to compute a couple of IRRs and use the data to evaluate the key risk of the project which could not be easily mitiagated. This excel file comes straight from the HBS case study where provision of the contracts were published.
.
Excel File with Data from the HBS Dabhol Electricity Plant Case with PPA and Capital Costs
.
The file below has the exercise for Eurotunnel. You can evaluate the construction risk and the traffic risk, both of which were not properly mitigated and both of which were difficult to accept in project finance.
.
.
The file below has the initial offering memo for Eurotunnel which describes the construction contracts and the traffic projections. The file is ancient from the 1980’s but you can see some of the ideas that we would now think are crazy. The ideas include taking traffic risk, having the EPC contractor own a majority of the project during the signing of the contracts, having an IPO structure …
.
Offering Memo for Initial Public Stock Offering of Eurotunnel Project before Financial Close
.
The file below is back-up data in an excel file for Orsted. This file was only availble after the large write-off for the Ocean Wind project. Before the write-off it was not possible to see detailed data on a project by project basis. There is still limited data on the performance of individual projects.
.
.
Excel Files with Corproate Financial Analysis Used to Illustrate Project Finance Concepts
The file below is an excel file with analysis of corporate finance. The files compare renewable energy companies to other more traditional corporations.
.
.
.
Monte Carlo Simulation, Risk, Mean Reversion and DSCR
The first exercise demonstrates risk issues with volatility and mean reversion. The idea is to show how project finance is about managing risk over long-term periods. You can use the probability of default with the DSCR and the probability of loss with the PLCR. You can see the probability of default and probability of loss with different DSCR Ratios. The idea of this file is to enter different levels of volatility and mean reversion and then determine what DSCR will result in a reasonable probability of default and probability of loss. You can look at the macros in the file that are used to create a Monte Carlo simulation.
.
.
The file below is an excel file that reconciles project finance with corporate finance.
.
Excel File with Projects Consolidating to Portfolio Demonstrating Returns and Financial Ratios
.
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
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
.
.
.