Question

In: Accounting

WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current...

WIPER INC.
Condensed Balance Sheets
December 31, 2020, 2019, 2018
(in millions)
2020 2019 2018
Current assets $ 681 $ 906 $ 753
Other assets 2,415 1,922 1,721
Total assets $ 3,096 $ 2,828 $ 2,474
Current liabilities $ 566 $ 805 $ 712
Long-term liabilities 1,521 995 842
Stockholders’ equity 1,009 1,028 920
Total liabilities and stockholders' equity $ 3,096 $ 2,828 $ 2,474
WIPER INC.
Selected Income Statement and Other Data
For the year Ended December 31, 2020 and 2019
(in millions)
2020 2019
Income statement data:
Sales $ 3,052 $ 2,915
Operating income 298 312
Interest expense 86 67
Net income 197 192
Other data:
Average number of common shares outstanding 41.5 46.9
Total dividends paid $ 52.0 $ 52.5


Required:

  1. Calculate return on investment, based on net income and average total assets, for 2020 and 2019.
  2. Calculate return on equity for 2020 and 2019.
  3. Calculate working capital and the current ratio for each of the past three years.
  4. Calculate earnings per share for 2020 and 2019.
  5. If Wiper's stock had a price/earnings ratio of 12 at the end of 2020, what was the market price of the stock?
  6. Calculate the cash dividend per share for 2020 and the dividend yield based on the market price calculated in part e.
  7. Calculate the dividend payout ratio for 2020.
  8. Assume that accounts receivable at December 31, 2020, totaled $311 million. Calculate the number of days' sales in receivables at that date.
  9. Calculate Wiper's debt ratio and debt/equity ratio at December 31, 2020 and 2019.
  10. Calculate the times interest earned ratio for 2020 and 2019.

Solutions

Expert Solution

Solution-

2020 2019
Return on investment 6.65% 7.24%
Net income/Average total assets 197/2,962 192/2651
Average total assets (3096+ 2828)/2 (2828+ 2474)/2
2,962 2,651
2020 2019
Return on equity 19.34% 19.71%
Net income/Average stockholders' equity 197/1018.5 192/974
Average stockholders' equity (1009+ 1028)/2 (1028+ 920)/2
1018.5 974
2020 2019 2018
Working capital 115 101 41
Current ratio 1.20 1.12 1.05
Working capital = CA - CL 681-566 906-805 753-712
Current ratio = CA/CL 681/566 906/805 753/712
2020 2019
Earnings per share 4.74 4.09
Net income/Average number of common shares outstanding 197/41.5 192/46.9
Market price $56.88
Price/earnings ratio = Market price/EPS
12= Market price/4.74
Market price = 12 x 4.74 = 56.88
Cash dividends per share $1.25
Dividend yield 2.19%
Cash dividends per share
$52.0/41.5= 1.25
Dividend yield = Dividends paid/Market price
$1.25/$56.88= 2.19%
Dividend payout ratio 26.39%
Dividends paid / Net income
$52.0/ 197= 26.39%
Number of days sales 37.20days
Accounts receivable/Average daily credit sales
$311/($3052/365 days) = 37.20
2020 2019
Debt ratio 67.40% 63.65%
Debt/equity ratio 2.06% 1.75%
Debt ratio
Total debt/Total assets

2087/3096

(1521+566)/3096

1800/2828

(995+805)/2828

Debt/equity ratio
Total debt / Total stockholders' equity 2087/1009 1800/1028
2020 2019
Times interest earned 3.46times 4.65times
Profit before interest & tax / Interest 298/86 312/67

Related Solutions

WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current...
WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 683 $ 915 $ 763 Other assets 2,416 1,923 1,722 Total assets $ 3,099 $ 2,838 $ 2,485 Current liabilities $ 576 $ 806 $ 713 Long-term liabilities 1,513 1,003 851 Stockholders’ equity 1,010 1,029 921 Total liabilities and stockholders' equity $ 3,099 $ 2,838 $ 2,485 WIPER, INC Selected Income Statement and Other Data For the year Ended December 31, 2017...
Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019....
Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019. Sales for the year ended December 31, 2020, totaled $1,700,000. HAMES INC. Balance Sheets December 31, 2020 and 2019 2020 2019 Assets Cash $ 63,000 $ 57,000 Accounts receivable 285,000 266,000 Merchandise inventory 261,000 247,000 Total current assets $ 609,000 $ 570,000 Land 109,000 82,000 Plant and equipment 375,000 330,000 Less: Accumulated depreciation (195,000 ) (180,000 ) Total assets $ 898,000 $ 802,000 Liabilities...
Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019....
Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019. Sales for the year ended December 31, 2020, totaled $590,000. Assets 2020 2019 Cash $21,000 $19,000 Accounts receivable 78,000 72,000 Merchandise inventory 103,000 99,000 Total current assets $202,000 $190,000 Land 50,000 40,000 Plant and equipment 125,000 110,000 Less: Accumulated depreciation (65,000) (60,000) Total assets $312,000 $280,000 Liabilities Short-term debt $18,000 $17,000 Accounts payable $64,800 $75,000 Other accrued liabilities $20,000 $18,000 Total current liabilities $102,800...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners’ Equity   Current assets   Current liabilities     Cash $ 42,646 $ 54,402      Accounts payable $ 191,422 $ 199,111     Accounts receivable 60,781 81,139      Notes payable 86,520 138,088     Inventory 127,265 193,375             Total $ 277,942 $ 337,199       Total $ 230,692 $ 328,916   Long-term debt $ 240,000 $ 176,750   Owners’ equity      Common stock and paid-in surplus $ 215,000 $ 215,000      Accumulated retained earnings 155,597 189,495...
Condensed financial data of Cheng Inc. follow. CHENG INC. Comparative Balance Sheets December 31 Assets 2020...
Condensed financial data of Cheng Inc. follow. CHENG INC. Comparative Balance Sheets December 31 Assets 2020 2019 Cash $104,300 $48,600 Accounts receivable 92,100 33,700 Inventory 111,500 102,000 Prepaid expenses 29,500 25,200 Investments 139,500 113,100 Equipment 264,100 241,000 Accumulated depreciation-equipment (46,800 ) (52,300 )    Total $694,200 $511,300 Liabilities and Stockholders’ Equity Accounts payable $111,700 $67,800 Accrued expenses payable 16,100 17,000 Bonds payable 113,100 149,900 Common stock 219,500 174,200 Retained earnings 233,800 102,400    Total $694,200 $511,300 CHENG INC. Income Statement For the...
Condensed financial data of Cheng Inc. follow. CHENG INC. Comparative Balance Sheets December 31 Assets 2020...
Condensed financial data of Cheng Inc. follow. CHENG INC. Comparative Balance Sheets December 31 Assets 2020 2019 Cash $99,700 $48,900 Accounts receivable 93,000 32,700 Inventory 112,800 102,800 Prepaid expenses 29,100 25,900 Investments 139,000 114,900 Equipment 270,600 241,300 Accumulated depreciation-equipment (46,600 ) (51,100 )    Total $697,600 $515,400 Liabilities and Stockholders’ Equity Accounts payable $112,000 $67,000 Accrued expenses payable 16,100 17,000 Bonds payable 112,700 149,000 Common stock 219,600 175,900 Retained earnings 237,200 106,500    Total $697,600 $515,400 CHENG INC. Income Statement For the...
ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000...
ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000 $ 36,000 Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 Investments 27,000 20,000 Plant (net) 270,000 255,000 Land 29,000 24,000 Total assets $ 600,000 $ 540,000 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000 Accounts payable 113,800 100,000 Salaries payable 21,000 15,000 Total current liabilities 151,800...
Shown are the comparative balance sheets of Dang Corporation for December 31, 2019 and 2018: December...
Shown are the comparative balance sheets of Dang Corporation for December 31, 2019 and 2018: December 31 2019 2018 Cash and cash equivalents .................................. $  350,000 $  320,000 Accounts receivable .............................................   327,600    356,000 Inventories ...........................................................   822,000    780,000 Available-for-sale securities ................................         0    200,000 Equipment ........................................................... 2,400,000 2,040,000 Accumulated depreciation ...................................   (700,000)    (760,000) $3,199,600 $2,936,000 Accounts payable ............................................... $  459,000 $  381,000 Bonds payable, due 2019 ................................... 0    400,000 Common stock, $20 par ...................................... 1,800,000 1,600,000 Paid-in capital in excess of par ...........................   280,000    200,000 Retained...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets Cash $ 109 $ 81 Accounts receivable 190 194 Investment revenue receivable 6 4 Inventory 205 200 Prepaid insurance 4 8 Long-term investment 156 125 Land 196 150 Buildings and equipment 412 400 Less: Accumulated depreciation (97 ) (120 ) Patent 30 32 $ 1,211 $ 1,074 Liabilities Accounts payable $ 50 $ 65 Salaries payable 6 11 Interest payable (bonds) 8 4 Income...
Holmes Company reported the following balance sheets at December 31, 2017 and 2018: ($ in millions)...
Holmes Company reported the following balance sheets at December 31, 2017 and 2018: ($ in millions) December 31, 2018 2017 Cash $ 45 $ 40 Accounts receivable 170 175 Inventory 250 230 Fixed assets 500 400 Accumulated depreciation (150 ) (120 ) Total assets $ 815 $ 725 Accounts payable $ 100 $ 80 Long-term debt 455 425 Common stock 50 50 Retained earnings 280 200 Treasury stock (70 ) (30 ) Total liabilities and stockholders' equity $ 815 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT