Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, please help me create a cash flow worksheet and a cash flow statement in the exact same format in the pictures. see pictures of
Hi, please help me create a cash flow worksheet and a cash flow statement in the exact same format in the pictures. see pictures of statement with dollar figure to get details.
Cash Flow Worksheet 2. Jan 31 Jan 1 3 4 Cash 5 Accounts Receivable 6 Prepaid Advertising 7 Supplies 8 Equipment 9 Accumulated Depreciation 10 Total Assets 34,000 67,000 2,000 5,000 114,000 (13,000) 209,000 28,000 50,000 8,000 6,000 102,000 (12,000) 182,000 Change 6,000 17,000 (6,000) (1,000) 12,000 (1,000) 27,000 12 13 15 16 17 Total Liab + SE 718 19 20 Net Income Dividends 21 22 23 24 Statement of Cash Flows For the month ended January 31 Cash Flow From Operating Activities 2 B Net Cash from Operating Activities 1 5 Cash Flow From Investing Activities 5 7 Net Cash from Investing Activites B 3 Cash Flow from Financing Activities 1 2 3 Net Cash From Financing Activities 4 5 Net Increase (Decrease) in Cash Inc Stmt SE Stmt Bal Sheet Po II Net Cash from Operating Activities Cash Flow From Investing Activities Net Cash from Investing Activites Cash Flow from Financing Activities Net Cash From Financing Activities Net Increase (Decrease) in Cash Cash Balance, January 1 Cash Balance, January 31 Ind Stmt WHIN Bal Sheet B For the Month Ended January 31 Credit # Debit 34,000 67,000 2,000 5,000 114,000 . Cash Accounts Receivable Prepaid Advertising Supplies Equipment 1 Accumulated Depreciation Accounts Payable Unearned Revenue Long-term Notes Payable Common Stock Retained Earnings Dividends 2 Service Revenue 1 Salaries Expense 2 Rent Expense 3 Depreciation Expense Supplies Expense 5 Advertising Expense 13,000 77,500 3,000 25,000 65,500 38,000 al 222,000 222,000 Inc Stmt SE Stmt Bal Sheet Post-Closing Trial Balance C Income Statement For the month ended January 31 Service Revenue $30,000 Expense Salaries Expense Rent Expense Depreciation Expense Supplies Expense Advertising Expense Total Expense 8,000 4,000 1,000 4,000 6,000 $23,000 Net Income $7,000 Statement of Stockholders' Equity For the month ended January 31 Common Retained Stock Earning Total Beginning Balance 58,000 33,000 91,000 Add:Common Stock Issued 7,500 7,500 Net Income 7,000 7,000 65,500 40,000 105,500 Less: Dividends 2,000 2,000 Ending Balance 65,500 38,000 103,500 Jay Cohen Consulting, Inc. Opening Trial Balance January 1 Account Number Account Name Debit Credit 100 Cash 28,000 120 Accounts Receivable 50,000 130 Prepaid Advertising 8,000 140 Supplies 6,000 180 Equipment 102,000 181 Accumulated Depreciation 12,000 200 Accounts Payable 77,000 205 Unearned Revenue 250 Long-term Notes Payable 14,000 300 Common Stock 58,000 5 310 Retained Earnings 33,000 5 350 Dividends 7 400 Service Revenue 3 501 Salaries Expense 3 502 Rent Expense 503 Depreciation Expense 1 504 Supplies Expense 2 505 Advertising Expense 3 Total 194,000 194,000 4 Opening balances Journal Worksheet Ready
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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