Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT(Figures in $ millions)Net sales$14,000Cost of goods sold 4,510Other expenses 4,212Depreciation 2,788Earnings before interest and taxes (EBIT)$2,490Interest expense 730Income before tax$1,760Taxes (at 30%) 528Net income$1,232Dividends$946 BALANCE SHEET(Figures in $ millions) End of Year Start of YearAssets Cash and marketable securities$98 $167 Receivables 2,832 2,670 Inventories 232 283 Other current assets 912 977 Total current assets$4,074 $4,097 Net property, plant, and equipment 20,063 20,005 Other long-term assets 4,306 3,860 Total assets$28,443 $27,962 Liabilities and shareholders' equity Payables$2,654 $3,130 Short-term debt 1,464 1,618 Other current liabilities 856 832 Total current liabilities$4,974 $5,580 Long-term debt and leases 4,777 5,222 Other long-term liabilities 6,268 6,239 Shareholders' equity 12,424 10,921 Total liabilities and shareholders' equity$28,443 $27,962 Calculate the following financial ratios for Phone Corporation: (Use 365 days in a year
Here are simplified financial statements for Phone Corporation in a recent year:
INCOME STATEMENT(Figures in $ millions)Net sales$14,000Cost of goods sold 4,510Other expenses 4,212Depreciation 2,788Earnings before interest and taxes (EBIT)$2,490Interest expense 730Income before tax$1,760Taxes (at 30%) 528Net income$1,232Dividends$946
BALANCE SHEET(Figures in $ millions) End of Year Start of YearAssets Cash and marketable securities$98 $167 Receivables 2,832 2,670 Inventories 232 283 Other current assets 912 977 Total current assets$4,074 $4,097 Net property, plant, and equipment 20,063 20,005 Other long-term assets 4,306 3,860 Total assets$28,443 $27,962 Liabilities and shareholders' equity Payables$2,654 $3,130 Short-term debt 1,464 1,618 Other current liabilities 856 832 Total current liabilities$4,974 $5,580 Long-term debt and leases 4,777 5,222 Other long-term liabilities 6,268 6,239 Shareholders' equity 12,424 10,921 Total liabilities and shareholders' equity$28,443 $27,962
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.)
a. Return on equity (use average balance sheet figures) . % b. Return on assets (use average balance sheet figures) . % c. Return on capital (use average balance sheet figures) . % d. Days in inventory (use start-of-year balance sheet figures) . days e. Inventory turnover (use start-of-year balance sheet figures) . f. Average collection period (use start-of-year balance sheet figures) . days g. Operating profit margin . h. Long-term debt ratio (use end-of-year balance sheet figures) . Total debt ratio (use end-of-year balance sheet figures) . j. Times interest earned . k. Cash coverage ratio . I. Current ratio (use end-of-year balance sheet figures) . E Quick ratio (use end-of-year balance sheet figures) .
Expert Solution
Net Operating Profit after tax = EBIT * (1 - Tax Rate)
Net Operating Profit after tax = $2,490 * (1 - 0.30)
Net Operating Profit after tax = $1,743
a) Return on Equity:
Average Stockholders' Equity = ($12,424 + $10,921) / 2
Average Stockholders' Equity = $11,672.50
Return on Equity = Net Income / Average Stockholders' Equity
Return on Equity = $1,232 / $11672.50
Return on Equity = 10.55%
b) Return on Assets:
Average Total Assets = ($28,443 + $27,962) / 2
Average Total Assets = $28,202.50
Return on Assets = Net Operating Profit after tax / Average Total Assets
Return on Assets = $1,743 / $28,202.50
Return on Assets = 6.18%
c) Return on Capital:
Average Capital = Average Long-term Debt and Leases + Average Stockholders' Equity
Average Capital = ($4,777 + $5,222) / 2 + ($12,424 + $10,921) / 2
Average Capital = $16,672
Return on Capital = Net Operating Profit after tax / Average Capital
Return on Capital = $1,743 / $16,672
Return on Capital = 10.45%
d) Days in Inventory)
Days in Inventory = 365 * Inventory / Cost of Goods Sold
Days in Inventory = 365 * $283/ $4,510
Days in Inventory = 22.90 days
e) Inventory Turnover:
Inventory Turnover = Cost of Goods Sold / Inventory
Inventory Turnover = $4,510 / $283
Inventory Turnover = 15.94 times
f) Average Collection Period:
Average Collection Period = 365 * Receivables / Net Sales
Average Collection Period = 365 * $2,670 / $14,000
Average Collection Period = 69.61 days
g) Operating Profit Margin:
Operating Profit Margin = Earnings before Interest and Taxes / Net Sales
Operating Profit Margin = $2,490 / $14,000
Operating Profit Margin = 17.79%
h) Long-term Debt Ratio:
Long-term debt ratio = Long-term debt and leases / [Long-term debt and leases + Shareholders' equity]
Long-term debt ratio = $4,777 / [$4,777 + $12,424]
Long-term debt ratio = $4,777 / $17,201
Long-term debt ratio = 0.28
i) Total Debt Ratio:
Total debt ratio = [Current liabilities + Long-term debt and leases + Other long-term liabilities] / Total assets
Total debt ratio = [$4,974 + $4,777 + $6,268] / $28,443
Total debt ratio = $16,019 / $28,443
Total debt ratio = 0.56
j) Times Interest Earned:
Times interest earned = Earnings before interest and taxes / Interest expense
Times interest earned = $2,490 / $730
Times interest earned = 3.41
k) Cash Coverage Ratio:
Cash coverage ratio = [Earnings before interest and taxes + Depreciation] / Interest expense
Cash coverage ratio = [$2,490 + $2,788] / $730
Cash coverage ratio = $5,278 / $730
Cash coverage ratio = 7.23
i) Current Ratio:
Current ratio = Current assets / Current liabilities
Current ratio = $4,074 / $4,974
Current ratio = 0.82
m) Quick Ratio:
Quick ratio = [Cash and marketable securities + Receivables] / Current liabilities
Quick ratio = [$98 + $2,832] / $4,974
Quick ratio = $2,930 / $4,974
Quick ratio = 0.59
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





