Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 1117 (Algo) Ratio analysis-comprehensive problem Presented here are summarized data from the balance sheets and income statements of Wiper Incorporated: Required: a. Calculate return
Problem 1117 (Algo) Ratio analysis-comprehensive problem Presented here are summarized data from the balance sheets and income statements of Wiper Incorporated: Required: 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 10 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 $323 million. Calculate the number of days' sales in receivables 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. 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. Complete this question by entering your answers in the tabs below. 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. Complete this question by entering your answers in the tabs below. Calculate earnings per share for 2023 and 2022. Note: Round your answers to 2 decimal places. e. If Wiper's stock had a price/earnings ratio of 10 at the end of 2023, what was the market price of the stock? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Note: Do not round intermediate calculations. 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 nearest whole percentage (i.e., 0.12 should be entered as 12). h. Assume that accounts receivable at December 31,2023 , totaled $323 million. Calculate the number of days' sales in receivables at that date. Note: Use 365 days a year. Do not round intermediate calculations. 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). Complete this question by entering your answers in the tabs below. Calculate the times interest earned ratio for 2023 and 2022. Note: Round your answers to 1 decimal place. Problem 1117 (Algo) Ratio analysis-comprehensive problem Presented here are summarized data from the balance sheets and income statements of Wiper Incorporated: Required: 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 10 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 $323 million. Calculate the number of days' sales in receivables 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. 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. Complete this question by entering your answers in the tabs below. 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. Complete this question by entering your answers in the tabs below. Calculate earnings per share for 2023 and 2022. Note: Round your answers to 2 decimal places. e. If Wiper's stock had a price/earnings ratio of 10 at the end of 2023, what was the market price of the stock? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Note: Do not round intermediate calculations. 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 nearest whole percentage (i.e., 0.12 should be entered as 12). h. Assume that accounts receivable at December 31,2023 , totaled $323 million. Calculate the number of days' sales in receivables at that date. Note: Use 365 days a year. Do not round intermediate calculations. 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). Complete this question by entering your answers in the tabs below. Calculate the times interest earned ratio for 2023 and 2022. Note: Round your answers to 1 decimal place
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started