SQL Utilities/Financial Utility

[BradZ]

Also, I can't quite figure out how it is handing out the revenue sharing $$'s to the lower payroll teams. It doesn't appear to be % based (to either revenue or previous player expenses). There has to be a formula, but at the moment I don't see it

[Andrew]

Throwing some numbers out there from a test I was working on.

The changes I made were:

• Market sizes evenly distributed from 5-8 instead of 3-8
• Revenue sharing. Each team contributes 30% of all income into pool which gets evenly distributed among all teams. Revenue sharing ranged from -$10m to +$11m with Virginia paying the most and Morgantown receiving the most.

Pros:

• Media revenue gap was reduced by ~$13m from $35m to $22m.
• Revenue sharing numbers made sense. Teams in need of the most help got it.

Cons:

• Lack of penalties for large market teams spending to their budget. Because of this the actual gap between large market teams and small market teams remained essentially unchanged. May be worth considering a hard salary cap.

<table x:str="" style="border-collapse: collapse; width: 595pt;" border="0" cellpadding="0" cellspacing="0" width="792"><col style="width: 104pt;" width="138"> <col style="width: 78pt;" width="104"> <col style="width: 57pt;" width="76"> <col style="width: 63pt;" width="84"> <col style="width: 104pt;" width="138"> <col style="width: 78pt;" width="104"> <col style="width: 19pt;" width="25"> <col style="width: 92pt;" width="123"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 104pt;" height="17" width="138">Team</td> <td class="xl25" style="width: 78pt;" width="104">Current Budget</td> <td class="xl25" style="width: 57pt;" align="center" width="76">Old Market</td> <td class="xl25" style="width: 63pt;" align="center" width="84">New Market</td> <td class="xl25" style="width: 104pt;" width="138">Team</td> <td class="xl25" style="width: 78pt;" width="104">Current Budget</td> <td class="xl25" style="width: 19pt;" width="25"></td> <td class="xl25" style="width: 92pt;" width="123">Budget Difference</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Baltimore Bulldogs</td> <td class="xl24" x:num="113502767" align="right">$113,502,767 </td> <td x:num="" align="center">8</td> <td x:num="" align="center">8</td> <td>Baltimore Bulldogs</td> <td class="xl24" x:num="122010000" align="right">$122,010,000 </td> <td>
</td> <td class="xl24" x:num="8507233" x:fmla="=F2-B2" align="right">$8,507,233 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Batavia Muckdogs</td> <td class="xl24" x:num="69275090" align="right">$69,275,090 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Batavia Muckdogs</td> <td class="xl24" x:num="73910000" align="right">$73,910,000 </td> <td>
</td> <td class="xl24" x:num="4634910" x:fmla="=F3-B3" align="right">$4,634,910 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">California Kodiaks</td> <td class="xl24" x:num="100927990" align="right">$100,927,990 </td> <td x:num="" align="center">6</td> <td x:num="" align="center">7</td> <td>California Kodiaks</td> <td class="xl24" x:num="95940000" align="right">$95,940,000 </td> <td>
</td> <td class="xl24" x:num="-4987990" x:fmla="=F4-B4" align="right">($4,987,990)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Carolina Tobs</td> <td class="xl24" x:num="91502548" align="right">$91,502,548 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Carolina Tobs</td> <td class="xl24" x:num="100280000" align="right">$100,280,000 </td> <td>
</td> <td class="xl24" x:num="8777452" x:fmla="=F5-B5" align="right">$8,777,452 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Dallas Snappers</td> <td class="xl24" x:num="110202016" align="right">$110,202,016 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">8</td> <td>Dallas Snappers</td> <td class="xl24" x:num="102740000" align="right">$102,740,000 </td> <td>
</td> <td class="xl24" x:num="-7462016" x:fmla="=F6-B6" align="right">($7,462,016)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Davenport Brawlers</td> <td class="xl24" x:num="86399626" align="right">$86,399,626 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">5</td> <td>Davenport Brawlers</td> <td class="xl24" x:num="81780000" align="right">$81,780,000 </td> <td>
</td> <td class="xl24" x:num="-4619626" x:fmla="=F7-B7" align="right">($4,619,626)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Denver Bulls</td> <td class="xl24" x:num="92823058" align="right">$92,823,058 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Denver Bulls</td> <td class="xl24" x:num="91130000" align="right">$91,130,000 </td> <td>
</td> <td class="xl24" x:num="-1693058" x:fmla="=F8-B8" align="right">($1,693,058)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Hartford Whalers</td> <td class="xl24" x:num="77431952" align="right">$77,431,952 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">5</td> <td>Hartford Whalers</td> <td class="xl24" x:num="75060000" align="right">$75,060,000 </td> <td>
</td> <td class="xl24" x:num="-2371952" x:fmla="=F9-B9" align="right">($2,371,952)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Hyundai Dinos</td> <td class="xl24" x:num="89752209" align="right">$89,752,209 </td> <td x:num="" align="center">6</td> <td x:num="" align="center">7</td> <td>Hyundai Dinos</td> <td class="xl24" x:num="107140000" align="right">$107,140,000 </td> <td>
</td> <td class="xl24" x:num="17387791" x:fmla="=F10-B10" align="right">$17,387,791 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Indianapolis Clowns</td> <td class="xl24" x:num="72115106" align="right">$72,115,106 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Indianapolis Clowns</td> <td class="xl24" x:num="84720000" align="right">$84,720,000 </td> <td>
</td> <td class="xl24" x:num="12604894" x:fmla="=F11-B11" align="right">$12,604,894 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Los Alamos Bandits</td> <td class="xl24" x:num="95267626" align="right">$95,267,626 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">7</td> <td>Los Alamos Bandits</td> <td class="xl24" x:num="98870000" align="right">$98,870,000 </td> <td>
</td> <td class="xl24" x:num="3602374" x:fmla="=F12-B12" align="right">$3,602,374 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Los Lunas Javelinas</td> <td class="xl24" x:num="89329298" align="right">$89,329,298 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">6</td> <td>Los Lunas Javelinas</td> <td class="xl24" x:num="80300000" align="right">$80,300,000 </td> <td>
</td> <td class="xl24" x:num="-9029298" x:fmla="=F13-B13" align="right">($9,029,298)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Maine Guides</td> <td class="xl24" x:num="101928810" align="right">$101,928,810 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">7</td> <td>Maine Guides</td> <td class="xl24" x:num="97820000" align="right">$97,820,000 </td> <td>
</td> <td class="xl24" x:num="-4108810" x:fmla="=F14-B14" align="right">($4,108,810)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Mississippi Storm</td> <td class="xl24" x:num="81261758" align="right">$81,261,758 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Mississippi Storm</td> <td class="xl24" x:num="80360000" align="right">$80,360,000 </td> <td>
</td> <td class="xl24" x:num="-901758" x:fmla="=F15-B15" align="right">($901,758)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Morgantown Mohawks</td> <td class="xl24" x:num="62258528" align="right">$62,258,528 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Morgantown Mohawks</td> <td class="xl24" x:num="69830000" align="right">$69,830,000 </td> <td>
</td> <td class="xl24" x:num="7571472" x:fmla="=F16-B16" align="right">$7,571,472 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Pawtucket Patriots</td> <td class="xl24" x:num="83887479" align="right">$83,887,479 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">7</td> <td>Pawtucket Patriots</td> <td class="xl24" x:num="94580000" align="right">$94,580,000 </td> <td>
</td> <td class="xl24" x:num="10692521" x:fmla="=F17-B17" align="right">$10,692,521 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Philadelphia Freedom</td> <td class="xl24" x:num="100919633" align="right">$100,919,633 </td> <td x:num="" align="center">6</td> <td x:num="" align="center">7</td> <td>Philadelphia Freedom</td> <td class="xl24" x:num="95970000" align="right">$95,970,000 </td> <td>
</td> <td class="xl24" x:num="-4949633" x:fmla="=F18-B18" align="right">($4,949,633)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Pittsburgh Millers</td> <td class="xl24" x:num="76067904" align="right">$76,067,904 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Pittsburgh Millers</td> <td class="xl24" x:num="82630000" align="right">$82,630,000 </td> <td>
</td> <td class="xl24" x:num="6562096" x:fmla="=F19-B19" align="right">$6,562,096 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sin City Gamblers</td> <td class="xl24" x:num="102197525" align="right">$102,197,525 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">8</td> <td>Sin City Gamblers</td> <td class="xl24" x:num="105680000" align="right">$105,680,000 </td> <td>
</td> <td class="xl24" x:num="3482475" x:fmla="=F20-B20" align="right">$3,482,475 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Syracuse Slammers</td> <td class="xl24" x:num="106790075" align="right">$106,790,075 </td> <td x:num="" align="center">8</td> <td x:num="" align="center">8</td> <td>Syracuse Slammers</td> <td class="xl24" x:num="108890000" align="right">$108,890,000 </td> <td>
</td> <td class="xl24" x:num="2099925" x:fmla="=F21-B21" align="right">$2,099,925 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Virginia Colonials</td> <td class="xl24" x:num="117158026" align="right">$117,158,026 </td> <td x:num="" align="center">8</td> <td x:num="" align="center">8</td> <td>Virginia Colonials</td> <td class="xl24" x:num="116060000" align="right">$116,060,000 </td> <td>
</td> <td class="xl24" x:num="-1098026" x:fmla="=F22-B22" align="right">($1,098,026)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Washington Bats</td> <td class="xl24" x:num="114576362" align="right">$114,576,362 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">8</td> <td>Washington Bats</td> <td class="xl24" x:num="116000000" align="right">$116,000,000 </td> <td>
</td> <td class="xl24" x:num="1423638" x:fmla="=F23-B23" align="right">$1,423,638 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Wilmington Wildcats</td> <td class="xl24" x:num="88176895" align="right">$88,176,895 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Wilmington Wildcats</td> <td class="xl24" x:num="87690000" align="right">$87,690,000 </td> <td>
</td> <td class="xl24" x:num="-486895" x:fmla="=F24-B24" align="right">($486,895)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Windy City Playboys</td> <td class="xl24" x:num="87768054" align="right">$87,768,054 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">6</td> <td>Windy City Playboys</td> <td class="xl24" x:num="99040000" align="right">$99,040,000 </td> <td>
</td> <td class="xl24" x:num="11271946" x:fmla="=F25-B25" align="right">$11,271,946 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">Average</td> <td class="xl26" x:num="92146680.625" x:fmla="=AVERAGE(B2:B25)" align="right">$92,146,681 </td> <td class="xl25" x:num="5.416666666666667" x:fmla="=AVERAGE(C2:C25)" align="center">5.42</td> <td class="xl25" x:num="" x:fmla="=AVERAGE(D2:D25)" align="center">6.5</td> <td class="xl25">Average</td> <td class="xl26" x:num="94517916.666666672" x:fmla="=AVERAGE(F2:F25)" align="right">$94,517,917 </td> <td class="xl25"></td> <td class="xl25"></td> </tr> </tbody></table>

