Waterfall Section

---

Transcript

---

Welcome to this video. In this video, I will cover the waterfall section in the ARGUS Multi-Family Model. Waterfall is a terminology of a profit-splitting structure between general partners and limited partners.

Waterfall Assumptions

I am going to say the cash is distributed on a quarterly basis. The maximum number of tiers is 5 here in the ARGUS Multi Family Model. If I input 5 tiers, I can see 5 tiers are activated at the Annual Waterfall tab. If I change it to 2, only 2 tiers are activated. The preferred return is 8%. Preferred return is similar to the interest on the capital deployed. HC capital contributes 10% of the equity stack and BBT capital contributes the remaining 90%. Both of them will earn an 8% preferred return on their contribution before the return of their capital and the profit distributed through different tiers.

The preferred return is accumulative rather than compounding. If a preferred return is missed due to a temporary lack of cash flow. The missed amount will simply be carried forward. For the compounding preferred return, the interest on the missed amount will also need to be paid. If the preferred return is met, then the first-tier kicks in. Before the BBT Capital, which is the limited partner, reaches 12% IRR, the cash flow is split 30/70 between the general partner and the limited partner. I can see that HC Capital is being disproportionally rewarded as it contributes 10% of the capital stock but receives 30% of the cash flow over the preferred return. This disproportional reward is also called promotion. The waterfall is designed this way to incentivize the general partner to achieve a higher return for the deal. After the BBT Capital reaches 12% IRR, the cash flow will be split 50/50.

Waterfall Cash Flow

Let’s go to the Annual Waterfall tab. I can see how the cash flow is distributed in detail. The preferred return. Return of Capital. The first tier. You can see the second tier if you input 2 tiers here. The return summary of HC Capital and BBT Capital. At last, the promotion summary.

let’s go to the Annual CF Summary tab. I can see the sale is about 31 million dollars. The cost of sale is about 400,000 dollars. Debt repayment is about 12 million dollars. The total cash flow from sale is about 18 million dollars. Everything looks good.

Alright, I have completed the waterfall section in the ARGUS Multi Family Model. Thanks for watching this video. I will see you in the next one.