Question

In: Accounting

Selected financial data for Surf City and Paradise Falls are as follows: ($ in millions) Surf...

Selected financial data for Surf City and Paradise Falls are as follows:

($ in millions) Surf City Paradise Falls
2018 2017 2018 2017
  Total assets $ 16,133 $ 14,922 $ 33,296 $ 34,121
  Total liabilities 9,720 8,195   13,938 14,188
  Total stockholders’ equity 6,413 6,727 19,358 19,933
  Sales revenue $ 6,503 $ 14,616
  Interest expense 318 408
  Tax expense 44
  Net income 568 2,324

1-a. Calculate the debt to equity ratio for Surf City and Paradise Falls for the most recent year. (Do not round intermediate calculations. Round ratios answers to 2 decimal places. Enter dollar answer in millions. (i.e., $5,500,000 should be entered as 5.5))

2-a. Calculate the return on assets for Surf City and Paradise Falls. (Round your answers to 1 decimal place. Enter dollar answer in millions. (i.e., $5,500,000 should be entered as 5.5))

3-a. Calculate the times interest earned ratio for Surf City and Paradise Falls. (Round ratios answers to 1 decimal place. Enter dollar answer in millions. (i.e., $5,500,000 should be entered as 5.5))

Solutions

Expert Solution

Debt Equity ratio = Total Debt / Equity

Surf City = 9720 / 6413 = 1.52

Paradise Falls = 13938 / 19358 = 0.72

2-a. Calculate the return on assets for Surf City and Paradise Falls.

Firstly calculate the average total assets = [ Assets (2018) + Assets (2017) ] / 2

Surf City = [ 16133 + 14,922 ] / 2 = 15527.5

Paradise Falls = [33296 + 34121] /2 = 33708.5

Return on Assets = Net Income / Average Assets * 100

Surf City = 568 / 15527.5 * 100 = 3.66 %

Paradise Falls = 2324 / 33708.5 * 100 = 6.89%

3-a. Calculate the times interest earned ratio for Surf City and Paradise Falls.

First we need to compute EBIT = earnings before interst and tax. For this add the interest and tax back to the net income given in the question. i.e EBIT = Net Income + Tax + Interest

Surf city = 568 + 0 + 318 = 886

Paradise city = 2324 + 44 + 408 = 2776

Times Interest Earned ratio = EBIT / Interest

Surf city = 886 / 318 = 2.77

Paradise city = 2776 / 408 = 6.80


Related Solutions