[Z]

I don't pay much attention to finances on a macro level. Andrew seems to know what he's doing and how the game works, so I'll defer to him.

[BradZ]

Throwing some numbers out there from a test I was working on.

Spoiler

The changes I made were:

• Market sizes evenly distributed from 5-8 instead of 3-8
• Revenue sharing. Each team contributes 30% of all income into pool which gets evenly distributed among all teams. Revenue sharing ranged from -$10m to +$11m with Virginia paying the most and Morgantown receiving the most.

Pros:

• Media revenue gap was reduced by ~$13m from $35m to $22m.
• Revenue sharing numbers made sense. Teams in need of the most help got it.

Cons:

• Lack of penalties for large market teams spending to their budget. Because of this the actual gap between large market teams and small market teams remained essentially unchanged. May be worth considering a hard salary cap.

<table x:str="" style="border-collapse: collapse; width: 595pt;" border="0" cellpadding="0" cellspacing="0" width="792"><col style="width: 104pt;" width="138"> <col style="width: 78pt;" width="104"> <col style="width: 57pt;" width="76"> <col style="width: 63pt;" width="84"> <col style="width: 104pt;" width="138"> <col style="width: 78pt;" width="104"> <col style="width: 19pt;" width="25"> <col style="width: 92pt;" width="123"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 104pt;" height="17" width="138">Team</td> <td class="xl25" style="width: 78pt;" width="104">Current Budget</td> <td class="xl25" style="width: 57pt;" align="center" width="76">Old Market</td> <td class="xl25" style="width: 63pt;" align="center" width="84">New Market</td> <td class="xl25" style="width: 104pt;" width="138">Team</td> <td class="xl25" style="width: 78pt;" width="104">Current Budget</td> <td class="xl25" style="width: 19pt;" width="25"></td> <td class="xl25" style="width: 92pt;" width="123">Budget Difference</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Baltimore Bulldogs</td> <td class="xl24" x:num="113502767" align="right">$113,502,767 </td> <td x:num="" align="center">8</td> <td x:num="" align="center">8</td> <td>Baltimore Bulldogs</td> <td class="xl24" x:num="122010000" align="right">$122,010,000 </td> <td>
</td> <td class="xl24" x:num="8507233" x:fmla="=F2-B2" align="right">$8,507,233 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Batavia Muckdogs</td> <td class="xl24" x:num="69275090" align="right">$69,275,090 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Batavia Muckdogs</td> <td class="xl24" x:num="73910000" align="right">$73,910,000 </td> <td>
</td> <td class="xl24" x:num="4634910" x:fmla="=F3-B3" align="right">$4,634,910 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">California Kodiaks</td> <td class="xl24" x:num="100927990" align="right">$100,927,990 </td> <td x:num="" align="center">6</td> <td x:num="" align="center">7</td> <td>California Kodiaks</td> <td class="xl24" x:num="95940000" align="right">$95,940,000 </td> <td>
</td> <td class="xl24" x:num="-4987990" x:fmla="=F4-B4" align="right">($4,987,990)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Carolina Tobs</td> <td class="xl24" x:num="91502548" align="right">$91,502,548 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Carolina Tobs</td> <td class="xl24" x:num="100280000" align="right">$100,280,000 </td> <td>
</td> <td class="xl24" x:num="8777452" x:fmla="=F5-B5" align="right">$8,777,452 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Dallas Snappers</td> <td class="xl24" x:num="110202016" align="right">$110,202,016 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">8</td> <td>Dallas Snappers</td> <td class="xl24" x:num="102740000" align="right">$102,740,000 </td> <td>
</td> <td class="xl24" x:num="-7462016" x:fmla="=F6-B6" align="right">($7,462,016)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Davenport Brawlers</td> <td class="xl24" x:num="86399626" align="right">$86,399,626 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">5</td> <td>Davenport Brawlers</td> <td class="xl24" x:num="81780000" align="right">$81,780,000 </td> <td>
</td> <td class="xl24" x:num="-4619626" x:fmla="=F7-B7" align="right">($4,619,626)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Denver Bulls</td> <td class="xl24" x:num="92823058" align="right">$92,823,058 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Denver Bulls</td> <td class="xl24" x:num="91130000" align="right">$91,130,000 </td> <td>
</td> <td class="xl24" x:num="-1693058" x:fmla="=F8-B8" align="right">($1,693,058)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Hartford Whalers</td> <td class="xl24" x:num="77431952" align="right">$77,431,952 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">5</td> <td>Hartford Whalers</td> <td class="xl24" x:num="75060000" align="right">$75,060,000 </td> <td>
</td> <td class="xl24" x:num="-2371952" x:fmla="=F9-B9" align="right">($2,371,952)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Hyundai Dinos</td> <td class="xl24" x:num="89752209" align="right">$89,752,209 </td> <td x:num="" align="center">6</td> <td x:num="" align="center">7</td> <td>Hyundai Dinos</td> <td class="xl24" x:num="107140000" align="right">$107,140,000 </td> <td>
</td> <td class="xl24" x:num="17387791" x:fmla="=F10-B10" align="right">$17,387,791 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Indianapolis Clowns</td> <td class="xl24" x:num="72115106" align="right">$72,115,106 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Indianapolis Clowns</td> <td class="xl24" x:num="84720000" align="right">$84,720,000 </td> <td>
</td> <td class="xl24" x:num="12604894" x:fmla="=F11-B11" align="right">$12,604,894 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Los Alamos Bandits</td> <td class="xl24" x:num="95267626" align="right">$95,267,626 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">7</td> <td>Los Alamos Bandits</td> <td class="xl24" x:num="98870000" align="right">$98,870,000 </td> <td>
</td> <td class="xl24" x:num="3602374" x:fmla="=F12-B12" align="right">$3,602,374 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Los Lunas Javelinas</td> <td class="xl24" x:num="89329298" align="right">$89,329,298 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">6</td> <td>Los Lunas Javelinas</td> <td class="xl24" x:num="80300000" align="right">$80,300,000 </td> <td>
</td> <td class="xl24" x:num="-9029298" x:fmla="=F13-B13" align="right">($9,029,298)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Maine Guides</td> <td class="xl24" x:num="101928810" align="right">$101,928,810 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">7</td> <td>Maine Guides</td> <td class="xl24" x:num="97820000" align="right">$97,820,000 </td> <td>
</td> <td class="xl24" x:num="-4108810" x:fmla="=F14-B14" align="right">($4,108,810)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Mississippi Storm</td> <td class="xl24" x:num="81261758" align="right">$81,261,758 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Mississippi Storm</td> <td class="xl24" x:num="80360000" align="right">$80,360,000 </td> <td>
</td> <td class="xl24" x:num="-901758" x:fmla="=F15-B15" align="right">($901,758)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Morgantown Mohawks</td> <td class="xl24" x:num="62258528" align="right">$62,258,528 </td> <td x:num="" align="center">3</td> <td x:num="" align="center">5</td> <td>Morgantown Mohawks</td> <td class="xl24" x:num="69830000" align="right">$69,830,000 </td> <td>
</td> <td class="xl24" x:num="7571472" x:fmla="=F16-B16" align="right">$7,571,472 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Pawtucket Patriots</td> <td class="xl24" x:num="83887479" align="right">$83,887,479 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">7</td> <td>Pawtucket Patriots</td> <td class="xl24" x:num="94580000" align="right">$94,580,000 </td> <td>
</td> <td class="xl24" x:num="10692521" x:fmla="=F17-B17" align="right">$10,692,521 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Philadelphia Freedom</td> <td class="xl24" x:num="100919633" align="right">$100,919,633 </td> <td x:num="" align="center">6</td> <td x:num="" align="center">7</td> <td>Philadelphia Freedom</td> <td class="xl24" x:num="95970000" align="right">$95,970,000 </td> <td>
</td> <td class="xl24" x:num="-4949633" x:fmla="=F18-B18" align="right">($4,949,633)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Pittsburgh Millers</td> <td class="xl24" x:num="76067904" align="right">$76,067,904 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Pittsburgh Millers</td> <td class="xl24" x:num="82630000" align="right">$82,630,000 </td> <td>
</td> <td class="xl24" x:num="6562096" x:fmla="=F19-B19" align="right">$6,562,096 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sin City Gamblers</td> <td class="xl24" x:num="102197525" align="right">$102,197,525 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">8</td> <td>Sin City Gamblers</td> <td class="xl24" x:num="105680000" align="right">$105,680,000 </td> <td>
</td> <td class="xl24" x:num="3482475" x:fmla="=F20-B20" align="right">$3,482,475 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Syracuse Slammers</td> <td class="xl24" x:num="106790075" align="right">$106,790,075 </td> <td x:num="" align="center">8</td> <td x:num="" align="center">8</td> <td>Syracuse Slammers</td> <td class="xl24" x:num="108890000" align="right">$108,890,000 </td> <td>
</td> <td class="xl24" x:num="2099925" x:fmla="=F21-B21" align="right">$2,099,925 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Virginia Colonials</td> <td class="xl24" x:num="117158026" align="right">$117,158,026 </td> <td x:num="" align="center">8</td> <td x:num="" align="center">8</td> <td>Virginia Colonials</td> <td class="xl24" x:num="116060000" align="right">$116,060,000 </td> <td>
</td> <td class="xl24" x:num="-1098026" x:fmla="=F22-B22" align="right">($1,098,026)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Washington Bats</td> <td class="xl24" x:num="114576362" align="right">$114,576,362 </td> <td x:num="" align="center">7</td> <td x:num="" align="center">8</td> <td>Washington Bats</td> <td class="xl24" x:num="116000000" align="right">$116,000,000 </td> <td>
</td> <td class="xl24" x:num="1423638" x:fmla="=F23-B23" align="right">$1,423,638 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Wilmington Wildcats</td> <td class="xl24" x:num="88176895" align="right">$88,176,895 </td> <td x:num="" align="center">5</td> <td x:num="" align="center">6</td> <td>Wilmington Wildcats</td> <td class="xl24" x:num="87690000" align="right">$87,690,000 </td> <td>
</td> <td class="xl24" x:num="-486895" x:fmla="=F24-B24" align="right">($486,895)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Windy City Playboys</td> <td class="xl24" x:num="87768054" align="right">$87,768,054 </td> <td x:num="" align="center">4</td> <td x:num="" align="center">6</td> <td>Windy City Playboys</td> <td class="xl24" x:num="99040000" align="right">$99,040,000 </td> <td>
</td> <td class="xl24" x:num="11271946" x:fmla="=F25-B25" align="right">$11,271,946 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">Average</td> <td class="xl26" x:num="92146680.625" x:fmla="=AVERAGE(B2:B25)" align="right">$92,146,681 </td> <td class="xl25" x:num="5.416666666666667" x:fmla="=AVERAGE(C2:C25)" align="center">5.42</td> <td class="xl25" x:num="" x:fmla="=AVERAGE(D2:D25)" align="center">6.5</td> <td class="xl25">Average</td> <td class="xl26" x:num="94517916.666666672" x:fmla="=AVERAGE(F2:F25)" align="right">$94,517,917 </td> <td class="xl25"></td> <td class="xl25"></td> </tr> </tbody></table>

