Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Fraud Auditing And Detection Guide

Authors: Rebecca S. Busch

2nd Edition

978-1118179802

More Books

Students also viewed these Accounting questions

Question

Did you leave out anything that matters to your reader?

Answered: 1 week ago