Calculation guide
The agency takes a percentage of the gross sponsorship fee excluding sales tax. Production is a fixed expense. Net proceeds are before income tax.
Inputs
Gross sponsorship fee offered
Example entry 6000 (in the selected currency).
Agency commission
Example entry 20 %. Allowed range 0 to 100.
Production expenses
Example entry 1200 (in the selected currency).
Target net proceeds
Example entry 4000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Gross sponsorship fee offered | 6,000 |
| Agency commission | 20% |
| Production expenses | 1,200 |
| Target net proceeds | 4,000 |
| Result | Value |
|---|---|
| Net proceeds from offer | 3,600 |
| Gross quote for target | 6,500 |
| Agency fee on offer | 1,200 |
Calculation steps
Net proceeds from offer = ((Gross sponsorship fee offered × (1 − (Agency commission ÷ 100))) − Production expenses)
((6,000 × (1 − (20 ÷ 100))) − 1,200) = 3,600
Gross quote for target = ((Production expenses + Target net proceeds) ÷ (1 − (Agency commission ÷ 100)))
((1,200 + 4,000) ÷ (1 − (20 ÷ 100))) = 6,500
Agency fee on offer = ((Gross sponsorship fee offered × Agency commission) ÷ 100)
((6,000 × 20) ÷ 100) = 1,200
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Gross sponsorship fee offered | 6,000 | 6,600 | Net proceeds from offer | 3,600 | 4,080 |
| Agency commission | 20% | 22% | Net proceeds from offer | 3,600 | 3,480 |
| Production expenses | 1,200 | 1,320 | Net proceeds from offer | 3,600 | 3,480 |
| Target net proceeds | 4,000 | 4,400 | Gross quote for target | 6,500 | 7,000 |
