FILL IN THE YELLOW HIGHLIGHTED CELLS USING THE FINANCIAL STATEMENTS IN THE OTHER 2 SPREADSHEETS. CALCULATE 2 YEARS OF RATIOS FOR EACH COMPANY

facebook vs twitter ratios

-first 4 = facebook

ambers File Edit Insert Table Organize Format Arrange View Share Window Help Financial Statement Analysis Project Ratios -- Facebook 125% T View Zoom Ad Category Insert Tablo Chart Text Shape Media + Facebook Twitter Ratio Calculations B C D E F G H 3 FACEBOOK, INC. CONSOLIDATED STATEMENTS OF INCOME milions, except per share amounts) 5 7 2010 2018 Revenue $ 10 70.697 $ 56,838 11 Costs and expenses: 12 13 14 Cost of revenue 12.770 9,355 15 Research and development 13,600 10,273 16 12 TE Marketing and sales 9,876 7.846 General and administrative 10,465 3,451 20 Total costs and expenses 46,711 30,925 Earnings before interest and taxes 23,986 24,913 24 Interest and other income, not 826 26 Nati time Tom CONSOLIDATED STATEMENTS OF INCOME TE 24 stv ambers File Edit insert Table Organize Format Arrange View Share Window Help Financial Statement Analysis Project Ratios - Facebook vs Twitter 2016 T NI Insert tatue Chart Media Cum + Facebook Twitter Ratio Calculations C 0 o H times interest and 2 hooma bolore provision for thcome to 24,512 25361 25 Provision for income 6.39 3,249 30 Net Income 33 5 18.45 22.112 16 35 FACEBOOK, INC CONSOLIDATED BALANCE SHEETS 30 in milions, except for number of shares and para 30 41 4 2018 2 Assets A Current and 46 Cash and cash $ 10010 8,079 Marketable securities 119 35,770 31,005 Accounts receivable to wowances of $200 $223 of December 31, 2010 and December 31, 2018.rectively 9,510 7,557 5.832 SI Pred and the CONSOLIDATED STATEMENTS OF INCOME 24 etv ia 293 so F bu 3- Te 2 3 $ 4 & 7 5 6 8 9 Flie Edit insert 1204 Table Organize Format Arrange View Share Window Help Financial Statement Analysis Project Ratios Facebook vs Twitter .. MC int Table Chart Shap Mes comma Twitter Ratio Calculations Facebook 0 D 1.52 1,770 Prepaid expenses and other current stats 1.000 16 68325 Total current assos 48.560 50,480 24,683 18,721 35,323 Property and equipment, nat Opening lhouse net 9,400 1,884 1.294 894 Intangible sot, net Good +8,291 18.301 18.715 64 65 2.135 2.576 2.750 Other assets 133.370 Total assets 97834 84.524 67 Liabilities and stockholders' equity 10 7 73 Current 1.3 820 380 20 888 541 390 Partners payable Opening 17 BOO Acord expenses and other currentes 11.735 5.509 2002 an 747 Datoedrovence and 200 deposits Total units 15.05 CONSOUDATED STATEMENTS OF INCOM 7017 270 24 sty ! 90 S8 Du 18 FE FS IN $ % & Numbers Edt Insert Table Organic Format Arrange View Share Window Help Franco Santa Project - Facebook Twitter T Table Chart Text Twitter tination GO D Acer 11.735 5.500 2.00 209 147 Deferred over and doo Total current 55.00 7,017 3,750 Curro Omeri 7.345 6.100 5.417 32 322 13:20 10.177 Comments and contingencies Commons 45.00 0:06 20,584 Action Mounted her combensive Run (490 080) 55.602 01 11 3.000 101654 64.127 14.347 Totale and ockholders $ 13337 07-334 8454 CONSOLIDATED STATEMENT OF INCOME IV GO esc SO ora 1: D 18 % 2 3 $ 4 6 & 7 8 Q W E R T Y Fie fot insert Table Organize Format Arrange View Share Window Help Financial Statement Analysis Project Ratios Facebook vs Twitter Chat Test Shape and Company Rallo Calculations Facebook TWITTER.INC CONSOUDATED STATEMENTS OF OPERATIONS Onthousands, except per shared 2011 2010 30250 Cost of Red sales and man Tutar getallid wespere 1.137.641 682.21 53,813 350.00 1,000 33 138180 15,709 40 BEST 563.850 771 298,810 25 45332 -132.00 111.221 -390 424 Oreo combine Pico 1.075,50 - Netcome TA 1.205.568 TWITTER CONSOLIDATED BALANCE SHEETS hands, Der 2050 Dec 2013 December Ba tui TOG 124 tv A * bu DD # 3 A 2 $ 4 5 6 7 8 9 C . ambers File Edit Insert Table Organize Format Amage View Share Window Help Financial statement Analysis Project Ratios Facebook Twitter T Table Chan Facebook Racacions ba Cribor Current 4444 41300 0.14 431405 78.700 Internet Account wordt RADIO Prepaid expenses The te Pront 5,63 413 2.764,000 564,268 254,514 53212684 773.715 0330 112.05 TA ON 1,001,711 000 56.100 12 90 154 27033 45.00 222 Gow Desde On Total 69.65 1.1.335 10,455 67.834 712 15,705 S wie scho'quity 11.14 500 A Noorder On som Opergo 145.180 15.750 SOT 13 17000 327333 146.35 68040 3163 1,700 114,976 583 278 1,627460 1083 Tour Com George Opetugas France logo Dewan Omerom COB 206 24.TTO 20 7. 24107 B1,308 13.24 89973 2,365,260 97.02 Command Prele 10.000 mund De 10 000 000.000 where ding 24 dtv MacBook 30 983 4 2 # 3 $ 4 5 6 & 7 8 9 Q W E R T Y U 0 File Edit Insert Table Organize Format Arrange View Share Window Help Financial Statement Analysis Project Ratio -- Facebook Twitter Table Chan Mad Cane Ratio Calcio 81300 Facebook Twitter Firsen Delong beset 244 1740 24.170 13.240 62.500 24.107 2003 2.305 259 Costa and to a 56) BY Pred 10000005 par 200.000 har hoved one ing Conok. 1000000 0.000.000 70017257 harus dan dy Aanaa Num.com Tureng der Tutors Tour 10.534 11 SM -65311 1454.07 GE 1007 7.750.522 3150 2671,720 5047 218 12 24 otv TS ga DU DO : $ %