The Personal Economics of Farmville, Part 2

Yesterday, I wrote a fairly popular post about the personal economics of Farmville, the extremely popular Facebook game by Zynga.  There were enough comments and emails about the original post, I decided to write a quick follow-up to cover some of the most common ideas and concerns.

gameBig_farmville

I was also able to get the data on Red Wheat and Yellow Mellon, which were missing from my original post.  Also, this weekend saw the (temporary?) advent of “Super Berries”.  I’ve updated my original table here, showing the rank of all Farmville crops based on net profit per day per square.  Let’s just say there is a reason Super Berries are, well, super:

Crop Profit / Day
Super Berries 900.00
Tomatoes 174.00
Sunflowers 165.00
Coffee 162.00
Blueberries 156.00
Carrots 150.00
Raspberries 132.00
Broccoli 129.00
Red Wheat 84.67
Yellow Mellon 77.00
Peppers 77.00
Rice 72.00
Corn 71.67
Pumpkin 69.00
Pineapple 66.00
Potatoes 65.00
Strawberries 60.00
Yellow Bell 54.00
Watermelon 50.75
Cotton 39.00
Soybeans 33.00
Squash 33.00
Artichoke 29.75
Eggplant 24.00
Wheat 21.67

The most interesting questions and comments came from Abhi Kumar, product manager for Farmville at Zynga.  Needless to say, it was extremely flattering to have Abhi interested in my post, and to hear his thoughts on the topic.

The first point Abhi raised was interesting.  The question was, how would I factor experience into these calculations.  Clearly, experience is crucial to the game in several regards:

  • It’s crucial for rising in the technology tree, to get access to new crops, tools, and other beneficial items.
  • It’s a basic game mechanic that drives people to see their “score” rise.
  • It’s public to your neighbors.  As a social game, this adds an additional game mechanic, similar to a leaderboard, that encourages you to boost your score.

In order to calculate the experience for each crop, I took the experience that each crop delivers per cycle, added one experience point per cycle for re-plowing, and then normalized the values for a single day (24 hours) and a single square.

Crop Experience / Day
Super Berries 24.00
Blueberries 12.00
Strawberries 12.00
Raspberries 12.00
Tomatoes 6.00
Pumpkin 6.00
Carrots 4.00
Rice 4.00
Peppers 3.00
Soybeans 3.00
Coffee 3.00
Broccoli 2.50
Sunflowers 2.00
Pineapple 1.50
Yellow Bell 1.50
Squash 1.50
Eggplant 1.50
Red Wheat 1.00
Corn 1.00
Potatoes 1.00
Cotton 1.00
Wheat 1.00
Yellow Mellon 0.75
Watermelon 0.75
Artichoke 0.75

Not surprisingly, the quick cycle-time of the berries dominates this table.

The question is, how do you blend the value of experience and coins? The truth is, the function for valuing experience is probably too complicated to get right.

However, I did find a simplistic proxy.  1 experience point = 15 coins.

Why? Well, it turns out you can just sit there, plow a square for 15 coins, and get 1 experience point.  You can then delete the square and do it again.  So at least, in theory, you can “buy” an infinite supply of experience points for 15 coins each.

When you include experience at this price, the rank of the crops changes significantly from the original “coins only” version of the most profitable crops:

Crop Profit + XP / Day
Super Berries 1260.00
Blueberries 336.00
Raspberries 312.00
Tomatoes 264.00
Strawberries 240.00
Carrots 210.00
Coffee 207.00
Sunflowers 195.00
Broccoli 166.50
Pumpkin 159.00
Rice 132.00
Peppers 122.00
Red Wheat 99.67
Pineapple 88.50
Yellow Mellon 88.25
Corn 86.67
Potatoes 80.00
Soybeans 78.00
Yellow Bell 76.50
Watermelon 62.00
Squash 55.50
Cotton 54.00
Eggplant 46.50
Artichoke 41.00
Wheat 36.67

