Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Create a statement of cash flows using the direct method in Microsoft Excel based on the cash information provided below: 1. In 2023, Casa
1. Create a statement of cash flows using the direct method in Microsoft Excel based on the cash information provided below: 1. In 2023, Casa Del Sueno Company had a beginning cash balance of $20,000. Ending 2023 cash balance was $17,800. 2. Customers paid a total of $32,000 cash. 3. Received $7,300 cash by selling an old equipment. 4. Purchased a new business vehicle for $51,000 cash. 5. Paid cash dividends of $17,200. 6. Issued stocks to raise a total of $50,000 cash. 7. Received $1,000 cash interest. 8. Paid $13,500 cash for employee salaries and wages. 9. Paid $10,000 cash for purchase of treasury stock. 10. Purchased supplies for $800 cash. 2. Make sure to include the following information: 1. Company name 2. Name of the report 3. Reporting period 4. Cash flows from operating activities, cash flows from investing activities, and cash flows from financing activities 5. Net change of cash, beginning cash balance, and ending cash balance 3. Use the following numbers to check your statement of cash flows: 1. Cash Flows from Operating Activities should be $18,700. 2. Cash Flows from Investing Activities should be $(43,700). 3. Cash Flows from Financing Activities should be $22,800. 4. Net Decrease of Cash should be $(2,200). 5. Beginning Cash Balance should be $20,000. 6. Ending Cash Balance should be $17,800. 4. Be creative as to the formats of the contents (such as colors, fonts, tables, design, etc.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started