Open calculator ↗

Multi-property sale proceeds waterfall · Calculation guide

Calculate cash available to distribute.

Calculation guide

Pool two property sales. Pay closing expenses and debt, return contributed capital, pay accrued preference, then split the residual profit. Any shortfall is reported separately.

cash = max(0,sale_a+sale_b-costs-debt); returned = min(cash,capital); preference = min(pref,cash-returned); sponsor = (cash-returned-preference)*(1-split/100); investor = cash-sponsor; shortfall = max(0,costs+debt-sale_a-sale_b)

Inputs

First property sale price

Example entry 600000 (in the selected currency).

Second property sale price

Example entry 400000 (in the selected currency).

Combined selling expenses

Example entry 50000 (in the selected currency).

Combined debt payoff

Example entry 500000 (in the selected currency).

Investor capital outstanding

Example entry 300000 (in the selected currency).

Accrued investor preference

Example entry 50000 (in the selected currency).

Investor share of residual profit

Example entry 80 %. Allowed range 0.0 to 100.0.

Worked example

InputValue
First property sale price600,000
Second property sale price400,000
Combined selling expenses50,000
Combined debt payoff500,000
Investor capital outstanding300,000
Accrued investor preference50,000
Investor share of residual profit80%
ResultValue
Cash available to distribute450,000
Investor capital returned300,000
Preference paid50,000
Sponsor distribution20,000
Total investor distribution430,000
Additional cash required at sale0

Calculation steps

Cash available to distribute = max(0, (((First property sale price + Second property sale price) − Combined selling expenses) − Combined debt payoff))

max(0, (((600,000 + 400,000) − 50,000) − 500,000)) = 450,000

Investor capital returned = min(Cash available to distribute, Investor capital outstanding)

min(450,000, 300,000) = 300,000

Preference paid = min(Accrued investor preference, (Cash available to distribute − Investor capital returned))

min(50,000, (450,000 − 300,000)) = 50,000

Sponsor distribution = (((Cash available to distribute − Investor capital returned) − Preference paid) × (1 − (Investor share of residual profit ÷ 100)))

(((450,000 − 300,000) − 50,000) × (1 − (80 ÷ 100))) = 20,000

Total investor distribution = (Cash available to distribute − Sponsor distribution)

(450,000 − 20,000) = 430,000

Additional cash required at sale = max(0, (((Combined selling expenses + Combined debt payoff) − First property sale price) − Second property sale price))

max(0, (((50,000 + 500,000) − 600,000) − 400,000)) = 0

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
First property sale price600,000660,000Cash available to distribute450,000510,000
Second property sale price400,000440,000Cash available to distribute450,000490,000
Combined selling expenses50,00055,000Cash available to distribute450,000445,000
Combined debt payoff500,000550,000Cash available to distribute450,000400,000
Investor capital outstanding300,000330,000Investor capital returned300,000330,000
Accrued investor preference50,00055,000Preference paid50,00055,000
Investor share of residual profit80%88%Sponsor distribution20,00012,000
Multi-property sale proceeds waterfall →