Private Markets Pacing Model (BETA)

• Deterministic model based on the Takahashi and Alexander model.
• Comprehensive Fund Tracking – Monitor individual fund and asset class performance with dedicated tracking tabs.
• ‍Rolling Forecast Updates – Updates projections based on actuals
• ‍Long-Term Commitments Planning – Supports unlimited investments with visibility through 2055 (expandable).
• Range of dashboards - Aids aid analysis of performance, cash flow, exposures as well as drill down to individual funds.
• ‍Flexible Asset Classes & Pacing Structures – Let's you define at least 10 different asset types and 10 pacing structures for contributions and distributions, growth, with option to override default settings.
• ‍Built-in Checks & Balances – Ensure data accuracy and model integrity with robust validation rules.
• Advanced Goal-seek and Solver features - Helps to speed up analyst work.
• UX for fast long-term planning - dedicated tabs to easily set-up hundreds of commitments to build a really long-term plan across multiple strategies.

Inputs Per Commitment / Investment:

• Investment details (Name, Vintage, Commitment Size, Strategy (Asset Class, Investment Type, Geo), Sponsor)
• Growth & Yield Assumptions (Projected Growth Rate, Fund Life, Distributions)
• Quarterly Actuals for Capital Calls & NAV

Other Inputs:

• Default Call, Growth & Distribution Pacing Assumptions (Takahashi & Alexander model)
• Target allocations across Asset Classes, Geo Split and Private vs Public split
• Public market portfolio and assumptions

Outputs:

• Report of Actuals
• Allocation weights dashboard
• Cashflow dashboard
• ‍Time Series of KPIs for actuals and Projected variables (TVPI, DPI, IRR, and Net Cash Flow)
• Projected vs. Actual Variance Analysis (Coming soon)
• Cumulative Cash Flows & Unfunded Commitments

‍

This financial model ("Model") has been prepared solely for illustrative and informational purposes. It is provided to the recipient ("User") on an "as-is" basis and is subject to the following terms:

Acceptance of Terms: By using the Model, the User acknowledges and agrees to these terms.

No Liability for Errors or Omissions: While every effort has been made to ensure the accuracy of the Model, the author makes no representations or warranties, express or implied, regarding the completeness, accuracy, or reliability of the Model, its calculations, or its assumptions. The User assumes full responsibility for verifying the Model's outputs and ensuring their applicability to the User’s specific circumstances.

Assumptions: The Model relies on assumptions, estimates, and projections provided by the User or based on publicly available information. The author does not guarantee that these assumptions will be realized or that the results will align with future outcomes. Any reliance on these assumptions is at the User's own risk.

No Professional Advice: This Model is not intended to provide financial, legal, tax, accounting, or investment advice. Users should seek independent advice from qualified professionals before making any decisions based on the Model.

Limitation of Liability: Under no circumstances shall the author be liable for any direct, indirect, incidental, consequential, or punitive damages arising out of the use of or reliance on the Model, including but not limited to financial losses, business interruptions, or loss of profits.

Improper Use: The author accepts no liability for any consequences resulting from improper use of the Model or alterations made by the User or third parties.

No Guarantee of Outcomes: The Model does not guarantee any particular outcome, including but not limited to successful fundraising, credit approvals, or project feasibility.