Problem 11-17 (Static) Ratio analysis-comprehensive problem Presented here are summarized data from the balance sheets and...

Transcribed Image Text:

Problem 11-17 (Static) Ratio analysis-comprehensive problem Presented here are summarized data from the balance sheets and income statements of Wiper Incorporated: WIPER INCORPORATED Condensed Balance Sheets December 31, 2023, 2022, 2021 (in millions) Current assets Other assets Total assets Current liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity 2023 2022 2021 $ 650 2,750 $ 900 2,050 $ 700 1,750 $ 3,400 $ 2,950 $ 2,450 $ 500 800 $ 700 1,500 1,000 800 1,400 1,150 950 $ 3,400 $ 2,950 $ 2,450 WIPER INCORPORATED Selected Income Statement and Other Data For the Years Ended December 31, 2023 and 2022 (in millions) Income statement data: Sales Operating income Interest expense Net income Other data: Average number of common shares outstanding Total dividends paid Required: 2023 2022 $ 3,300 $ 2,900 380 300 80 70 300 230 44 42 $ 50 $ 30 a. Calculate return on investment, based on net income and average total assets, for 2023 and 2022. b. Calculate return on equity for 2023 and 2022. c. Calculate working capital and the current ratio for each of the past three years. d. Calculate earnings per share for 2023 and 2022. e. If Wiper's stock had a price/earnings ratio of 14 at the end of 2023, what was the market price of the stock? f. Calculate the cash dividend per share for 2023 and the dividend yield based on the market price calculated in part e. g. Calculate the dividend payout ratio for 2023. h. Assume that accounts receivable at December 31, 2023, totaled $310 million. Calculate the number of days' sales in receivables at that date. i. Calculate Wiper's debt ratio and debt/equity ratio at December 31, 2023 and 2022. j. Calculate the times interest earned ratio for 2023 and 2022. Complete this question by entering your answers in the tabs below. Req A and B Req C Req D Req E to H Req I Req J a. Calculate return on investment, based on net income and average total assets, for 2023 and 2022. Note: Do not round intermediate calculations. Round your percentage answers to 1 decimal place (i.e., 0.123 should be entered as 12.3. b. Calculate return on equity for 2023 and 2022. Note: Round your percentage answers to 1 decimal place (i.e., 0.123 should be entered as 12.3. a. Return on investment b. Return on equity 2023 2022 % % % % Show less Req A and B Req C Req D Req E to H Req I Req J Calculate working capital and the current ratio for each of the past three years. Note: Enter your answers in millions (i.e., 5,000,000 should be entered as 5). Round "Current ratio" to 1 decimal place. 2023 2022 2021 Working capital Current ratio Calculate earnings per share for 2023 and 2022. Note: Round your answers to 2 decimal places. Earnings per share 2023 2022 Req A and B Req C Req D Req E to H Req I Req J e. If Wiper's stock had a price/earnings ratio of 14 at the end of 2023, what was the market price of the stock? Note: Round intermediate calculations and final answer to 2 decimal places. f. Calculate the cash dividend per share for 2023 and the dividend yield based on the market price calculated in part e. Note: Round your percentage answers to 2 decimal place (i.e., 0.1234 should be entered as 12.34. g. Calculate the dividend payout ratio for 2023. Note: Do not round intermediate calculations. Round your percentage answers to 1 decimal place (i.e., 0.123 should be entered as 12.3). h. Assume that accounts receivable at December 31, 2023, totaled $310 million. Calculate the number of days' sales in receivables at that date. Note: Use 365 days a year. Do not round intermediate calculations. Round your answer to 1 decimal place. e. Market price f. Cash dividends per share f. Dividend yield % g. Dividend payout ratio % h. Number of days' sales days Show less Req A and B Req C Req D Req E to H Req I Req J Calculate Wiper's debt ratio and debt/equity ratio at December 31, 2023 and 2022. Note: Round "Debt ratio" to 1 decimal place (i.e., 0.123 should be entered as 12.3) and "Debt/equity ratio" to the nearest whole percent (i.e., 012 should be entered as 12). Debt ratio Debt/equity ratio 2023 2022 % % % % Req A and B Req C Req D Req E to H Req I Req J Calculate the times interest earned ratio for 2023 and 2022. Note: Round your answers to 1 decimal place. Times interest earned 2023 times 2022 times Problem 11-17 (Static) Ratio analysis-comprehensive problem Presented here are summarized data from the balance sheets and income statements of Wiper Incorporated: WIPER INCORPORATED Condensed Balance Sheets December 31, 2023, 2022, 2021 (in millions) Current assets Other assets Total assets Current liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity 2023 2022 2021 $ 650 2,750 $ 900 2,050 $ 700 1,750 $ 3,400 $ 2,950 $ 2,450 $ 500 800 $ 700 1,500 1,000 800 1,400 1,150 950 $ 3,400 $ 2,950 $ 2,450 WIPER INCORPORATED Selected Income Statement and Other Data For the Years Ended December 31, 2023 and 2022 (in millions) Income statement data: Sales Operating income Interest expense Net income Other data: Average number of common shares outstanding Total dividends paid Required: 2023 2022 $ 3,300 $ 2,900 380 300 80 70 300 230 44 42 $ 50 $ 30 a. Calculate return on investment, based on net income and average total assets, for 2023 and 2022. b. Calculate return on equity for 2023 and 2022. c. Calculate working capital and the current ratio for each of the past three years. d. Calculate earnings per share for 2023 and 2022. e. If Wiper's stock had a price/earnings ratio of 14 at the end of 2023, what was the market price of the stock? f. Calculate the cash dividend per share for 2023 and the dividend yield based on the market price calculated in part e. g. Calculate the dividend payout ratio for 2023. h. Assume that accounts receivable at December 31, 2023, totaled $310 million. Calculate the number of days' sales in receivables at that date. i. Calculate Wiper's debt ratio and debt/equity ratio at December 31, 2023 and 2022. j. Calculate the times interest earned ratio for 2023 and 2022. Complete this question by entering your answers in the tabs below. Req A and B Req C Req D Req E to H Req I Req J a. Calculate return on investment, based on net income and average total assets, for 2023 and 2022. Note: Do not round intermediate calculations. Round your percentage answers to 1 decimal place (i.e., 0.123 should be entered as 12.3. b. Calculate return on equity for 2023 and 2022. Note: Round your percentage answers to 1 decimal place (i.e., 0.123 should be entered as 12.3. a. Return on investment b. Return on equity 2023 2022 % % % % Show less Req A and B Req C Req D Req E to H Req I Req J Calculate working capital and the current ratio for each of the past three years. Note: Enter your answers in millions (i.e., 5,000,000 should be entered as 5). Round "Current ratio" to 1 decimal place. 2023 2022 2021 Working capital Current ratio Calculate earnings per share for 2023 and 2022. Note: Round your answers to 2 decimal places. Earnings per share 2023 2022 Req A and B Req C Req D Req E to H Req I Req J e. If Wiper's stock had a price/earnings ratio of 14 at the end of 2023, what was the market price of the stock? Note: Round intermediate calculations and final answer to 2 decimal places. f. Calculate the cash dividend per share for 2023 and the dividend yield based on the market price calculated in part e. Note: Round your percentage answers to 2 decimal place (i.e., 0.1234 should be entered as 12.34. g. Calculate the dividend payout ratio for 2023. Note: Do not round intermediate calculations. Round your percentage answers to 1 decimal place (i.e., 0.123 should be entered as 12.3). h. Assume that accounts receivable at December 31, 2023, totaled $310 million. Calculate the number of days' sales in receivables at that date. Note: Use 365 days a year. Do not round intermediate calculations. Round your answer to 1 decimal place. e. Market price f. Cash dividends per share f. Dividend yield % g. Dividend payout ratio % h. Number of days' sales days Show less Req A and B Req C Req D Req E to H Req I Req J Calculate Wiper's debt ratio and debt/equity ratio at December 31, 2023 and 2022. Note: Round "Debt ratio" to 1 decimal place (i.e., 0.123 should be entered as 12.3) and "Debt/equity ratio" to the nearest whole percent (i.e., 012 should be entered as 12). Debt ratio Debt/equity ratio 2023 2022 % % % % Req A and B Req C Req D Req E to H Req I Req J Calculate the times interest earned ratio for 2023 and 2022. Note: Round your answers to 1 decimal place. Times interest earned 2023 times 2022 times