We are almost done with the trickiest part of the Facebook Model. We almost have the cash flow statement with us. Just to recap, the basic steps in creating the cash flow statements were:
If you remember we had also discussed the BASE Rule where we had discussed the generalized methodology of creating the closing accounts of the balance sheet from the other statements. It is time we put all our basic knowledge into action!
Now that we have the basic elements of the cash flow statement with us and the pre requite knowledge to create the cash flow statement, we would find the real cash at the end of the year and ensure that it balances with the cash in the balance sheet.
Today we calculate the closing cash balance for Facebook in the cash flow statement and ensure that it balances the cash in the balance sheet. Please note that this balancing is a basic error check in the model. If you are not getting it right, it is time to check your old numbers.
Remember: Closing Cash Balance = Beginning Cash Balance + Net Changes in Cash Flow
Try on your own and calculate the closing cash balance for the Facebook and see whether the resultant figure is the one that is given in the historical balance sheet.
Tomorrow we would release the cash flow statement of Facebook. You would see that the closing cash balance calculated in the Cash Flow Statement is same as the Cash in Facebook’s balance sheet. Next step’s integrated linked model would include all financial statements for Facebook
Once we have the Cash Flow Statement in the model, we would clearly see the linkage between P&L,B/S and the cash flow statement.
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!
The cash Flow statement for FB
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!
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!
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 email@example.com and we will rectify it.
2015 © Edupristine. ALL Rights Reserved.