Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete the following for the company Facebook 1. Collect stock data?price, shares outstanding, insider ownership, insider transactions, stock repurchase program, options, etc. 2. Calculate

image text in transcribed

Please complete the following for the company Facebook

1. Collect stock data?price, shares outstanding, insider ownership, insider transactions, stock repurchase program, options, etc.

2. Calculate the following financial ratios using Microsoft Excel:

current ratio

quick ratio inventory turnover DSO fixed assets turnover total assets turnover debt ratio liabilities to assets ratio times interest earned ratio EBITDA coverage ratios profit margin BEP ROA ROE price/earnings ratio price/cash flow ratio market book ratio common size analysis percentage change analysis extended DuPont equation to provide a summary and overview of Facebook's financial positionand compare to industry average. Include the balance sheet and income statement on the same worksheet as the ratios. What can you conclude from the ratios? Any warning signs? Anything that stands out?

image text in transcribed Please complete the ratios for Facebook by using the following information: http://www.nasdaq.com/symbol/fb/financials?query=income-statement stock dataprice Date Open 2/3/2017 2/2/2017 2/1/2017 1/31/2017 1/30/2017 1/27/2017 1/26/2017 1/25/2017 1/24/2017 1/23/2017 1/20/2017 1/19/2017 1/18/2017 1/17/2017 1/13/2017 1/12/2017 1/11/2017 1/10/2017 1/9/2017 1/6/2017 1/5/2017 1/4/2017 High 131.240005 133.220001 132.25 130.169998 131.580002 132.679993 131.630005 130 129.380005 127.309998 128.100006 128.229996 128.410004 128.039993 127.489998 125.610001 124.349998 124.82 123.550003 120.980003 118.860001 117.550003 Low 132.850006 135.490005 133.490005 130.660004 131.580002 132.949997 133.139999 131.740005 129.899994 129.25 128.479996 128.350006 128.429993 128.339996 129.270004 126.730003 126.120003 125.5 125.43 123.879997 120.949997 119.660004 130.759995 130.399994 130.679993 129.520004 129.600006 131.080002 131.440002 129.770004 128.380005 126.949997 126.779999 127.449997 126.839996 127.400002 127.370003 124.800003 124.059998 124.279999 123.040001 120.029999 118.32 117.290001 shares outstanding The outstanding shares of the company as per 2016 financial year is 2,845 among them 2, insider ownership From the financial point of view, insider ownership is defined as the percentage of shares The face book company insider ownership is 0.30% insider transactions f insider stock purchases, sales, and option exercises for Facebook Inc (FB). Trading Period Insider Insider Sales Buying year-month Option Exercises Shares Value Shares Value Shares 2017-01 0 $0 291,744 $36,192,854 0 2016-12 0 $0 1,902,460 $226,204,254 0 2016-11 0 $0 3,402,088 $405,036,970 1,371,442 2016-10 0 $0 5,368,646 $695,974,164 0 2016-09 0 $0 5,873,580 $757,708,226 0 2016-08 0 $0 5,657,341 $705,540,517 1,358,414 2016-07 0 $0 2,403,361 $282,996,788 0 2016-06 0 $0 3,794,862 $430,224,235 0 2016-05 0 $0 7,523,819 $890,949,470 1,377,301 2016-04 0 $0 3,859,470 $434,720,174 0 2016-03 0 $0 4,295,818 $477,043,970 0 2016-02 0 $0 4,502,227 $468,337,194 1,365,488 2016-01 0 $0 134,803 $12,876,923 0 2015-12 0 $0 41,934 $4,426,563 0 2015-11 0 $0 6,960,127 $729,001,465 5,446,741 2015-10 0 $0 337,647 $33,618,188 0 2015-09 0 $0 91,934 $8,566,183 0 2015-08 0 $0 1,516,448 $142,450,067 61,823 2015-07 0 $0 393,568 $35,277,161 0 2015-06 0 $0 134,047 $11,093,052 0 2015-05 0 $0 361,317 $29,143,075 91,781 2015-04 0 $0 229,761 $18,941,517 0 2015-03 0 $0 116,934 $9,284,641 0 2015-02 0 $0 368,389 $28,051,309 85,876 2015-01 0 $0 966,822 $74,831,898 0 2014-12 0 $0 57,871 $4,381,249 0 2014-11 0 $0 632,555 $47,121,939 36,265 2014-10 0 $0 823,088 $61,703,609 0 2014-09 0 $0 725,539 $56,198,184 0 2014-08 0 $0 1,355,354 $100,639,284 36,265 2014-07 0 $0 1,328,245 $94,007,016 0 2014-06 0 $0 690,573 $44,452,417 0 2014-05 0 $0 972,410 $57,799,648 63,180 2014-04 0 $0 871,982 $53,813,407 0 2014-03 0 $0 770,969 $53,560,694 0 2014-02 0 $0 902,482 $60,481,035 24,248 2014-01 0 $0 2,115,199 $125,745,467 0 2013-12 0 $0 44,220,207 $2,428,815,636 0 2013-11 0 $0 2,507,588 $120,981,620 0 2013-10 0 $0 41,535 $2,068,428 0 2013-09 0 $0 417,604 $19,207,359 0 2013-08 0 $0 3,055,792 $118,488,516 0 2013-07 0 $0 1,098,108 $34,117,713 0 2013-06 0 $0 602,164 $14,376,406 0 2013-05 0 $0 1,886,138 $52,560,877 0 2013-04 0 $0 573,650 $15,307,419 0 2013-03 0 $0 636,513 $17,113,904 0 2013-02 0 $0 3,324,003 $97,432,758 0 2013-01 0 $0 1,292,775 $37,927,077 0 2012-12 0 $0 1,564,092 $43,050,358 0 2012-11 0 $0 3,379,690 $78,882,190 0 2012-10 0 $0 4,314,666 $96,916,284 0 2012-09 0 $0 5,850,000 $111,092,699 0 47,846 $1,006,201 21,708,068 $434,975,157 0 2012-08 2012-05 0 $0 388,526,653 $14,601,154,217 0 Stock repurchase program The company made an announcement of purchasing a share program worth $6 billion in response to within the past month for apparent reasons. Close Volume Adj Close 130.979996 24325000 130.979996 130.839996 54179400 130.839996 133.229996 42482700 133.229996 130.320007 19444000 130.320007 130.979996 18891400 130.979996 132.179993 19493900 132.179993 132.779999 19818100 132.779999 131.479996 18731300 131.479996 129.369995 15130100 129.369995 128.929993 16514200 128.929993 127.040001 18798000 127.040001 127.550003 12157100 127.550003 127.919998 13069000 127.919998 127.870003 15228000 127.870003 128.339996 24838700 128.339996 126.620003 18561300 126.620003 126.089996 18298500 126.089996 124.349998 17247300 124.349998 124.900002 22861600 124.900002 123.410004 28504400 123.410004 120.669998 19443100 120.669998 118.690002 19549800 118.690002 year is 2,845 among them 2,293 shares being for class A while 552 shares being for class B. d as the percentage of shares owned by insiders of the company in relation to the aggregate shares outstanding. Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 worth $6 billion in response to the beat down in the stock Question 2 Current ratio=current assets /current liabilities Quick ratio=current assets-inventoy/current liabilities Inventory turnover=cost of goods sold/average inventory DSO=Number of days/accounts receivable turnover Fixed asset turnover =sales /fixed assets Total asset turnover =sales/total assets Debt ratio=total liabilities/total assets Liabilities to assets ratio=liabilities/assets Times aerned ratio=EBIT/Interest expense EBITDA coverage ratio=EBITDA+lease payments/interest payment+lease payments Profit margin =profit/sales BEP=Fixed csot /contribution ROA =profit /total assets ROE=Profit/equity Price/earnings ratio= Price cash flow ratio market book ratio Company ratio 11.97 11.51 2.89 52.73 3.22 0.43 0.04 0.04 137.56 137.56 36.97% 30897.64 0.16 0.17 50.32 43.66 6.96 Industrial average 1.84 1.23 Revenue $ 1.45 48.63 Costs and expenses: 2.69 0.23 Cost of revenue 1.22 1.87 Research and development 52.89 72.56 Marketing and sales 12.34% 2359.24 General and administrative 0.09 0.12 Total costs and expenses 35.27 36.71 Income from operations 4.85 Interest and other income/(expense), net 2016 27,638 3,789 5,919 3,772 1,731 15,211 12,427 91 Income before provision for income taxes 12,518 Provision for income taxes Net income 2,301 $ Less: Net income attributable to participating securities 10,217 29 Net income attributable to Class A and Class B common stockholders $ Earnings per share attributable to Class A and Class B common stockholders: Basic 10,188 $ 3.56 Diluted 2016 Assets Current assets: Cash and cash equivalents Marketable securities $ 8,903 20,546 Accounts receivable, net of allowances for doubtful accounts of $94 and $68 as of December 31, 2016 and December 31, 2015, respectively 3,993 Prepaid expenses and other current assets 959 Total current assets 34,401 Property and equipment, net 8,591 Intangible assets, net 2,535 Goodwill 18,122 Other assets Total assets 1,312 $ 64,961 $ 302 Liabilities and stockholders' equity Current liabilities: Accounts payable Partners payable Accrued expenses and other current liabilities 280 2,203 Deferred revenue and deposits 90 Current portion of capital lease obligations Total current liabilities Capital lease obligations, less current portion Other liabilities Total liabilities Commitments and contingencies Stockholders' equity: 2,875 2,892 5,767 Common stock, $0.000006 par value; 5,000 million Class A shares authorized, 2,354 million and 2,293 million shares issued and outstanding, including 4 million and 8 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively; 4,141 million Class B shares authorized, 538 million and 552 million shares issued and outstanding, including 2 million and 3 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively Additional paid-in capital 38,227 Accumulated other comprehensive loss Retained earnings (703 21,670 Total stockholders' equity 59,194 ) 2015 $ 17,928 2,867 4,816 2,725 1,295 11,703 6,225 (31 ) 6,194 2,506 $ 3,688 19 $ 3,669 $ 1.31 2015 $ 4,907 13,527 2,559 659 21,652 5,687 3,246 18,026 796 $ 49,407 $ 196 217 1,449 56 7 1,925 107 3,157 5,189 34,886 (455 9,787 44,218 ) Common size analysis 2,016 Revenue 27,638 100.00% Cost of revenue 3,789 13.71% Research and development 5,919 21.42% Marketing and sales 3,772 13.65% General and administrative 1,731 6.26% Total costs and expenses 15,211 55.04% Income from operations 12,427 44.96% Interest and other income/ (expense), net 91 0.33% 12,518 45.29% 2,301 8.33% 10,217 36.97% 29 0.10% 10,188 36.86% Costs and expenses: Income before provision for income taxes Provision for income taxes Net income Less: Net income attributable to participating securities Net income attributable to Class A and Class B common stockholders Earnings per share attributable to Class A and Class B common stockholders: Basic $ Diluted Assets Current assets: Cash and cash equivalents 2016 8,903 13.71% Marketable securities 20,546 31.63% 3,993 6.15% 959 1.48% 34,401 52.96% Property and equipment, net 8,591 13.22% Intangible assets, net 2,535 3.90% 18,122 27.90% 1,312 2.02% 64,961 100.00% Accounts payable 302 0.46% Partners payable 280 0.43% 2,203 3.39% Deferred revenue and deposits 90 0.14% Current portion of capital lease obligations Accounts receivable, net of allowances for doubtful accounts of $94 and $68 as of December 31, 2016 and December 31, 2015, respectively Prepaid expenses and other current assets Total current assets Goodwill Other assets Total assets Liabilities and stockholders' equity Current liabilities: Accrued expenses and other current liabilities Total current liabilities Capital lease obligations, less current portion Other liabilities Total liabilities 2,875 4.43% 2,892 4.45% 5,767 8.88% Commitments and contingencies Stockholders' equity: $0.000006 par value; 5,000 million Class A shares authorized, 2,354 million and 2,293 million shares issued and outstanding, including 4 million and 8 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively; 4,141 million Class B shares authorized, 538 million and 552 million shares issued and outstanding, including 2 million and 3 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively Additional paid-in capital 38,227 58.85% Accumulated other comprehensive loss Retained earnings (703 21,670 33.36% 59,194 91.12% Total stockholders' equity 2016 Revenue $ 27,638 Costs and expenses: Cost of revenue 3,789 Research and development 5,919 Marketing and sales 3,772 General and administrative 1,731 Total costs and expenses 15,211 Income from operations 12,427 Interest and other income/(expense), net 91 Income before provision for income taxes 12,518 Provision for income taxes Net income 2,301 $ 10,217 Net income attributable to Class A and Class B common stockholders $ 10,188 Earnings per share attributable to Class A and Class B common stockholders: Basic $ 3.56 Diluted 2016 Assets Current assets: Cash and cash equivalents Marketable securities $ 8,903 20,546 Accounts receivable, net of allowances for doubtful accounts of $94 and $68 as of December 31, 2016 and December 31, 2015, respectively 3,993 Prepaid expenses and other current assets 959 Total current assets 34,401 Property and equipment, net 8,591 Intangible assets, net 2,535 Goodwill 18,122 Other assets Total assets 1,312 $ 64,961 $ 302 Liabilities and stockholders' equity Current liabilities: Accounts payable Partners payable Accrued expenses and other current liabilities 280 2,203 Deferred revenue and deposits 90 Current portion of capital lease obligations Total current liabilities 2,875 Capital lease obligations, less current portion Other liabilities Total liabilities Commitments and contingencies Stockholders' equity: 2,892 5,767 Common stock, $0.000006 par value; 5,000 million Class A shares authorized, 2,354 million and 2,293 million shares issued and outstanding, including 4 million and 8 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively; 4,141 million Class B shares authorized, 538 million and 552 million shares issued and outstanding, including 2 million and 3 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively Additional paid-in capital 38,227 Accumulated other comprehensive loss Retained earnings (703 21,670 Total stockholders' equity 59,194 %Change 2015 54.16% $ 17,928 32.16% 2,867 22.90% 4,816 38.42% 2,725 33.67% 1,295 29.98% 11,703 99.63% 6,225 193.55% 31 102.10% 6,194 -8.18% 2,506 177.03% $ 3,688 177.68% $ 3,669 171.76% $ 1.31 2015 81.43% 51.89% $ 4,907 13,527 56.04% 2,559 45.52% 659 58.88% 21,652 51.06% 5,687 -21.90% 3,246 0.53% 18,026 64.82% 796 54.08% $ 49,407 $ 196 29.03% 217 52.04% 1,449 60.71% 56 -100.00% 7 1,925 -100.00% 107 -8.39% 3,157 11.14% 5,189 9.58% 34,886 121.42% (455 9,787 33.87% 44,218 ) stock dataprice Date Open 2/3/2017 2/2/2017 2/1/2017 1/31/2017 1/30/2017 1/27/2017 1/26/2017 1/25/2017 1/24/2017 1/23/2017 1/20/2017 1/19/2017 1/18/2017 1/17/2017 1/13/2017 1/12/2017 1/11/2017 1/10/2017 1/9/2017 1/6/2017 1/5/2017 1/4/2017 High 131.240005 133.220001 132.25 130.169998 131.580002 132.679993 131.630005 130 129.380005 127.309998 128.100006 128.229996 128.410004 128.039993 127.489998 125.610001 124.349998 124.82 123.550003 120.980003 118.860001 117.550003 Low 132.850006 135.490005 133.490005 130.660004 131.580002 132.949997 133.139999 131.740005 129.899994 129.25 128.479996 128.350006 128.429993 128.339996 129.270004 126.730003 126.120003 125.5 125.43 123.879997 120.949997 119.660004 130.759995 130.399994 130.679993 129.520004 129.600006 131.080002 131.440002 129.770004 128.380005 126.949997 126.779999 127.449997 126.839996 127.400002 127.370003 124.800003 124.059998 124.279999 123.040001 120.029999 118.32 117.290001 shares outstanding The outstanding shares of the company as per 2016 financial year is 2,845 among them 2, insider ownership From the financial point of view, insider ownership is defined as the percentage of shares The face book company insider ownership is 0.30% insider transactions f insider stock purchases, sales, and option exercises for Facebook Inc (FB). Trading Period Insider Insider Sales Buying year-month Option Exercises Shares Value Shares Value Shares 2017-01 0 $0 291,744 $36,192,854 0 2016-12 0 $0 1,902,460 $226,204,254 0 2016-11 0 $0 3,402,088 $405,036,970 1,371,442 2016-10 0 $0 5,368,646 $695,974,164 0 2016-09 0 $0 5,873,580 $757,708,226 0 2016-08 0 $0 5,657,341 $705,540,517 1,358,414 2016-07 0 $0 2,403,361 $282,996,788 0 2016-06 0 $0 3,794,862 $430,224,235 0 2016-05 0 $0 7,523,819 $890,949,470 1,377,301 2016-04 0 $0 3,859,470 $434,720,174 0 2016-03 0 $0 4,295,818 $477,043,970 0 2016-02 0 $0 4,502,227 $468,337,194 1,365,488 2016-01 0 $0 134,803 $12,876,923 0 2015-12 0 $0 41,934 $4,426,563 0 2015-11 0 $0 6,960,127 $729,001,465 5,446,741 2015-10 0 $0 337,647 $33,618,188 0 2015-09 0 $0 91,934 $8,566,183 0 2015-08 0 $0 1,516,448 $142,450,067 61,823 2015-07 0 $0 393,568 $35,277,161 0 2015-06 0 $0 134,047 $11,093,052 0 2015-05 0 $0 361,317 $29,143,075 91,781 2015-04 0 $0 229,761 $18,941,517 0 2015-03 0 $0 116,934 $9,284,641 0 2015-02 0 $0 368,389 $28,051,309 85,876 2015-01 0 $0 966,822 $74,831,898 0 2014-12 0 $0 57,871 $4,381,249 0 2014-11 0 $0 632,555 $47,121,939 36,265 2014-10 0 $0 823,088 $61,703,609 0 2014-09 0 $0 725,539 $56,198,184 0 2014-08 0 $0 1,355,354 $100,639,284 36,265 2014-07 0 $0 1,328,245 $94,007,016 0 2014-06 0 $0 690,573 $44,452,417 0 2014-05 0 $0 972,410 $57,799,648 63,180 2014-04 0 $0 871,982 $53,813,407 0 2014-03 0 $0 770,969 $53,560,694 0 2014-02 0 $0 902,482 $60,481,035 24,248 2014-01 0 $0 2,115,199 $125,745,467 0 2013-12 0 $0 44,220,207 $2,428,815,636 0 2013-11 0 $0 2,507,588 $120,981,620 0 2013-10 0 $0 41,535 $2,068,428 0 2013-09 0 $0 417,604 $19,207,359 0 2013-08 0 $0 3,055,792 $118,488,516 0 2013-07 0 $0 1,098,108 $34,117,713 0 2013-06 0 $0 602,164 $14,376,406 0 2013-05 0 $0 1,886,138 $52,560,877 0 2013-04 0 $0 573,650 $15,307,419 0 2013-03 0 $0 636,513 $17,113,904 0 2013-02 0 $0 3,324,003 $97,432,758 0 2013-01 0 $0 1,292,775 $37,927,077 0 2012-12 0 $0 1,564,092 $43,050,358 0 2012-11 0 $0 3,379,690 $78,882,190 0 2012-10 0 $0 4,314,666 $96,916,284 0 2012-09 0 $0 5,850,000 $111,092,699 0 47,846 $1,006,201 21,708,068 $434,975,157 0 2012-08 2012-05 0 $0 388,526,653 $14,601,154,217 0 Stock repurchase program The company made an announcement of purchasing a share program worth $6 billion in response to within the past month for apparent reasons. Close Volume Adj Close 130.979996 24325000 130.979996 130.839996 54179400 130.839996 133.229996 42482700 133.229996 130.320007 19444000 130.320007 130.979996 18891400 130.979996 132.179993 19493900 132.179993 132.779999 19818100 132.779999 131.479996 18731300 131.479996 129.369995 15130100 129.369995 128.929993 16514200 128.929993 127.040001 18798000 127.040001 127.550003 12157100 127.550003 127.919998 13069000 127.919998 127.870003 15228000 127.870003 128.339996 24838700 128.339996 126.620003 18561300 126.620003 126.089996 18298500 126.089996 124.349998 17247300 124.349998 124.900002 22861600 124.900002 123.410004 28504400 123.410004 120.669998 19443100 120.669998 118.690002 19549800 118.690002 year is 2,845 among them 2,293 shares being for class A while 552 shares being for class B. d as the percentage of shares owned by insiders of the company in relation to the aggregate shares outstanding. Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 worth $6 billion in response to the beat down in the stock Question 2 Current ratio=current assets /current liabilities Quick ratio=current assets-inventoy/current liabilities Inventory turnover=cost of goods sold/average inventory DSO=Number of days/accounts receivable turnover Fixed asset turnover =sales /fixed assets Total asset turnover =sales/total assets Debt ratio=total liabilities/total assets Liabilities to assets ratio=liabilities/assets Times aerned ratio=EBIT/Interest expense EBITDA coverage ratio=EBITDA+lease payments/interest payment+lease payments Profit margin =profit/sales BEP=Fixed csot /contribution ROA =profit /total assets ROE=Profit/equity Price/earnings ratio= Price cash flow ratio market book ratio Company ratio 11.97 11.51 2.89 52.73 3.22 0.43 0.04 0.04 137.56 137.56 36.97% 30897.64 0.16 0.17 50.32 43.66 6.96 Industrial average 1.84 1.23 Revenue $ 1.45 48.63 Costs and expenses: 2.69 0.23 Cost of revenue 1.22 1.87 Research and development 52.89 72.56 Marketing and sales 12.34% 2359.24 General and administrative 0.09 0.12 Total costs and expenses 35.27 36.71 Income from operations 4.85 Interest and other income/(expense), net 2016 27,638 3,789 5,919 3,772 1,731 15,211 12,427 91 Income before provision for income taxes 12,518 Provision for income taxes Net income 2,301 $ Less: Net income attributable to participating securities 10,217 29 Net income attributable to Class A and Class B common stockholders $ Earnings per share attributable to Class A and Class B common stockholders: Basic 10,188 $ 3.56 Diluted 2016 Assets Current assets: Cash and cash equivalents Marketable securities $ 8,903 20,546 Accounts receivable, net of allowances for doubtful accounts of $94 and $68 as of December 31, 2016 and December 31, 2015, respectively 3,993 Prepaid expenses and other current assets 959 Total current assets 34,401 Property and equipment, net 8,591 Intangible assets, net 2,535 Goodwill 18,122 Other assets Total assets 1,312 $ 64,961 $ 302 Liabilities and stockholders' equity Current liabilities: Accounts payable Partners payable Accrued expenses and other current liabilities 280 2,203 Deferred revenue and deposits 90 Current portion of capital lease obligations Total current liabilities Capital lease obligations, less current portion Other liabilities Total liabilities Commitments and contingencies Stockholders' equity: 2,875 2,892 5,767 Common stock, $0.000006 par value; 5,000 million Class A shares authorized, 2,354 million and 2,293 million shares issued and outstanding, including 4 million and 8 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively; 4,141 million Class B shares authorized, 538 million and 552 million shares issued and outstanding, including 2 million and 3 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively Additional paid-in capital 38,227 Accumulated other comprehensive loss Retained earnings (703 21,670 Total stockholders' equity 59,194 ) 2015 $ 17,928 2,867 4,816 2,725 1,295 11,703 6,225 (31 ) 6,194 2,506 $ 3,688 19 $ 3,669 $ 1.31 2015 $ 4,907 13,527 2,559 659 21,652 5,687 3,246 18,026 796 $ 49,407 $ 196 217 1,449 56 7 1,925 107 3,157 5,189 34,886 (455 9,787 44,218 ) Common size analysis 2,016 Revenue 27,638 100.00% Cost of revenue 3,789 13.71% Research and development 5,919 21.42% Marketing and sales 3,772 13.65% General and administrative 1,731 6.26% Total costs and expenses 15,211 55.04% Income from operations 12,427 44.96% Interest and other income/ (expense), net 91 0.33% 12,518 45.29% 2,301 8.33% 10,217 36.97% 29 0.10% 10,188 36.86% Costs and expenses: Income before provision for income taxes Provision for income taxes Net income Less: Net income attributable to participating securities Net income attributable to Class A and Class B common stockholders Earnings per share attributable to Class A and Class B common stockholders: Basic $ Diluted Assets Current assets: Cash and cash equivalents 2016 8,903 13.71% Marketable securities 20,546 31.63% 3,993 6.15% 959 1.48% 34,401 52.96% Property and equipment, net 8,591 13.22% Intangible assets, net 2,535 3.90% 18,122 27.90% 1,312 2.02% 64,961 100.00% Accounts payable 302 0.46% Partners payable 280 0.43% 2,203 3.39% Deferred revenue and deposits 90 0.14% Current portion of capital lease obligations Accounts receivable, net of allowances for doubtful accounts of $94 and $68 as of December 31, 2016 and December 31, 2015, respectively Prepaid expenses and other current assets Total current assets Goodwill Other assets Total assets Liabilities and stockholders' equity Current liabilities: Accrued expenses and other current liabilities Total current liabilities Capital lease obligations, less current portion Other liabilities Total liabilities 2,875 4.43% 2,892 4.45% 5,767 8.88% Commitments and contingencies Stockholders' equity: $0.000006 par value; 5,000 million Class A shares authorized, 2,354 million and 2,293 million shares issued and outstanding, including 4 million and 8 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively; 4,141 million Class B shares authorized, 538 million and 552 million shares issued and outstanding, including 2 million and 3 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively Additional paid-in capital 38,227 58.85% Accumulated other comprehensive loss Retained earnings (703 21,670 33.36% 59,194 91.12% Total stockholders' equity 2016 Revenue $ 27,638 Costs and expenses: Cost of revenue 3,789 Research and development 5,919 Marketing and sales 3,772 General and administrative 1,731 Total costs and expenses 15,211 Income from operations 12,427 Interest and other income/(expense), net 91 Income before provision for income taxes 12,518 Provision for income taxes Net income 2,301 $ 10,217 Net income attributable to Class A and Class B common stockholders $ 10,188 Earnings per share attributable to Class A and Class B common stockholders: Basic $ 3.56 Diluted 2016 Assets Current assets: Cash and cash equivalents Marketable securities $ 8,903 20,546 Accounts receivable, net of allowances for doubtful accounts of $94 and $68 as of December 31, 2016 and December 31, 2015, respectively 3,993 Prepaid expenses and other current assets 959 Total current assets 34,401 Property and equipment, net 8,591 Intangible assets, net 2,535 Goodwill 18,122 Other assets Total assets 1,312 $ 64,961 $ 302 Liabilities and stockholders' equity Current liabilities: Accounts payable Partners payable Accrued expenses and other current liabilities 280 2,203 Deferred revenue and deposits 90 Current portion of capital lease obligations Total current liabilities 2,875 Capital lease obligations, less current portion Other liabilities Total liabilities Commitments and contingencies Stockholders' equity: 2,892 5,767 Common stock, $0.000006 par value; 5,000 million Class A shares authorized, 2,354 million and 2,293 million shares issued and outstanding, including 4 million and 8 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively; 4,141 million Class B shares authorized, 538 million and 552 million shares issued and outstanding, including 2 million and 3 million outstanding shares subject to repurchase, as of December 31, 2016 and December 31, 2015, respectively Additional paid-in capital 38,227 Accumulated other comprehensive loss Retained earnings (703 21,670 Total stockholders' equity 59,194 %Change 2015 54.16% $ 17,928 32.16% 2,867 22.90% 4,816 38.42% 2,725 33.67% 1,295 29.98% 11,703 99.63% 6,225 193.55% 31 102.10% 6,194 -8.18% 2,506 177.03% $ 3,688 177.68% $ 3,669 171.76% $ 1.31 2015 81.43% 51.89% $ 4,907 13,527 56.04% 2,559 45.52% 659 58.88% 21,652 51.06% 5,687 -21.90% 3,246 0.53% 18,026 64.82% 796 54.08% $ 49,407 $ 196 29.03% 217 52.04% 1,449 60.71% 56 -100.00% 7 1,925 -100.00% 107 -8.39% 3,157 11.14% 5,189 9.58% 34,886 121.42% (455 9,787 33.87% 44,218 )

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

Real Estate Finance and Investments

Authors: William Brueggeman, Jeffrey Fisher

14th edition

73377333, 73377339, 978-0073377339

More Books

Students also viewed these Finance questions

Question

=+7-32. Work Problem 7-28 if the glazing system is 5b.

Answered: 1 week ago