Fixed Price: Not Sure
| Posted: 1h, 8m ago | Ends: 22h, 51m |
We need assistance with an excel form on calculations. We currently have two forms that calculate fees, but need a logical statement defined in excel that we are unsure how to do. I have attached the excel form that we are using and we need to the following performed. Take a value and calculate a fee based off of several variables. There is a pricing grid structure that is scaled off of value, we call this tiered. For the basic setup the fee is X*Y to get Z where X = AUM and Y = Fee percentage and Z = Dollar Fee. Our pricing Grid is 0-250k is 1.50%, 250,001 - 500k is 1.25%, 500,001 1,000,000 is 1%, etc... We need to first check what the value of X is, if X is 350,000 we need to take the first 250,000 and multiple that by .015 then take the remainder value (100,000) and multiple that by .0125. We then need to add both of those values together to get a total management fee. Since this is a tiered structure you must always take what the amount of each segment is and use the %fee to...