Dark Cloud's Financial Market Model Version 1.0 - Page 5

darkcloud4579 · 01-20-2008, 01:40 PM

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 · 01-20-2008, 02:36 PM

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

darkcloud4579 · 01-22-2008, 12:36 AM

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 · 01-22-2008, 01:40 AM

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

darkcloud4579 · 01-22-2008, 01:56 AM

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 · 01-22-2008, 02:03 AM

Quote:

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 · 01-22-2008, 08:49 AM

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 · 01-22-2008, 10:03 AM

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 · 01-22-2008, 11:09 AM

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 · 01-22-2008, 11:15 AM

Quote:

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 · 04-14-2008, 01:25 PM

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.

darkcloud4579 · 06-21-2008, 10:02 AM

I plan to release a new version of this for OOTP9.

bailey · 06-21-2008, 09:19 PM

Thank you. I just discovered this thread. How much of this actually made it into 9?

darkcloud4579 · 06-23-2008, 08:21 AM

I'm not exactly sure. It was certainly on the radar, but the overall premise of it wasn't incorporated at all. Most of the financial changes were cosmetic, except the revenue sharing overhaul, which I'd removed from this after a while anyway.

There is still a need for this if you want a semblance of market size reality, though.

darkcloud4579 · 06-23-2008, 07:16 PM

The newest version of this tool is here.

01-22-2008, 01:56 AM	#85
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,305 Blog Entries: 32	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. __________________ Godfather of Fast-Sim OOTP My Mods: GMExcel 24 Major League Women's Baseball (OOTP24) quickstart Indian Premier League \| 300+ years of baseball quickstart \| Expatriate League quickstart \| Off-Field Injuries Update \| Women's Name File for OOTP \| My (outdated) market calculator & financial spreadsheets

01-22-2008, 08:49 AM	#87
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,305 Blog Entries: 32	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. Last edited by darkcloud4579; 01-22-2008 at 08:53 AM.

06-21-2008, 09:19 PM	#93
bailey Hall Of Famer Join Date: Jun 2005 Posts: 3,127	Thank you. I just discovered this thread. How much of this actually made it into 9? __________________

01-20-2008, 02:36 PM	#82
dl5175 Major Leagues Join Date: Mar 2006 Posts: 345	Where do we get the Team owners net worth number from?

01-22-2008, 12:36 AM	#83
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,305 Blog Entries: 32	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.

01-22-2008, 01:40 AM	#84
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,660 Blog Entries: 1	would this work for fictional leagues at all? More specifically ones that have to play one year?

01-22-2008, 10:03 AM	#88
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,660 Blog Entries: 1	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?

01-22-2008, 11:09 AM	#89
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,305 Blog Entries: 32	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.

06-21-2008, 10:02 AM	#92
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,305 Blog Entries: 32	I plan to release a new version of this for OOTP9.

06-23-2008, 08:21 AM	#94
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,305 Blog Entries: 32	I'm not exactly sure. It was certainly on the radar, but the overall premise of it wasn't incorporated at all. Most of the financial changes were cosmetic, except the revenue sharing overhaul, which I'd removed from this after a while anyway. There is still a need for this if you want a semblance of market size reality, though.

06-23-2008, 07:16 PM	#95
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,305 Blog Entries: 32	The newest version of this tool is here.