Question

In: Accounting

Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER,...


Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.:

WIPER, INC.
Condensed Balance Sheets
December 31, 2017, 2016, 2015
(in millions)
2017 2016 2015
Current assets $ 707 $ 939 $ 793
Other assets 2,419 1,926 1,725
Total assets $ 3,126 $ 2,865 $ 2,518
Current liabilities $ 583 $ 836 $ 724
Long-term liabilities 1,530 997 870
Stockholders’ equity 1,013 1,032 924
Total liabilities and stockholders' equity $ 3,126 $ 2,865 $ 2,518
WIPER, INC
Selected Income Statement and Other Data
For the year Ended December 31, 2017 and 2016
(in millions)
2017 2016
Income statement data:
Sales $ 3,056 $ 2,919
Operating income 302 316
Interest expense 90 71
Net income 209 204
Other data:
Average number of common shares outstanding 41.9 47.3
Total dividends paid $ 56.0 $ 52.9

e. If Wiper stock had a price/earnings ratio of 14 at the end of 2017 what was the market price of the stock

f.Calculate the cash dividend per share for 2017 and the dividend yield base on the market price calculated in part E

g.Calculate the dividend payout ratio for 2017

h.Assume acct receviable at Dec 31, 2017 totaled 315 million. Calculate the number of days in receivables at that date.

I.Calculate Wipers debt ratio at Dec 31,2017 and 2016

J. Calculate the times interest earned ratio of 2017 and 2016

Solutions

Expert Solution

(E) Market Price Per Stock = $69.86

(F) 1. Cash dividend per share = $ 1.34

2. Dividend yield ratio = 1.92%

(G) Dividend Payout Ratio = 26.85%

(H) No. Of days in Recievables = 37.62 days

(I) Debt Ratio : 2017 = 67.59%

2016 = 63.98%

(J) Times interest earned ratio : 2017= 3.32 times

2016 = 3.87 times


Related Solutions

Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER,...
Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 829 $ 1,071 $ 933 Other assets 2,433 1,940 1,739 Total assets $ 3,262 $ 3,011 $ 2,672 Current liabilities $ 597 $ 850 $ 752 Long-term liabilities 1,638 1,115 982 Stockholders’ equity 1,027 1,046 938 Total liabilities and stockholders' equity $ 3,262 $ 3,011 $ 2,672...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 798 $ 1,031 $ 893 Other assets 2,429 1,936 1,735 Total assets $ 3,227 $ 2,967 $ 2,628 Current liabilities $ 593 $ 846 $ 748 Long-term liabilities 1,611 1,079 946 Stockholders’ equity 1,023 1,042 934 Total liabilities and stockholders' equity $ 3,227 $ 2,967 $ 2,628...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 722 $ 949 $ 803 Other assets 2,420 1,927 1,726 Total assets $ 3,142 $ 2,876 $ 2,529 Current liabilities $ 584 $ 837 $ 730 Long-term liabilities 1,544 1,006 874 Stockholders’ equity 1,014 1,033 925 Total liabilities and stockholders' equity $ 3,142 $ 2,876 $ 2,529...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 734 $ 959 $ 813 Other assets 2,421 1,928 1,727 Total assets $ 3,155 $ 2,887 $ 2,540 Current liabilities $ 585 $ 838 $ 731 Long-term liabilities 1,555 1,015 883 Stockholders’ equity 1,015 1,034 926 Total liabilities and stockholders' equity $ 3,155 $ 2,887 $ 2,540...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 798 $ 1,031 $ 893 Other assets 2,429 1,936 1,735 Total assets $ 3,227 $ 2,967 $ 2,628 Current liabilities $ 593 $ 846 $ 748 Long-term liabilities 1,611 1,079 946 Stockholders’ equity 1,023 1,042 934 Total liabilities and stockholders' equity $ 3,227 $ 2,967 $ 2,628...
Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER,...
Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 707 $ 939 $ 793 Other assets 2,419 1,926 1,725 Total assets $ 3,126 $ 2,865 $ 2,518 Current liabilities $ 583 $ 836 $ 724 Long-term liabilities 1,530 997 870 Stockholders’ equity 1,013 1,032 924 Total liabilities and stockholders' equity $ 3,126 $ 2,865 $ 2,518...
The information presented here represents selected data from the December 31, 2016, balance sheets and income...
The information presented here represents selected data from the December 31, 2016, balance sheets and income statements for the year then ended for three firms. Required: Calculate the missing amounts for each firm. Firm A Firm B Firm C Total assets, 12/31/16 $348,000 $416,000 Total liabilities, 12/31/16 64,000 164,000 Paid-in capital, 12/31/16 44,000 47,200 112,000 Retained earnings, 12/31/16 148,800 Net income for 2016 54,400 88,000 64,800 Dividends declared and paid during 2016 9,600 22,400 Retained earnings, 1/1/16 40,000 99,200
Hypothetical balance sheets of Nike, Inc. are presented here.
Hypothetical balance sheets of Nike, Inc. are presented here. (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. If amount and percentage are a decrease show the numbers as negative, es -55,000, -20% or (55,000). (20%). Round percentages to 1 decimal place, es. 12.5%) b) Prepare a vertical analysis of the balance sheet data for Nike for 2022 NIKE
​Hypothetical balance sheets of Nike, Inc. are presented here.
Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000).(20%). Round percentages to 1 decimal place, eg. 12.5%.) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) (b) Prepare a vertical analysis of the balance sheet data for Nike for...
Suppose the comparative balance sheets of Nike, Inc. are presented here. Nike, Inc. Comparative Balance Sheets...
Suppose the comparative balance sheets of Nike, Inc. are presented here. Nike, Inc. Comparative Balance Sheets May 31 ($ in millions) 2020 2019 Assets Current assets $ 9,379 $ 8,300 Property, plant, and equipment (net) 1,836 1,700 Other assets 1,536 1,600 Total assets $12,751 $11,600 Liabilities and Stockholders’ Equity Current liabilities $ 3,267 $ 3,300 Long-term liabilities 1,358 1,400 Stockholders’ equity 8,126 6,900 Total liabilities and stockholders’ equity $12,751 $11,600 (a) Prepare a horizontal analysis of the balance sheet data...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT