Question

In: Finance

Below is selected balance sheet and income statement information from O'Reilly (in millions) 2019 2017 Cash...

  1. Below is selected balance sheet and income statement information from O'Reilly

(in millions)

2019

2017

Cash

$   1,600.00

$ 1,500.00

Accounts receivable

1,197.16

835.30

Current assets

4,013.56

3,018.33

Current liabilities

3,485.39

6,257.95

Long-term debt

17,620.81

3,611.63

Short-term debt

1,133.96

4,668.83

Total liabilities

23,318.42

26,463.17

Interest expense

1,666.90

1,438.29

Capital expenditures

1,645.48

1,211.50

Equity

4,600.00

-7,200.00

Cash from operations

610.89

685.98

Earnings before interest and taxes

1,594.84

2,002.84

  1. Compute the following liquidity, solvency and coverage ratios for both years.

(Round each computation to two decimal places.)

  • Quick ratio
  • Total debt-to-equity
  • Times interest earned
  1. What is your overall assessment of the company’s credit risk? Explain. What differences do you observe between the two years? No less than 2points. (1/. )

Solutions

Expert Solution

Solution:

Part A )

2017

  • Quick ratio = (Cash + AR ) / Current Liability = (1500 + 835.30) / 6,257.95 = 0.37
  • Total debt-to-equity = Total debt / Equity = (Long term asset + short term asset )/ Equity = (3,611.63+4,668.83)/-7,200.00 = -1.15
  • Times interest earned =  Earnings before interest and taxes / Interest = 2,002.84 / 1,438.29 =1.39

2019

  • Quick ratio = (Cash + AR ) / Current Liability = (1,600 + 1,197.16) /3,485.39 = 0.80
  • Total debt-to-equity = Total debt / Equity = (Long term asset + short term asset )/ Equity = (17,620.81 + 1,133.96 ) / 4,600 = 4.07
  • Times interest earned =  Earnings before interest and taxes / Interest = 1,594.84 / 1,666.90=0.96

Part B )

The credit risk of the company is very high as the Debt to equity ratio is very high. Times interest earned ratio is also very low and it means that the firm is generating low operating profit as compared to the interest expense.

From the year 2017 to 2019 the Debt to equity ratio has improved slightly as the equity has become positive, and times interest earned has decreased from 1.39 to 0.96.


Related Solutions

Selected balance sheet and income statement information from Verizon Communications Inc. follows. $ millions 2016 2015...
Selected balance sheet and income statement information from Verizon Communications Inc. follows. $ millions 2016 2015 Current assets . . . . . . . . . . . . . . . . . . . . . . . . . $ 26,395 $ 22,355 Current liabilities. . . . . . . . . . . . . . . . . . . . . . . . 30,340 35,052 Total debt . . . ....
Label each section Below is selected balance sheet and income statement information from aldo Company. (in...
Label each section Below is selected balance sheet and income statement information from aldo Company. (in millions) 2014 2012 Cash $ 1,483.36 $   1,536.73 Accounts receivable 735.30 1,097.16 Current assets 2,918.33 3,913.56 Current liabilities 6,157.95 3,385.39 Long-term debt 3,611.63 17,620.81 Short-term debt 4,568.83 1,033.96 Total liabilities 26,363.17 23,218.42 Interest expense 1,338.29 1,566.90 Capital expenditures 211.50 1,545.48 Equity -7,152.90 4,587.67 Cash from operations 185.98 110.89 Earnings before interest and taxes 1,902.84 1,594.84 a. Compute the following liquidity, solvency and coverage ratios...
Based on the information below create an income statement, balance sheet, and cash flow statement. On...
Based on the information below create an income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in legal fees,...
The Verbrugge Publishing Company's 2019 balance sheet and income statement are as follows (in millions of...
The Verbrugge Publishing Company's 2019 balance sheet and income statement are as follows (in millions of dollars). Balance Sheet Current assets $300 Current Liabilities $40 Net fixed assets $200 Advance payments by customers $80 Noncallable Preferred Stock, $6 coupon, $110 par value (1,000,000 shares) 110 Callable preferred stick, $10 coupon, no par, $100 call price (2,000,000 shares) 200 Common stock, $2 par value (5,000,000 shares) $10 Retained earnings $60 Total Assets $500 Total liabilities and equity $500 Income Statement Net...
The Verbrugge Publishing Company’s 2019 balance sheet and income statement are as follows (in millions of...
The Verbrugge Publishing Company’s 2019 balance sheet and income statement are as follows (in millions of dollars): Balance Sheet Current assets Net fixed assets Total assets Income Statement Net sales Operating expense $300 200 $500 Current liabilities
Advance payments by customers Noncallable preferred stock, $6 coupon, $110 par value (1,000,000 shares)
Callable preferred stock, $10 coupon, no par, $100 call price (200,000 shares) Common stock, $2 par value (5,000,000 shares) Retained earnings Total liabilities & equity $ 40 80 110...
INCOME STATEMENT AND BALANCE SHEET FOR 2015 SELECTED U.S. INDUSTRIES FOR 2015 (Figures in $ millions)...
INCOME STATEMENT AND BALANCE SHEET FOR 2015 SELECTED U.S. INDUSTRIES FOR 2015 (Figures in $ millions) Food Pharmaceuticals Oil and Coal Computers and Peripherals Food Stores Income Statement Data: Sales $ 676.7 $ 396.8 $ 1,049.2 $ 206.1 $ 463.7 Cost of goods sold 614.2 328.9 990.6 166.3 439.8 Balance Sheet Data: Inventory $ 64.1 $ 52.4 $ 49.5 $ 8.8 $ 25.1 Accounts receivable 51.4 60.6 73.2 20.2 5.7 Accounts payable 41.8 39.2 76.3 28.3 21.6 Note: Cost of...
Use the following information for the Problems below. Lansing Company’s 2017 income statement and selected balance...
Use the following information for the Problems below. Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow. LANSING COMPANY Income Statement For Year Ended December 31, 2017 Sales revenue $ 148,200 Expenses Cost of goods sold 59,000 Depreciation expense 20,500 Salaries expense 35,000 Rent expense 10,700 Insurance expense 5,500 Interest expense 5,300 Utilities expense 4,500 Net income $ 7,700    LANSING COMPANY Selected Balance Sheet Accounts...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $ 140.0 Accounts payable $800.0 Accts. Receivable 880.0 Notes payable ` 600.0 Inventories 1,320.0 Accruals 400.0 Total current assets 2,340.0 Total current liabilities 1,800.0 Long-term bonds 1,000.0 Total debt 2,800.0 Common stock 200.0 (50,000 shares) Retained earnings 1,000.0 Net plant & equip 1,660.0 Total common equity 1,200.0 Total assets $4,000.0 Total liabilities & equity $4,000.0 INCOME STATEMENT Net sales $6,000.0 Operating costs 5,599.8 Depreciation 100.2...
From the information below prepare, in proper accounting form the, Income Statement, Balance Sheet, and Statement...
From the information below prepare, in proper accounting form the, Income Statement, Balance Sheet, and Statement of Changes in Owners’ Equity, and Statement of Cash Flows for 2016 and 2017. In your Income Statement Calculation, include Subtotals for EBITDA, EBIT, and EBT in addition to Net Income. You must submit your answers in either a MS Word or an MS Excel file. TANDY COMPANY Year Ending 6/30/2017 6/30/2016 6/30/2015 Common Stock 100,000 shares outstanding $460,000 $460,000 $460,000 Net Receivables 632,160...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT