Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have posted the entire question. There is no additional information to add. Please help Slim Perkins, a business journalist, is a recent hire at

I have posted the entire question. There is no additional information to add. Please help

Slim Perkins, a business journalist, is a recent hire at his firm. Since he joined the firm, he has been following Facebook Inc.s (FB) initial public offering (IPO) and the stocks performance. His task is to estimate Facebooks fair market value, also referred to as intrinsic value, and compare this value with the current stock price, and recommend a buy, sell, or hold rating to investors. Slim pulls the companys consolidated financial statements to collect relevant data on the companys historical financial performance.

He notices that the company assumes a 45% marginal tax rate after the IPO, and mentions that the company projects that user rates and revenue growth will decline over time.

Slim starts his evaluation by calculating ratios of costs and expenses to revenues, interest expense to revenues, and others that will form the set of assumptions in his analysis which will be used to calculate free cash flows.

Financial Statements

Balance Sheet

2011

2010

2009

(in millions)

(in millions)

(in millions)

Assets
Cash and cash equivalents $3,908 $1,785 $633
Receivables 547 373
Prepaid expenses and other current assets 149 88
Total current assets $4,604 $2,246
Property and equipment, net 1,475 574 $148
Goodwill and intangible assets, net 162 96
Other assets 90 74
Total assets $6,331 $2,990 $1,109
Liabilities and equity
Accounts payable $63 $29
Platform partners payable 171 75
Accrued expenses and other current liabilities 296 137
Deferred revenue and deposits 90 42
Current portion of capital lease obligations 279 106
Total current liabilities $899 $389
Capital lease obligations, less current portion 398 117
Long-term debt 250
Other liabilities 135 72
Total liabilities 1,432 828 241
Convertible preferred stock 615 615
Common stock
Additional paid-in capital 2,684 947
Accumulated other comprehensive loss (6) (6)
Retained earnings 1,606 606
Total stockholders equity $4,899 $2,162 $868
Total liabilities and stockholders equity $6,331 $2,990

Income Statement

2011

2010

2009

(in millions)

(in millions)

(in millions)

Revenue $3,711 $1,974 $777
Costs and expenses
Cost of revenue 860 493 223
Marketing and sales 427 184 115
Research and development 388 144 87
General and administrative 280 121 90
Total costs and expenses $1,955 $942 $515
Income from operations $1,756 $1,032 $262
Interest and other income (expense), net:
Interest expense $(42) $(22) $(10)
Other income (expense), net (19) (2) 2
Income before provision for income taxes $1,695 $1,008 $254
Provision for income taxes 695 402 25
Net income $1,000 $606 $229
Net income attributable to participating securities 332 234 107
Net income attributable to class A and class B common stockholders $668 $372 $122

Statement of Stockholder's Equity

Balances at Dec 31

(in millions)

(in millions)

(in millions)

2011 2010 2009
Convertible preferred stock $615 $615 $615
Class A and Class B common stock
Additional paid-in capital 2,684 947 253
Accumulated other comprehensive loss (6) (6)
Retained earnings (accumulated deficit) 1,606 606
Total stockholders equity $4,899 $2,162 $868

Statement of Cash Flows

2011

2010

2009

(in millions)

(in millions)

(in millions)

Cash flows from operating activities
Net income $1,000 $606 $229
Adjustments to reconcile net earnings to net cash from operating activities:
Depreciation and amortization 323 139 78
Loss on write-off of assets 4 3 1
Share-based compensation 217 20 27
Other adjustments (1)
Changes in assets and liabilities:
Accounts receivable (174) (209) (112)
Prepaid expenses and other current assets (31) (38) (30)
Other assets (32) 17 (59)
Accounts payable 6 12 (7)
Platform partners payable 96 75
Accrued expenses and other current liabilities 38 20 27
Deferred revenues and deposits 49 37 1
Other liabilities 53 16 1
Net cash provided by operating activities $1,549 $698 $155
Cash flows from investing activities
Purchases of property and equipment $(606) $(293) $(33)
Purchases of marketable securities (3,025)
Maturities of marketable securities 516
Sales of marketable securities 113
Investments in non-marketable equity securities (3)
Acquisitions of business, net of cash acquired (24) (22) 3
Change in restricted cash and deposits 6 (9) (32)
Net cash used in investing activities $(3,023) $(324) $(62)
Cash flows from financing activities
Net proceeds from issuance of convertible preferred stock $200
Net proceeds from issuance of common stock $998 $500
Proceeds from exercise of stock options 28 6 9
Proceeds from (repayments of) long-term debt (250) 250
Proceeds from sale and lease-back transactions 170 31
Principal payments on capital lease obligations (181) (90) (48)
Excess tax benefit from share-based award activity 433 115 51
Net cash provided by financing activities $1,198 $781 $243
Non-cash financing activities:
Property and equipment acquired under capital leases 473 217 56

Problem:

Please answer the blanks below in this table.

2012

2013

2014

2015

2016

2017

2018

(in millions)

(in millions)

(in millions)

(in millions)

(in millions)

(in millions)

(in millions)

Revenue growth rate 18% 18% 18% 18% 18% 5% 5%
Revenues $ $ $ $ $ $ $
Total costs and expenses
Income from operations (EBIT)
Taxes
Net operating profit after taxes (NOPAT)
Operating current assets
Operating current liabilities
NOWC
Change in NOWC
Net fixed assets (plant property & equipment)
Change in net fixed assets
+ Depreciation and amortization
Capital expenditure
Free cash flow
Present value of FCF
Horizon value
Present value of horizon value
Total firm value

Please answer the following blanks.

The value of total long-term liabilities that FB reported in 2011 was _____ million, and the value of preferred stock in 2011 was _______million. Thus, using the firms value, the derived equity value will be ____________million. The company issued___________ shares of class A common stock in 2012. Thus, the value of each stock, rounded to two decimal places, is ______.

Please answer whether or not to buy, sell, or hold

According to the SEC filings, FB stocks IPO was priced at $38.00 per share. If Slim strictly follows the theoretical rules of investing, based on his analysis, what strategy would he recommend to investors interested in FBs stock as an asset in their short-term investment portfolio?

Buy, Sell, or Hold

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Interpreting And Analyzing Financial Statements

Authors: Karen P. Schoenebeck

3rd Edition

0130082163, 9780130082169

More Books

Students also viewed these Accounting questions

Question

What is the use of bootstrap program?

Answered: 1 week ago

Question

What is a process and process table?

Answered: 1 week ago

Question

What is Industrial Economics and Theory of Firm?

Answered: 1 week ago

Question

Which of the sources is most cost effective?

Answered: 1 week ago