Otomatik Kaydet HD financialratiosexercise (1) - Uyumluluk Modu - Excel Ara yiit saklica x Dosya Giri Ekle Sayfa Dzeni Formller Veri Gzden Geir Grnm Yardm Payla Aklamalar Otomatik Toplam LO Arial 10 ~A? ab Metni Kaydr Genel 2 Doldur Yaptr Ekle Sil ar Av Biim Duyarllk Birletir ve Ortala v LE %90 Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Temizle Srala ve Filtre Bul ve Uygula Se Pano Yaz Tipi Hizalama Sayi Stiller Hcreler Dzenleme Duyarllk K46 fic L M N O Q R S T U V W X - I J A B D E F. G . J K 1 2 Advertising Agency Airline Commercial Bank 3 Computer Software Developer Department Store Chain Electric & Gas Utility 4 Health Maintenance Org. Meat Packer Pharmaceutical Manufacturer 5 Retail Drug Chain Retail Grocery Chain 6 7 8 A B D E F G H 9 Line Balance Sheet Percentages 10 #1 Cash and marketable securities 5 12 2 1 4 4 3 77 11 2 Account receivables 85 55 4 15 7 6 4 7 12 3 Inventories 0 0 1 24 43 0 22 0 13 4 Other current assets 1 4 2 2 4 6 2 3 14 5 Plant and equipment (net) 2 7 77 55 37 71 41 9 15 6 Other assets 7 23 15 3 5 13 29 4 16 7 Total assets 100 100 100 100 100 100 100 100 17 18 8 Notes payable 62 3 0 2 0 4 2 0 19 9 Accounts payable 18 63 3 17 18 5 13 32 20 10 Accrued taxes 2 2 0 1 1 0 1 3 21 11 Other current liabilities 0 0 4 9 17 17 12 2 22 12 Long-term debt 7 6 29 38 0 40 29 0 23 13 Preferred stock 4 8 21 5 10 17 14 1 24 14 Other liabilities 2 0 5 3 0 0 0 0 25 15 Capital stock and capital surplus 2 10 11 1 3 12 5 11 26 16 Retained earnings 4 7 28 23 51 5 24 51 27 17 Total liabilities and stockholder equity 100 100 100 100 100 100 100 100 28 29 Selected Financial Data 30 18 Current assets/current liabilities 1,11 1,03 1,31 1,46 1.59 0,63 1,1 2,35 19 Cash, marketable securities and accounts 31 receivable/current liabilities 11 0.98 1.4 1:49 104 2 28 Sheet1 9 28 13 3 35 13 100 67 9 2 2 17 2 100 19 13 12 6 48 1 100 0 6 7 5 6 0 15 6 13 19 6 5 0 0 2 8 15 1 0 16 46 100 0 0 24 18 100 28 55 100 1,58 4,72 2,31 0.97 04 15 4.59 203 Otomatik Kaydet HD financialratiosexercise (1) - Uyumluluk Modu - Excel Ara yiit saklica x Dosya Giri Ekle Sayfa Dzeni Formller Veri Gzden Geir Grnm Yardm Payla Aklamalar Otomatik Toplam LO Arial 10 ~A? ab Metni Kaydr Genel 2 Doldur Yaptr Ekle Sil ar Av Biim Duyarllk Birletir ve Ortala v LE %90 Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Temizle Srala ve Filtre Bul ve Uygula Se Pano Yaz Tipi Hizalama Sayi Stiller Hcreler Dzenleme Duyarllk K46 fic L M N O Q R S T U V W X - I J A B D E F. G . J K 1 2 Advertising Agency Airline Commercial Bank 3 Computer Software Developer Department Store Chain Electric & Gas Utility 4 Health Maintenance Org. Meat Packer Pharmaceutical Manufacturer 5 Retail Drug Chain Retail Grocery Chain 6 7 8 A B D E F G H 9 Line Balance Sheet Percentages 10 #1 Cash and marketable securities 5 12 2 1 4 4 3 77 11 2 Account receivables 85 55 4 15 7 6 4 7 12 3 Inventories 0 0 1 24 43 0 22 0 13 4 Other current assets 1 4 2 2 4 6 2 3 14 5 Plant and equipment (net) 2 7 77 55 37 71 41 9 15 6 Other assets 7 23 15 3 5 13 29 4 16 7 Total assets 100 100 100 100 100 100 100 100 17 18 8 Notes payable 62 3 0 2 0 4 2 0 19 9 Accounts payable 18 63 3 17 18 5 13 32 20 10 Accrued taxes 2 2 0 1 1 0 1 3 21 11 Other current liabilities 0 0 4 9 17 17 12 2 22 12 Long-term debt 7 6 29 38 0 40 29 0 23 13 Preferred stock 4 8 21 5 10 17 14 1 24 14 Other liabilities 2 0 5 3 0 0 0 0 25 15 Capital stock and capital surplus 2 10 11 1 3 12 5 11 26 16 Retained earnings 4 7 28 23 51 5 24 51 27 17 Total liabilities and stockholder equity 100 100 100 100 100 100 100 100 28 29 Selected Financial Data 30 18 Current assets/current liabilities 1,11 1,03 1,31 1,46 1.59 0,63 1,1 2,35 19 Cash, marketable securities and accounts 31 receivable/current liabilities 11 0.98 1.4 1:49 104 2 28 Sheet1 9 28 13 3 35 13 100 67 9 2 2 17 2 100 19 13 12 6 48 1 100 0 6 7 5 6 0 15 6 13 19 6 5 0 0 2 8 15 1 0 16 46 100 0 0 24 18 100 28 55 100 1,58 4,72 2,31 0.97 04 15 4.59 203