Dark Cloud's Financial Market Model Version 1.0

[darkcloud4579]

I updated it because I forgot to include an area that calculates the team budget. The game will add the media money and revenue generated from attendance and merchandise in the future, but for the first year, the budget is derived from a portion of the media deal, generates ticket revenue for that first year since the game won't until the following year and subtracts an average of payroll.

To lower the number for past years or inflate for future years, use this inflation calculator.

[dl5175]

Where do we get the Team owners net worth number from?

[darkcloud4579]

It's a guesstimated number. There isn't any hard and fast number on it. You just use your own discretion, realizing that the average major league owner is a billionaire and there are obvious exceptions, but that when an owner is personally worth less than say $200 million or so, you can figure that the team isn't exactly teeming with prosperity. But play with the factor. All it effects is the cash amount that the team has on hand.

[canadiancreed]

would this work for fictional leagues at all? More specifically ones that have to play one year?

[darkcloud4579]

Of course. It's adept for either one, so long as you're intending it for modern-day financials. You mean the league is only one year long? It might be a lot of work to invest for that, but...it could be used for one team, for an entire league or whatever you want. It's able to do either.

[canadiancreed]

Originally Posted by darkcloud4579

Of course. It's adept for either one, so long as you're intending it for modern-day financials. You mean the league is only one year long? It might be a lot of work to invest for that, but...it could be used for one team, for an entire league or whatever you want. It's able to do either.

ya liek I have the population stats, but outside of that.....not a thing.

also how woudl you determine market population for Canadian areas?

[darkcloud4579]

Top 100 Canadian metropolitan areas

Here are the Canadian DMAs by size (DMA is TV market), but there is no number listed...and the information isn't readily available like the US info is. So, you might want to use population and make iit a percentage of that, based on the rankings maybe.

[canadiancreed]

fair enough

Some more questions. In your example it uses a formula to do ticket prices. any reason why it wouldnt' be easier to jsut input a price? Also what is the stadium column's purpose?

[darkcloud4579]

It would be easier to insert a price into the game, but not into the spreadsheet since it does its own and is calcuated to give you a bigger budget to start with. Stadium column is a 1-100 measure of the stadium quality. It's subjective and I used this as the foundation for its initial development.

[canadiancreed]

Originally Posted by darkcloud4579

It would be easier to insert a price into the game, but not into the spreadsheet since it does its own and is calcuated to give you a bigger budget to start with. Stadium column is a 1-100 measure of the stadium quality. It's subjective and I used this as the foundation for its initial development.

that's what I figured. Since it's mostly new statdiums I'm using, that throws a monkey wrench into my plans

[darkcloud4579]

Version 8 is here kids.

This version includes a historical modifier to where you can transport your calculations to the past (or future values up to the year 2025) into the game. Here are screenshots.

Ctorg was the one responsible for adding the historical modifier, so give him props for all of the historical population and financial data.


For the main screen, make sure to input normal numbers in there. Based on the year you choose on


this screen, you will get accurate calculations based on the modifiers. All you have to input here is the year at the top. The other numbers are generated automatically from the modifiers sheet.


Here are the modifiers. The only thing you'd need to change is the length of your season if you have a longer/shorter season than what's indicated here. It's intended to mimic real life and you shouldn't have to make any changes, but...that's what these are there for.