Selected financial data for Bahama Bay and Caribbean Key are as follows: ($ in millions) Bahama...
Selected financial data for Bahama Bay and Caribbean Key are as follows: ($ in millions) Bahama Bay Caribbean Key 2018 2017 2018 2017   Total assets $ 9,883 $ 9,802 $ 9,083 $ 9,122   Total liabilities 8,172 7,636 7,613 7,603   Total stockholders’ equity 1,711 2,166 1,470 1,519   Sales revenue $ 5,997 $ 12,969   Interest expense 237 181   Tax expense 85 359   Net income 347 380 Selected financial data for Bahama Bay and Caribbean Key are as follows: ($ in millions) Bahama...
The financial statements of Friendly Fashions include the following selected data (in millions):      ($ in...
The financial statements of Friendly Fashions include the following selected data (in millions):      ($ in millions) 2018 2017   Sales $ 10,043   $ 11,134     Net income $ 312   $ 818     Stockholders' equity $ 1,850   $ 2,310     Average Shares outstanding (in millions) 675   -   Dividends per share $ 0.31     Stock price $ 6.20   - Required: Calculate the following ratios for Friendly Fashions in 2018 Return on equity, Dividend yield,earnings per share,Price earnings ratio
The financial statements of Friendly Fashions include the following selected data (in millions):      ($ in...
The financial statements of Friendly Fashions include the following selected data (in millions):      ($ in millions) 2018 2017   Sales $ 10,043   $ 11,134     Net income $ 312   $ 818     Stockholders' equity $ 1,850   $ 2,310     Average Shares outstanding (in millions) 675   -   Dividends per share $ 0.31     Stock price $ 6.20   - Required: Calculate the following ratios for Friendly Fashions in 2018 Return on equity, Dividend yield,earnings per share,Price earnings ratio
Selected financial information from General Mills as of May 29, 2016 follows. $ millions Debit Credit...
Selected financial information from General Mills as of May 29, 2016 follows. $ millions Debit Credit Net sales $16,689.6 Cost of sales $10,758.9 Selling, general, & administrative expense & other 3,098.4 Interest expense, net 329.1 Income tax expense 780.5 Retained earnings 12,041.4 Assume the company has not yet closed any accounts to retained earnings. Prepare journal entries to close the temporary accounts above. Set up the needed T-accounts, and post the closing entries. After these entries are posted, what is...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).
Problem 13-5ASuppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).TargetCorporationWal-MartStores, Inc.Income Statement Data for YearNet sales$65,900$409,000Cost of goods sold45,000303,000Selling and administrative expenses15,10076,000Interest expense6502,100Other income (expense)(95)(400)Income tax expense1,3006,700Net income$ 3,755$ 20,800Balance Sheet Data(End of Year)Current assets$16,000$49,000Noncurrent assets25,700123,000Total assets$41,700$172,000Current liabilities$11,000$56,000Long-term debt17,30045,000Total stockholders’ equity13,40071,000Total liabilities and stockholders’ equity$41,700$172,000Beginning-of-Year BalancesTotal assets$45,000$163,000Total stockholders’ equity12,50066,000Current liabilities10,00058,000Total liabilities32,50097,000Other DataAverage net accounts receivable$7,700$3,800Average inventory7,20033,600Net cash provided by operating activities5,60026,200Capital expenditures1,70011,500Dividends4603,900(a) For each company, compute the following ratios. (Round all answers to 2 decimal...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).                     Income Statement Data for Year                           Net sales            $6,900     $417,000   cost ot goods sold           44,000     38,000  Selling and administratv  epenses            14400    3,000  Interest...
Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Target...
Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Target Corporation Walmart Inc. Income Statement Data for Year Net sales $66,750 $414,180 Cost of goods sold 44,800 302,400 Selling and administrative expenses 15,500 81,000 Interest expense 650 1,900 Other income (expense) (80 ) (400 ) Income tax expense 1,400 7,300 Net income $ 4,320 $ 21,180 Balance Sheet Data (End of Year) Current assets $17,050 $47,040 Noncurrent assets 26,700 120,000 Total assets $43,750 $167,040...
Consider Fisher & Company’s financial data as follows (unit: millions of dollars except ratio and time...
Consider Fisher & Company’s financial data as follows (unit: millions of dollars except ratio and time figures): Cash and marketable securities $100 Fixed assets $280 Sales $1,200 Net income $358 Inventory $180 Current ratio 3.2 Average collection periods 45 days Average common equity $500 Find Fisher’s accounts receivable Calculate the amount of current assets Determine the amount of current liabilities Determine the amount of total assets Calculate the amount of the long-term debt Calculate the net profit margin
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Income Statement Data for YearTarget CorporationWal-Mart Stores, Inc.Net sales$65,357$408,214Cost of goods sold45,583304,657Selling and administrative expenses15,10179,607Interest expense7072,065Other income (expense)(94)(411)Income tax expense1,3847,139Net income$2,488$14,335Balance Sheet Data (End ofYear)Current assets$18,424$48,331Noncurrent assets26,109122,375Total assets$44,533$170,706Current liabilities$11,327$55,561Long-term debt17,85944,089Total stockholders' equity15,34771,056(b) Compare the liquidity, solvency, and profitability of the two companies.
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Please...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Please show how to do the equations. Thank you. Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $66,700 $409,000 Cost of goods sold 46,000 306,000 Selling and administrative expenses 14,700 76,000 Interest expense 650 1,800 Other income (expense) (95 ) (420 ) Income tax expense 1,400 7,200 Net income $ 3,855 $ 17,580 Balance Sheet Data (End of Year) Current assets...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT