Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me to complete the cash flows statement based on the excel data given. THE SIMPSON CO Statement of Cash Flows For Month Ended

please help me to complete the cash flows statement based on the excel data given. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
THE SIMPSON CO Statement of Cash Flows For Month Ended May 31 Cash flows from operating activities: Cash received from customers Cash paid for rent Cash paid for cleaning Cash paid for telephone Cash paid for utilities Cash paid to employees Net cash provided by operating activities Cash flows from investing activities Purchase of equipment et cash used by investing activities Cash flows from financing activities: Investments by owner Withdrawals by owner Net cash provided by financing activities Net increase in cash Cash balance, May 1 Cash balance. May 31 $ $ 5600 5600 Total revenue Revenue: service revenue Total revenue Less: COGS Gross profit operating expenses: utilities expenses salaries expenses rent expenses Total operating expenses Net income 5600 440 1200 800 -2440 3160 $ $ 56000 common stock (capital) Add: Net income 3160 59160 Less: Drawings Stockholder's equity -700 58,460 S S S S Liabilities: current liabilities: alc payable 11300 Assets: current assets: Cash office supplies ac receivable Total current assets 49.960 1400 600 51.960 Total current liabilities 11300 Fixed assets electrical equipment office equipment total fixed assets stockholders' equity: Owner's capital 58460 14,000 3800 17,800 total stockholder's equity 58460 Total assets: 69,760 total kiabilities and stockholder's equity 69760

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 Advanced

Authors: Claudia Bienias Gilbertson

9th Edition

0538447559, 9780538447553

More Books

Students also viewed these Accounting questions