Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

LIM N 0 F T 1 2 BCT E G H Statement of Cash Flows Excel Problem Prepare a Statement of Cash Flows for Banana

image text in transcribed

image text in transcribed

LIM N 0 F T 1 2 BCT E G H 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 3 5 recue 6 7 Banana World Comparative Balance Sheet December 31, 2025 and 2024 8 2025 2024 Sectio Add + ifferenc n (0, 1, Subtra F, NC) ct 12 13 12,125 $ 523,693 $ 23,840 2.422 355 60 Additional Information: 1. The Income Statement for 2025 included the following items: (0.1, F. Subtra a. Net Income $ 417 000 b. Depreciation Expense 3 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 Cashreceived 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 notrelate to operations. 7,600 n 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 17 165 2.000 18 19 20 155,000 85 000 610 000 35 000 12 000 12,000 150.000 (35,180) 1850) $ 1442,190 $ 153,040 Liabilities 27 Current Liabilities: Balance Sheet and Info Statement of Cash Flows - $ 3.050 295 745 700 1.250 15,000 Liabilities Current Liabilities: Accounts Payable Utilities Payable Telephone Payable Wages Payable Notes Payable Interest Payable Unearned Revenue 35 Long-term Liabilities: Notes Payable Mortgage Payable Bonds Payable Discount on Bonds Payable Total Liabilities 500 350 7,200 405,000 210.000 (1.270) 647.670 Stockholders' Equity 43 Paid-In Capital: Preferred Stock Paid-In-Capital in Excess of Par-Preferred 46 Common Stook Paid-In-Capitalin Excess of Par-Common 48 Retained Earnings 49 Total Stockholders' Equity 50 Total Liabilities and Stockholders' Equity 60.000 10,000 186.000 136.000 150,000 388,520 4,520 140.520 $ 1,442,190 $ 158,040

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Managers Interpreting Accounting Information For Decision Making

Authors: Paul M. Collier

3rd Edition

0470777648, 9780470777640

More Books

Students also viewed these Accounting questions

Question

What is the message frequency?

Answered: 1 week ago

Question

What is the schedule for this project?

Answered: 1 week ago

Question

Who is responsible for this project?

Answered: 1 week ago