course bg
EduPristine>Blog>Modeling Balance Sheet Drivers

Modeling Balance Sheet Drivers

February 23, 2012

Till date, we have modeled the historical statements (P/L, B/S & Cash Flow Statement) and P/L drivers. Today’s post is to help you in modeling balance sheet drivers.

Balance Sheet Drivers

Balance sheet drivers are both mixed and pure ratios. By mixed ratio we mean ratios calculated taking into consideration both P/L and B/S line items and pure rations means ratios calculated using only the B/S line items.

Balance Sheet Drivers

A/c receivable Turnover = Revenue/Average Receivable

Days of Account Receivable = 365/A/c Receivable Turnover

I.e. Days of Account Receivable = Average A/c Receivable/ (Revenue/365)

Using the same formula you can calculate the payable in days, calculate prepaid and accrued expenses by calculating year-on-year growth rate and other drivers as %age of revenue.

Please note that this is a simple model and hence the drivers are simple. And also note that we will use these drivers to project the future Balance Sheet of Facebook.

If you find any problem in modeling B/S drivers feel free to discuss this in our comments or email me your queries, we would love to answer you queries.

Next Steps

2moro we will release filled template of historical drivers (both P/L & B/S drivers), so that you can check your progress.

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

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

Post ID = 12540