Financial ratios

profileknezle
Here are simplified financial statements of Phone Corporation from a recent year:

   

INCOME STATEMENT
(Figures in millions of dollars)
  Net sales12,300  
  Cost of goods sold3,610  
  Other expenses4,022  
  Depreciation2,248  
 
  Earnings before interest and taxes (EBIT)2,420  
  Interest expense640  
 
  Income before tax1,780  
  Taxes (at 35%)623  
 
  Net income1,157  
  Dividends756  
 


    

BALANCE SHEET
(Figures in millions of dollars)
 End of YearStart of Year
  Assets  
     Cash and marketable securities80  149  
     Receivables1,932  2,310  
     Inventories142  193  
     Other current assets822  887  
 

        Total current assets2,976  3,539  
     Net property, plant, and equipment19,883  19,825  
     Other long-term assets4,126  3,680  
 

        Total assets26,985  27,044  
 



  Liabilities and shareholders’ equity  
     Payables2,474  2,950  
     Short-term debt1,374  1,528  
     Other current liabilities766  742  
 

        Total current liabilities4,614  5,220  
     Long-term debt and leases9,259  8,444  
     Other long-term liabilities6,088  6,059  
     Shareholders’ equity7,024  7,321  
 

        Total liabilities and shareholders’ equity26,985  27,044  
 




   

Calculate the following financial ratios: (Use 365 days in a year. Do not round intermediate calculations.Round your answers to 2 decimal places.)

    

    
 a.Long-term debt ratio[removed] 
 b.Total debt ratio[removed] 
 c.Times interest earned[removed] 
 d.Cash coverage ratio[removed] 
 e.Current ratio[removed] 
 f.Quick ratio[removed] 
 g.Operating profit margin[removed] %
 h.Inventory turnover[removed] 
 i.Days in inventory[removed] days
 j.Average collection period[removed] days
 k.Return on equity[removed] %*
 l.Return on assets[removed] %
 m.Return on capital[removed] %**
 n.Payout ratio[removed] 

 

    • 11 years ago
    • 10
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      ratios.xlsx
    • attachment
      ratios.xlsx