Private Markets Portfolio Model
Budget: $250 – $750 USD
I need a single, sophisticated workbook that captures everything happening inside our private-markets programme—evergreen and closed-end funds in private equity, credit, and infrastructure, plus a hedge-fund sleeve used for liquidity management. The model must let me follow commitments, capital calls, reinvestments, recycling, NAV progression and cash-flow waterfalls while spotlighting three headline metrics: liquidity coverage, yield, and capital appreciation.
I already hold detailed internal transaction files; your structure should ingest those feeds automatically (Power Query, VBA, or another elegant solution) so the model refreshes at the press of a button. From there I want a clean, well-designed dashboard that:
• Summarises exposure by strategy, fund and vintage
• Projects short-term and long-term liquidity needs under configurable scenarios
• Breaks out yield vs. growth contributors across time
• Flags any breach of liquidity-coverage thresholds
Beyond the live view, I need scenario and sensitivity modules—commitment pacing, market drawdowns, delayed exits, fee changes—plus the ability to toggle recycling assumptions to see their effect on IRR and MOIC.
Acceptance criteria
• Fully linked, error-free spreadsheet with transparent assumptions and audit sheet
• Automated upload of internal data sources with no manual copy-paste
• Dynamic dashboards that recalc in under 5 seconds on a standard laptop
• Clear documentation and quick video walkthrough so my team can maintain the file independently
Visual clarity is as important as technical depth; charts, colour coding and navigation should make the model intuitive for both investment staff and senior management. If you have built similar alternative-asset models and can marry rigorous analytics with crisp design, let’s get started.
I already hold detailed internal transaction files; your structure should ingest those feeds automatically (Power Query, VBA, or another elegant solution) so the model refreshes at the press of a button. From there I want a clean, well-designed dashboard that:
• Summarises exposure by strategy, fund and vintage
• Projects short-term and long-term liquidity needs under configurable scenarios
• Breaks out yield vs. growth contributors across time
• Flags any breach of liquidity-coverage thresholds
Beyond the live view, I need scenario and sensitivity modules—commitment pacing, market drawdowns, delayed exits, fee changes—plus the ability to toggle recycling assumptions to see their effect on IRR and MOIC.
Acceptance criteria
• Fully linked, error-free spreadsheet with transparent assumptions and audit sheet
• Automated upload of internal data sources with no manual copy-paste
• Dynamic dashboards that recalc in under 5 seconds on a standard laptop
• Clear documentation and quick video walkthrough so my team can maintain the file independently
Visual clarity is as important as technical depth; charts, colour coding and navigation should make the model intuitive for both investment staff and senior management. If you have built similar alternative-asset models and can marry rigorous analytics with crisp design, let’s get started.