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 $ 12,500 Cost of goods sold 3,710 Other expenses 4,112 Depreciation 2,308 Earnings before interest and taxes (EBIT) $2,370 Interest expense 650 Income before tax $1,720 Taxes (at 30%) 516 Net income $1,204 Dividends $806 BALANCE SHEET(Figures in $ millions) End of Year Start of Year Assets Cash and marketable securities $82 $151 Receivables 2,032 2,350 Inventories 152 203 Other current assets 832 897 Total current assets $3,098 $3,601 Net property, plant, and equipment 19,903 19,845 Other long-term assets 4,146 3,700 Total assets $27,147 $27,146 Liabilities and shareholders' equity Payables $2,494 $2,970 Short-term debt 1,384 1,538 Other current liabilities 776 752 Total current liabilities $4,654 $5,260 Long-term debt and leases 8,761 8,086 Other long-term liabilities 6,108 6,079 Shareholders' equity 7,624 7,721 Total liabilities and shareholders' equity $27,147 $27,146 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 $ 12,500
Cost of goods sold 3,710
Other expenses 4,112
Depreciation 2,308
Earnings before interest and taxes (EBIT) $2,370
Interest expense 650
Income before tax $1,720
Taxes (at 30%) 516
Net income $1,204
Dividends $806
BALANCE SHEET(Figures in $ millions) End of Year Start of Year
Assets
Cash and marketable securities $82 $151
Receivables 2,032 2,350
Inventories 152 203
Other current assets 832 897
Total current assets $3,098 $3,601
Net property, plant, and equipment 19,903 19,845
Other long-term assets 4,146 3,700
Total assets $27,147 $27,146
Liabilities and shareholders' equity
Payables $2,494 $2,970
Short-term debt 1,384 1,538
Other current liabilities 776 752
Total current liabilities $4,654 $5,260
Long-term debt and leases 8,761 8,086
Other long-term liabilities 6,108 6,079
Shareholders' equity 7,624 7,721
Total liabilities and shareholders' equity $27,147 $27,146
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. day in inventory (use average balance sheet figures)
e. inventory turnover (use average balance sheet figures)
f. average collection period (use start of yr bal sheet fig)
g. Operating profit margin
h. long term debt ratio (use end of year bal sheet)
I. total debt ratio (use of end of yr)
j. times interest earned
k. cash coverage ratio
l. current ratio (use end of yr)
m. quick ratio (use end of yr)
Expert Solution
Net Operating Profit after tax = EBIT * (1 - Tax Rate)
= $2,370* (1 - 0.30)
Net Operating Profit after tax = $1,659.0
a) Return on Equity:
Average Stockholders' Equity = ($7,624+ $7,721) / 2 = $7,672.5
Return on Equity = Net Income / Average Stockholders' Equity
= $1,204/ $7,672.5
Return on Equity = 15.69%
b) Return on Assets:
Average Total Assets = ($27,147+ $27,146) / 2 = $27,146.5
Return on Assets = Net Operating Profit after tax / Average Total Assets
= $1,659/ $27,146.5
Return on Assets = 6.11%
c) Return on Capital:
Average Capital = Average Long-term Debt and Leases + Average Stockholders' Equity
= ($8,761+ $8,086) / 2 + ($7,624+ $7,721) / 2
Average Capital = $16,096
Return on Capital = Net Operating Profit after tax / Average Capital
= $1,659 / $16,096
Return on Capital = 10.30%
d) Days in Inventory:
Days in Inventory = 365 * Inventory / Cost of Goods Sold
= 365 * $203 / $3,710
Days in Inventory = 19.97days
e) Inventory Turnover:
Inventory Turnover = Cost of Goods Sold / Inventory
= $3,710/ $203
Inventory Turnover = 18.27times
f) Average Collection Period:
Average Collection Period =Beginning Receivables/Sales*365
= 2350/12500*365
Average Collection Period = 68.62 days
g) Operating Profit Margin:
Operating Profit Margin = EBIT*(1-Tax Rate)/Sales
= 2370*(1-30%)/12500
Operating Profit Margin = 13.27%
h) Long-term Debt Ratio:
Long-term Debt Ratio = Long-term Debt at the End/Total Assets at the End
= (8761+6108)/27147
= 14869/27147
Long-term Debt Ratio = 0.55 times
i) Total Debt Ratio:
Total Debt Ratio = Total Liabilities / Total Assets
= (4654+8761+6108)/27147
= 19523/27147
Total Debt Ratio = 0.72 times
j) Times-Interest Earned Ratio:
Times-Interest Earned Ratio = EBIT/Interest
= 2370/650
Times-Interest Earned Ratio = 3.65 times
k) Cash Coverage Ratio:
Cash Coverage Ratio = (EBIT+Depreciation)/Interest
= (2370+2308)/650
= 4678/650
Cash Coverage Ratio = 7.20 times
l) Current Ratio:
Current Ratio = Current Assets at the End / Current Liabilities at the End
= 3098/4654
Current Ratio = 0.67:1
m) Quick Ratio:
Quick Ratio = Quick Assets/Current Liabilities
= (82+2032)/4654
= 2114/4654
Quick Ratio = 0.45:1
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.





