Portfolio returns to model in Excel
€30-250 EUR
Paid on delivery
Given a portfolio of 20 private equity company shares, I would like you to build an Excel spreadsheet, that will help decide what's the optimum strategy, with regards to participating to follow-on rounds of financing or not.
Each company have 3 rounds of financing (1M€ to which we participate + 5M€ to which we participate depending on the portfolio strategy + 10M€ to which we never participate), each time dilutive of 20%.
Please compute - showing step by step - the expected returns, of the following strategies (with a total starting cash of 1M€ to invest in total) :
- We invest 25% in rounds 1 and the rest we systematically follow-on on 1 subsequent round for all portfolio companies, to keep a 20% ownership after round 2 ;
- Zero follow-on on any subsequent round, i.e. we invest 50k€ in the 20 companies ;
- We invest 25% in rounds 1 and the rest in Follow-on on 1 subsequent round for the top exit 5 companies (companies A/B/C/D/E) ;
- We invest 25% in rounds 1 and the rest in Follow-on on 1 subsequent round for an average pick of 5 companies.
The companies exit (for 100% of the equity) at the following values, after the round 3 of financing (in $M):
Company A € 2 400
Company B € 850
Company C € 650
Company D € 350
Company E € 150
Company F € 100
Company G € 50
Company H € 50
Company I € 50
Company J € 25
Company K € 25
Company L € 15
Company M € 15
Company N € 15
Company O € 15
Company P € 10
Company Q € 10
Company R € 10
Company S € 10
Company T € 5
Company L € 5
Company M € 0
Company N € 0
Company O € 0
Company P € 0
Company Q € 0
Company R € 0
Company S € 0
Company T € 0
Please note that the % given to a round/decision should be changeable in your model, so that I can play with the numbers.
Please ask me the relevant questions that allow you to start & finish this task, as there might be some missing information for you.
Thanks for reading me.
Project ID: #19327432
About the project
23 freelancers are bidding on average €153 for this job
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the pro More
Msc computer science. MBA accounts and finance. Mphill in statistics. having seven years of experience in Excel vba and Excel macros. I already done many Excel complex projects like: Excel models designing. Exce More
I have expertise model in excel . Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
Hello. I have good skills in "Data Entry, Data Processing, Excel, Finance, Financial Analysis". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description More
Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from cli More
I have many experiences in ACCESS, Excel VBA developing and data mining. I'm software engineer and algorithm expert. Your task is suitable with me. I'm also perfected in C, C++, C#, SQL, PHP .... Regard your good .
We are good worker here send details I will do the job here with in 3 days only we completely work
After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I am an expert in Microsoft Excel, Document Processing, Copy Typing, Data Entry. All output o More
I have done a research on mutual funds returns. So if it's a time series data, I would be able to analyse Relevant Skills and Experience Microsoft excel, basic statistical skills
Hello Sir/Madam Hope you are in good condition. I’m interested with the job description that been offered, which is “Portfolio returns to model in Excel”. I have an experience in learning this during my study. Fur More
Hey there, please share your missing project details. I can do your project efficiently in the given time frame.
Expertise in excel, tally ,data entry Relevant Skills and Experience Accounting and taxation