Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

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

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M.Dater, George Foster, Madhav

13th Edition

8120335643, 136126634, 978-0136126638

More Books

Students also viewed these Accounting questions