course bg
EduPristine>Blog>Filled Historical Drivers of Facebook

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?

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 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 = 12575