Optimal Cost Structure Help

diarrheaplanet

New Member
Joined
Jun 26, 2016
Messages
15
Hey guys!

Been busting my head trying to do something in Excel; but haven't been able to reach a satisfactory procedure.

So here's the case, on bullets:

1) We have to open a fund to handle our investments. Each fund has a cost of $15,000 for opening, and each one can handle twenty investments
2) On each investment, an infinite number of investors can invest; yet, we don't expect the number of investors to exceed 20 per investment
3) Each investor invests $50,000 on average
3) For every investor that participates in one investment, the fund charges us $2,000 to register him
4) Also, the fund charges us 1.5% of the total amount raised per investment, to handle each investment
5) For each investment, we charge a 8% fee of the total raised
6) We also have fixed costs per month of around $300k
7) The 8% that we charge should be able to cover all the costs from the fund and our fixed costsBasically, that's the standard workings of the fund, yet; given that we're a new client and they'd like to work with us, that told us we could propose a cost structure that would benefit us the most. What I've been playing with is, leaving out the $2,000 registration fee, or leaving out the 1.5% fee from funds raised. Or, seeing if maybe it's better to offer them a higher % fee of funds raised but leave out the $2,000 fee.

I would like to determine what would be the optimal scenario that would help us cover our fees (Ex: You need 15 investors, investing 70k each, and getting charged only 1% from the fund to be able to cover the costs).

Been trying to run a few data tables, but since there are so many variables, I've gotten a bit stuck in my analysis. The other thing I thought about was maybe using NORMINV function to create a portfolio and a statistical distribution and optimize the structure using solver.

Any ideas appreciated, I could also share what I've been working on so far.

Many thanks!
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,214
Messages
6,170,774
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top