60.1K

Verified Solution

Link Copied!

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 2024 Section Difference (0, 1, F, NC) Add + / Subtract- $ 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 60 0 12,125 0 7,600 0 165 2,000 155,000 85,000 610,000 35,000 12,000 12,000 150,000 0 (35,180) (850) $ 1,442,190 $ 153,040 $ 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 295 325 1,250 0 50 350 7,200 405,000 210,000 (1,270) 647,670 $ 7,200 0 0 0 12,520 $ 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 $ 153,040 Additional Information: Section (0, Add + / 1. The Income Statement for 2025 included the following items: I, F, NC) Subtract a. Net Income $ 417,000 b. Depreciation Expense $ 34,330 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 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 cash: $ 15,000 5. 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. $

Answer & Explanation Solved by verified expert

See Answer