Requirement 1. Prepare a Statement of Cash Flows for Banana World using the Comparative Balance Sheet and additional information. The year ended on December 31, 2025 and the indirect method will be used.
- Fill in the dollar difference between the years.
- Next fill in the section of the Statement of Cash Flows that line will appear in.
Identify each item as a(n):
- Operating activity (O)
- Investing activity (I)
- Financing activity (F)
- Activity that is not used to prepare the indirect statement of cash flows (N)
- Lastly, identify if it will be added or subtracted in that section. The cells that are grey are to be completed.
Requirement 2.
Prepare the statement of cash flows for the year ended December 31, 2025, using the indirect method. The cells that are grey are to be completed.
Statement of Cash Flows Excel Problem Prepare a Statement of Cash Flows for Banana World using the Comparative Balance Sheet and additional information. The year ended on December 31, 2025 and the indirect method wil be used. Fill in the dollar difference between the years. Next fill in the section of the Statement of Cash Flows that line will appear in. Lastly, identify if it will be added or subtracted in that section. The cells that are grey are to be completed Banana World Comparative Balance Sheet December 31, 2025 and 2024 2025 $ Additional Information: Jection had | (0, 1, F, Subtra 1. The Income Statement for 2025 included the following items: NC a. Net Income $ 417,000 O ADD b. Depreciation Expense $ 34.330 O ADD c. Amortization on Bonds Payable $ 254 2. There were no disposals of property, plant and equipment during the year All acquisitions of PP&E were for cash except for the land, which was acquired by issuing preferred stock. 3. The company issued bonds payable. Face Value of Bonds: $ 210,000 Cash received for Bonds: $ 208,476 F ADD 4. The company distributed 4,000 shares of common stock in a stock dividend when the market value was $4.50 per share. Other dividends paid in oash: $ 15,000 F SUBTRACT The common stock, except for the stock dividend, was issued for cash. 6. The cash receipt from the Notes Payable in 2025 is considered a financing activity because it does not relate to operations. Assets Current Assets: Cash Short-term Investments, net Accounts Receivable, net Merchandise Inventory Office Supplies Prepaid Rent Property, Plant and Equipment: Land Building Delivery Truck Office Furniture and Equipment Accumulated Depreciation - PP&E Total Assets 523,693 $ 23,840 2,422 355 2024) Section Add +/ Difference (0,1,F, Subtra NC) ct - 12,125 $ 511,568 ADD 0 $ 23,840 O ADD 7,600 $ (5,178) O SUBTRACT 0 $ 355 0 ADD 165 $ (105) O SUBTRACT 2,000 $ 2,000 O ADD 60 0 SUBTRACT 155,000 85,000 $70,000 610.000 35,000 $575,000 0 12,000 12,000 $ In 150,000 0 $ 150,000 (35,180) (850) $ (36,030) $ 1,442,190 $ 153,040 SUBTRACT $ Liabilities Current Liabilities: Accounts Payable Utilities Payable Telephone Payable Wages Payable Notes Payable Interest Payable Unearned Revenue Long-term Liabilities: Notes Payable Mortgage Payable Bonds Payable Discount on Bonds Payable Total Liabilities 5,195 $ 745 700 4,250 15,000 350 500 3,050 $ 2.145 0 295 $ 450 O 325 $ 375 O 1,250 $ 3,000 O 0 $ 15.000 F 50 $ 300 O 350 $ 150 ADD ADD ADD ADD ADD ADD ADD 7,200 7,200 $ - NC 405,000 0 $405,000 F 210,000 0 $ 210,000 (1,270) 0 $ (1,270) $ 647,670 $ $ 12,520 SUBTRACT Stockholders' Equity Paid-In Capital Preferred Stock Paid-In-Capital in Excess of Par-Preferred Common Stock Paid-In-Capital in Excess of Par-Common Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 60,000 0 10,000 0 186,000 136,000 150.000 0 388,520 4.520 794.520 140,520 $ 1.442.190 $ 158.040 60,000 F 10,000 F 50,000 F 150,000 F 384,000 654,000 ADD ADD Requirement Prepare the statement of cash flows for the year ended December 31, 2025, using the indirect method. The cells that are grey are to be completed. Banana World Statement of Cash Flows Year End December 31 2025 Adjustments to Reconcile Net Income to Net Cash
