347 647 9001+1 714 797 8196Request a Call
Call Me

Filled Historical Drivers of Facebook

February 23, 2012
, ,

In the previous two posts we gave you hints on how to model P/L & B/S drives. Today's post has just a filled template of Historical Drivers of Facebook, so that you can check your efforts and see whether you modeled Historical Drivers of Facebook as we did. And I am sure yours going to match with ours.

How do I create the model then?

The complete historical driver's model. You can download the model from here - Historical Drivers of Facebook.

Recap of the steps in getting the historical drivers in place


Revenue drivers are model using the YOY or CAGR concept.

Most of the cost drivers are calculate as percentage of revenue while provision for tax is calculated as percentage of earning before tax (EBT).


Balance sheet drivers are modeled by calculating mixed and pure ratios.

I am sure if you tried hard, you would have got it right. If not, let's discuss the issues on our forum.

Next Steps

Next we will focus on modeling assumption needed to model projected P/L & B/S of Facebook, so tomorrow we will be releasing an unfilled template for you to try on your own to model the assumptions needed to forecast the future financial statements of Facebook.


About the Author

Pankaj Baheti is a CFA Level III Candidate currently working with Pristine. Prior to Pristine, he was working with Achi Group. He has done his Post Graduate Diploma in Management and loves trekking in the hills of Arunachal.


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

Post ID = 12575