Al Sevice Corporation 2022 operating performance vs. 2021 operating performance Calculate the following financial factors for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Al Sevice Corporation 2022 operating performance vs. 2021 operating performance Calculate the following financial factors for both years: Place X in proper colum 2022 2021 Better Worse Al Sevice Corporation Statement of Financial Position December 31, 2022 Financial Statement Analysis Horizontal Analysis Vertical 2022 2021 Avg Change Change % 2022 2021 Current assets: Cash Gross Margin % 100,000 110,000 105,000 A/R, net Inventory 210,000 220,000 215,000 Earnings per Share of CS 110,000 120,000 115,000 Prepaid expenses 10,000 10,000 10,000 Price Earnings Ratio Total current assets 430,000 460,000 445,000 Permanent assets: Payout Ratio Plant & equipment, net 900,000 880,000 Total assets 1,330,000 1,340,000 890,000 1,335,000 Profit Margin Current liabilities: Return on Assets Accounts payable 160,000 170,000 165,000 Accrued liabilities 50,000 50,000 50,000 Other S/T payables 100,000 90,000 95,000 Total current liabilities 310,000 310,000 310,000 Long-term liabilities: Bonds payable 190,000 240,000 215,000 Total liabilities 500,000 550,000 525,000 Stockholders' equity: Preferred stock, $100 par value, 10% 200,000 200,000 200,000 Common stock, ($1 par) 100,000 100,000 100,000 APIC-Common Stock 110,000 110,000 110,000 Retained earnings 420,000 380,000 400,000 Total stockholders' equity 830,000 790,000 810,000 Total liabilities & stk's equity 1,330,000 1,340,000 1,335,000 Al Service Corporation Income Statement For the Year Ended December 31, 2022 2017 Sales (all on account) 1,330,000 Cost of goods sold 850,000 2016 1,450,000 890,000 1,390,000 870,000 Gross margin 480,000 560,000 520,000 Selling and admin expense 292,000 290,000 291,000 Net operating income 188,000 270,000 229,000 Interest expense 31,000 33,000 32,000 Net income before taxes Income taxes (30%) Net income 157,000 47,000 110,000 237,000 197,000 49,000 188,000 48,000 149,000 Preferred Stock Dividends Paid Common Stock Dividends Paid Common Stockholders Equity Common shares outstanding Preferred shares outstanding $ 20,000 $ 18,000 50,000 610,000 45,000 590,000 600,000 100,000 100,000 100,000 2,000 2,000 2,000 Current Market Value per share $ 9.36 $ 10.15 Return on Common Stockholder Equity Asset Turnover Working Capital Current Ratio Acid-Test Ratio Accounts Receivable Turnover (Times) Average Collection Period (Days) Inventory Turnover Average Sales Period Vertical 2021 Times Interest Earned Financial Statement Analysis Horizontal Analysis | Change | Change % 2022 Debt to Asset Ratio Al Sevice Corporation 2022 operating performance vs. 2021 operating performance Calculate the following financial factors for both years: Place X in proper colum 2022 2021 Better Worse Al Sevice Corporation Statement of Financial Position December 31, 2022 Financial Statement Analysis Horizontal Analysis Vertical 2022 2021 Avg Change Change % 2022 2021 Current assets: Cash Gross Margin % 100,000 110,000 105,000 A/R, net Inventory 210,000 220,000 215,000 Earnings per Share of CS 110,000 120,000 115,000 Prepaid expenses 10,000 10,000 10,000 Price Earnings Ratio Total current assets 430,000 460,000 445,000 Permanent assets: Payout Ratio Plant & equipment, net 900,000 880,000 Total assets 1,330,000 1,340,000 890,000 1,335,000 Profit Margin Current liabilities: Return on Assets Accounts payable 160,000 170,000 165,000 Accrued liabilities 50,000 50,000 50,000 Other S/T payables 100,000 90,000 95,000 Total current liabilities 310,000 310,000 310,000 Long-term liabilities: Bonds payable 190,000 240,000 215,000 Total liabilities 500,000 550,000 525,000 Stockholders' equity: Preferred stock, $100 par value, 10% 200,000 200,000 200,000 Common stock, ($1 par) 100,000 100,000 100,000 APIC-Common Stock 110,000 110,000 110,000 Retained earnings 420,000 380,000 400,000 Total stockholders' equity 830,000 790,000 810,000 Total liabilities & stk's equity 1,330,000 1,340,000 1,335,000 Al Service Corporation Income Statement For the Year Ended December 31, 2022 2017 Sales (all on account) 1,330,000 Cost of goods sold 850,000 2016 1,450,000 890,000 1,390,000 870,000 Gross margin 480,000 560,000 520,000 Selling and admin expense 292,000 290,000 291,000 Net operating income 188,000 270,000 229,000 Interest expense 31,000 33,000 32,000 Net income before taxes Income taxes (30%) Net income 157,000 47,000 110,000 237,000 197,000 49,000 188,000 48,000 149,000 Preferred Stock Dividends Paid Common Stock Dividends Paid Common Stockholders Equity Common shares outstanding Preferred shares outstanding $ 20,000 $ 18,000 50,000 610,000 45,000 590,000 600,000 100,000 100,000 100,000 2,000 2,000 2,000 Current Market Value per share $ 9.36 $ 10.15 Return on Common Stockholder Equity Asset Turnover Working Capital Current Ratio Acid-Test Ratio Accounts Receivable Turnover (Times) Average Collection Period (Days) Inventory Turnover Average Sales Period Vertical 2021 Times Interest Earned Financial Statement Analysis Horizontal Analysis | Change | Change % 2022 Debt to Asset Ratio
Expert Answer:
Answer rating: 100% (QA)
Detailed Explanation Horizontal Analysis Balance Sheet 1 Current Assets Cash100000 2022 vs 110000 2021 AR net210000 2022 vs 220000 2021 Inventory10000 2022 vs 10000 2021 Prepaid Expenses10000 2022 vs ... View the full answer
Related Book For
Intermediate Accounting IFRS
ISBN: 9781119607519
4th Edition
Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield
Posted Date:
Students also viewed these accounting questions
-
The Director of Planning for Devine Dining Inc. wishes to study the relationship between the time of day a customer dined and whether the guest orders dessert. To investigate the relationship, the...
-
A punch press needs to move a stamp downward 2.0 inches in 0.8 seconds and return in 0.4 seconds. Determine the time ratio Q and the crank angular speed (in rpm). Also, sketch the timing chart and...
-
The summarized statements for the year ended 31 December 2007 for Mat, Rug and P entities are as follows: Statements of comprehensive income for the year ended 31 December 2007 The following...
-
Duhail Complex averages about 15% of Bananas spoil before they can be sold. The manager purchases 200kg of bananas for 2.03QR per kilogram. What is the selling price if there is a 45% markup on the...
-
Suggest an experiment to test the proposition that the Hofmann reaction is an intramolecular rearrangement-that is, one in which the migrating R group never fully separates from the amide molecule.
-
Describe the revenue recognition, matching, and historical cost principles as they are applied in the construction of a firm's financial statements.
-
Aztec plc was incorporated in 1968 as an importer of silver artefacts from South America which it customised for the UK market. The company had sold its products in the luxury market and traded...
-
Atwater Manufacturing Co. leases its equipment from Westside Leasing Company. In each of the following cases, assuming none of the other criteria for capitalizing leases are met, determine whether...
-
a curve with polar equation r=41/ 8sin theta + 17cos theta represents a line. this line has a cartesian equation of the form y=mx+b, where m and b are constants. give the formula for y in terms of x....
-
It is October 16, 2020, and you have just taken over the accounting work of China Moon Products, whose annual accounting period ends October 31. The company?s previous accountant journalized its...
-
The two subimages shown were extracted from the top, Thus, the subimage on the left is the result of using an arithmetic mean filter of size 3x3; the other subimage is the result of using a geometric...
-
De to show a 2. (3 marks) Evaluate lim 2 sin(x) sin(2x) - x-0 2ex-2- 2x - x2 2 AC
-
1. In general terms, why are some risks diversifiable? Why aren't others? What can you conclude that an investor can control the level of unsystematic risk in a portfolio, but not the level of...
-
Please read the following case: https://supreme.justia.com/cases/federal/us/555/323/Links to an external site. and watch the following video: https://www.youtube.com/watch?v=cAfn20FMheALinks to an...
-
Answers only with solutions. No need to explain. Thanks! 1. Suppose an American visits a particular market in India. The visitor bought 25 cupcakes for 250 Indian rupees and remarked that cupcakes...
-
Suppose that f(x, y) = y. Find the directional derivative of f(x, y) at the point (x, y) = ( -2, -1) in the direction of (2, 1). Answer exactly or round to 2 decimal places. Preview
-
Check my work Chocolaterie de Geneve, SA, is located in a French-speaking canton in Switzerland. The company makes chocolate truffles that are sold in popular embossed tins. The company has two...
-
Assume that a trial balance is prepared with an account balance of $21,360 listed as $21,630 and an account balance of $1,500 listed as $15,000. Identify the transposition and the slide.
-
Broussard Company reported net income of $3.5 million in 2022. Depreciation for the year was $520,000, accounts receivable increased $500,000, and accounts payable increased $300,000. Compute net...
-
Refer to the information in E18.31. Instructions a. Does the accounting for capitalized costs change if the contract is for 1 year rather than 3 years? Explain. b. Dans Demolition is a startup...
-
Presented below is the adjusted trial balance of Abbey plc at December 31, 2022. Additional information: 1. Net loss for the year was 2,500. 2. No dividends were declared during 2022. Instructions...
-
Prepare a flexible budget for planning (Learning Objective 1) Lasting Bubbles produces multicolored bubble solution used for weddings and other events. The companys static budget income statement for...
-
Comprehensive flexible budget, standards, and variances problem (Learning Objectives 2, 3,4, 5) One System assembles PCs and uses flexible budgeting and a standard cost system. One System allocates...
-
Work backward through labor variances (Learning Objective 4) Amandas Music manufactures harmonicas. Amanda uses standard costs to judge performance. Recently, a clerk mistakenly threw away some of...
Study smarter with the SolutionInn App