Historical Cash Flow Statement of Facebook
February 19th, 2012
If you have been following the posts till now, this post is as simple as it can be! This just releases the complete cash flow statement of Facebook. It is like a guide for you to check your efforts for the past few days. If you have been working hard, I am sure you would enjoy the glory today!
How do I create the model then?
The cash Flow statement for FB
Recap of the steps in getting the CFS in place
It is a matter of 2 minor steps: Categorizing Balance Sheet items of Facebook in Operating, Investing and Financing Activities and then taking difference of two consecutive years. Some numbers also need to be taken from the profit and loss account (i.e. Income Statement) like net profit.
Remember to maintain discipline – hard coded numbers in blue, calculations in black.
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!
Release all your Pains on our forums and Blogs and we would be happy to discuss your modeling troubles!
You can download the current updated template from here.
Now that we have the historical financial statements of Facebook (P&L , B/S and CFS) in place, we move forward to model historical drivers. Historical drivers are like crystal balls to predict future. Most of the revenue drivers would be in the form of growth and Costs would be %ages of Revenue. We would give more details tomorrow. In the meanwhile try to build historical drivers on your own!
Enroll for the entire Facebook Valuation Program here!
Why go hunting for each individual post on our blog, when the entire Facebook Valuation Program can come right in your inbox? Yes. It's now a simple click away, just provide your email address in the form below, and we will email you the entire 1 month program 1 article a day!!
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.
FREE 10 days