Calculating mgt fee and incentive fee

[sillynanny]

Hello,

I am trying to create a formula where it will calculate mgt fee (pretty straight forward) and incentive fee (not so straight forward). Mgt fee is 1%, incentive fee is 15%ytd in excess of a 5% annualized return (hurdle). The incentive fee is based on each year’s capital account appreciation, as reflected in the foregoing formula, but no incentive fee will be made unless the net capital appreciation of a Member’s capital account exceeds any net capital depreciation in the capital account (reduced pro rata for any withdrawals) accumulated in prior years (i.e., a “high water mark”).

Thanks,

 

[StephenCrump]

Some preliminary ground (that might be relevant) was covered here ...

http://www.mrexcel.com/forum/excel-...e-calc-based-hurdle-rate-high-water-mark.html

 

[sillynanny]

i started a new thread, last one got confusing and i could not get anything out of it. Hence, the new thread. I was just hoping the new thread would be simplif