If we're trying to keep as much in game as possible, then this looks good if combined with a hard cap, but won't that probably mean the rich teams are always going to awash with cash at the end of the season (provided their revenue meets their budget targets)?

[Andrew]

If we're trying to keep as much in game as possible, then this looks good if combined with a hard cap, but won't that probably mean the rich teams are always going to awash with cash at the end of the season (provided their revenue meets their budget targets)?

Yes, but anything over the $20m cash max is removed anyways and if we're using a hard cap they wouldn't be able to spend over it regardless of how much cash they had.

[Andrew]

I think the important point is that the in game luxury tax settings are not feasible because they're based completely on player expenses/payroll rather than revenue.

Without a mechanism in place to control spending by the large budget teams, the options are:

1) Implement a hard cap
2) Make media contracts/market size the same for every team

[Delandis]

Yes, but anything over the $20m cash max is removed anyways and if we're using a hard cap they wouldn't be able to spend over it regardless of how much cash they had.

With a 20 million max being removed, would stadium renovations be financed by that 20 million or could they be financed before those monies are wiped away?

[Delandis]

I think the important point is that the in game luxury tax settings are not feasible because they're based completely on player expenses/payroll rather than revenue.

Without a mechanism in place to control spending by the large budget teams, the options are:

1) Implement a hard cap
2) Make media contracts/market size the same for every team

