SQL Utilities/Financial Utility

[Andrew]

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

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

[Delandis]

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

[Andrew]

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

[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.

[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?

[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

[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.

[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)?

[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.

[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>

[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

[BradZ]

Yeah I'm playing around with settings now and the in game luxury tax definitely won't work. It's based on payroll rather than revenue. When I ran my test Baltimore, one of the largest market teams, ended up receiving over $30m in luxury tax because they had a low payroll last year.

It's based on Player Expenses and doesn't factor in revenue earned at all, only on what was spent. It's basically making the assumption that a team only spent X on player expenses because that's all they could afford. It doesn't "think" about a team just having a low player expense number in a given year.

[Andrew]

From reading the description of the luxury tax setting it sounds like there will be luxury tax paid each year, no matter what. Since it's always based on league average payroll, there will always be teams above that payroll level by default. I only wonder if it calculates off the end of year payroll number or if it is calculating off of actual player expenses? There can be a large gap between the two figures.

Yeah I'm playing around with settings now and the in game luxury tax definitely won't work. It's based on payroll rather than revenue. When I ran my test Baltimore, one of the largest market teams, ended up receiving over $30m in luxury tax because they had a low payroll last year.

[BradZ]

This is the page that explains most of OOTP's financial options:

http://www.ootpdevelopments.com/docu...inancial_rules

It looks like the revenue sharing system is robust enough now to come close to what we were doing before. The only difference is the soft cap would be based on the current year rather than previous year.

From reading the description of the luxury tax setting it sounds like there will be luxury tax paid each year, no matter what. Since it's always based on league average payroll, there will always be teams above that payroll level by default. I only wonder if it calculates off the end of year payroll number or if it is calculating off of actual player expenses? There can be a large gap between the two figures.

[Lintyfresh85]

Many times.

Probably should work on correcting that problem.