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.
Because some of the pages may be tricky to find with the menus, I have included the links to various subjects that I think are more advanced than the basic building of a model. I have included a model that contains many of the issue below. The workbook attached to the button has many of the subjects discussed below.
1. I consider the following subjects fairly advanced, if you want find any of these subjects are interesting to you.
a. Structuring a project with evaluation of debt size from either P90, P50, or maximum debt to capital.
b. Inclusion of DSRA changes in the DSCR for debt sculpting.
c. Resolving circular references without copy and paste macros or the iteration button.
d. Effective control pages where you can evaluate changes to inputs and properly include the inputs in relevant input sheets.
e. Debt sculpting of multiple debt issues where cash flow is affected by interest expenses and income taxes.
f. Computing debt repayment where the debt size is given, and sculpting is used to obtain a minimum DSCR with varying DSCR’s.
g. Modelling development fees in the context of multiple investors.
h. Creating data tables using VBA to resolve problems with data tables
i. Developing timelines that can easily convert monthly to semi-annual or quarterly and creating semi-annual sums in monthly models without SUM(OFFSET).
j. Incorporating options for DSRA funding with an L/C or with cash funding.
k. Adding re-financing assumptions to a model where the debt size depends on taxes which are also affected by interest on the re-financing.
l. Including actual data in models for the construction period and operating period.
m. Developing alternative ways to model working capital requirements in the initial operating periods of a project.
n. Evaluating different structures for equity investors including cash flow flips and incentives to developers.
o. Modelling the effect of financing in different currencies including translation adjustments on the balance sheet.
p. Modelling alternative cash sweep structures.
q. Modelling mini-perms and different re-financing assumptions.
r. Modelling equity bridge loans and the associated circular references along with options to include or not include interest during construction in the borrowing base.
s. Valuation of projects with changing buyer target IRR’s and computation of holding period returns.
t. Evaluation of NOL time limits on the calculation of income tax.
u. Accumulation of projects into a portfolio
v. Evaluation of defaults and the risks of senior and subordinated debt
w. Computation of the LLCR with different debt issues using the prospective debt IRR
Featured Project Finance and Real Estate Model Collection
Project Finance On Line Course
Circular References in Project Finance and Becoming a Top Modeller Instead of a Copy and Paster
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 email@example.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
- Link to Course Outlines on Project Finance Theory.
- Link to Course Outlines on Project Finance Modelling
- Read my Book on Project Finance Modelling link to description of my book.
- Become part of our community on Linkedin
- Read a description of my services – on-line courses, personal calls and other products