need help with this exercise.

1 E13.15 Prepare a worksheet 2 3 Comparative balance sheets for International Company are presented as follows. + 11 12 13 14 International Company Comparative Balance Sheets December 31 2022 2021 Assets Cash $ 73,000 $ 22,000 Accounts receivable 85,000 76,000 Inventory 180,000 189,000 Land 75,000 100,000 Equipment 250,000 200,000 15 Accumulated depreciation - Equipment (66,000) (42,000) 16 Total $ 597,000 $ 545,000 17 18 Liabilities and Stockholders' Equity 19 Accounts payable 34,000 47,000 20 Bonds Payable 150,000 200,000 21 Common stock ($1 par) 214,000 164,000 22 Retained earnings 199,000 134,000 23 Total $ 597,000 $ 545,000 24 25 Additional information: 26 1. Net income for 2022 was $135,000 27 2. Cash dividends of $70,000 was declared and paid. 28 3. Bonds payable amounting to $50,000 were redeemed for cash $50,000 29 4. Common stock was issued for $50,000 cash 30 5. Depreciation expense was $24,000. 31 6. Sales revenue for the year was $978,000. 32 7. Land was sold at cost, and equipment was purchased for cash 33 34 Instructions 1 Prepare a worksheet for a statement of cash flows for 2022 using the indirect method. Enter the reconciling items directly 36 on the workshoot, using lotters to cross-reference oach entry. 37 3* NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), Into the yellow shaded input a 39 cells. 40 41 E13.15 P13.7 Cala K A B 43 44 45 D F G H Worksheet Statement of Cash Flows For the Year Ended December 31, 2022 Reconciling Items Balance 12/31/21 Debit Credit 46 Balance 12/31/22 47 48 49 50 51 52 53 Balance Sheet Accounts Debits Cash Accounts receivable Inventory Land Equipment Total 54 Credits Accumulated depreciation equipment Accounts payable Bonds payable Common stock Retained earnings Total 55 56 57 58 59 50 51 62 63 64 55 66 57 58 69 70 71 73 24 75 76 77 7 79 10 Statement of Cash Flow Effects Operating activities Not income Increase in accounts receivable Decrease in inventory Decrease in accounts payablo Depreciation expense Investing activities Sale of land Purchase of equipment Financing activities Payment of dividendo Redemption of bonds Issuance of common stock Totals Increase in cash Totals E13.15 P13.7 +