Quote Originally Posted by FinanceGQ View Post
Sorry, you are correct, the 5% would be applied to only the portion between 4x-5x, then the excess, 0.4x would be multiplied by $1.2M then by 7%.

So if you had a 5.4x multiple, you would multiply 1.0x times $1.2M times 5% ($60,000) + 0.4 times $1.2M times 7.5% ($36,000) for a total fee of $96,000.

My apologies for the confusion.

I'm trying to build on this concept and I think the additional variable is throwing me off.

http://www.excelforum.com/excel-form...mula-help.html
Ok. I'm at kids soccer atm. Will come back and look later today