Cash Flow Waterfall Model
Originally published: 29/06/2016 08:35
Publication number: ELQ-91632-1
View all versions & Certificate

Cash Flow Waterfall Model

A cash flow model for Real Estate based on a waterfall structure

This model represents the traditional capital structure between the real estate parties, developer and investor.

The waterfall cash flow model is used for payment schemes where more senior creditrs receive both interest and principal payments, and lower tier creditors receive only interest payments. The waterfall structure is a typical real estate capital structure where the developer is usually the minority investor. The waterfall is really Internal Rate of Return (IRR) hurdles which determine how cash flows at each level are split.

The model is dynamic and amenable to deal variation.

Note: You are welcome to report any errors or any suggestion for improvement. I will earnestly consider all your valuable inputs

This Best Practice includes
1 Excel Model

Amit Tandon offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

To model cash flow in the traditional real estate partnership between investors and developers

Applicable for traditional real estate partnerships.
Dynamic and easily amenable to deal variation.


keyboard_arrow_downShow all


Discussion feed for Cash Flow Waterfall Model

The user community and author are here to help. Go ahead!

  • Ola Hensworth
    In your waterfall calculation is NPV 0
    arrow_drop_uparrow_drop_downReply reply
    • Loren C. Divers
      Hi, my computer crashed with loss of the Excel Cash Flow Waterfall Model for Real Estate and am wording if you would be able to open a new download for the spreadsheets again please ??

      Thank you so much.

      Loren in Honolulu
      1arrow_drop_uparrow_drop_downReply reply
      • Manager Timothée Demoures
        Hi Loren,
        Your New Password to access your account has just been sent to your email, from which you will be able to access Eloquens again and download Amit's Cash Flow Waterfall Excel Model, from your "Library" Tab. Hope this helps!
        The Eloquens User Support Team
        arrow_drop_uparrow_drop_downReply reply
        • Loren C. Divers
          Thank you and can you please refresh the link, its expired. Thank you so much I appreciate it.

          1arrow_drop_uparrow_drop_downReply reply

      4.6 / 5 (106 votes)

      please wait...