In many ways, this final table is a more satisfying answer on what to plant, since it gives a fairly balanced view across coins (which are needed to buy seeds, tools, and other items) and experience (which is also needed to raise your level to buy seeds, tools, and other items).

Clearly, this analysis is very sensitive to the value of an experience point. The more value you ascribe to experience, the more the compound table begins to resemble the experience-only version.

As part of my original post, I had run some analysis that suggested that if you value the time that it requires to check on your crops, harvest them, and re-plow & plant, then you might get a different order.  I’ve now updated the chart to include the three crops that I didn’t have yesterday.

Farmville_Economics_Updated

click to see the enlarged chart graphic

Based on the addition of the new crops, the top five crops in terms of their value in $ US / hour are:

  1. Yellow Mellon
  2. Broccoli
  3. Red Wheat
  4. Corn
  5. Watermelon

All of the values are still well below $1 / hour.

I re-ran these numbers utilizing the experience points.  While they did shift the numbers to the right, they didn’t alter the ranking significantly.  This is likely because the cost in time (15 minutes) for each cycle and the high conversion rate (1500 coins / $1 US) means that the time cost of checking dwarfs the incremental value of the experience per cycle.

That’s why you can see that one wacky line, Super Berries, which starts so high it’s off the chart, but crashes down under the weight of 12 cycle refreshes per day.

A couple people specifically wanted to see this analysis taking into account the new Tractor, which speeds plowing by up to 4x (although you need to buy fuel).  Since I don’t have a Tractor yet (working on it), I estimated what would happen if a cycle plow/plant took only 5 minutes instead of 15.  Here is the updated chart:

Farmville Economics Updated Tractor

click to see the enlarged chart graphic

For those of you playing at home, sorry to disappoint.  It turns out that dropping the time it takes does shift the value per hour out almost linearly.  You’ll note that in this chart, now the equivalent value for Yellow Mellon is over $2.62 / hour.  The order of the most valuable crops, however, does not change, because even five minutes dominates with such a high US $ to Farmville coin exchange rate.

Abhi did make one last point that I agree with completely.  The primary value of the game is not the coins you make.  (In fact, since you can’t really convert coins back to dollars, they are arguably worthless.)  The value is the fun and enjoyment you get from the time spent.

In fact, I could theorize that if you normally bill $50/hour for your time, the delta between your normal rate and the amount you are making with Farmville crops shows just how much you value playing Farmville.

Hope this post was as interesting to folks as the last.  I’ve got to go harvest some Super Berries…

Updates: I’ve now posted additional articles on Farmville Economics:

How Virtual Goods Caused the Market Crash of 2016

No, that’s not a typo.  I have seen the future.  And in the future, a burgeoning virtual goods economy that has been building over the past few years will lead to the next great financial bubble and crash.

Far-fetched?  Read on.

In some ways, virtual goods are almost as old as role-playing games.  Experience and special weapons are time consuming to earn, so a light grey market to “cheat” by purchasing equipment or characters has always existed.

This ecosystem exploded with popularity of massively multiplayer games, like World of Warcraft, and virtual worlds, like Second Life.  For the first time, cottage industries of real human beings sprang up to devote full time effort to investing time and resources into accumulating virtual wealth.

While typical Silicon Valley chit-chat turned to the impressive revenues that virtual goods firms began generating in 2008 & 2009, it wasn’t until Zynga IPO’ed in 2010 with eye-popping revenues of more than a quarter billion real dollars that the concept of virtual economies really became mainstream.  Major players from across the entertainment and technology domains raced to enter the market, and to leverage the powerful virality of social platforms combined with the fundamental addictiveness of gaming, reading a comprehensive buying guide every time you buy a gaming monitor is really important.  Add the final magic ingredient – pure monetary greed, and you had all the animal spirits needed to create the great virtual goods boom.

Unfortunately, as described in Devil Take the Hindmost, almost all great booms and busts are created through a combination of financial innovation in products that create leverage combined with a technology innovation that drives wildly optimistic views of future value.

