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 business tool includes
1 Excel Model
Amit Tandon offers you this business tool for free!
download for free
Add to bookmarks
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.
- Mike Savino, MBA, CPA(last updated: 21/04/2018 16:36)
- Gia Hy Le Pham(last updated: 20/04/2018 12:17)
- Hussein Wada(last updated: 14/04/2018 23:52)
- Mohammed Halaseh(last updated: 12/03/2018 12:53)
- Matteo Cattaneo(last updated: 25/01/2018 08:39)
- Alex Peter Kigenza(last updated: 22/01/2018 08:05)
- Ken Creighton(last updated: 14/12/2017 22:28)
- Sean Fan(last updated: 12/10/2017 23:03)
- Real123(last updated: 21/09/2017 20:48)
- Hong Nhat Tran(last updated: 17/08/2017 11:32)
- Raffaella Pirrello(last updated: 02/05/2017 14:10)
People using this tool also downloaded
Discounted Cash Flow (DCF) Analysis with IRR and NPVSeveral spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow6,352 remove_red_eye
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorpropertysensitivity analysisrental property3,229 remove_red_eyefreeby Amit Tandon
Band Mortgage Equity Capitalization or Atkerson format EllwoodIncorporate and understand a financing's impact on value and compute the cap rate.financereal estatemortgageassumptionsellwoodcapitalizationcap ratenoiatkerson322 remove_red_eye
Entrepreneur's Cost of Capital TemplateEstimate the statistical parameters for determining an entrepreneur's cost of capitalventurefinancevaluationcash flowcost of capitalreturn on investmententrepreneurpartial commitmentwealth allocation159 remove_red_eye
Real Estate Professional Developer's Excel Tool KitFinancial analysis tools for educational purposesfeasibilitytoolmodelreal estatedeveloperfinancial analysisincome propertyland propertyreal estate developmenttoolkit2,410 remove_red_eye
Startup Excel ModelA startup financial model that can be sent to a Venture Capital, Private Equity Firm or Hedge Fund.financecash flowprivate equityfinancial modelstartupfundraisingventure capitalassumptionscapexheadcount8,538 remove_red_eye
Real Estate Excel ModelA Real Estate Financial Model where new property owners purchase their houses outrightfinancereal estatefinancial modelproceedstown housereturnsenior debtmezzanine debt2,447 remove_red_eye
Discounted Cash Flow (DCF) Excel ModelThis DCF Excel Model provides a rough guide to which discounted cash flow model may be best suited to your firm.financemodelcash flowdiscounteddecisioneducationlearnchooseversus822 remove_red_eye
Commercial Real Estate Financial ModelCompute a Commercial Real Estate Valuation and Financial Feasibility of your Investment Project - excel modelinvestmentfinancereal estateassumptionsproject financeproperty valuation2,543 remove_red_eyefreeby Will Ferrigno
Cash Flow Return on Investment (CFROI) for a Firm Excel ModelThis Excel model calculates CFROI (Cash Flow Return on Investment).financecash flowcfroireturn on investment1,674 remove_red_eye
Discussion feed for Cash Flow Waterfall Model
The user community and author are here to help. Go ahead!
- 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 Honolulu1arrow_drop_uparrow_drop_downReply reply
- 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 Teamarrow_drop_uparrow_drop_downReply reply
- Thank you and can you please refresh the link, its expired. Thank you so much I appreciate it.