Nord/LB

Project Finance Model

Enabling one of Germany's largest commercial banks to determine their funding requirements and optimise their sources of funding.

Expanded functionality

We replaced the existing model which only accepted one debt tranche, to efficiently manage five

Intelligent forecasting

Improved functionality in the new model allowed returns to be calculated for up to three equity investors

Completely flexible

Since the initial scoping session, the forecasting model has been adapted for use with another project

Challenge

Nord/LB’s existing project finance model only had the functionality to size and sculpt a single tranche of senior debt. To scope out bigger projects, they needed a model that handled up to five tranches, with the option to allocate costs to be funded by each debt tranche, and to incorporate scenarios that would calculate the returns for up to three equity investors and sculpt the dividend distribution between investors.

Solution

We held a model scoping session with the lead bank to understand what variables and functionality the new model required. We then worked in additional functionality to the model, which included fixing the size of individual tranches of debt, selecting certain expenses to be funded by specified debt tranches, calculating the repayment profile for each debt tranche, and putting in place a DSRF, a DSRA or a combination of both.

Results

The new model is simple to use despite the complex functionalities, allowing all tranches of debt to be resized and repayment profiles re-sculpted quickly and easily, via a macro. The model can also switch between scenarios with ease.

Related Success Stories
We’re trusted modelling advisors across a wide range of business industries, including 10 FTSE 100 companies and Fund Managers with over £1.75 Trillion of assets under management.

Just Eat

Developing an integrated profit and loss, balance sheet and cashflow model to support the online takeaway delivery giant’s proposed £6.2bn merger deal.

Read More »

Attraqt

Giving the rapidly growing digital merchandising company the ability to demonstrate adequate working capital for a proposed acquisition.

Read More »

Avios

Helping the FTSE 100 aviation group IAG carve out its loyalty and rewards points programme from BA and Iberia into a separate entity.

Read More »
James Davis CFO

Listen to – The Forward Thinking CFO Podcast

Episode 4 with james davis