AutoSave On Ratio Analysis Worksheet(1) (1) - Excel Search Dillan Porry DP File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri ~A A == 82 Wrap Text General EX NI 27 O 4 Paste X Out [Copy * Format Painter Clipboard Insert Delete format Idees BIU. Marge Center $ -% -8 AutoSum Brill Sort & Tind Clear Filter Select Eding Conditional Format as Cell Formatting Table Styles Styles Font Alignment Number Cels dias 030 ! 1 K L M N U P Q B R S T V w X A B D H 1 Student Names: 2 Use the financial information provided for Snapchat to calculate the ratice listed below for 2016 and 2017. 3 what do these ralius tell you about the liquidity, use of assets activity. Timancial leverage idealan proteiity of the company from one year to the next? 5 what is improving in the company and what is getting worse? 4 1 2011 2010 Income Statement: Balance sheet: Current ratio RAE J2/31/2017 2016 Period Ending 31/2017 12/31/2016 8 Tasal Raw 824949 404,482 Carwin Cost of Revenue 677,148 451,5601 Total Asset 9 Turnover Days Sales 10 Outstanding Times Interest 11 Earned 12 Debt Ratio Cash Case Egle 334063 Gruss Profit 147.801 -47,178 Storm Operwig Expenses Par Marchables Operating Profil Margin Development 1,525,151 183,618 Story 13 Net Profit Margin 2,043,586 289,404 Tanel Chur 2,366,704 1,179,95 ichigative 74 13 Non Recurring 22.00 11,500 Longo Proper Pawan 24,470 185 166,70 100,95 16 Others Total Operating Experte Operating 1.270,658 921,867 Good 639,182 319,137 17 Sheet1 + Ready -- 80% Type here to search O w 'o ENC 1:11 PM 1/30/2021 AutoSave On Ratio Analysis Worksheet(1) (1) - Excel Search Dillan Porry DP File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri ~A A == 89 Wrap Text General NI EX Insert Delete Format 27 O 4 Brill X Out [Copy Paste * Format Painter Cipboard Idees BIU H Merge & Center $ % -8 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Tind Filter Select Eding Font Alignment Number Cels dias 030 f A B D D E H ! M N N P o R S T V w X 166,45 18 19 F Operating -3,445,709 -520.383 Tricomar Loss Income from Cowinwing Openlos Total Osler come Experces -17,699 -1,338 Ner Ower 585 33303 DeLone Tere ssar Charger 20 -520,385 Tul. 3,421,566 1.722.792 21 -1,424 CNTTM Liability -521,723 dowe 71,194 8,419 Fassing Regar -3,443,709 Interval ww Taxe Interest Expense -3.456 Incone Bolor Tat -3,453,408 Income Tax Expense 18,342 Minority Interest Net Income From -3.445.066 Continuing Ou -7,080 Siare Cu Long 16,083 15,140 24 231 631 25 314,643 -514,643 346,256 156.744 26 Our Care 2 Tore! Charme Lobilier Longe Door Other Libres Tanel Lobeli 30 31 66,920 31,994 429239 203.875 Stockholders' Equity 12 4656667 -12072 16.152 206 4,834,539 2,067 2.14 Cow Stock Red tarny Stock CoolSwis Our Stockholder Rouin Tah'' Tata Lets TN Stockholder Equity 39 34 35 2,992.327 1,518.913 3,421.866 1.722.792 20 40 Sheet1 + Ready M -- 80% Type here to search o W ENC 1:11 PM 1/30/2021 AutoSave On Ratio Analysis Worksheet(1) (1) - Excel Search Dillan Porry DP File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri ~A A == 82 Wrap Text General EX NI 27 O 4 Paste X Out [Copy * Format Painter Clipboard Insert Delete format Idees BIU. Marge Center $ -% -8 AutoSum Brill Sort & Tind Clear Filter Select Eding Conditional Format as Cell Formatting Table Styles Styles Font Alignment Number Cels dias 030 ! 1 K L M N U P Q B R S T V w X A B D H 1 Student Names: 2 Use the financial information provided for Snapchat to calculate the ratice listed below for 2016 and 2017. 3 what do these ralius tell you about the liquidity, use of assets activity. Timancial leverage idealan proteiity of the company from one year to the next? 5 what is improving in the company and what is getting worse? 4 1 2011 2010 Income Statement: Balance sheet: Current ratio RAE J2/31/2017 2016 Period Ending 31/2017 12/31/2016 8 Tasal Raw 824949 404,482 Carwin Cost of Revenue 677,148 451,5601 Total Asset 9 Turnover Days Sales 10 Outstanding Times Interest 11 Earned 12 Debt Ratio Cash Case Egle 334063 Gruss Profit 147.801 -47,178 Storm Operwig Expenses Par Marchables Operating Profil Margin Development 1,525,151 183,618 Story 13 Net Profit Margin 2,043,586 289,404 Tanel Chur 2,366,704 1,179,95 ichigative 74 13 Non Recurring 22.00 11,500 Longo Proper Pawan 24,470 185 166,70 100,95 16 Others Total Operating Experte Operating 1.270,658 921,867 Good 639,182 319,137 17 Sheet1 + Ready -- 80% Type here to search O w 'o ENC 1:11 PM 1/30/2021 AutoSave On Ratio Analysis Worksheet(1) (1) - Excel Search Dillan Porry DP File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri ~A A == 89 Wrap Text General NI EX Insert Delete Format 27 O 4 Brill X Out [Copy Paste * Format Painter Cipboard Idees BIU H Merge & Center $ % -8 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Tind Filter Select Eding Font Alignment Number Cels dias 030 f A B D D E H ! M N N P o R S T V w X 166,45 18 19 F Operating -3,445,709 -520.383 Tricomar Loss Income from Cowinwing Openlos Total Osler come Experces -17,699 -1,338 Ner Ower 585 33303 DeLone Tere ssar Charger 20 -520,385 Tul. 3,421,566 1.722.792 21 -1,424 CNTTM Liability -521,723 dowe 71,194 8,419 Fassing Regar -3,443,709 Interval ww Taxe Interest Expense -3.456 Incone Bolor Tat -3,453,408 Income Tax Expense 18,342 Minority Interest Net Income From -3.445.066 Continuing Ou -7,080 Siare Cu Long 16,083 15,140 24 231 631 25 314,643 -514,643 346,256 156.744 26 Our Care 2 Tore! Charme Lobilier Longe Door Other Libres Tanel Lobeli 30 31 66,920 31,994 429239 203.875 Stockholders' Equity 12 4656667 -12072 16.152 206 4,834,539 2,067 2.14 Cow Stock Red tarny Stock CoolSwis Our Stockholder Rouin Tah'' Tata Lets TN Stockholder Equity 39 34 35 2,992.327 1,518.913 3,421.866 1.722.792 20 40 Sheet1 + Ready M -- 80% Type here to search o W ENC 1:11 PM 1/30/2021