course bg
EduPristine>Blog>Projecting Financial Statements for Facebook

Projecting Financial Statements for Facebook

February 26, 2012

If you remember (I am sure if you are concentrating on modeling rather than facebooking, you would atleast remember a bit), we are creating a simple model to Projecting Financial Statements for Facebook (and hence be in awe with the worth of Mark Zuckerberg! ;-))

Recap on Facebook Valuation Tutorial Course

We have already modeled:

  • The historical statements of Facebook:The P/L & B/S mostly was hardcoded, with a few derived numbers and cash flow statement was modeled using the indirect method and derived from the historical B/S and P&L
  • The Historical Drivers of Facebook: Mostly were calculated as %age of Revenue and some as year-on-year growth rate. The few balance sheet historical drivers were calculated in days and so on.
  • The Assumption of Facebook: Mostly this was modeled by taking the average of historical drivers and by using S1 and public, non-public and non-material information of the facebook.

From today onwards we start Projecting Financial Statements for Facebook using the modeled assumptions.

Projecting the Statements

Today’s exercise is to start modeling the future P/L, B/S and Cash Flow Statement of FB. Once we have the projected future P/L, B/S and Cash Flow statement of Facebook. Once we have the cash, it will be easy to estimate the value that FB and Mark Zuckerberg will have!

Template for Projected Statement

I have for you a simple template to project the future financial statements for Facebook.

Download the template and try to project the future P/L, B/S and CFS of the Facebook using the assumptions modeled in the previous exercise.

Go ahead & predict how rich Zuckerberg is gonna be!!!

About Author

avatar EduPristine

EduPristine is a member of Adtalem Global Education (NYSE: ATGE), a global education provider headquartered in the United States. Adtalem is a 3 billion dollars (20,000 crores) company that has about 9 institutions and companies with more than 16,000 employees spread across 145 locations. Adtalem takes pride in training 142,000 degree-seeking students all over the world.The organization's purpose is to empower students to achieve their goals, find success and make inspiring contributions to our global community. EduPristine is one of India's leading training providers in Analytics, Accounting, Finance, Healthcare, and Marketing. Founded in 2008, EduPristine has a strong online platform and network of classrooms across India and caters to self-paced learning and online learning, in addition to classroom learning


Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

Post ID = 12696