Expert answer:Module 04 Written Assignment – The Cash Flow Statement
Review the partially completed cash flow statement for Ma and Pa Grocery for the period ended December 31, 20## in the Excel Template.
Requirements:
•Complete the missing areas of the Statement of Cash Flows for the period ending December 31, 20##.
kespinosa_modue4cashflow_12317.xlsx
Unformatted Attachment Preview
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
…
Purchase answer to see full
attachment
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more