I'm not understanding why the financial model based on team budgets is relevant. Can't we just severely penalize team over payroll, say 2:1 or even 3:1 for every dollar over?


Edit: I meant payroll not budget.

[Andrew]

The idea was to come up with a system that doesn't require record keeping or making edits in game

[Delandis]

Without a luxury tax, what is the spending deterrent for larger market teams?

[Andrew]

Without a luxury tax, what is the spending deterrent for larger market teams?

http://www.simgamingnetwork.com/foru...8&postcount=36

[funclown]

Ok, so now I have to ask: What was the advantage or "great features" that had us so hell bent on going to 11???? Unless you think "He likes to fish" feature is compelling I'm not getting this.

With that, Andrew I agree. Your new setting with a combo Hard Salary cap. Will OOTP 11 at least reset the hard cap based on yearly revenue increases??

[Andrew]

Ok, so now I have to ask: What was the advantage or "great features" that had us so hell bent on going to 11???? Unless you think "He likes to fish" feature is compelling I'm not getting this.

With that, Andrew I agree. Your new setting with a combo Hard Salary cap. Will OOTP 11 at least reset the hard cap based on yearly revenue increases??

No, the hard cap is a hard cap. Revenue shouldn't change much from year to year once we get things settled though. We can always adjust it on a yearly basis if we need to.

[Delandis]

http://www.simgamingnetwork.com/foru...8&postcount=36

I saw that. It is just that the the luxury tax gave me a target to not spend above. A goal for me last year was to not spend above the luxury tax and I achieved that.

Without a luxury tax, at least for a higher budget team like mine, I don't see any incentive to not spend to the cap every year. My revenue sharing % is fixed at 30%, regardless. Hell, with a 30% hit on revenue I shouldn't expect to be profitable, ever.

[BradZ]

I saw that. It is just that the the luxury tax gave me a target to not spend above. A goal for me last year was to not spend above the luxury tax and I achieved that.

Without a luxury tax, at least for a higher budget team like mine, I don't see any incentive to not spend to the cap every year. My revenue sharing is fixed at 30%, regardless. Hell, with a 30% hit on revenue I shouldn't expect to be profitable, ever.

You're not paying 30% revenue sharing if I am understanding this correctly. Every team pitches in 30% (yes, your payment would be larger than others based on your revenue) and the amount that is pooled from every team gets broken up and redistributed to every team in equal shares.