Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Next »

Step 1: Output Total Portfolio

This detailed report allows to drill into the details.

  • Identify top performing funds per metric

  • compare the performance by fund breakdown category

  • Identify sub-categories e.g. Tech Europe

It shows the key data of each individual fund and allow to aggregate by multiple dimensions.

Step 2: Charts

The Charts-Step visualize for the investor

  1. Composition of the portfolio performance

  2. Value development over time

  3. Cashflow overview

Chart 1: Development of value

  • Composition of the portfolio performance

  • on individual fund level

  • investment vehicle

  1. The first chart is a waterfall as we have seen it on the “investor report earlier”

    1. Aggregate portfolio

    2. select Investment vehicle

      1. show the dropdown, do not choose

    3. select a single fund like Cherry 3

    4. Switch back to Fund “aggregate Portfolio”

    5. Next

  2. Next

Chart 2: Aggregate Portfolio Development

Value development over time and the projected NAV and distribution

  • This report show the development of the portfolio

  • Cash flow projections are important to plan liquidity

  1. Up to the last reported quarter

    • Grey: the NAV of the invested companies

    • Blue the cumulative distributions

    • red line: cumulative contributions

  2. after last reported quarter: projections

    • This projection is based on the current portfolio, assuming there are no new funds added.

    • The projection is based on the Takahashi-Alexander Model, also know as the Yale model. The model requires to define for each fund a distributions and contribution model.

    • The projection can be fine tuned by the LP or the data can also be purchased of dataprovider like Prequin.

For more details to the projection methods consult Projection Methods

Chart 3: Cash Flow Overview

The Cash Flow Overview Chart shows the development of the total

  • distributions (blue) and

  • contributions (red) and the

  • Net invested capital (grey) - the J curve

Step 3: Actuals

The value of actuals reports are the ability to investigate further - after the fairly high level Charts.

Actuals 1: Summary

If you would like dive deeper into the data, in the next report the data is listed in a table.

  1. Possible actions

    1. Change “years actuals” from 5 to 10

    2. Crossdrill on “Distributions” in the “Actuals EUR” Table by “Geography”
      open DACH and show the Papaya funds to be found

    3. Show “Investment Vehicle” drill down

  2. Find out what funds contributed to the Q3 distributions:
    right-click on row header and “drill-down” by Fund

  3. “Last Quarter YoY” Card compares the Year over Year development

  4. “Normalized Investment Performance” reports the created value add by the fund.
    see Glossary

Actuals 2: Aggregate Portfolio Overview - Actuals

nearly the same report as the one before, instead of quarter - on focus on years

This shows that the data can be structured diferently

Step 4: Region and Sector analysis

This report allows to understand the geographical and sector allocation and in what industries the capital is invested

  1. Aggregate Portfolio per Breakdown

  2. Pie Chart per Breakdown

  3. Cluster Diagram per breakdown

All the funds have been decomposed to show their share in the different regions

Region Breakdown

  1. Potential actions:

  2. Choose Mango 11 to show the split up

    • Drill into Europe to show the DACH hierarchy

  3. Switch back “fund” to aggregate portfolio

  4. next

Sector breakdown

Step 5: Projections

Projections are a tricky business, however having a model in place help to articulate expectations and allows to plan cash-flows more reliably.

The solution supports various projection capabilities.

Projections I

the projection of the cash-flow and the portfolio value for the coming quarters

  • Explain the “Mesure” column items

  • Change the “years projections” to 5 years

(question)

  • why decreases Projected NAF and Distribution in the future quarter?

  • what are “projected capital calls”? Contributions? warum nicht einheitlich

Projections 2: Aggregate Portfolio overview - Projections

the projection of the cash-flow and the portfolio value for the coming years

  • clearly a longterm view with many risks to appear, but based on the historic performance of the asset class.

  • This is the end of the pre-packaged analytical steps in the “Investor reporting”

  • No labels