How to calculate CTA monthly Advisor Fee and monthly percentage performance?
Assuming an emerging CTA has the Advisor Fee structure of 0%/10% (0% for management fee and 10% for incentive/performance fee).
Further assuming that:
1. 2007-01-01 --- An investor opened a new account with the CTA and deposited $100K into his new account which was managed by the CTA.
2. 2007-01-05 --- The investor withdrew $10k from his account.
3. 2007-01-10 --- The investor deposited $20k into his account.
4. 2007-01-31 --- The account final balance (Net Liquidation Value which includes everything except Advisor Fee) is $200K.
QUESTIONS:
1. What is the Advisor Fee for January, 2007? ------ Since the investor deposited $100K, withdrew $10K and deposited $20K, so he invested total of $100K - $10K + 20K = $110K. At the end of the month, the account balance (before fee) is $200K, so he made (before fee) $200K - $110K = $90K for the month. So the Advisor Fee will be $90K * 10% = $9K which will be deducted from (and posted to) his account next month (February, 2007). Is this calculation correct?
2. What is the monthly percentage performance for January, 2007? ---
a. Since the investor made $90K (before fee) but there is $9K Advisor Fee to be charged (posted) in next month, so his net gain for January is $90K - $9K = $81K (after fee). But he invested $110K in January, so his return will be $81K/$110K = 73.64%. --- This method may be incorrect (too simplify), since the investor did not deposit $110K all together on 2007-02-01.
b. The method (a) in above is incorrect, since the investor had additional deposit and withdraw during the month, it breaks the month into 3 periods: (from 2007-01-01 to 2007-01-05) & (from 2007-01-05 to 2007-01-10) & (from 2007-01-10 to 2007-01-31), we need to calculate the return for each and all three periods independently. Assuming the return for three periods are r1%, r2% and r3%. The month return will be ((1+100*r1) * (1+100*r2) (1+100*r3) -1) * 100 = R%. But this method is complicate, since we need to know the end value of each period and need to take the Advisor Fee into consideration for each period.
If non of (a) and (b) in above is correct, what is the correct method to calculate monthly percentage performance? Please advice. Thanks.
Assuming an emerging CTA has the Advisor Fee structure of 0%/10% (0% for management fee and 10% for incentive/performance fee).
Further assuming that:
1. 2007-01-01 --- An investor opened a new account with the CTA and deposited $100K into his new account which was managed by the CTA.
2. 2007-01-05 --- The investor withdrew $10k from his account.
3. 2007-01-10 --- The investor deposited $20k into his account.
4. 2007-01-31 --- The account final balance (Net Liquidation Value which includes everything except Advisor Fee) is $200K.
QUESTIONS:
1. What is the Advisor Fee for January, 2007? ------ Since the investor deposited $100K, withdrew $10K and deposited $20K, so he invested total of $100K - $10K + 20K = $110K. At the end of the month, the account balance (before fee) is $200K, so he made (before fee) $200K - $110K = $90K for the month. So the Advisor Fee will be $90K * 10% = $9K which will be deducted from (and posted to) his account next month (February, 2007). Is this calculation correct?
2. What is the monthly percentage performance for January, 2007? ---
a. Since the investor made $90K (before fee) but there is $9K Advisor Fee to be charged (posted) in next month, so his net gain for January is $90K - $9K = $81K (after fee). But he invested $110K in January, so his return will be $81K/$110K = 73.64%. --- This method may be incorrect (too simplify), since the investor did not deposit $110K all together on 2007-02-01.
b. The method (a) in above is incorrect, since the investor had additional deposit and withdraw during the month, it breaks the month into 3 periods: (from 2007-01-01 to 2007-01-05) & (from 2007-01-05 to 2007-01-10) & (from 2007-01-10 to 2007-01-31), we need to calculate the return for each and all three periods independently. Assuming the return for three periods are r1%, r2% and r3%. The month return will be ((1+100*r1) * (1+100*r2) (1+100*r3) -1) * 100 = R%. But this method is complicate, since we need to know the end value of each period and need to take the Advisor Fee into consideration for each period.
If non of (a) and (b) in above is correct, what is the correct method to calculate monthly percentage performance? Please advice. Thanks.