Waterfall models in real estate projects are one of the most difficult concepts to understand. Cash flow from a development or investment project can be split in countless number of ways. A waterfall is a method of splitting profits among partners in a transaction that allows for profits to follow an uneven distribution. The waterfall structure can be thought of as a series of pools that fill up with cash flow and then once full, spill overall excess cash flow into additional pools.
This Excel model contains 2 types of waterfall methods. The first method of waterfall distributes profits based on a pro-rata basis between the investor and the sponsor, effectively sharing the risk between the two. On the other hand, the second method of waterfall distributes profits first to investors until they get back their capital and preferred returns, and then starts distributing profits to the sponsor, effectively minimizing the risk to the investor, and increasing the risk to the sponsor.
Inputs are always depicted with a yellow fill while calculations are depicted with white fill and black characters.
There is also color coding for the various tabs of the model. Yellow tabs are mostly assumptions tabs, and light blue tabs are admin tabs (for example: the cover page).
Similar Products
Other customers were also interested in...
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
Quantity Surveyor / Architect – Project Fina...
This Project Feasibility Model is purpose-built to assist Quantity Surveyors, Architects, Developers... Read more
Capital Budgeting Model Excel Template
Capital Budgeting consists of a process that companies use for decision making on investment project... Read more
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements (profit & loss, balance ... Read more
Leveraged Buyout (LBO) Model
Leveraged Buy Out (LBO) Model presents the business case of the purchase of a company by using a hig... Read more
Mergers and Acquisition (M&A) Financial Model
Merger and Acquisition Model template consists of an excel model which assists the user to assess th... Read more
Operating Company Financial Model
Operating Company Model consists of an Excel model which allows the user to generate forecast financ... Read more
Cash Budget Model
Cash Budget Excel Model generates a simple cash forecast based on a series of assumptions, and compa... Read more
Options and Real Options Model Template
Options and Real Options model consists of an Excel model which presents a valuation framework calcu... Read more
Inventory Dashboard Model Template
!! Kindly use the latest Microsoft Excel Version before purchasing the model, otherwise, the dynamic... Read more
You must log in to submit a review.