Virtual goods and virtual economies had all the right elements to boom.  Initially, the conversion from real world stores of value into virtual stores was highly controlled.  Some of these economies allowed for the transfer of goods and virtual wealth, and some didn’t.  Quickly, however, competition forced a basic truth – people like obtaining virtual wealth in the form of virtual goods.   They like seeing that value multiply and grow.  More and more innovative services and economies were built, and increasingly they enabled mechanisms to convert those virtual stores of value into other virtual stores.  They also enabled players to compound their virtual wealth.  In fact, some even enabled the conversion back into real money.

Thus the vicious cycle was born.  Converting real money into virtual goods, and then taking advantage of the ability to compound that virtual value at unrealistic rates, set off a true boom.  The rate of return on virtual investments was so high compared to the anemic returns offered by the still moribund real economy, that early adopters looked like geniuses.  In 2014, the meme began to spread that everyone should have a portion of their portfolio allocated to “virtual assets”, which were not highly correlated to traditional stores of value.   Funds sprang up to allow the average individual without the time or inclination to invest and build virtual wealth to access the market.

The companies providing these ecosystems had no reason to dampen this enthusiasm.  Their systems, like those of investment bankers or market makers of yore, ensured a percentage of all transactions as revenues.   They made money as people converted real currency to virtual currency, and technically, as they converted it back.  Like central bankers with no fear of inflation, they juiced their economies to juice their own revenues.  Fortunately, the higher the internal rates of return in the virtual worlds, the less people were incented to take their virtual goods out and convert to real money.  Everyone effectively let their money ride, watching their virtual wealth grow.

By 2015, the notional value of virtual goods exceeded $1 Trillion for the first time.  Government bureaucrats began to explore the possibility of taxing these virtual economies to help cover increasing deficits.  Lobby groups sprang up to protect this “new economy” from destruction.  Pundits debated this nightly on all major cable networks.  People borrowed real money at relatively low rates in the real world to invest in virtual goods, because the returns were so much higher.  Real debt grew, savings dropped, but virtual assets grew faster.

Then, in 2016, one of the more flagrant virtual worlds began to see withdrawals rise.  Not significantly at first, but it turned out they had allowed virtual wealth of their members to grow high enough that people began to “retire”.  Everyone was in the game, so new entrants with smaller balances could match the asset loss.  Suddenly, the bear arguments, which had been discussed for years (beginning with a famous blog post from 2009) began to make more sense.

No one had the real money to cover these virtual “liabilities” the companies implicitly had to their members.  There was no virtual FDIC to cover accounts.  There was no regulation to ensure that these accounts would be paid.  The first “run” on a virtual economy had begun.

Suddenly, it became clear that these virtual economies were linked, even if owned by different giant companies.  People who lost money in one virtual economy, began pulling real money out of others.  One virtual world froze conversion, like a panicked 20th century third world nation.  Then the run really began.

Virtual asset values plummeted.  But the real debts did not.  Suddenly it turned out that more companies had their fingers in the virtual pie than most people thought.  Asset management firms.  Insurance firms.  Hedge funds.  Large banks.  Tech giants.

And that’s how virtual goods caused the market crash of 2016.

Do I believe that it will really happen?  No.  Do I believe that conceptually, virtual goods and economies could lead us into uncharted waters economically if we are not careful?  Yes.

I’ve read quite a bit in the past decade about the history of market bubbles and panics, and the patterns of each.  In every case, financial innovation creates some new way for people to assume liabilities in a highly leveraged way, outside of existing regulation or norms.  In combination, some technology offers the world hope of a much larger economic future.  Given the new found ability to invest heavily in that future, and radically different perceptions of that future, people invest, creating a virtuous cycle of high returns and increased investment that sucks almost all the air out of the system… and then keels over.

A fun mental exercise for a Thursday night.

Still I wonder. Since it’s only 2009, I feel like I don’t own enough stock in these companies.  It’s going to be quite a ride.  🙂