The Cash Flow Statement Excel Sheet

Module 4 Assignment:Complete the missing areas of the Statement of Cash Flows for Ma and Pa Grocery as of December 31, 20XX.
Additional Information:
Depreciation for the year was 10,000.
Cash received from the sale of investments was 8000.
Cash paid for construction of the building was 42,000.
Cash paid for dividends was 4,000.
Cash at the beginning of the year was 7,800, and at the end of the year was 61,500.
Common stock issued to retire bonds payable was 10,000.
Ma and Pa Grocery
Statement of Cash Flows-Indirect Method
For the Year Ended 20XX
Cash Flows from Operating Activities:
Net Income
Reconciliation of net income to net cash flows:
Depreciation
Patent Amortization
Changes in Current Assets and Current Liabilities:
Decrease in Accounts Receivable
Increase in Inventory
Increase in Prepaid Expenses
Decrease in Accounts Payable
Increase in Accrued Liabilities
Decrease in Income Taxes Payable
Net Cash Flows Provided by Operating Activities
Cash Flows from Investing Activities:
Cash received from sale of:
Investments (long-term)
Land
Less: Cash Paid for construction on building
Net Cash Flows Used In Investing Activities
Cash Flows from Financing Activities:
Cash received from issuing mortgage note payable
Less: Cash paid for dividends
Net Cash Flows Used for Financing Activities
Increase in cash
Cash at the Beginning of the Year
Cash at the End of the Year
Schedule of Non-Cash Investing and Financing Activities:
Issued common stock to retire bonds payable
2,400
4,000
-750
-430
-1,200
380
-500
22,000
12,000
ecember 31, 20XX.
43,800