In addition to
DCCash, a modified version of my financial spreadsheet that will take you no more than 5 minutes to do and be ready to play each season. The other module is called
DCTicketPrice, which you need to have in order to complete the DC Cash spreadsheet.
Here's the express financial model. It's pretty sweet. It'll save you a ton of time and you can use it only for your team. It's especially helpful when running a small-market club, because then you can use it to model how much money your club truly has, depending on the size of your small market.
Here are the variables:
TEAM CITY: Where your team is located.
MARKET POP.: Your market population. Includes the metropolitan statistical area nearby and any other areas within 300 miles or so, that you claim within your market, so long as they are not part of another team's market. If so, adjust that number.
TICKET PRICES: Use the amount calculated from DCTicketPrice in this variable here.
CY WINS: Current Year wins
LY WINS: Last year wins
PLAYOFFS: Enter a 1 if your team makes the playoffs, a 2 if you make it to the LCS and 2nd round of the playoffs and a 3 if you make the World Series or final round of your league.
WS TITLE: Enter a 4 if your team wins the league title/world series
MEDIA TYPE: Media Types: (includes media sponsorship)
Quote:
Bare Bones: No Broadcast TV deal, radio deal only (Expos death sentence) (Enter 0.75)
Radio deal, Broadcast TV contract: (Enter 2)
Radio deal, Regional Cable TV contract (FOX SPORTS NET, TBS): (Enter 5)
Licensed radio deal, Regional Sports Network owned by team (YES, NESN): (Enter 8)
|
EXPANSION: Enter a 1 if your team is in its first 2 years of expansion franchise-dom and a 0 if not.
---
THAT'S IT! The rest of the formulas are completed automatically!!
Your media deal should stay the same for five years, so you shouldn't change it each year and you ought to complete this spreadsheet at the end of the playoffs each year.
---
The Orange section of the spreadsheet are for OOTP.
The fan interest number goes into your fan interest area of the game.
Fan interest modifier is the same. (I'm working on a way to model when your team signs a new player that gives you a 'boost' in fan interest. But not in this particular version.)
Code:
FAN LOYALTY: Enter this into that area in the game.
MARKET SIZE: Same deal.
LY MERCH: Last year's merchandising income
MEDIA DEAL: Total media contract plus sponsorships. Do NOT enter this into the game's media contract area.
MEDIA RTY: Enter this amount (it's the amount of your media deal each year for five years) into the media contract area and media revenue last year box and put 5 years as the total number of years. You never have to mess with it again. Until 5 years are up.
CASH: Enter this into the cash area in the game.
Avail Budget: This goes into the budget area in the game.
If you check this out, let me know what you think....I'll be tweaking it, but it's a good starting point I think. And it's meant for modern day baseball, so if you're simulating another era, it's not going to work for you moneywise.