# Portfolio returns to model in Excel

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.

Aptitudini: Introducere date, Procesare date, Excel, Finanțe, Analiză financiară

Despre angajator:
( 6 recenzii ) luxembourg, Luxembourg

ID Proiect: #19327432

## 23 freelanceri licitează în medie 153€ pentru acest proiect

javed1705

Sir, i have done the same work many times. I have few questions, you donot want optimal portfolio with maximum return and minimum risk. Or you are giving fixing your weights. I am a qualified professional accountan Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(489 recenzii)
7.7
schoudhary1553

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. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 4 zile
(317 recenzii)
7.9
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agree Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 5 zile
(123 recenzii)
7.2
elqueabandona

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 5 zile
(224 recenzii)
6.9
usmanhassan123

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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(74 recenzii)
6.1
axiomswb

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..

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(42 recenzii)
5.9
dvcontact

Hi, You won’t make the right candidate selection without knowing what your project on building Excel spreadsheet that will help in deciding what optimum strategy to follow-on rounds of financing will look like. Fortu Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(46 recenzii)
6.0
tferreira67

Hi there, I believe to be a perfect fit to help you with your Excel Portfolio Model returns project if you are looking for professional work. Please find below my relevant experience and qualifications for your r Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 5 zile
(23 recenzii)
5.7
lightingdavid

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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(59 recenzii)
5.6
hemsingh1

Data Entry, Data Processing, Excel, Finance, Financial Analysis skilled professional with the required expertise. Can help to deliver the solution as needed on the expected lines. Please private message me to discuss t Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(10 recenzii)
3.3
avucetic

Hello, It's exactly what I can do best. l've been working at firms that required strong MS Excel/Word/PowerPoint, data entry, data processing and web research skills, as a business assistant for a few years. I was als Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(5 recenzii)
2.8
IbexEnterprises

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 2 zile
(7 recenzii)
2.1
bluesea1990

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 .

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(1 părere)
1.0
mentor09

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)
0.0
ifk6414

Hello Dear Client As a highly skilled data entry expert, I’ve more than 7 years’ of experience in organizing information, prioritizing tasks and document management. I’ve a passion for accurate data entry. If select Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)
0.0
nathasazetty

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)
0.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)
0.0
fjanzen

Excel Expert and Industrial Engineer with 7 years of experience in Project Management/ Project Finance for major Oil&Gas Projects. Advanced skills in Excel, VBA, Invesment Analysis, Cash Flow Estimation, etc. For mor Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 2 zile
(0 recenzii)
0.0
zikriyazid

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(0 recenzii)
0.0
Helenstuart0

Hello, In my opinion, the key to being successful is consistency. As far as I can remember, I have made a strong effort to be consistent in my work, no matter what the task is. Consistency means showing up every day Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)
0.0