Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
panelIconId1f4b2
panelIcon:heavy_dollar_sign:
panelIconText💲
bgColor#FFFAE6

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

Panel
panelIconId1f4b2
panelIcon:heavy_dollar_sign:
panelIconText💲
bgColor#FFFAE6

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 Use “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 Normalized Investment Performance” Performancereports the created value add by the fund.
    see Glossary

Actuals 2: Aggregate Portfolio Overview - Actuals

Panel
panelIconId1f4b2
panelIcon:heavy_dollar_sign:
panelIconText💲
bgColor#FFFAE6

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

...

Region Breakdown

  1. Potential actions:

  2. Choose Mango 11 Fund to show the split up

    • Drill into Europe to show the DACH hierarchy

  3. Switch back “fund” to aggregate portfolionext

...

Sector breakdown

...

Step 5: Projections

Panel
panelIconId1f4b2
panelIcon:heavy_dollar_sign:
panelIconText💲
bgColor#FFFAE6

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

Panel
panelIconId1f4b2
panelIcon:heavy_dollar_sign:
panelIconText💲
bgColor#FFFAE6

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

...

Explain the “Mesure” column items

...

...

...

  • 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

...

  • 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”

...