This is a guest post by Jeremy Liew, a managing director at Lightspeed Venture Partners where he invests in the internet and mobile sectors. His investments include Flixster, Living Social, Playdom, Rockyou and Shoedazzle. He blogs at lsvp.wordpress.com.

There has been a lot of speculation about Zynga’s revenue. Last week Business insider said:

Zynga, the social gamesmaker behind Farmville, has a revenue run-rate around $600 million, a source close to the company tells us. Another source confirms that Zynga is doing well over $1 million in revenue a day.

Businessweek says:

More than 120 million people play Zynga’s online games. Employee headcount has almost quadrupled in the past year, to 775. Revenue for the three-year-old company should surpass $450 million in 2010, according to two people who have been briefed on its financials.

We thought that we would estimate Zynga’s revenue ourselves by looking at publicly available info. Here is what Linus Chung and I did:

• Focused on only top games on Facebook
• For each game, pulled daily active user (DAU) numbers on first of every month since 1/1/09 from Developer Analytics.
• To get the average DAU for each month, took the average of the first of the month and the first of the following month. So for March, the average DAU for the month is the average of DAU on 3/1 and DAU on 4/1.
• Inside Virtual Goods published a monthly ARPU range (low and high end) for each game genre. In general, we used the average of low and high, with some exceptions:

  - For virtual gifts, we used the high end: $0.50. This only affects Friends for Sale.

  - For simulation games (e.g., CafeWorld, PetVille), we used the low end: $1.00. These games have been wildy popular in terms of users. We assumed that the recent increase in users results in lower monetizing users being added.

  - For poker, we used the low end: $2.00

  - For FarmVille, we estimated ARPU at $0.50 due to its scale

• Mapped each game to its game genre, and multiplied average DAU each month with the ARPU.

This estimate is likely to be inaccurate for many reasons, notably (i) the coarse estimates of revenue/DAU (rounding to the nearest 50c), (ii) the low end of range estimates for many of Zynga’s most popular games, and (ii) the fact that we ignore revenue from MySpace, Zynga’s websites, and mobile. None the less, it shows some interesting results:

Again, note that these are all estimates. However, our estimates show that revenue ramped fast over calendar 2009. The H1 ramp was driven by Poker and Mafia Wars, and the H2 ramp driven by Farmville, Cafeworld and Fishville. Our estimates show that revenues have been flatish since the beginning of 2010, with a decline in older games compensated for by the launch of Treasure Isle.

Feel free to see the details and play with the assumptions yourself – the spreadsheet is here. It is a read only Google Doc so that your changes won’t affect others who are later to check it out, but you can download the spreadsheet to change assumptions. Note that there are four tabs to the spreadsheet (at the very bottom of the page). To download, click File–> Download as –> Excel.

Play with the assumptions, and let us know what you think.

Crunchbase

• ZYNGA
• JEREMY LIEW
• LIGHTSPEED VENTURE PARTNERS

Company: Zynga

Website: zynga.com

Funding: $860M

Zynga was founded in July 2007 by Mark Pincus and is named for his late American Bulldog, Zinga. Loyal and spirited, Zinga’s name is a nod to a legendary African warrior queen. The early supporting founding team included Eric Schiermeyer, Michael Luxton, Justin Waldron, Kyle Stewart, Scott Dale, John Doerr, Steve Schoettler, Kevin Hagan, and Andrew Trader. Zynga’s mission is connecting the world through games. Everyday millions of people interact with their friends and express their unique personalities through our...

Learn more

Person: Jeremy Liew

Companies: Serious Business, AOL, Citysearch, McKinsey & Company, Flixster, StreetFire, Lightspeed Venture Partners, Slice, Friend.ly, KIXEYE

Jeremy Liew is a Managing Director at Lightspeed Venture Partners. He invests primarily in the Internet and mobile sectors, with a particular interest in social media, commerce, gaming and methods for increasing monetization. He joined Lightspeed in early 2006. Previously, Jeremy was with AOL, first as SVP of Corporate Development and Chief of Staff to the CEO and then as General Manager of Netscape. Jeremy joined AOL from InterActiveCorp (originally USA Networks), where he was VP of Strategic Planning. While there,...

Learn more

Financial-organization: Lightspeed Venture Partners

Website: lightspeedvp.com

Lightspeed Venture Partners is an early stage, global venture capital firm with offices and partners inMenlo Park, China, India, and Israel. Lightspeed focuses on investments in enterprise infrastructure, internet media and commerce, mobile, digital media, semiconductors, and cleantech. Past notable investments include Brocade communications, Ciena, DoubleClick, Phone.com, and Riverbed. Selected current portfolio companies in the enterprise infrastructure space include: AppDynamics Cirtas Delphix Embrane FusionIO MapR Technology Nimble Storage Pliant Technology Riptano Tintri Selected current portfolio companies in internet media and commerce space include: Thefind.com Kosmix Living Social MediaV Playdom RockYou Shoedazzle Wikio Selected current portfolio companies in the mobile and...

Learn more