Graphs


Graphs

The graphs section shows different figures. For example the Cashflow Waterfall or Uses & Sources of liquid assets.

Internal CF Waterfall

 The Cashflow Waterfall shows the Cash-out positions related to the Net Sales of electricity.


The Cashflow Waterfall shows all Cash-out positions related to Net Sales. Cash-out positions are Redemption payments on Shareholder Loans, Payouts, Reserves (internal), Redemption payments on Debt, Debt interests, Capex (internal), Taxes, Opex (internal) and Open Items (internal). Furthermore the Cashflow Waterfall shows changes in Liquidity Traps and Gaps.


Presentation Possibilities
Graph

Data is shown as graph

Table

Data is shown as table (unit: in 1'000 or 1)

Time Period
YearData is shown on yearly basis.
QuarterData is shown on quarterly basis (3 months).
MonthData is shown on monthly basis.

Graphical Representation

The graph shows the use of operative Cash-Ins.

In the example graph there are liquid assets build during the first three years. But they can't be distributed because of Payout Restrictions. In year four there are Payouts. The liquid assets previously built are distributed now.



Internal CF Waterfall ( ∑ )

 The Internal Cashflow Waterfall ( ∑ ) shows the accumulated Cash-out positions related to the accumulated Net Sales of electricity.


The accumulated Cashflow Waterfall shows the accumulated Cash-out positions related to the accumulated Net Sales. Cash-out positions are Redemption payments on Shareholder Loans, Payouts, Reserves (internal), Redemption payments on Debt, Debt interests, Capex (internal), Taxes, Opex (internal) and Open Items (internal).


Presentation Possibilities
Graph

Data is shown as graph

Table

Data is shown as table (unit: in 1'000 or 1)

Time Period
YearData is shown on yearly basis.
QuarterData is shown on quarterly basis (3 months).
MonthData is shown on monthly basis.

Graphical Representation

This graph shows the accumulated Cash-Out positions and the accumulated Sales of the internal Cashflow Waterfall (compare graph internal Cashflow Waterfall).


Uses & Sources

 Uses & Sources show the source from external funds and their use.


The source shows the origin of external assets. Possible sources are Equity, Debt, Shareholder Loans and Liquidity Funding for External Financing. The use shows the usage of the external assets. Possible uses are required Liquidity for External Financing, Opex (external), Capex (external), reserves (external) and Open Items (external).


Presentation Possibilities
Graph

Data is shown as graph

Table

Data is shown as table (unit: in 1'000 or 1)

Time Period
YearData is shown on yearly basis.
QuarterData is shown on quarterly basis (3 months).
MonthData is shown on monthly basis.

Graphical Representation

In the example graph there are external financed Capex and Liquidity for external financing covered by Equity in the first Period. In the next Period, Debt is raised to cover external financed Capex, Liquidity for external financing and external financed Opex. In the third Period the Liquidity Funding is used for external financed Capex.


Uses & Sources ( ∑ )

 Uses & Sources ( ∑ ) show the source from accumulated external funds and their accumulated use.


The accumulated source shows the origin of external assets. Possible sources are Equity, Debt, Shareholder Loans and Liquidity Funding for external financing. The accumulated use shows the usage of the external assets. Possible uses are required Liquidity for external financing, Opex (external), Capex (external), reserves (external) and Open Items (external).


Presentation Possibilities
Graph

Data is shown as graph

Table

Data is shown as table (unit: in 1'000 or 1)

Time Period
YearData is shown on yearly basis.
QuarterData is shown on quarterly basis (3 months).
MonthData is shown on monthly basis.

Graphical Representation

The graph shows the accumulated source and the accumulated use of the Uses & Sources graph (compare graph Uses & Sources).


CFs

 The Cashflow graphic shows the different Cashflows.

The Cashflow graph shows the different Cashflows (Adjusted Free Cashflow, Cashflow to Equity and Payout) over the Project Lifetime.


Presentation Possibilities
Graph

Data is shown as graph

Table

Data is shown as table (unit: in 1'000 or 1)

Time Period
YearData is shown on yearly basis.
QuarterData is shown on quarterly basis (3 months).
MonthData is shown on monthly basis.

Graphical Representation

The graph shows if positive or negative Cashflows are generated.


CFs ( ∑ )

 The Cashflow graph ( ∑ ) shows the different accumulated Cashflows.


The Cashflow ( ∑ ) graph shows the different accumulated Cashflows (Adjusted Free Cashflow, Cashflow to Equity and Payout) over the Project Lifetime.


Presentation Possibilities
Graph

Data is shown as graph

Table

Data is shown as table (unit: in 1'000 or 1)

Time Period
YearData is shown on yearly basis.
QuarterData is shown on quarterly basis (3 months).
MonthData is shown on monthly basis.

Graphical Representation


The graph shows if the accumulated Cashflow are positive or negative. The transition from negative to positive Cashflows shows the Break Even point of each Cashflow.


DSCR

 The DSCR graph shows the DSCR and the required Minimum DSCR value which has to be reached to make Payouts.


The graph DSCR shows the Debt Service Coverage Ratio (DSCR) and the Minimum DSCR which has to be reached to make Payouts in the particular Period.


Presentation Possibilities
Graph

Data is shown as graph

Table

Data is shown as table (unit: in 1'000 or 1)

Time Period
YearData is shown on yearly basis.
QuarterData is shown on quarterly basis (3 months).
MonthData is shown on monthly basis.

DSCR Calculation: DSCR = internal financed components of the operative Cashflow(t) / Debt Service referred to the Look Back Period

Graphical Representation

In the example graph the Minimum DSCR is violated in several years. Thus there are no Payouts in those years.


Liquidity

 The Liquidity graph shows the available liquidity, liquidity required for external financing and liquidity gaps.

This Liquidity graph shows the any Liquidity Gap (not enough liquidity to run the project at this specific date), Liquidity Trap (project trapped in the portfolio when it is not needed), Future External Financing Need (as example for a replacement of a production unit) and the Minimum liquidity profile (can be changed in the Transaction tab). 

Liquidity gaps arise when internal financed cost entities can't be covered with current cashflows. Internal financed cashflows are internal Opex, Capex, Reserves and Transaction Expenditures as well as Taxes. Therefore a liquidity gap arise when the sales aren't sufficient to cover the internal financed cost entities. Liquidity gap = Cashflow to Equity - Equity - Shareholder Loan