+61(2) 9976 0909
[email protected]
Contact Us
Facebook
Twitter
LinkedIn
  • Home
  • Who We Are
  • Expertise
    • Financial Modelling
    • Training
  • Our Work
  • Testimonials
Resources Contact

Cashflow Waterfall

March 10, 2017No CommentsTheo West

The aim of this tutorial is to provide an understanding of what the Cashflow Waterfall is and how to set it up correctly in a financial model. The tutorial will also focus on the cashflow available for debt service (CFADS). Given that the cashflow waterfall is the most common financial statement in a project finance transaction, the intended audience are those preparing or analysing project finance related financial models.

What is a Cashflow Waterfall and why is it a powerful tool for project finance?

The Cashflow Waterfall, not to be confused with Cashflow Statement, together with CFADS are often the most important financial statement and cashflow item respectively in project finance.

Project finance is a method of financing the development of a particular asset or pool of assets whereby repayment of funding is limited to the cashflow generated by the asset or pool of assets. Hence, given lenders are essentially lending against a stream of future cashflows generated by the asset or pool of assets and given that there are often multiple parties that are providing funding, it is important to understand who gets paid first. This is where a well-structured Cashflow Waterfall becomes a powerful tool as its key difference to a Cashflow Statement is that cashflows are all arranged in seniority, giving clear sight to lenders and equity the cashflows available to them.

Quite often when transactions are large and complex, the waterfall can turn into a minefield. Therefore, this tutorial attempts to illustrate how a typical waterfall should be laid out with an explanation of the categories and the key line items that it should or may contain.

DOWNLOAD EXCEL MODEL
DOWNLOAD PDF
Previous post Net Present Value & Internal Rate of Return Next post Using Python with Excel – Part One

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

BOOK AN APPOINTMENT

Superior Solutions From Experienced Modellers

Recent Posts

  • Using Python with Excel – Part Four
  • Using Python with Excel – Part Three
  • Using Python with Excel – Part Two
  • Using Python with Excel – Part One
  • Cashflow Waterfall

Categories

  • Articles
  • Kenny Chew
  • Levi Bailey
  • Resources
  • Theo West
  • Tutorials

Sharpen your focus. Superior solutions from experienced modellers.

ABOUT US

  • Our Senior Team
  • What We Believe In
  • Blog
  • Resources
  • Contact

FOLLOW US

Facebook
Twitter
LinkedIn
RSS
Log InPrivacy PolicyTerms And Conditions
© 2016 Lentran Modelling Solutions Pty Ltd. ABN 66 615 474 523. Site By Design Fox