Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I don't think my cash flow statement is correct Aules (@CH H 5 ACC 2001 Project Excel File (2) Excel Brittany Konkle File Home Insert
I don't think my cash flow statement is correct
Aules (@CH H 5 ACC 2001 Project Excel File (2) Excel Brittany Konkle File Home Insert Draw Page Layout Formulas Data Review View Help Search Share F32 X f A D E F G H J J 1 L M N P B S 1 1 2 3 3 B Dress Right Clothing Adjusted Trial Balance December 31, 2020 4 Credits Debits $49,000 12,400 1,200 10,000 48,500 120.000 Current Year Change $ $44,350 (1,500) 400 1,000 9,600 $71,400 40,000 5 6 Account Title 7 Cash B Accounts Receivable 9 Supplies 10 Prepaid Rent 11 Inventory 12 Equipment 13 Accumulated Depreciation - Equipment 14 Long Term Investments 15 Accounts Payable 16 Deferred Revenue 17 Salaries Payable 18 Interest Payable 19 Notes Payable due in 3 years 20 Commen Stock 21 Retained Carnings 22 Dividends 23 Sales Revenue 24 Interest Ravenue 25 Cost at Goods Sold 26 Salaries Expense 27 Supplies Expense 29 Rent Expense 29 Depreciation Expense 30 Interest Expense 31 Income Tax Expense 32 33 34,600 7,800 500 400 40,000 60,000 14,800 4,000 5,400 3,700 12,500) 14,150) 400 (30,000) 36,200 19,900 938,860 5,600 540,600 175,260 8,500 120,000 4,000 3,600 21,000 *-Beginning of year balance minus end of the year balance. To be used for the Statement of Cash Flows $1,173,960 $1,173,960 35 Adj Trial Balance income Statement Statement of SHE Balance Sheet Statement of Cash Flows + O Type here to search x ? RR ) 1:50 PM 9/18/2020 AutoSave H5 ACC 2001 Project 3 Excel File (2) - Excel Brittany Konkle File Home Insert Draw Page Layout Formulas Data Review View Help Search Share 125 D E F H K M N R S 1 A B c 1 Dress Right Clothing 2 Statement of Cash Flow 3 For the Year Ended December 31, 2020 4 5 Operating Activities: 6 Net Income $71,500 7 Depreciation 4,000 B Change in Accounts Receivable () (1,500) 9 Change in Supplies 400 10 Change in Prepaid Rent 1,000 11 Change in Inventory 9,600 12 Chanpe in Accounts Payable 3,700 13 Change in Deferred Revenue ( (2,500) 14 Change in Salaries Payable (4,150) 15 Change in Interest Payable 400 16 Total Operating Activities 82,150 17 18 Investing Activities 19 Change in Investment 5,400 20 Total Investing Activities 5,400 21 22 Financing Activities 23 Change in Common Stock 36,200 24 Change in Notes Payable (30,000) 25 Payment of Dividends 19,900 26 Total Financing Activities 26,100 27 20 Increase/(Decrease) in Cash 29 Cash at the beginning of the year 44,350 30 Cash at the end of the year $49,000 31 32 33 34 Adi Trial Balance Income Statement Statement of SHE Head Balance Sheet Statement of Cash Flows + # Dll + 100% O Type here to search Ei e x ? RR 4) 10:58 AM 9/20/2020 AutoSave OH H5 ACC 2001 Project 3 Excel File (2) - Excel Brittany Konic File Home Insert Draw Page Layout Formulas Data Review View Help Search Share F34 F H 1 J 1 L M N 0 P B 5 1 1 - A B C D 1 Dress Right Clothing 2 Statement of Stockholders' Equity For the year onded December 31, 2020 4 Total 5 Common Retained Stockholders 6 Stock Carnings Equity 7 Beginning of year balance $ 23,800 $ 14,800 S 38,600 8 Issuance of Common Stuck 36,200 36,200 9 Net Income 0 71,500 71,500 10 Dividends U 19,900 19,900 11 17 End of year balance $60,000 $ 66,400 $ 166,200 13 14 15 16 17 18 19 20 21 22 24 25 26 27 28 29 30 31 32 33 311 T Adi Trial Balance Income Statement Statement of SHE Balance Sheet Statement of Cash Flows + Read il- + 100% Type here to search e x ? RR 11:41 AM 9/20/2020 AutoSave OH H5 ACC 2001 Project 3 Excel File (2) - Excel Brittany Konde File Home Insert Draw Page Layout Formulas Data Review View Help Search Share F34 X f A D F H 1 K L M N P Q 1 2 3 4 C Dress Right Clothing Balance Sheet December 31, 2020 $49,000 12,400 1,200 48,500 Liabilities Current Liabilities: Accounts Payable Deferred Revenue Salaries Payable Interest Payable Total Current Liabilities $34,600 7,8X 500 400 43,300 S111,100 Long Term Liabilities: Notes Payable due in 2 years Total Long Term Liabilities 40,000 40,000 5 6 Assets 7 Current Assets: 6 Cash 9 Accounts Receivable 10 Supplies 11 Inventory 12 13 Total Current Assets 14 Long Term Assets: 15 Equipment 16 Accumulated Depreciation - Equipment 17 Long-Term Investments Total Long Term Assets 19 20 21 22 23 24 25 Total Assets 26 27 28 29 120,000 $71,400 40,000 88,600 Total Liabilities 83,300 60,000 Stockholders' Equity Cornmon Stock Retained Earnings Total Stockholders' Equity 66,400 126,400 $199,700 Total Liabilities & Stockholders' Equity $209,700 $ 31 32 33 341 T Adi Trial Balance Income Statement Statement of SHE Balance Sheet Statement of Cash Flows + Read Dll + 100% Type here to search exa ? RR 11:41 AM 9/20/2020
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