347 647 9001+44 7901 188805Request a Call
Call Me

Modeling the Historical P&L of Facebook

I hope that you all enjoyed modeling the historical Profit and Loss of Facebook. This part is a simple and it contains the filled P&L of Facebook, so that you can check your efforts for the past 2 days.

Discuss P&L of Faceboook

Where do I get the Profit and Loss data from the S1 filing

If you go to the consolidated financial statements section, you would get the complete Profit and Loss for Facebook.

How do I create the model then??

Most of the stuff (Revenue, Costs, etc.) just needs to be hardcoded in the P&L template. Some numbers like total revenue and incomes can be derived from the revenue and cost numbers.

Just remember two simple things

  • Revenue – cost = Profits!
  • Typically we would try to maintain a discipline: hard coded numbers in blue, calculations in black.

So did you get it right?

I am sure if you tried hard, you would have got it right. If not, let’s discuss the issues that you faced and start learning together!

Next Steps

Now that we have the historical P&L in place, we move forward and create the Balance Sheet. Creating the Balance Sheet is similar to creating the P&L, most of the numbers are hardcoded and a few are derived. In the next video, we would release the empty template for the same. In the meanwhile, why don’t you try to create it on your own? The data is with you in the S1 filing!

Learn More:
Modeling the Historical Profit and Loss of Facebook


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

us_blank.php Post ID = 88830