Question

In: Finance

Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in...

Here are simplified financial statements for Phone Corporation in a recent year:

INCOME STATEMENT
(Figures in $ millions)
Net sales $ 12,700
Cost of goods sold 3,810
Other expenses 4,112
Depreciation 2,368
Earnings before interest and taxes (EBIT) $ 2,410
Interest expense 660
Income before tax $ 1,750
Taxes (at 30%) 525
Net income $ 1,225
Dividends $ 826

  

BALANCE SHEET
(Figures in $ millions)
End of Year Start of Year
Assets
Cash and marketable securities $ 84 $ 153
Receivables 2,132 2,390
Inventories 162 213
Other current assets 842 907
Total current assets $ 3,220 $ 3,663
Net property, plant, and equipment 19,923 19,865
Other long-term assets 4,166 3,720
Total assets $ 27,309 $ 27,248
Liabilities and shareholders’ equity
Payables $ 2,514 $ 2,990
Short-term debt 1,394 1,548
Other current liabilities 786 762
Total current liabilities $ 4,694 $ 5,300
Long-term debt and leases 8,263 7,728
Other long-term liabilities 6,128 6,099
Shareholders’ equity 8,224 8,121
Total liabilities and shareholders’ equity $ 27,309 $ 27,248

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

I. Total debt ratio

J. Times interest earned

K. Cash coverage ratio

L. Current ratio

M. Quick ratio

Solutions

Expert Solution

Answer i.

Total debt = Current liabilities + Long-term debt and leases + Other long-term liabilities
Total debt = $4,694 + $8,263 + $6,128
Total debt = $19,085

Total debt ratio = Total debt / Total assets
Total debt ratio = $19,085 / $27,309
Total debt ratio = 0.70

Answer j.

Times interest earned = Earnings before interest and taxes / Interest expense
Times interest earned = $2,410 / $660
Times interest earned = 3.65

Answer k.

Cash coverage ratio = (Earnings before interest and taxes + Depreciation) / Interest expense
Cash coverage ratio = ($2,410 + $2,368) / $660
Cash coverage ratio = 7.24

Answer l.

Current ratio = Current assets / Current liabilities
Current ratio = $3,220 / $4,694
Current ratio = 0.69

Answer m.

Quick ratio = (Cash and marketable securities + Receivables) / Current liabilities
Quick ratio = ($84 + $2,132) / $4,694
Quick ratio = 0.47


Related Solutions

Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in...
Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in $ millions) Net sales $ 13,900 Cost of goods sold 4,460 Other expenses 4,197 Depreciation 2,758 Earnings before interest and taxes (EBIT) $ 2,485 Interest expense 725 Income before tax $ 1,760 Taxes (at 30%) 528 Net income $ 1,232 Dividends $ 936 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Cash and marketable securities $ 97 $ 166...
Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in...
Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in $ millions) Net sales $ 13,000 Cost of goods sold 3,960 Other expenses 4,037 Depreciation 2,458 Earnings before interest and taxes (EBIT) $ 2,545 Interest expense 675 Income before tax $ 1,870 Taxes (at 30%) 561 Net income $ 1,309 Dividends $ 856 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Cash and marketable securities $ 87 $ 156...
Here are simplified financial statements for Phone Corporation in a recent year:    INCOME STATEMENT (Figures...
Here are simplified financial statements for Phone Corporation in a recent year:    INCOME STATEMENT (Figures in $ millions)   Net sales $ 13,600   Cost of goods sold 4,310   Other expenses 4,162   Depreciation 2,668   Earnings before interest and taxes (EBIT) $ 2,460   Interest expense 710   Income before tax $ 1,750   Taxes (at 30%) 525   Net income $ 1,225   Dividends $ 906    BALANCE SHEET (Figures in $ millions) End of Year Start of Year   Assets      Cash and marketable securities $ 94...
Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in...
Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in $ millions) Net sales $ 12,400 Cost of goods sold 3,660 Other expenses 4,137 Depreciation 2,278 Earnings before interest and taxes (EBIT) $ 2,325 Interest expense 645 Income before tax $ 1,680 Taxes (at 30%) 504 Net income $ 1,176 Dividends $ 796    BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Cash and marketable securities $ 81 $...
Here are simplified financial statements for Phone Corporation in a recent year:    INCOME STATEMENT (Figures...
Here are simplified financial statements for Phone Corporation in a recent year:    INCOME STATEMENT (Figures in $ millions)   Net sales $ 13,600   Cost of goods sold 4,310   Other expenses 4,162   Depreciation 2,668   Earnings before interest and taxes (EBIT) $ 2,460   Interest expense 710   Income before tax $ 1,750   Taxes (at 30%) 525   Net income $ 1,225   Dividends $ 906    BALANCE SHEET (Figures in $ millions) End of Year Start of Year   Assets      Cash and marketable securities $ 94...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 895.00 Cost of goods sold 755.00 Depreciation 45.00 Earnings before interest and taxes (EBIT) $ 95.00 Interest expense 26.00 Income before tax $ 69.00 Taxes 14.49 Net income $ 54.51 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 383 $ 340 Long-term assets 286 236 Total assets $ 669 $ 576 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 887.00 Cost of goods sold 747.00 Depreciation 37.00 Earnings before interest and taxes (EBIT) $ 103.00 Interest expense 18.00 Income before tax $ 85.00 Taxes 29.75 Net income $ 55.25 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 375 $ 324 Long-term assets 270 228 Total assets $ 645 $ 552 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 895.00 Cost of goods sold 755.00 Depreciation 45.00 Earnings before interest and taxes (EBIT) $ 95.00 Interest expense 26.00 Income before tax $ 69.00 Taxes 14.49 Net income $ 54.51 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 383 $ 340 Long-term assets 286 236 Total assets $ 669 $ 576 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 888.00 Cost of goods sold 748.00 Depreciation 38.00 Earnings before interest and taxes (EBIT) $ 102.00 Interest expense 19.00 Income before tax $ 83.00 Taxes 17.43 Net income $ 65.57 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 376 $ 326 Long-term assets 272 229 Total assets $ 648 $ 555 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 893.00 Cost of goods sold 753.00 Depreciation 43.00 Earnings before interest and taxes (EBIT) $ 97.00 Interest expense 24.00 Income before tax $ 73.00 Taxes 15.33 Net income $ 57.67 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 381 $ 336 Long-term assets 282 234 Total assets $ 663 $ 570 Liabilities and shareholders’ equity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT