Expense S/S with tiered rates and minimums

Hi All,

New to this forum and would appreciate some help with the below.
Need to create a s/s with tiered expense charges and minimums.

0-100m @ .05%
100m-250m @ .04%
250m-500m @ .03%
500+ @ .02%

I also need to incorporate a minimum annual charge of 30,000 into this calculation.

Thanks in advance for any help.

Hi Oldchippy,

That works fine but I was wondering if there is a formulae which would do the calculation based off the rates etc.

I will need to calculate this daily and retain the historical data.