Graphs
- Former user (Deleted)
- Support
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.
Graphical RepresentationThe 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).
Graphical RepresentationThis 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).
Graphical RepresentationIn 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).
Graphical RepresentationThe 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.
Graphical RepresentationThe 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.
Graphical RepresentationThe 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.
DSCR Calculation: DSCR = internal financed components of the operative Cashflow(t) / Debt Service referred to the Look Back PeriodGraphical RepresentationIn 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
|