Question

In: Accounting

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 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

1-a. Calculate the debt to equity ratio for Bahama Bay and Caribbean Key for the most recent year. (Do not round intermediate calculations. Round ratios answers to 1 decimal place. Enter dollar answer in millions. (i.e., $5,500,000 should be entered as 5.5).)  

Debt to Equity Ratio

Bahama Bay =

Caribbean Key =

1-b. Which company has the higher ratio?

Bahama Bay
Caribbean Key

2-a. Calculate the return on assets for Bahama Bay and Caribbean Key. (Do not round intermediate calculations. Round ratios answers to 1 decimal place. Enter dollar answer in millions. (i.e., $5,500,000 should be entered as 5.5).)

Return on Assets Ratio

Bahama Bay=

Caribbean Key=

2-b. Which company appears more profitable?

Bahama Bay
Caribbean Key

3-a. Calculate the times interest earned ratio for Bahama Bay and Caribbean Key. (Do not round intermediate calculations. Round ratios answers to 1 decimal place. Enter dollar answer in millions. (i.e., $5,500,000 should be entered as 5.5).)

Return on Assets Ratio

Bahama Bay=

Caribbean Key=

2-b. Which company appears more profitable?

Bahama Bay
Caribbean Key

3-a. Calculate the times interest earned ratio for Bahama Bay and Caribbean Key. (Do not round intermediate calculations. Round ratios answers to 1 decimal place. Enter dollar answer in millions. (i.e., $5,500,000 should be entered as 5.5).)

Times Interest Earned Ratio

Bahama Bay=

Caribbean Key=

3-b. Which company is better able to meet interest payments as they become due?

Bahama Bay

Caribbean Key

Solutions

Expert Solution

Solutions:

1 a) Debt Equity Ratio =Debt/ Equity

Bahama Bay = 8172/ 1711 = 4.78              Hence Debt Equity Ratio = 4.78:1

Caribbean Key = 7613/ 1470= 5.18                    Hence Debt Equity Ratio = 5.18:1

1 b) Caribbean Key has the higher ratio (5.18)

2 a) Return on Assets Ratio = Net Income/Average Assets

Bahama Bay

Average Asset = (9883+9802)/2 = 9842.5

Net Income = 347

Return on Assets Ratio = 347/9842.5 = 0.03

Hence Return on Assets Ratio = 0.03:1

Caribbean Key

Average Asset = (9083+9122)/2 = 9102.50

Net Income = 380

Return on Assets Ratio = 380/9102.5 = 0.04

Hence Return on Assets Ratio = 0.04:1

2 b) Caribbean Key appears more profitable ( 0.04 )

3 a) Interest earned ratio = Net Income+ Tax+ Interest/Interest

Bahama Bay

Net Income+ Tax+ Interest = 347+85+237 = 669

Interest = 237

Interest earned ratio = 669/237 = 2.82 times

Ratio = 2.82 : 1

Caribbean Key

Net Income+ Tax+ Interest = 380+359+181 = 920

Interest = 181

Interest earned ratio = 920/181 = 5.08 times

Ratio = 5.08 : 1

3 b ) Carribbean Key is better able to meet interest payments as they become due.


Related Solutions

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...
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