Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Question for Performance Fee

General questions about using Fund Manager that do not fit into any other forum.

Postby coolspot » Sun Jul 10, 2022 8:43 pm

Hi Mark,

We currently have a portfolio with 0% management fee and 25% performance fee. The fee is paid separately (not deducted from portfolio).

fms.png
fms.png (9.27 KiB) Viewed 395 times


Period 0 1 2 3 4
Managed 20,000 22,176 22,299 22,493 27,479
End HWM 20,000 21,632 22,132 22,403 26,210
Fee 544 167 90 1,269

Total Fee (0-4): 2,070

I have simulate this in excel and the number tally with FMS output. I notice that for the calculation of HWM each period, the way it was calculated is to get the value and reduced it by the fee of the period.

I am still trying to understand why the fee of the period will decrease the HWM. This will make sense if the fee is deducted from the portfolio, so it will have similar effect with addition, or withdrawing of the capital.

Since this is 0% mgmt fee and 25%, the calculation should be straight forward. At the end 4 periods, the cumulative fee should be 25% x (27,479 - 20,000) = 1,870. FMS calculation is 2,070. I suspect that this is caused by the deduction of the fee from HWM.

If my thinking is right, then shouldnt the HWM reduced only when the fee is taken from the portfolio?

Thanks. Looking fwd for some answers.
coolspot
 
Posts: 12
Joined: Fri May 12, 2017 11:14 pm

Postby Mark » Mon Jul 11, 2022 12:48 pm

Hi coolspot,

Are you sure you haven’t withdrawn money from the portfolio? You can create an Investment Transaction report with the filter option to only show portfolio external contributions and withdrawals to verify. I’m out of the office this week, but I will try to reproduce this when I return.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 10531
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby coolspot » Mon Jul 11, 2022 9:53 pm

Hi Mark,

Yes. I am quite sure. That is why the "managed value" is still above the HWM. And the difference, i found, is always equal to the fee at that period.

Thanks!
coolspot
 
Posts: 12
Joined: Fri May 12, 2017 11:14 pm

Postby Mark » Tue Jul 12, 2022 5:13 am

Hi coolspot,

Okay. I’m out of the office until Friday, but when I return I’ll try to reproduce this and get back to you.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 10531
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Mark » Fri Jul 15, 2022 7:50 am

Hi coolspot,

I've had a chance to look into this, and yes, the HWM is calculated assuming you will be paying these fees from the account, and not separately. You can also verify the details in a Management Fee report using "Help / Logs / Report Calculation...". You'll see a line something like this:

HWM ending 3/31/2022 is 10,750.00 (End Value (11,000.00) - Fixed fee (0.00) - Performance Fee (250.00))

If this is an important feature for you, we can look at getting you a test version with an option added to not make this assumption.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 10531
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby coolspot » Mon Jul 18, 2022 12:54 am

Hi Mark,

So my understanding is this:
If the initial number is 100, and it become 200 at the end of the period, using 20% performance fee, the ending managed value will be 200, with HWM of 180. The way to understand this is, the managed value should be 180, but because the fee was not taken out, it is equivalent to a deposit of 20? So the 20 will be new money added to the portfolio.

If this is the case, I can compensate this by taking out the fee (transfering out the money).

Can I confirm that the best way to do this is:
- "Sell" cash for the amount of the last quarter fee on the 1st of next month? So for Q1 fee, I will take the fee on the 1st of April?
- Am I correct to say that whenever Investor wants to withdraw cash, "sell" should always be used for cash account? If that is the case, is there instance when "distribution" is used for cash account?

Thanks,
Chris
coolspot
 
Posts: 12
Joined: Fri May 12, 2017 11:14 pm

Postby Mark » Mon Jul 18, 2022 12:17 pm

Hi Chris,

You could create a new investment called "Management Fees" or something. Add this to the client's portfolio and when they pay the fee record both:

1) Buy of $X for X shares and a price of $1
2) Reinvested Account Fee for -$X and -X shares and a price of $1

This investment will maintain a $0 balance, but keep track of their paid fees. This really is what is happening.

If you don't want to track this at all, we have added a new option for the next release (2022.17.3):

Added a new option for a management fee method using the "% of Ending Value Plus Performance" method: Calculate HWM Assuming Fees Paid Externally. Determines whether fees are deducted from the High Water Mark (HWM) or not.


If you'd like a pre-release of this version, please send me an email.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 10531
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby coolspot » Tue Jul 19, 2022 5:41 am

Hi Mark

Your suggested method is a better workaround. That will work!

Looking forward for the next release.

Thanks!
Chris
coolspot
 
Posts: 12
Joined: Fri May 12, 2017 11:14 pm


Return to General

Who is online

Users browsing this forum: No registered users and 3 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2022 Beiley Software, Inc. All rights reserved.
cron