FACEBOOK, INC. CONSOLIDATED STATEMENTS OF INCOME Wins. Ai pur share amuns 2019 2018 Revenue $ 70,697 $ 55,838 Costs and expenses: Cost of revenue 12,770 9,355 Research and development 13,600 10,273 Marketing and sales 9,876 7,846 General and administrative 10,465 3,451 Total costs and expenses 46,711 30,925 Earnings before interest and taxes 23,986 24,913 Interest and other income, net 826 448 Note: times Income before provision for income taxes 24,812 25,361 Provision for income taxes 6,327 3,249 Net income $ 18,485 $ 22,112 FACEBOOK, INC. CONSOLIDATED BALANCE SHEETS li mwilinis. exerky number of shares ada aku Assets Current assets: Cash and cash equivalents $ 19,079 $ 10.019 $ 8,079 Marketable securities 35,776 31,095 33,632 Accounts receivable, net of allowances of $206 and $229 as of December 31, 2019 and December 31, 2018, respectively 9,518 7,587 5,832 Prepaid expenses and other current assets 1,852 1,779 1,020 Total current assets 66,225 50,480 48,563 Property and equipment, net 35,323 24,683 13.721 Operating lease right-of-use assets, net 9,460 ntangible assets, net 894 1,294 1,884 Goodwill 18,715 18,301 18,221 Other assets 2,759 2,576 2,135 Total assets $ 133,376 $ 97,334 $ 84,524 Liabilities and stockholders' equity Current liabilities: Accounts payable $ 1,363 $ 820 $ 380 886 541 390 Partners payable Operating lease liabilities, current 800 Accounts payable 1,363 $ 820 $ 380 Partners payable 886 541 390 Operating lease liabilities, current 800 Accrued expenses and other current liabilities 11,735 5,509 2,892 Deferred revenue and deposits 269 147 98 Total current liabilities 15,053 7,017 3,760 perating lease liabilities, non- urrent 9,524 ther liabilities 7,745 6,190 6,417 Total liabilities 32,322 13,207 10,177 commitments and ontingencies tockholders' equity: Common stock, $0.000006 par value; 45,851 42,906 40,584 Additional paid-in capital Accumulated other comprehensive loss Retained earnings (489) (760) (227) 55,692 41,981 33,990 Total stockholders' equity 101,054 84,127 74,347 otal liabilities and tockholders' equity $ 133,376 $ 97,334 FA 84,524 Directions: 1 2 3 4 Fill in the yellow highlighted cells using the financial statements in the other 2 spreadsheets. You will calculate 2 years' of ratios for each company. Most Current Year Previous Year #DIV/0! #DIV/0! 9 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 Last year A/R Last year A/R A/R 2 years ago #DIV/0! #DIV/0! 0 0 inventory 2 years ago Last year inventory Last year inventory Facebook Ratios: 6 Liquidity and Efficiency Ratios: 7 8 Current Assets Current Ratio Current Liabilities 10 11 Cash + Short-term Investments + Receivables Acid-Test Ratio 2 Current Liabilities 13 14 A/R Turnover Net Sales 15 Avg. Accounts Receivable 16 This year A/R 17 Avg. A/R Calculation 18 19 Inventory Turnover Cost of Goods Sold 20 Avg. Inventory 21 This year inventory 22 Avg. Inventory Calculation 23 24 Total Asset Turnover Net Sales 25 Avg. Total Assets 26 This year total assets 27 Avg. Total Assets Calculation 28 29 0 Solvency Ratios: 31 32 Debt Ratio Total Liabilities 3 Total Assets 34 4 35 Times Interest Earned Earnings before Interest and Taxes 56 6 Interest Expense 87 38 Profitability Ratios: 39 10 Profit Margin Ratio Net Income 21 Net Sales #DIV/0! #DIV/0! " 0 Last year total assets Last year total assets total assets 2 years ago #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! - #DIV/0! Acid-Test Ratio Cash + Short-term Investments + Receivables Current Liabilities #DIV/0! #DIV/0! A/R Turnover Net Sales Avg. Accounts Receivable #DIV/0! #DIV/0! This year A/R Last year A/R Last year A/R A/R 2 years ago Avg. A/R Calculation Inventory Turnover Cost of Goods Sold Avg. Inventory #DIV/0! #DIV/0! 0 0 This year inventory Last year inventory Last year inventory inventory 2 years ago Avg. Inventory Calculation Total Asset Turnover Net Sales Avg. Total Assets #DIV/0! #DIV/0! 0 0 Last year total assets This year total assets Last year total assets total assets 2 years ago Avg. Total Assets Calculation Solvency Ratios: Debt Ratio Total Liabilities Total Assets #DIV/0! #DIV/0! Times Interest Earned Earnings before Interest and Taxes Interest Expense #DIV/0! = #DIV/0! Profitability Ratios: Profit Margin Ratio Net Income Net Sales #DIV/0! #DIV/0! Gross Profit Ratio Gross Profit Net Sales = #DIV/0! = #DIV/0! Return on Assets Ratio Net Income Avg. Total Assets #DIV/0! = #DIV/0! calculated from above Return on Equity Ratio Net Income Avg. Stockholders' Equity #DIV/0! #DIV/0! 0 Last year total equity This year total equity This year total equity Last year total equity
