Payout calculations


Inputs

Payout Components:

  • Cashflow to Equity
  • Debt Service Coverage Ratio (DSCR)
  • DSCR Look Back Period
  • Payout Restrictions in Redemption Free Periods

Difference between Cashflow to Equity and Payout

Payout corresponds to Cashflow to Equity after applying all Payout Restrictions. Therefore the Cashflow to Equity corresponds to the Payout potential and the Payout corresponds to the actual Payout. Payout Restrictions include violations of Debt Service Coverage Ratios, Payout Restrictions in Redemption Free Periods and the restriction that payouts are only possible at the end of every year.

Calculations

Profit & Loss statement

No influence

Cashflow statement

 Payouts depend on the Cashflow to Equity.

Cashflow to Equity is calculated as follows:


Sales
-Opex
-Taxes
=Operative Cashflow
-Capex
-Transactional Expenditures
=Free Cashflow
-Debt payouts
-Debt Service
-Reserves
=Cashflow to Equity


The Payout potential yields from the liquidity off the previous period and from the actual Cashflow to Equity. The Payout potential is limited through external financing needs which occur in future periods.

When for example liquid assets of EUR 80'000 from the previous period exists and the actual Cashflow to Equity is EUR 500'000, then the Payout potential is EUR 580'000. But in 12 month there are Capex expenditures of EUR 400'000, so the Payout potential is only EUR 180'000.

 Payouts depend on the Payout Restrictions.
  • The DSCR input serves as Payout Restriction for dividend payments. When the entered ratio is violated there can be no payouts in this period. The DSCR is calculated as follows:

  • There can be a defined Payout Restriction for all Debt Tranches or for individual tranches during the Redemption Free Period. In these years there can be no Payouts.
  • Payouts are only possible in December of the particular year,

Balance Sheet

 Liquidity yields from the Balance Sheet logic.

The Balance Sheet gets calculated from the closing Balance Sheet of the previous period and from the difference between the Profit & Loss statement and the Cashflow statement of the actual period.

Balance Sheet(t) = Balance Sheet(t - 1) + Profit & Loss statement(t) - Cashflow statement(t)

The following example explains this functionality:


∑01.201602.201603.201604.201605.201606.201607.201608.201609.201610.201611.201612.2016
Profit & Loss statement48444444444444
Cashflow statement480012001200120012
Balance Sheet
480480480480

For 06 / 2016 the book value is calculated as follows:

Balance Sheet(06.2016) = 8 + 4 - 12 = 0