2.2.3 Dashboard
- Support
The Portfolio Dashboard grants an overview over the selected portfolio and includes several graphs and tables with the most important figures. Portfolio A always represents the reference versions that have been previously selected. Portfolio B represents the comparison versions.
The main KPIs are shown in the Dashboard Table (see screenshot below). The individual entries are calculated as described below:
Projects in Portfolio: Based on how many projects have been added to the portfolio
MW in Portfolio: The MW sum of all projects in the portfolio
NAV @ Hurdle Rate: Remaining cashflows to Equity of all projects at the specific date discounted at Hurdle Rate (which is selected in each individual project)
NAV @ Effective Equity IRR: Remaining cashflows to Equity of all projects at the specific date discounted at effective equity IRR
Net Present Value: Difference between the two NAVs at the different discount rates
⌀ Lifetime: Average Lifetime of the different projects in the portfolio. All projects are equally weighted
⌀ P-Value: Average Lifetime of the different projects in the portfolio. All projects are equally weighted
IRR (Adjusted Free Cashflow): For each months, all adjusted free cashflows of each individual project are aggregated. Thereafter, IRR is calculated on the aggregated cashflows, just as it is done for an individual project
IRR (Cashflow to Equity): For each months, all cashflows to equity of each individual project are aggregated. Thereafter, IRR is calculated on the aggregated cashflows, just as it is done for an individual project
IRR (Payout): For each months, all payout cashflows of each individual project are aggregated. Thereafter, IRR is calculated on the aggregated cashflows, just as it is done for an individual project
Distribution by Technology and Country
Below graphs show the distribution of the portfolio by technology and country. In below example, there are 4 Wind and one PV project in the portfolio. Out of those projects, 6 are located within Germany. One is located in Spain.
IRR Distribution
Under IRR Distribution you get an overview over the performance of the portfolio. In the table on the left, the Y-Axis indicates the MW of the individual projects in the portfolio, The portfolio can be changed in the left-top sector of the graph, by clicking on either Portfolio A or Portfolio B.
The X-Axis indicates the IRR. It is possible to chose which IRR should be indicated. With the dropdown in the bottom of the graph you can switch between Project, Equity and Payout IRR. The colors indicate either the Country or the Technology of the individual projects, depending on what is chosen as legend in the top-right sector of the graph. The pointed blue line represents the average IRR of the portfolio. Overall, this graph is used to quickly perceive whether a project in the portfolio performs better / worse than average and also indicates (by the MW) which asset contains the highest risk. If you click on a point in the graph you will see the projects name, MW and IRR.
In the table on the right you have an aggregated view on the project IRRs. The table indicates how many projects reach a certain IRR. Again, you can switch the legend to either Country or Technology.
Payout
The Payout graph indicates the Investment, Payout and Cumulative Payout of all the projects in the portfolio. In the graph view, all the cashflows are aggregated. In dark blue are the aggregated investments of each individual project, in yellow are the aggregated Payouts, and the golden are indicates the cumulative payout. You can also switch to table, in which case you will also see the cashflows of the individual projects on a non-aggregated basis. Both table and graph can be shown on a yearly, quarterly and monthly basis and can be indicated for each portfolio.
Liquidity planning
The liquidity planning section indicates any Liquidity Trap, liquidity gap as well as the liquidity on portfolio level. If you switch to table, you can see the Liquidity Trap, Liquidity Gap and Liquidity of the individual assets.
