Lockhart Industries reported total stockholders' equity of $415,000 on its balance sheet dated December 31, 2021. During the year ended December 31, 2022, the company declared and paid a cash dividend of $15,500, declared and distributed a 10% stock dividend with a $16,000 total market value, and issued additional common stock for $95,000. If total stockholders' equity as of December 31, 2022 is $527,000, what was the amount of net income for the year ended December 31, 2022?
Q: Darren corp has the following details for one of its subsidiaries: Long-term debt: 9% payable for…
A: Earnings per share= Net Income earned - Preferred dividends paid * / Weighted average number of…
Q: Required: 1. Prepare the journal entry to establish the petty cash fund. 2 Prepare a petty cash…
A: Preparing the petty cash fund and petty cash report form.
Q: Presented below are the balances taken from the books of Abacus Corporation on January 1, 2020:…
A: You have posted more than one unrelated questions, so as per our policy only first question is…
Q: ACCOUNT NAME Cash Accounts Receivable Allowance for Doubtful Accounts Receivable from Highest Bidder…
A: Closing Entries - Closing entries are required to close the temporary accounts after making…
Q: Solaris Company Limited , makers of solar water heaters, uses a perpetual inventory system. The…
A: Here discuss about the details of the inventory valuation using the first in first out method and to…
Q: Cardinal uses the high-low method of estimating costs. Cardinal had total costs of $26,450 at its…
A: The high-low method is used to differentiate the mixed cost. The mixed cost is the combination of…
Q: 2. How would you expect the ratios to differ between a discount supermarket and luxury retailer? A.…
A: Discount Stores The retail format provided by a discount store or discounter allows for the sale of…
Q: how to fill in the boxes
A: 1. Accounting Equation - Accounting Equation is calculated using following equation - Assets =…
Q: Accounting Consider a bank with 10M in shareholder equity. It has assets and liabilities according…
A: Shareholder equity (SE) is supplied by a company's net value, which is generated from the leftover…
Q: Examples: Receive payment in cash for outstanding account receivable Assets Liability Equity…
A: Accounting equation serves as the basis for the double-entry accounting method as it shows the total…
Q: Calculate : (1) (2) (3) (4) (5) Current Assets to Fixed assets 31 मार्च को एक कम्पनी का आर्थिक…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Alberta Gauge Company, Ltd., a small manufacturing company in Calgary, Alberta, manufactures three…
A: Note: As per our guidelines, we will solve the first three subparts for you. 1. 1. The suggested…
Q: Provide the costs incurred on the plant or machinery used for the purpose of the business which is…
A: Answer: As per Income Tax Act 1956, where the expenditure incurred on Plant or Machinery for the…
Q: Do you believe that KFC would have been so successful in China today if executives had tried to make…
A: Comment- We’ll answer the first question since the exact one wasn’t specified. Please submit a new…
Q: Instructions The following equity investment transactions were completed by Romero Company during a…
A: A journal entry is used to disclose a business deal in a company's accounting records. A journal…
Q: Question 1 Limonade produced 11,000 cases of powdered drink mix and sold 10,000 cases in April 2010.…
A: In the context of the given question, we are required to compute the total cost per unit, the value…
Q: Mazin and Marwan commenced business as partners on Jan 1, 2020. They contributed RO 60,000, RO…
A: Since nothing is given we will provide interest on beginning capital . Interest on capital = Capital…
Q: The Hua Company has decided to undertake a large project. Consequently, there is a need for…
A: Paid in capital stock consist of preferred and common stock where preferred shares are issued by the…
Q: Janet sells custom made window blinds. If her raw materials are $15, labor costs are $125, and…
A: Job order costing is the method of computing costs wherein the cost per job is calculated. This…
Q: plain the financial aspects of planning and costing as embe
A: Budget : It is an expression of an organisation's plan, policies and programmes in the form of…
Q: Current Attempt in Progress The ledger of Kingbird, Inc. at the end of the current year shows…
A: Introduction: Accounting journal entries are employed in the accounting system to record financial…
Q: At December 31, 2020, Tojosa Corporation reported a deferred tax liability of $240,000 which was…
A: Lets understand the basics. When there is taxable temporary difference arise between the income as…
Q: ABC Company sells inventory to XYZ Company for $2,400. If XYZ purchases additional inventory it…
A: Discount on purchase :— It is an offer provided to purchaser to Purchase Goods in Less Price then…
Q: Crane Company reports the following Inventory Accounts Payable End of Year $24700 $204800. O…
A: Cash paid to suppliers means the amount of money paid to the suppliers for purchasing inventory from…
Q: Inventories Materials January 1 December 31 $78,750 $94,450 Work in process 108,600 96,800 Finished…
A: Cost of goods sold was related with production of an product where it includes direct materials…
Q: . Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three…
A: POC % = cost incurred till date/ Total Estimated cost of completion. As per POC method, Revenue…
Q: The General Journal was not completed. Please fill out the missing answers for these dates: 1) S
A: General Journal is the book of prime entry where the transactions are first…
Q: On December 28, 2021, the board of directors of Talon Corporation, a calendar year, accrual method C…
A: Taxability and deduction of donation in the United States of America is dependent on the income…
Q: Determine the amount of the adjusting entry for bad debt expense. fill in the blank 1 of 2$ b.…
A: Allowance For Doubtful Debt :— It is Provision Or Reserve for Bad Debt. It is Liability. Bad Debt…
Q: Diva Ltd has an item of equipment with a carrying amount of $110000 (cost $150000 less accumulated…
A: Impairment Loss- Impairment loss is the term used to describe the fall in an asset's carrying value…
Q: Bond Company adopted the dollar-value LIFO inventory method on January 1, 2021. In applying the LIFO…
A: Under the dollar value LIFO method, the inventory at December 31, 2022, should be:
Q: Pharoah Company had the following records: 2022 2021 Ending inventory $42000 $30000…
A: In order to determine the average days in inventory, the total no. of days in a year are required to…
Q: Magenta Corporation wants to raise $50.6 million in a seasoned equity offering, net of all fees.…
A: The desired shares to be sold are determined with respect to the net price per share, after…
Q: 10. The current project earns $100,000 and has costs of $50,000. A ne project would earn $150,000…
A: INTRODUCTION: The cost of a project is defined as the cost of acquiring, constructing,…
Q: Question 6 Can a firm earn an economic loss and an accounting profit at the same time? E Forr
A: Lets understand the basics. Cost are divided into two parts which are, (1) Explicit cost (2)…
Q: Sweet Catering completed the following selected transactions during May 2016: • May 1: Prepaid rent…
A: The cash basis accounting system state that, the revenue and expenses should be recognized when cash…
Q: The hypothetical company XYZ Inc started its operations in 2020. On December 31 2020, it had the…
A: Balance sheet is an important part of accounting.It shows the company's current status whether it is…
Q: Assume the car can be purchased for 0% down for 60 months (in lieu of rebate). A car with a sticker…
A: INTRODUCTION: The term "annual percentage rate" (APR) describes the annual interest that is produced…
Q: Income Payment Professional/Management/Consultancy fees (Individual) EWT Gross receipts 3M or below…
A: Agency fees refers to the internal expenses which arises from the agent taking the action on the…
Q: An adverse opinion is most likely to be included in an audit report when Multiple Choice A…
A: There are 4 types of audit opinions. 1.unqualified 2.Qualified 3.Disclaimer 4.Adverse opinion
Q: Vernon Publications established the following standard price and costs for a hardcover picture book…
A: Here to calculate the details of the master Budget with the flexible budget which are incurred to…
Q: The hypothetical company XYZ Inc started its operations in 2020. On December 31 2020, it had the…
A: Accounting balance sheet is very important aspect as it gives clear cut picture of the company's…
Q: Before a person may be appointed as a director, they must? O a Consent but the consent need only be…
A: Condition For Appointment of Directors:— 1]. Every Directors shall be appointed in the General…
Q: According to a FIFO calculation, Montana Co. estimated its year-end inventory to be worth $649,000.…
A: As per inventory valuation method, the finished goods inventory on balance sheet are carried at…
Q: Instructions On January 1, Valuation Allowance for Available for Sale Investments had a zero balance…
A: The unrealized loss available for sale = $6110 ( $78400 - $72290 )
Q: Which of the following equations expresses the definition of “income”? Choices; Income = Revenues…
A: Revenues - It is the amount of money received through sale of goods and services . Gains - It is the…
Q: Justin Mathews is a waiter at the Delixe Lounge. In his first weekly pay in March, he earned…
A: Here discuss about the details of the net pay which are incurred after the whole statutory deduction…
Q: Xyz Company sells 20000 units SP per unit is 12= VC per unit is 9/= Fixed cost for the period…
A: Variable costs are those costs which changes with change in activity level. Fixed costs are costs…
Q: In 2011, Milford Corporation determined that it overstated salaries payable and salaries expense by…
A: The temporary accounts including expenses and revenues are closed at the end of accounting period by…
Q: Which of the following firms are more likely to hold NFA A. A firm who operates in a competitive…
A: Net foreign assets (NFA) are the amount of total cumulative assets that are held by one entity doing…
Lockhart Industries reported total
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Anoka Company reported the following selected items in the shareholders equity section of its balance sheet on December 31, 2019, and 2020: In addition, it listed the following selected pretax items as a December 31, 2019 and 2020: The preferred shares were outstanding during all of 2019 and 2020; annual dividends were declared and paid in each year. During 2019, 2,000 common shares were sold for cash on October 4. During 2020, a 20% stock dividend was declared and issued in early May. At the end of 2019 and 2020, the common stock was selling for 25.75 and 32.20, respectively. The company is subject to a 30% income tax rate. Required: 1. Prepare the comparative 2019 and 2020 income statements (multiple-step), and the related note that would appear in Anokas 2020 annual report. 2. Next Level Compute the price/earnings ratio for 2020. How does this compare to 2019? Why is it different?Lyon Company shows the following condensed income statement information for the year ended December 31, 2019: Lyon declared dividends of 6,000 on preferred stock and 17,280 on common stock. At the beginning of 2019, 10,000 shares of common stock were outstanding. On May 1, 2019, the company issued 2,000 additional common shares, and on October 31, 2019, it issued a 20% stock dividend on its common stock. The preferred stock is not convertible. Required: 1. Compute the 2019 basic earnings per share. 2. Show the 2019 income statement disclosure of basic earnings per share. 3. Draft a related note to accompany the 2019 financial statements.On January 1, 2019, Kittson Company had a retained earnings balance of 218,600. It is subject to a 30% corporate income tax rate. During 2019, Kittson earned net income of 67,000, and the following events occurred: 1. Cash dividends of 3 per share on 4,000 shares of common stock were declared and paid. 2. A small stock dividend was declared and issued. The dividend consisted of 600 shares of 10 par common stock. On the date of declaration, the market price of the companys common stock was 36 per share. 3. The company recalled and retired 500 shares of 100 par preferred stock. The call price was 125 per share; the stock had originally been issued for 110 per share. 4. The company discovered that it had erroneously recorded depreciation expense of 45,000 in 2018 for both financial reporting and income tax reporting. The correct depreciation for 2018 should have been 20,000. This is considered a material error. Required: 1. Prepare journal entries to record Items 1 through 4. 2. Prepare Kittsons statement of retained earnings for the year ended December 31, 2019.
- Cash dividends on the 10 par value common stock of Garrett Company were as follows: The 4th-quarter cash dividend was declared on December 21, 2019, to shareholders of record on December 31, 2019. Payment of the 4th-quarter cash dividend was made on January 18, 2020. In addition, Garrett declared a 5% stock dividend on its 10 par value common stock on December 3, 2019, when there were 300,000 shares issued and outstanding and the market value of the common stock was 20 per share. The shares were issued on December 24, 2019. What was the effect on Garretts shareholders equity accounts as a result of the preceding transactions?Statement of Stockholders' Equity At the end of 2019, Stanley Utilities Inc. had the following equity accounts and balances: During 2020, Stanley Utilities engaged in the following transactions involving its equity accounts: Sold 3,300 shares of common stock for $15 per share. Sold 1,000 shares of 12%, $100 par preferred stock at $105 per share. Declared and paid cash dividends of $8,000. Repurchased 1,000 shares of treasury stock (common) for $38 per share. Sold 400 of the treasury shares for $42 per share. Required: Prepare the journal entries for Transactions a through e. Assume that 2020 net income was $87,000. Prepare a statement of stockholders equity at December 31, 2020.Hyde Corporations capital structure at December 31, 2018, was as follows: On July 2, 2019, Hyde issued a 10% stock dividend on its common stock and paid a cash dividend of 2.00 per share on its preferred stock. Net income for the year ended December 31, 2019, was 780,000. What should be Hydes 2019 basic earnings per share? a. 7.80 b. 7.09 c. 7.68 d. 6.73
- The controller of Red Lake Corporation has requested assistance in determining income, basic earnings per share, and diluted earnings per share for presentation on the companys income statement for the year ended September 30, 2020. As currently calculated, Red Lakes net income is 540,000 for fiscal year 2019-2020. Your working papers disclose the following opening balances and transactions in the companys capital stock accounts during the year: 1. Common stock (at October 1, 2019, stated value 10, authorized 300,000 shares; effective December 1, 2019, stated value 5, authorized 600,000 shares): Balance, October 1, 2019issued and outstanding 60,000 shares December 1, 201960,000 shares issued in a 2-for-l stock split December 1, 2019280,000 shares (stated value 5) issued at 39 per share 2. Treasury stockcommon: March 3, 2020purchased 40,000 shares at 38 per share April 1, 2020sold 40,000 shares at 40 per share 3. Noncompensatory stock purchase warrants, Series A (initially, each warrant was exchangeable with 60 for 1 common share; effective December 1, 2019, each warrant became exchangeable for 2 common shares at 30 per share): October 1, 201925,000 warrants issued at 6 each 4. Noncompensatory stock purchase warrants, Series B (each warrant is exchangeable with 40 for 1 common share): April 1, 202020,000 warrants authorized and issued at 10 each 5. First mortgage bonds, 5%, due 2029 (nonconvertible; priced to yield 5% when issued): Balance October 1, 2019authorized, issued, and outstandingthe face value of 1,400,000 6. Convertible debentures, 7%, due 2036 (initially, each 1,000 bond was convertible at any time until maturity into 20 common shares; effective December 1, 2019, the conversion rate became 40 shares for each bond): October 1, 2019authorized and issued at their face value (no premium or discount) of 2,400,000 The following table shows the average market prices for the companys securities during 2019-2020: Adjusted for stock split Required: Prepare a schedule computing: 1. the basic earnings per share 2. the diluted earnings per share that should be presented on Red Lakes income statement for the year ended September 30, 2020 A supporting schedule computing the numbers of shares to be used in these computations should also be prepared. Assume an income tax rate of 30%.Statement of Stockholders' Equity At the end of 2019, Stanley Utilities Inc. had the following equity accounts and balances: During 2020, Haley engaged in the following transactions involving its equity accounts: Sold 5,000 shares of common stock for $19 per share. Sold 1.200 shares of 12%, $50 par preferred stock at $75 per share. Declared and paid cash dividends of $22,000. Repurchased 1,000 shares of treasury stock (common) for $24 per share. Sold 300 of the treasury shares for $26 per share. Required: Prepare the journal entries for Transactions a through e. Assume that 2020 net income was $123,700. Prepare a statement of stockholders equity at December 31, 2020.Selected transactions completed by Equinox Products Inc. during the fiscal year ended December 31, 2016, were as follows: a. Issued 15,000 shares of 20 par common stock at 30, receiving cash. b. Issued 4,000 shares of 80 par preferred 5% stock at 100, receiving cash. c. Issued 500,000 of 10-year, 5% bonds at 104, with interest payable semiannually. d. Declared a quarterly dividend of 0.50 per share on common stock and 1.00 per share on preferred stock. On the date of record, 100,000 shares of common stock were outstanding, no treasury shares were held, and 20,000 shares of preferred stock were outstanding. e. Paid the cash dividends declared in (d). f. Purchased 7,500 shares of Solstice Corp. at 40 per share, plus a 150 brokerage commission. The investment is classified as an available-for-sale investment. g. Purchased 8,000 shares of treasury common stock at 33 per share. h. Purchased 40,000 shares of Pinkberry Co. stock directly from the founders for 24 per share. Pinkberry has 125,000 shares issued and outstanding. Equinox Products Inc. treated the investment as an equity method investment. i. Declared a 1.00 quarterly cash dividend per share on preferred stock. On the date of record, 20,000 shares of preferred stock had been issued. j. Paid the cash dividends to the preferred stockholders. k. Received 27,500 dividend from Pinkberry Co. investment in (h). l. Purchased 90,000 of Dream Inc. 10-year, 5% bonds, directly from the issuing company, at their face amount plus accrued interest of 375. The bonds are classified as a heldtomaturity long-term investment. m. Sold, at 38 per share, 2,600 shares of treasury common stock purchased in (g). n. Received a dividend of 0.60 per share from the Solstice Corp. investment in (f). o. Sold 1,000 shares of Solstice Corp. at 45, including commission. p. Recorded the payment of semiannual interest on the bonds issued in (c) and the amortization of the premium for six months. The amortization is determined using the straight-line method. q. Accrued interest for three months on the Dream Inc. bonds purchased in (l). r. Pinkberry Co. recorded total earnings of 240,000. Equinox Products recorded equity earnings for its share of Pinkberry Co. net income. s. The fair value for Solstice Corp. stock was 39.02 per share on December 31, 2016. The investment is adjusted to fair value, using a valuation allowance account. Assume Valuation Allowance for Available-for-Sale Investments had a beginning balance of zero. Instructions 1. Journalize the selected transactions. 2. After all of the transactions for the year ended December 31, 2016, had been posted [including the transactions recorded in part (1) and all adjusting entries], the data that follows were taken from the records of Equinox Products Inc. a. Prepare a multiple-step income statement for the year ended December 31, 2016, concluding with earnings per share. In computing earnings per share, assume that the average number of common shares outstanding was 100,000 and preferred dividends were 100,000. (Round earnings per share to the nearest cent.) b. Prepare a retained earnings statement for the year ended December 31, 2016. c. Prepare a balance sheet in report form as of December 31, 2016.
- Selected transactions completed by Equinox Products Inc. during the fiscal year ended December 31, 2016, were as follows: a. Issued 15,000 shares of 0 par common stock at 0, receiving cash. b. Issued 4,000 shares of 80 par preferred 5% stock at 100, receiving cash. c. Issued 500,000 of 10-year, 5% bonds at 104, with interest payable semiannually. d. Declared a quarterly dividend of 0.50 per share on common stock and 1.00 per share on preferred stock. On the date of record, 100,000 shares of common stock were outstanding, no treasury shares were held, and 20,000 shares of preferred stock were outstanding. e. Paid the cash dividends declared in (d). f. Purchased 7,500 shares of Solstice Corp. at 40 per share, plus a 150 brokerage commission. The investment is classified as an available-for-sale investment. g. Purchased 8,000 shares of treasury common stock at 33 per share. h. Purchased 40,000 shares of Pinkberry Co. stock directly from the founders for 24 per share. Pinkberry has 125,000 shares issued and outstanding. Equinox Products Inc. treated the investment as an equity method investment. i. Declared a 1.00 quarterly cash dividend per share on preferred stock. On the date of record, 20,000 shares of preferred stock had been issued. j. Paid the cash dividends to the preferred stockholders. k. Received 27,500 dividend from Pinkberry Co. investment in (h). l. Purchased 90,000 of Dream Inc. 10-year, 5% bonds, directly from the issuing company, at their face amount plus accrued interest of 375. The bonds are classified as a held- to-maturitv long-term investment. m. Sold, at 38 per share, 2,600 shares of treasury common stock purchased in (g). n. Received a dividend of 0.60 per share from the Solstice Corp. investment in (f). o. Sold 1,000 shares of Solstice Corp. at 545, including commission. p. Recorded the payment of semiannual interest on the bonds issued in (c) and the amortization of the premium for six months. The amortization is determined using the straight-line method, q. Accrued interest for three months on the Dream Inc. bonds purchased in (1). r. Pinkberry Co. recorded total earnings of 240,000. Equinox Products recorded equity earnings for its share of Pinkberry Co. net income. s. The fair value for Solstice Corp. stock was 39.02 per share on December 31, 2016. The investment is adjusted to fair value, using a valuation allowance account. Assume Valuation Allowance for Available-for-Sale Investments had a beginning balance of zero. Instructions Journalize the selected transactions. After all of the transactions for the year ended December 31, 2016, had been posted [including the transactions recorded in part (1) and all adjusting entries], the data that follows were taken from the records of Equinox Products Inc. a. Prepare a multiple-step income statement for the year ended December 31, 2016, concluding with earnings per share. In computing earnings per share, assume that the average number of common shares outstanding was 100,000 and preferred dividends were 100,000. (Round earnings per share to the nearest cent.) b. Prepare a retained earnings statement for the year ended December 31, 2016. c. Prepare a balance sheet in report form as of December 31, 2016. Income statement data: Advertising expense 150,000 Cost of merchandise sold 3,700,000 Delivery expense 30,000 Depreciation expense -office buildings and equipment 30,000 Depreciation expensestore buildings and equipment 100,000 Dividend revenue 4,500 Gain on sale of investment 4,980 Income from Pinkberry Co. investment 76,800 Income tax expense 140,500 Interest expense 21,000 Interest revenue 2,720 Miscellaneous administrative expense 7.500 Miscellaneous selling expense 14,000 Office rent expense 50,000 Office salaries expense 170,000 Office supplies expense 10,000 Sales 5,254,000 Sales commissions 185,000 Sales salaries expense 385,000 Store supplies expense 21,000 Retained earnings and balance sheet data: Accounts payable 194,300 Accounts receivable 545,000 Accumulated depreciationoffice buildings and equipment 1,580,000 Accumulated depreciationstore buildings and equipment 4,126,000 Allowance for doubtful accounts 8,450 Available for sale investments (at cost) 260,130 Bonds payable. 5%. due 2024 500,000 Cash 246,000 Common stock, 20 par (400,000 shares authorized; 100,000 shares issued. 94,600 outstanding) 2,000,000 Dividends: Cash dividends for common stock 155,120 Cash dividends for preferred stock 100,000 Goodwill 500,000 Income tax payable 44,000 Interest receivable 1,125 Investment in Pinkberry Co. stock (equity method) 1,009,300 Investment in Dream Inc. bonds (long term) 90,000 Merchandise inventory [December 31, 2016). at lower of cost (FIFO) or market 778,000 Office buildings and equipment 4.320,000 Paid-in capital from sale of treasury stock 13,000 Excess of issue price over parcommon stock 886,800 Excess of issue price over parpreferred stock 150,000 Preferred 5% stock. 80 par (30,000 shares authorized; 20,000 shares issued] 1,600,000 Premium on bonds payable 19,000 Prepaid expenses 27,400 Retained earnings, January 1, 2016 9,319,725 Store buildings and equipment 12,560,000 Treasury stock (5,400 shares of common stock at cost of 33 per share) 178,200 Unrealized gain (loss) on available for sale investments (6,500) Valuation allowance for available for sale investments (6,500)Contributed Capital Adams Companys records provide the following information on December 31, 2019: Additional information: 1. Common stock has a 5 par value, 50,000 shares are authorized, 15,000 shares have been issued and are outstanding. 2. Preferred stock has a 100 par value, 3,000 shares are authorized, 800 shares have been issued and are outstanding. Two hundred shares have been subscribed at 120 per share. The stock pays an 8% dividend, is cumulative, and is callable at 130 per share. 3. Bonds payable mature on January 1, 2023. They carry a 12% annual interest rate, payable semiannually. Required: Prepare the Contributed Capital section of the December 31, 2019, balance sheet for Adams. Include appropriate parenthetical notes.Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019: Additional information: a. On January 2, 2019, Farrell sold equipment costing 45,000, with a book value of 24,000, for 19,000 cash. b. On April 2, 2019, Farrell issued 1, 000 shares of common stock for 23,000 cash. c. On May 14, 2019, Farrell sold all of its treasury stock for 25,000 cash. d. On June 1, 2019, Farrell paid 50, 000 to retire bonds with a face value (and book value) of 50, 000. e. On July 2, 2019, Farrell purchased equipment for 63, 000 cash. f. On December 31, 2019, land with a fair market value of 150,000 was purchased through the issuance of a long-term note in the amount of 150,000. The note bears interest at the rate of 15% and is due on December 31, 2021. g. Deferred taxes payable represent temporary differences relating to the use of accelerated depreciation methods for income tax reporting and the straight-line method for financial statement reporting. Required: 1. Prepare a spreadsheet to support a statement of cash flows for Farrell for the year ended December 31, 2019, based on the preceding information. 2. Prepare the statement of cash flows. (Appendix 21.1) Spreadsheet and Statement Refer to the information for Farrell Corporation in P21-13. Required: 1. Using the direct method for operating cash flows, prepare a spreadsheet to support a 2019 statement of cash flows. (Hint: Combine the income statement and December 31, 2019, balance sheet items for the adjusted trial balance. Use a retained earnings balance of 291,000 in this adjusted trial balance.) 2. Prepare the statement of cash flows. (A separate schedule reconciling net income to cash provided by operating activities is not necessary.)