course bg
EduPristine>Blog>Financial Modeling Contest: Complete the LinkedIn Model

Financial Modeling Contest: Complete the LinkedIn Model

February 19, 2011

Preparing an integrated financial model from the scratch for the equity valuation has always been a daunting task which requires both finance acumen and patience. Here is a challenging problem which checks both of these much required qualities of a good modeler.

Problem

You are provided with the template of LinkedIn’s incomplete model, which you need to figure out and complete. The blanks are highlighted with yellow color.

Following are 4 problems which you need to solve:

  1. Revenue Build-Up Sheet:
    • Making the projections for Number of registered Members and Corporate Solution Customers
    • Calculating the Quarterly Revenue from each head: Hiring Solution Revenue, Marketing Solution Revenue, Premium Solution Revenue
    • Finally consolidating quarterly revenues into yearly numbers and updating the P&L statement.
  2. Cash Flow Statement:
    • Preparing the complete Cash flow statement from the Profit & Loss statement and Balance sheet.
    • Updating the balance sheet by linking the Cash and Cash Equivalents row.
  3. Valuation Sheet:
    • Calculating the cost of Equity
    • Calculating the FCFF and FCFE and then discounting these free cash flows to get the Equity Value of the firm.
  4. Balance Sheet and P&L Sheet:
    • The Cash balance on the balance sheet will also earn some interest rate on it. Let’s suppose 4% per annum. Also if the cash balance of the company goes negative, they have any overdraft facility which charges at 6% per annum. You need to incorporate this interest calculation in the model.

How to get the template?

You can download the template @: Click this link.

How to submit?

You can submit your answer files mailing us at: contests@edupristine.com

What’s the duration of the contest?

Contest is open from 11 AM, 19thFeb, 2011 till 9 A.M. IST 21st Feb, 2011.

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