build excel model

In Progress Posted 7 months ago Paid on delivery
In Progress Paid on delivery

I am looking for someone to build an excel model that calculates IRR and MOIC (multiple of invested capital) for 35 Preferred Members (investors). Attached is the legal language of how the waterfall flows. I need an IRR and MOIC for each investor by Series. There are four Series - A, B, C and D.

The model should include fields that can be input for Purchase Price, Debt, Broker Fee, Legal & Professional Fees, etc. (see top of spreadsheet attached).

The model should show returns for Preferred Members as well as distributions to Management Members (Founders) and Common Members (Partners).

See attached.

Accounting Excel Finance

Project ID: #37252597

About the project

23 proposals Remote project Active 7 mos ago

Awarded to:

khurram1984

Hi. Thank you for sharing the attached files with required details. I am ranked among Top Business experts with 1000+ project awards and 600+ good reviews on freelancer. I have read your requirements mentioned in the p More

€2000 EUR in 12 days
(439 Reviews)
8.3

23 freelancers are bidding on average €2148 for this job

seaanddream

Hi, my name is Selim. I am the Director of ANC, registered in the UK. I read your "build excel model" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and k More

€2500 EUR in 30 days
(299 Reviews)
8.0
maverick44000

Hello Sir, Being highly skilled in Excel and accounting, I can implement the waterfall model with a weeks time. I am available to start working right away. Please invite for discussion so we may kick off. Thank you, More

€2500 EUR in 6 days
(73 Reviews)
6.9
saliba04

Hello there, this is my process to perform this project: IRR Calculation: Create a Table Enter Cash Flows Use the IRR Function Repeat for Each Investor Format as Percentage MOIC Calculation: Calculate Total Distrib More

€1800 EUR in 7 days
(96 Reviews)
6.0
KirubaNadarajan

❤️Hello there,❤️ Thank you for taking the time to read our proposal. Over 5 years of extensive experience and deep knowledge in Accounting and QB. Once you hire me, I can provide you Great Quality and 100% Complete wo More

€2200 EUR in 3 days
(9 Reviews)
3.8