
I need to built an excel template to calcuate PE returns
- or -
Post a project like this$$$
- Posted:
- Proposals: 13
- Remote
- #2499243
- Expired
Wordpress Developer *Full Stack Web Developer * Shopify Developer*PHP* REACT JS

Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!

54870024192372612585264240628769962975387300616330118283013977286276229695042742456




Description
Experience Level: Expert
I would like an excel built for a private equity fund investing in hotel assets to incorporate the following:
The model needs to be fully paramterized and be able to change the inputs. The model should include
- IRR and MOIC for the individual investments and the portfolio as a whole and for the GPs
- Fund Size: €100Million
- Fee Structure: [XX]% Management Fee to GPs which could be reduced after a certain periods of years
- [XX]% carried interest after [XX]% hurdle rate returned to investors
I have prepared the attached model to assist but needs to be professionally made.
The above should include separate DCFs valuations for each asset. I attach a PDF with sample valuations (do not have them in excel I am afraid). This should also be professionally made.
The model should be taking foretasted cash flows and investment inputs from work sheets.
Finally and ideally it should be ease to add new assets and delete old ones possibly using macros
Please let me know if this is something you can do. Time frame (not more than 1 week) and cost.
Thank you!
The model needs to be fully paramterized and be able to change the inputs. The model should include
- IRR and MOIC for the individual investments and the portfolio as a whole and for the GPs
- Fund Size: €100Million
- Fee Structure: [XX]% Management Fee to GPs which could be reduced after a certain periods of years
- [XX]% carried interest after [XX]% hurdle rate returned to investors
I have prepared the attached model to assist but needs to be professionally made.
The above should include separate DCFs valuations for each asset. I attach a PDF with sample valuations (do not have them in excel I am afraid). This should also be professionally made.
The model should be taking foretasted cash flows and investment inputs from work sheets.
Finally and ideally it should be ease to add new assets and delete old ones possibly using macros
Please let me know if this is something you can do. Time frame (not more than 1 week) and cost.
Thank you!

Michael C.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
25%
Last project
4 Oct 2019
France
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hey Michael,
Would you rather prefer this in google sheets?
Please let me know.
thx
A
837871
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