Royalty formula

[flyto123]

Hi there, I am having trouble coming up with a formula to calculate royalty percentage based on actual sharing of earnings. Here is the following data:

Revenue: $37,500,000
COGS: ($13,632,600)
GM: $23,867,400
Operating expenses: ($4,850,000)
EBIT: $19,017,400
Taxes: 39%
Net Profit: $11,600,614

[AliGW]

Administrative Note:

You have already been told not to duplicate posts.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...royalties.html