Hello!
I'm attempting to calculate a performance-based fee based on Excess Returns. I have a table of fees that would apply to each return, given the under/over performance from the index:
I've attempted to use the =CHOOSE function and can get as far as results when there's only one argument (i.e. using >= ), but for those instances where we under-performed index (-4.22%, -7.07%), it returns a #VALUE. If there's a way to combine >= and <= or maybe add a secondary function to get a result from the Perf/Fee table on every +/- return, that would be great. Or maybe I'm using the wrong combination of functions from the beginning and there's a better alternative.
Any guidance is much appreciated, thank you!
I'm attempting to calculate a performance-based fee based on Excess Returns. I have a table of fees that would apply to each return, given the under/over performance from the index:
| Perf | Fee | Return | Index | Excess Return | ||
-0.05% | 0.60% | 29.62% | 10.30% | 19.32% | ||
-0.50% | 0.70% | 25.34% | 29.57% | -4.22% | ||
0.50% | 0.80% | 30.20% | 0.08% | 30.12% | ||
1.50% | 0.90% | -2.61% | -8.14% | 5.53% | ||
2.50% | 1.00% | -49.33% | -42.26% | -7.07% | ||
3.50% | 1.10% | -2.18% | 19.11% | -21.30% | ||
4.50% | 1.20% | -19.81% | -25.16% | 5.35% | ||
5.50% | 1.30% | -58.42% | -72.30% | 13.87% | ||
6.50% | 1.40% | -13.96% | -33.63% | 19.67% | ||
142.19% | 131.73% | 10.47% | ||||
35.90% | 80.75% | -44.85% | ||||
37.62% | 17.62% | 20.00% |
I've attempted to use the =CHOOSE function and can get as far as results when there's only one argument (i.e. using >= ), but for those instances where we under-performed index (-4.22%, -7.07%), it returns a #VALUE. If there's a way to combine >= and <= or maybe add a secondary function to get a result from the Perf/Fee table on every +/- return, that would be great. Or maybe I'm using the wrong combination of functions from the beginning and there's a better alternative.
Any guidance is much appreciated, thank you!
