Project Finance

I believe this site includes a lot of unique ways to address advanced project finance issues from a modelling perspective, from a theoretical perspective and from an analysis perspective.  Financial modelling techniques allow you to address sculpting, DSRA, financing, re-financing, presentation, model structuring and a host of complex issues that arise in project finance modelling. Many, but not all, deal with the painful issue of circular references.  I addition, if you are new to project finance you can go to the A-Z page and watch some long videos that walk you thorough the process.  If you are advanced you can look at the advanced theory page.

 

Featured Project Finance and Real Estate Model Collection

 

Solar Project Finance Models

On-Shore and Off-Shore Wind Project Finance Models

Project Finance Models of Thermal Electricity Power Plants

Hydro Project Finance Models

Toll Road Project Finance

Sea Port Models

Hotel Project Finance

Commercial Real Estate and Lease Roll

Residential Real Estate Modelling

Mixed Development and Investment Portfolios of Projects

Collateral Debt Obligations and Other Modelling in Real Estate

Mining Models

Agriculture Project Finance

Upstream Oil Project Finance Models

Tax Equity Structures in the U.S. and Renewable Energy – Part 1, Modelling Cash Flows and Allocations

Tax Equity Structures in U.S. – DRO’s, Stop Loss, Outside Capital Account …

Manufacturing Project Finance

Project Finance Credit Analysis Examples

 

Project Finance On Line Course

 

Project Finance Theory and Marriage Contracts

A-Z Project Finance Modelling On-Line Course

Original (More Basic) Project Finance A-Z On-Line Course

Sculpting Fundamentals and Non-Constant Interest Rates

Repayments with Debt to Capital Constraint and Constant DSCR

Incorporating Taxes in Debt Sculpting and Simple UDF Functions

Sculpting and Debt Fees (Including Fees for DSRA L/C)

Interest Income on the DSRA and Sculpting

Learning What Not to do from Horrible Models

 

Circular References in Project Finance and Becoming a Top Modeller Instead of a Copy and Paster

 

Overview of Circular References and Hitting the Wall

 

Introduction to Parallel Circular Reference Template Model

 

 

The project finance resources are divided into five parts.

The first part contains selected project finance models that are complete, many of which include resolution of circular references.  For each of the section, I have tried to put an outrageous example from developing countries.  If you are interested in even more models, you can send me an e-mail at edwardbodmer@gmail.com. You can also click on the button below to make requests.

The second part contains free on-line lesson sets. A couple of the lesson walk through making a project finance model from A-Z.  Other of the lesson address complex and detailed issues in project finance structuring.  Many of these issues involve sculpting, DSRA and re-financing. The more complex courses show you how to become a top-modeller rather than a copy and paster. If you are interested in really learning how to become a top modeller, you can click on the button below.

The third project finance section addresses advanced debt and contract structuring issues. The debt structuring issues are divided into: (1) debt sizing; (2) debt funding during construction; (3) debt repayment; (4) interest rates and credit spreads; and (5) credit protections.  If you are interested in attending courses that address some of these more advanced issues, click on the button below.

The fourth project finance section explains in detail how to create UDF functions rather than using copy and paste macros to address circular reference problems.

The fifth section discusses how to update models for actual data after actual data arrives.

 

  • Featured Project Finance Models
  • A-Z Exercises to Build Project Finance Model
  • Advanced Project Finance Issues
  • Circular References in Project Finance Models
  • Dynamic Goal Seek and Other User Defined Functions in Project Finance Model