Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stepped fee calculation
Here's the situation:
Revenue = $2,800,000 I have the following fee schedule: First $1,000,000 = 0% of Revenue Next $500,000 = 5% of Revenue Next $500,000 = 6% of Revenue Next $500,000 = 7% of Revenue Next $500,000 = 8% of Revenue Over $3,000,000 = 9% of Revenue What formula would I write where it looks at the Revenue and then applies the fee schedule? In this case, the result should be $$114,000. Thanks for taking a look! |
#2
|
|||
|
|||
Your web site is just what I was looking for. Thanks so much!
"JE McGimpsey" wrote in message ... Take a look he http://www.mcgimpsey.com/excel/variablerate.html In article , "Betty Csehi" wrote: Here's the situation: Revenue = $2,800,000 I have the following fee schedule: First $1,000,000 = 0% of Revenue Next $500,000 = 5% of Revenue Next $500,000 = 6% of Revenue Next $500,000 = 7% of Revenue Next $500,000 = 8% of Revenue Over $3,000,000 = 9% of Revenue What formula would I write where it looks at the Revenue and then applies the fee schedule? In this case, the result should be $$114,000. Thanks for taking a look! |
#3
|
|||
|
|||
This reminds me very much of an income tax calculation.
< 1,000,000 0 1,000,000 < 1,500,000 # - 1,000,000 * 0.05 1,500,000 < 2,000,000 # - 1,500,000 * 0.06 + 500,000 * 0.05 2,000,000 < 2,500,000 # - 2,000,000 * 0.06 + 500,000 * 0.06 + 500,000 * 0.05 And so on. "Betty Csehi" wrote: Here's the situation: Revenue = $2,800,000 I have the following fee schedule: First $1,000,000 = 0% of Revenue Next $500,000 = 5% of Revenue Next $500,000 = 6% of Revenue Next $500,000 = 7% of Revenue Next $500,000 = 8% of Revenue Over $3,000,000 = 9% of Revenue What formula would I write where it looks at the Revenue and then applies the fee schedule? In this case, the result should be $$114,000. Thanks for taking a look! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |