Excel template: Private Asset Cash Flow Pacing Model
- or -
Post a project like this$75
- Posted:
- Proposals: 7
- Remote
- #4148802
- Expired
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
Top UK Based Services Provider | Amazon | Ebay | Etsy | Social Media | Graphic Design | CV
Liverpool
Designer and Developer|WordPress|Shopify|PSD|PHP HTML, JavaScript|WIX| PowerPoint/Keynote| Logo Designing
Berlin
⭐UK's no.1 Graphic Designer ⭐| Expert 2D/3D Render | Video Animator | Web Developer.
London
20989662502171381147858280869487324976046310889716
Description
Experience Level: Entry
We need a flexible Excel template to model private asset cash flows for an institutional investor.
Attached is the critical white paper upon which this model must rest. While the graphs / design in the paper are old, the general outputs are really what we're looking for. All of the necessary formulas and concepts are included here from the original authors.
For our output: we need a (relatively) simple Excel template that can be used by senior management. Here's an example of the scenario:
The university's endowment is currently at $1 billion. The portfolio currently has the following allocations (%) by market value.
Public equity: 25%
Absolute Return: 15%
Fixed Income: 25%
Venture Capital: 10%
Cash: 25%
With the following expectations of growth (capital market assumptions) over the next 10 years:
Public equity: 8%
Absolute Return: 6%
Fixed Income: 4%
Venture Capital: 10%
Cash: 3%
And the VOLATILITY assumptions over the same 10 years:
Public equity: 12%
Absolute Return: 8%
Fixed Income: 5%
Venture Capital: 20%
Cash: 0%
Given the legacy venture capital portfolio, what amount do we need to commit to venture capital each year going forward to reach a new target of 15%?
For the current exposure to venture capital of 10%, for simplicity's sake we can assume there are only two funds, both with an inception of four years ago that have called capital down equally over those four years and have no remaining capital to call down.
------
For reference I've attached the following:
1. white paper on this topic
2. samples of both a complex and simple version of this model
We need a new, bespoke, updated model that has some good looking charts, but more so, is relatively easy to interface with.
Attached is the critical white paper upon which this model must rest. While the graphs / design in the paper are old, the general outputs are really what we're looking for. All of the necessary formulas and concepts are included here from the original authors.
For our output: we need a (relatively) simple Excel template that can be used by senior management. Here's an example of the scenario:
The university's endowment is currently at $1 billion. The portfolio currently has the following allocations (%) by market value.
Public equity: 25%
Absolute Return: 15%
Fixed Income: 25%
Venture Capital: 10%
Cash: 25%
With the following expectations of growth (capital market assumptions) over the next 10 years:
Public equity: 8%
Absolute Return: 6%
Fixed Income: 4%
Venture Capital: 10%
Cash: 3%
And the VOLATILITY assumptions over the same 10 years:
Public equity: 12%
Absolute Return: 8%
Fixed Income: 5%
Venture Capital: 20%
Cash: 0%
Given the legacy venture capital portfolio, what amount do we need to commit to venture capital each year going forward to reach a new target of 15%?
For the current exposure to venture capital of 10%, for simplicity's sake we can assume there are only two funds, both with an inception of four years ago that have called capital down equally over those four years and have no remaining capital to call down.
------
For reference I've attached the following:
1. white paper on this topic
2. samples of both a complex and simple version of this model
We need a new, bespoke, updated model that has some good looking charts, but more so, is relatively easy to interface with.
Zebet M.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
16 May 2024
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Zebet,
Can't see either the White Paper or your samples of both a complex and simple version of this model, which you say is attached to the posting?
1086034
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies