rajiv_bishnoi
New Member
- Joined
- Jan 13, 2008
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Dear all,
I am trying to compute carry or performance fee for a hypothetical fund.
The performance fee or carry is 20% of total profit, provided
1) Hurdle rate or threshold is met
2) High water mark (HWM) clause, i.e. no performance fee is paid unless the net asset value (NAV) for this period is higher than previous HWM.
https://www.dropbox.com/s/1yyr22tejju1hfy/Circular_Carry.xlsx?dl=0
It works quite well, if the circular refernce is allowed. However, I am trying to understand if there is a way to avoid this circular reference somehow, either by using an alternate formula or some macro (copy/paste with loop, etc.)
Any help would be appreciated.
regards
RB
I am trying to compute carry or performance fee for a hypothetical fund.
The performance fee or carry is 20% of total profit, provided
1) Hurdle rate or threshold is met
2) High water mark (HWM) clause, i.e. no performance fee is paid unless the net asset value (NAV) for this period is higher than previous HWM.
https://www.dropbox.com/s/1yyr22tejju1hfy/Circular_Carry.xlsx?dl=0
It works quite well, if the circular refernce is allowed. However, I am trying to understand if there is a way to avoid this circular reference somehow, either by using an alternate formula or some macro (copy/paste with loop, etc.)
Any help would be appreciated.
regards
RB
Last edited: