Corality
View More Content
SHARE

CFADS – Cash flow available for debt service

CFADS – Cash flow available for debt service
CategoriesTutorials

A project’s cash flow available for debt service (CFADS) is analysed by project lenders (senior debt banks) to determine debt sizes and repayment criteria. CFADS is an important measure that determines debt repayment calculations and ratios including debt service coverage ratio (DSCR), loan life coverage ratio (LLCR) and project life coverage ratio (PLCR).

Extract from the Best-Practice Project Finance Modelling course ->

In a typical project finance model, the cash flow available for debt service is calculated by netting out revenue, operating expenditure, capital expenditure, tax and working capital adjustments. The annual cash flow waterfall below clearly demonstrates the calculations of CFADS.
 

Annual-cash-flow-waterfall-to-determine-CFADS
Screenshot 1: Annual cash flow waterfall to determine CFADS



Application of CFADS in project finance analysis

CFADS is preferred over EBITDA in determining gearing and lending capacity because this measure does not take taxes and timing of cash flows into consideration. EBITDA is a common metric in corporate finance but in project finance the focus is on actual cash flow.

 

Graph-of-CFADS-vs-debt-service
Screenshot 2: Graph of CFADS vs debt service



Many projects experience a ramp-up period before they reach steady state production and revenue. In screenshot 2, CFADS is plotted against debt service. CFADS is increasing over time while debt service is decreasing over time.

Project lenders usually determine borrowing capacity on the basis of debt service ratios. Most common debt ratios in project finance are debt service cover ratio (DSCR) and loan life cover ratio (LLCR) which both use CFADS in the numerator of the calculation.

Debt service cover ratio (DSCR)

The DSCR uses CFADS in the numerator and debt service (calculated as principal + interest) is in the denominator. A ratio of 1.00x means that the CFADS in a period is equal to the total debt service in that same period. A ratio of greater than 1.00x means that there is sufficient cashflow to meet principal and interest payments.

DSCR = CFADS / scheduled debt service

Scheduled debt service = interests + principal repayment

Loan life cover ratio (LLCR)

Unlike period on period measures such as the DSCR, LLCR measures how many times the discounted CFADS over the scheduled life of the loan can repay the outstanding debt balance.

LLCR = NPV (CFADS over loan life) / debt balance brought forward (b/f).

Full calculation of LLCR can be found in this related financial modelling tutorial for LLCR.

 

Screenshot-3_example-of-DSCR-calculation
Screenshot 3: Example of DSCR calculation

 


Common mistakes in CFADS calculations

It is important to check that each cash flow item leading to CFADS line occurs at the correct seniority to other items and is modelled in accordance to the term sheet. Common mistakes in CFADS modelling are listed below.

  • Incorrect and n-n cashflow items are included in the CFADS calculation, such as: depreciation, cash balances, and reserve accounts balances.
  • When modelling subordinated or mezzanine debt, it is important to include cash flow available at the appropriate level of seniority. Different CFADS may need to be calculated at each level of seniority.
  • CFADS calculations back calculated from EBITDA is a warning sign that the modeller is inexperienced in project finance modelling and should be checked carefully.

Extract from the Best-Practice Project Finance Modelling course ->


Corality Training Academy - SMART CAMPUS

There are numerous other tutorials and free resources related to financial modelling in Corality's SMART Campus.

Some of the more popular courses that relate to this topic include:

Best Practice Project Finance Modelling

Project Finance: Transaction Simulation Masterclass


Rickard Wärnelid
by Rickard Wärnelid

Rickard's passion for financial modelling is built on specialist roles in the highly quantitative fields of derivatives and project finance, a career path complemented by an academic grounding in engineering physics. Born in Sweden and with global consulting and leadership experience, Rickard is an internationally recognised authority, speaker and thought-leader on the organisational benefits of best practice financial modelling.

Contact Rickard Wärnelid

view all