Outdoor Waterworks Inc. Income Statement For Year Ended December 31, 2023 Net sales Cost of goods...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Outdoor Waterworks Inc. Income Statement For Year Ended December 31, 2023 Net sales Cost of goods sold: Inventory, Dec. 31, 2022 Purchases Goods available for sale Inventory, Dec. 31, 2023 Cost of goods sold Gross profit from sales Operating expenses Operating profit Interest expense Profit before taxes Income taxes Profit $1,036,000 $ 78,860 607,840 $ 686,700 60,090 626,610 $ 409,390 280,360 $ 129,030 12,100 $ 116,930 19,214 $ 97,716 Outdoor Waterworks Inc. Balance Sheet December 31, 2023 Assets Cash Current non-strategic investments Accounts receivable, net $ 22,900 25,320 52,780 Notes receivable Inventory Prepaid expenses Plant and equipment, net Total assets Liabilities and Equity 11,260 60,090 5,900 330,020 $508,270 Accounts payable $ 49,120 Accrued wages payable 6,380 Income taxes payable 7,170 Long-term note payable, secured by mortgage on plant 116,100 Common shares, 160,000 shares 195,500 Retained earnings 134,000 Total liabilities and equity $508,270 Assume all sales were on credit. Also assume the long-term note payable is due in 2026, with no current portion. On the December 31, 2022, balance sheet, the assets totalled $436,220, common shares were $195,500, and retained earnings were $109,740. Required: Calculate the following: (Use 365 days in a year. Do not round your intermediate calculations. Round the answers to 2 decimal places.) a. Current ratio b. Quick ratio c. Days' sales uncollected d. Inventory turnover e. Days' sales in inventory f. Ratio of pledged plant assets to secured liabilities g. Times interest earned to 1 to 1 days times days to 1 times h. Profit margin i. Total asset turnover % times j. Return on total assets % k. Return on common shareholders' equity % B Analysis Component: Identify whether the ratios calculated above are favourable or unfavourable to the industry averages. a. Current ratio b. Quick ratio c. Days' sales uncollected d. Inventory turnover e. Days' sales in inventory Industry Average 1.6:1 1.1:1 21 days 5 times 70 days f. Ratio of pledged plant assets to secured liabilities 1.4:1 g. Times interest earned h. Profit margin i. Total asset turnover j. Return on total assets 50 times 14 % 2.3 times 20 % k. Return on common shareholders' equity 32.7 % Outdoor Waterworks Inc. Income Statement For Year Ended December 31, 2023 Net sales Cost of goods sold: Inventory, Dec. 31, 2022 Purchases Goods available for sale Inventory, Dec. 31, 2023 Cost of goods sold Gross profit from sales Operating expenses Operating profit Interest expense Profit before taxes Income taxes Profit $1,036,000 $ 78,860 607,840 $ 686,700 60,090 626,610 $ 409,390 280,360 $ 129,030 12,100 $ 116,930 19,214 $ 97,716 Outdoor Waterworks Inc. Balance Sheet December 31, 2023 Assets Cash Current non-strategic investments Accounts receivable, net $ 22,900 25,320 52,780 Notes receivable Inventory Prepaid expenses Plant and equipment, net Total assets Liabilities and Equity 11,260 60,090 5,900 330,020 $508,270 Accounts payable $ 49,120 Accrued wages payable 6,380 Income taxes payable 7,170 Long-term note payable, secured by mortgage on plant 116,100 Common shares, 160,000 shares 195,500 Retained earnings 134,000 Total liabilities and equity $508,270 Assume all sales were on credit. Also assume the long-term note payable is due in 2026, with no current portion. On the December 31, 2022, balance sheet, the assets totalled $436,220, common shares were $195,500, and retained earnings were $109,740. Required: Calculate the following: (Use 365 days in a year. Do not round your intermediate calculations. Round the answers to 2 decimal places.) a. Current ratio b. Quick ratio c. Days' sales uncollected d. Inventory turnover e. Days' sales in inventory f. Ratio of pledged plant assets to secured liabilities g. Times interest earned to 1 to 1 days times days to 1 times h. Profit margin i. Total asset turnover % times j. Return on total assets % k. Return on common shareholders' equity % B Analysis Component: Identify whether the ratios calculated above are favourable or unfavourable to the industry averages. a. Current ratio b. Quick ratio c. Days' sales uncollected d. Inventory turnover e. Days' sales in inventory Industry Average 1.6:1 1.1:1 21 days 5 times 70 days f. Ratio of pledged plant assets to secured liabilities 1.4:1 g. Times interest earned h. Profit margin i. Total asset turnover j. Return on total assets 50 times 14 % 2.3 times 20 % k. Return on common shareholders' equity 32.7 %
Expert Answer:
Related Book For
Fundamental Accounting Principles Volume 2
ISBN: 9781260881332
17th Canadian Edition
Authors: Kermit D. Larson, Heidi Dieckmann, John Harris
Posted Date:
Students also viewed these finance questions
-
There are n lockers in a hallway, numbered sequentially from 1 to n . Initially, all the locker doors are closed. You make n passes by the lockers, each time starting with locker # 1 . On the ith...
-
The following items include the 2023 and 2022 balance sheet information and the 2023 income statement of the Clear Water Corporation. Additional information about the companys 2023 transactions is...
-
?
-
From the following data for three prospective fuels, calculate which could provide the most energy per unit volume: Density at 20 C Molar Enthalpy of Combustion Fuel (g/cm (kJ/mol) Nitroethane, C2H...
-
9. Open the Insurance Company Entry form in Design View and right align the right edges of the Insurance Code and Company Name labels. Left align the Insurance Code and Company Name text boxes. Add a...
-
Briefly explain the main differences among hierarchical, network, and relational databases.
-
Shervonne Thomas is the controller at a large manufacturing company located in Chestereld, Virginia. The company has several divisions that evaluate their performance using a return on investment...
-
Direct Materials Used, Cost of Goods Manufactured In September, Lauren Ashley Company purchased materials costing $210,000 and incurred direct labor cost of $140,000. Overhead totaled $320,000 for...
-
An in compressible, viscous fluid is placed between horizontal, infinite. parallel plates as is shown in Fig. P6.94. The two plates move in opposite directions with constant velocities, U1 and U2, as...
-
Your friend Georgia is planning to open an automobile parts shop and has come to you for advice about whether to use a perpetual or a periodic inventory system. Required: Before you advise her, list...
-
Tom Nelson has just graduated from Red River College with a major in marketing. He has three years of experience in the retail grocery business and has decided he would like to work as a salesperson...
-
Select an industry with which you are at least somewhat familiar. Utilize the search engines at www.findarticles.com and identify some of the important macroenvironmental influences faced by...
-
You are being interviewed for a sales position with a national electronics retailer. The job is very important to you as it will help pay your living expenses while you complete your studies. During...
-
Several weeks ago, Joy Hong fell in love with the Scion tC coupe. After reading about the car in a magazine, she decided to visit a local Scion dealer. A test drive convinced her to place an order....
-
Outline Starbucks ethical codes and Corporate Social Responsibility (CSR) Plan. If there is not an ethical code or CSR plan what would you include in each? How would you go about auditing your...
-
Organizations are increasing their use of personality tests to screen job applicants. What are some of the advantages and disadvantages of this approach? What can managers do to avoid some of the...
-
Using tha data file usmacro, estimate the ARDL \((2,1)\) model Your estimates should agree with the results given in equation (9.42). Use these estimates to verify the forecast results given in Table...
-
Using the data file usmacro, estimate the \(\operatorname{AR}(1)\) model \(G_{t}=\alpha+\phi G_{t-1}+v_{t}\). From these estimates and those obtained in Exercise 9.16, use the results from Exercise...
-
Consider the \(\operatorname{ARDL}(p, q)\) equation and the data in the file usmacro. For \(p=2\) and \(q=1\), results from the LM test for serially correlated errors were reported in Table 9.6 for...
Study smarter with the SolutionInn App