Tiered Fee Calculator

    Hi All,


    I am trying to put together a fee calculator for use on investment products. I am getting stuck with some of the tiered products offered in the market.


    eg. Fee is calculated as:


    $0-$100,000 - 0.65%
    $100,000-$200,000 - 0.55%
    $200,000-$500,000 - 0.45%
    etc.


    In this instance, an account value of $150,000 would be charged thus:
    $100000 - $650
    $50,000 - $275


    For one product, I can probably use a basic IF function. Does anyone know how to calculate the fee across multiple products, using differing fee structures?


    Regards,
    Andrew

    Re: Tiered Fee Calculator


    Hi Broady,


    Have a look at the attached worksheet. I have used a table for the charges in cells A2:B4. I have then used a Named Formula for the Charge, called 'Charge'. It means that you can type a value anywhere in the Spreadsheet and one cell to the right type =charge and it will give you the charge for that value.


    Bill

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login